Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

Banner 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 Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

PPRSKIL

PPRSKIL_COMMENTS

END_DATE End Date Date the skill was ended. DATE

PPRSKIL

PPRSKIL_END_DATE

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

LAST_DATE Last Date Date the skill was last used. DATE

PPRSKIL

PPRSKIL_LAST_DATE

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

PPRSKIL

PPRSKIL_NATIVE_IND

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

PPRSKIL

PPRSKIL_PIDM

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

NA

NA

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

PPRSKIL

PPRSKIL_READ_IND

SKILL Skill Identifies the type of skill. VARCHAR2(63)

PPRSKIL

PPRSKIL_SKIL_CODE

SKILL_DESC Skill Description Skill description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PPRSKIL

PPRSKIL_SKLV_CODE

SKILL_LEVEL_DESC Skill Level Description Skill Level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PPRSKIL

PPRSKIL_SPEAK_IND

START_DATE Start Date Date the skill was learned. DATE

PPRSKIL

PPRSKIL_START_DATE

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

PPRSKIL

PPRSKIL_TEACH_IND

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

PPRSKIL

PPRSKIL_TRANS_IND

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

PPRSKIL

PPRSKIL_WRITE_IND



Ver: 9.2