RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: SKILL

Description Contains data related to a person's skills.
Key & Frequency One row per person per skill.
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

COMMENTS Free text comments related to the skill. VARCHAR2(2000)

PPRSKIL

PPRSKIL_COMMENTS

END_DATE Date the skill was ended. DATE

PPRSKIL

PPRSKIL_END_DATE

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

LAST_DATE Date the skill was last used. DATE

PPRSKIL

PPRSKIL_LAST_DATE

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

NA

NA

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

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

PPRSKIL

PPRSKIL_PIDM

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

NA

NA

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

PPRSKIL

PPRSKIL_READ_IND

SKILL Identifies the type of skill. VARCHAR2(63)

PPRSKIL

PPRSKIL_SKIL_CODE

SKILL_DESC Skill description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PPRSKIL

PPRSKIL_SKLV_CODE

SKILL_LEVEL_DESC Skill Level description. VARCHAR2(255)

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



Ver: 3.1