RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_SKILL

Description Source composite view contains skill information for an employee or person applying for a position at the institution.

Target Column Business Definition Database Data Type Source Name Source Column
COMMENTS Free text comments related to the skill. VARCHAR2(60)

PPRSKIL

PPRSKIL_COMMENTS

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

END_DATE Date the skill was ended. DATE

PPRSKIL

PPRSKIL_END_DATE

LAST_DATE Date the skill was last used. DATE

PPRSKIL

PPRSKIL_LAST_DATE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NATIVE_IND Indicates if this language is the native language of this individual. VARCHAR2(1)

PPRSKIL

PPRSKIL_NATIVE_IND

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

PPRSKIL

PPRSKIL_PIDM

READ_IND Indicates if person can read this skill. VARCHAR2(1)

PPRSKIL

PPRSKIL_READ_IND

SKILL Identifies the type of skill. VARCHAR2(6)

PPRSKIL

PPRSKIL_SKIL_CODE

SKILL_DESC Skill description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SKILL_LEVEL Identifies the level of expertise achieved within the skill. VARCHAR2(3)

PPRSKIL

PPRSKIL_SKLV_CODE

SKILL_LEVEL_DESC Skill Level description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SPEAK_IND Indicates if person can speak this language skill. VARCHAR2(1)

PPRSKIL

PPRSKIL_SPEAK_IND

START_DATE Date the skill was learned. DATE

PPRSKIL

PPRSKIL_START_DATE

TEACH_IND Indicates if person can teach this skill. VARCHAR2(1)

PPRSKIL

PPRSKIL_TEACH_IND

TRANSLATE_IND Indicates if person can translate this language skill. VARCHAR2(1)

PPRSKIL

PPRSKIL_TRANS_IND

WRITE_IND Indicates if person can write with this language skill. VARCHAR2(1)

PPRSKIL

PPRSKIL_WRITE_IND

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1