Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_INTERVIEW

Description Source composite view contains application interview information for persons that are applying for a position at the institution.

Target Column Business Definition Database Data Type Source Name Source Column
APPLICATION_DATE Application submission date. DATE

PARAPIN

PARAPIN_APPL_DATE

COMMENTS Free form comment regarding this applicant. VARCHAR2(4000)

PARAPIN

PARAPIN_COMMENT

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

INTERVIEWER_NAME Current name of interviewer in the format of last, first middle name. VARCHAR2(255)

FUNCTION

F_FORMAT_NAME

INTERVIEWER_UID Employee identification number of the individual who conducted the interview. NUMBER(8)

PARAPIN

PARAPIN_INTERVIEW_PIDM

INTERVIEW_DATE Date of interview. DATE

PARAPIN

PARAPIN_INTERVIEW_DATE

INTERVIEW_TIME Time of interview. VARCHAR2(8)

PARAPIN

PARAPIN_INTERVIEW_TIME

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

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

PARAPIN

PARAPIN_PIDM

POSITION_APPLIED_FOR Position number associated with this applicant entry. VARCHAR2(6)

PARAPIN

PARAPIN_POSN

POSITION_APPLIED_FOR_TITLE Title or description of a position to which a candidate has applied. VARCHAR2(30)

NBBPOSN

NBBPOSN_TITLE

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)

PARAPIN

PARAPIN_PCLS_CODE

POSITION_CLASS_DESC 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(30)

FUNCTION

GOKODSF.F_GET_DESC

REQUISITION_NUMBER Requisition number of the position associated with this applicant entry. VARCHAR2(10)

PARAPIN

PARAPIN_REQ_NO

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

NA

NA



Ver: 8.0