HRS_APP_SCHD_VW

(SQL View)
Index Back

Interview Schedule View

Interview Schedule View

SELECT HRS_PERSON_ID ,HRS_RCMNT_ID ,HRS_RCM_INT_ID ,HRS_INT_ID ,HRS_INTERVIEWER_ID ,HRS_INT_DT ,HRS_START_TM ,HRS_END_TM ,TIMEZONE ,HRS_INTVW_LEVEL ,INTVW_LOCATION ,RECRUITER_COMMENTS FROM PS_HRS_INT_SCHED

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID
4 HRS_INT_ID Number(15,0) DECIMAL(15) NOT NULL Interview ID
5 HRS_INTERVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Interviewer
6 HRS_INT_DT Date(10) DATE Interview date
7 HRS_START_TM Time(15) TIMESTAMP Recruiting Solutions Start Time
8 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
10 HRS_INTVW_LEVEL Character(1) VARCHAR2(1) NOT NULL Interview Level

Prompt Table: HRS_INT_LVL_TBL

11 INTVW_LOCATION Character(50) VARCHAR2(50) NOT NULL Location
12 RECRUITER_COMMENTS Long Character CLOB Recruiter Comments