| 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
|
|
APPLICATION_DATE
|
Application Date
|
Application submission date.
|
DATE
|
PARAPIN
|
PARAPIN_APPL_DATE
|
|
COMMENTS
|
Comments
|
Free form comment regarding this applicant.
|
VARCHAR2(4000)
|
PARAPIN
|
PARAPIN_COMMENT
|
|
INTERVIEWER_NAME
|
Interviewer Name
|
Current name of interviewer in the format of last, first middle name.
|
VARCHAR2(255)
|
FUNCTION
|
F_FORMAT_NAME
|
|
INTERVIEWER_UID
|
Interviewer UID
|
Employee identification number if the individual who conducted the interview.
|
NUMBER
|
PARAPIN
|
PARAPIN_INTERVIEW_PIDM
|
|
INTERVIEW_DATE
|
Interview Date
|
Date of interview.
|
DATE
|
PARAPIN
|
PARAPIN_INTERVIEW_DATE
|
|
INTERVIEW_TIME
|
Interview Time
|
Time of interview.
|
VARCHAR2(8)
|
PARAPIN
|
PARAPIN_INTERVIEW_TIME
|
|
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
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PARAPIN
|
PARAPIN_PIDM
|
|
POSITION_APPLIED_FOR
|
Position Applied For
|
Position number associated with this applicant entry.
|
VARCHAR2(6)
|
PARAPIN
|
PARAPIN_POSN
|
|
POSITION_APPLIED_FOR_TITLE
|
Position Applied For Title
|
Title or description of a position to which a candidate has applied.
|
VARCHAR2(255)
|
NBBPOSN
|
NBBPOSN_TITLE
|
|
POSITION_CLASS
|
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(63)
|
PARAPIN
|
PARAPIN_PCLS_CODE
|
|
POSITION_CLASS_DESC
|
Position Class Description
|
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(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
REQUISITION_NUMBER
|
Requisition Number
|
Requisition number of the position associated with this applicant entry.
|
VARCHAR2(10)
|
PARAPIN
|
PARAPIN_REQ_NO
|