Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
APPLICATION_DATE
|
Application submission date.
|
DATE
|
PARAPST
|
PARAPST_APPL_DATE
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PARAPST
|
PARAPST_PIDM
|
NO
|
NO
|
POSITION_APPLIED_FOR
|
Position number associated with this applicant entry.
|
VARCHAR2(6)
|
PARAPST
|
PARAPST_POSN
|
NO
|
NO
|
POSITION_APPLIED_FOR_TITLE
|
Title or description of a position to which a candidate has applied.
|
VARCHAR2(30)
|
NBBPOSN
|
NBBPOSN_TITLE
|
NO
|
NO
|
POSITION_CLASS
|
Position class associated with the requisition to which this applicant has applied. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.
|
VARCHAR2(5)
|
PARAPST
|
PARAPST_PCLS_CODE
|
NO
|
NO
|
POSITION_CLASS_DESC
|
Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
REQUISITION_NUMBER
|
Requisition number to which this candidate has applied.
|
VARCHAR2(10)
|
PARAPST
|
PARAPST_REQ_NO
|
NO
|
NO
|
SEQUENCE_NUMBER
|
Sequence number given to each application.
|
VARCHAR2(3)
|
PARAPST
|
PARAPST_SEQ_NO
|
NO
|
NO
|
STATUS
|
Status of applicant.
|
VARCHAR2(2)
|
PARAPST
|
PARAPST_APPS_CODE
|
NO
|
NO
|
STATUS_COMMENT
|
Free form comment regarding this applicant status entry.
|
VARCHAR2(4000)
|
PARAPST
|
PARAPST_COMMENT
|
NO
|
NO
|
STATUS_DATE
|
Date the applicant status was entered.
|
DATE
|
PARAPST
|
PARAPST_APPS_DATE
|
NO
|
NO
|
STATUS_DESC
|
Status description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|