Reporting View Target: INTERVIEW

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: INTERVIEW

Description Contains information pertaining to the scheduling and result of an interview for a position.
Key & Frequency One row per person per requisition number per interviewer per interview date per position applied for.
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

APPLICATION_DATE Application submission date. DATE
PARAPIN

PARAPIN_APPL_DATE

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

PARAPIN_COMMENT

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 if the individual who conducted the interview. NUMBER
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

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

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
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(63)
PARAPIN

PARAPIN_PCLS_CODE

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(255)
FUNCTION

GOKODSF.F_GET_DESC

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 of the position associated with this applicant entry. VARCHAR2(10)
PARAPIN

PARAPIN_REQ_NO

Ver: 8.1

Description	Contains information pertaining to the scheduling and result of an interview for a position.
Key & Frequency	One row per person per requisition number per interviewer per interview date per position applied for.
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
APPLICATION_DATE	Application submission date.	DATE	PARAPIN	PARAPIN_APPL_DATE
COMMENTS	Free form comment regarding this applicant.	VARCHAR2(4000)	PARAPIN	PARAPIN_COMMENT
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 if the individual who conducted the interview.	NUMBER	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
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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	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(63)	PARAPIN	PARAPIN_PCLS_CODE
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(255)	FUNCTION	GOKODSF.F_GET_DESC
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 of the position associated with this applicant entry.	VARCHAR2(10)	PARAPIN	PARAPIN_REQ_NO