Reporting View Target: INTERVIEW

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

SGHE Banner Operational Data Store
Reporting View Target: INTERVIEW_SLOT

Description Uses data from the INTERVIEW view, displays up to 4 interviews assigned to a requisition in order of ascending interview time/date.
Key & Frequency One row per person per requisition number.
Recommended Search Columns PERSON_UID, REQUISITION_NUMBER
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE
NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

INTERVIEWER_NAME1 Interviewer Name 1 Current name of interviewer in the format of last, first middle name. VARCHAR2(255)
FUNCTION

F_FORMAT_NAME

INTERVIEWER_NAME2 Interviewer Name 2 Current name of interviewer in the format of last, first middle name. VARCHAR2(255)
FUNCTION

F_FORMAT_NAME

INTERVIEWER_NAME3 Interviewer Name 3 Current name of interviewer in the format of last, first middle name. VARCHAR2(255)
FUNCTION

F_FORMAT_NAME

INTERVIEWER_NAME4 Interviewer Name 4 Current name of interviewer in the format of last, first middle name. VARCHAR2(255)
FUNCTION

F_FORMAT_NAME

INTERVIEW_DATE1 Interview Date 1 Date of interview. DATE
PARAPIN

PARAPIN_INTERVIEW_DATE

INTERVIEW_DATE2 Interview Date 2 Date of interview. DATE
PARAPIN

PARAPIN_INTERVIEW_DATE

INTERVIEW_DATE3 Interview Date 3 Date of interview. DATE
PARAPIN

PARAPIN_INTERVIEW_DATE

INTERVIEW_DATE4 Interview Date 4 Date of interview. DATE
PARAPIN

PARAPIN_INTERVIEW_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

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

PARAPIN_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

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

PARAPIN_REQ_NO

Ver: 9.0

Description	Uses data from the INTERVIEW view, displays up to 4 interviews assigned to a requisition in order of ascending interview time/date.
Key & Frequency	One row per person per requisition number.
Recommended Search Columns	PERSON_UID, REQUISITION_NUMBER ACTIVITY_DATE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
INTERVIEWER_NAME1	Interviewer Name 1	Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
INTERVIEWER_NAME2	Interviewer Name 2	Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
INTERVIEWER_NAME3	Interviewer Name 3	Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
INTERVIEWER_NAME4	Interviewer Name 4	Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
INTERVIEW_DATE1	Interview Date 1	Date of interview.	DATE	PARAPIN	PARAPIN_INTERVIEW_DATE
INTERVIEW_DATE2	Interview Date 2	Date of interview.	DATE	PARAPIN	PARAPIN_INTERVIEW_DATE
INTERVIEW_DATE3	Interview Date 3	Date of interview.	DATE	PARAPIN	PARAPIN_INTERVIEW_DATE
INTERVIEW_DATE4	Interview Date 4	Date of interview.	DATE	PARAPIN	PARAPIN_INTERVIEW_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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PARAPIN	PARAPIN_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
REQUISITION_NUMBER	Requisition Number	Requisition number of the position associated with this applicant entry.	VARCHAR2(10)	PARAPIN	PARAPIN_REQ_NO