HRS_APP_SCHD_I

(SQL View)
Index Back

Interview Schedule Interface

Interview Schedule Interface

SELECT B.HRS_PERSON_ID ,B.HRS_RCMNT_ID ,A.HRS_INT_ID ,B.HRS_RCM_INT_ID ,A.HRS_INTERVIEWER_ID ,B.HRS_INT_DT ,B.HRS_START_TM ,B.HRS_INT_DT_END ,B.HRS_END_TM ,B.HRS_INTVW_LEVEL ,B.INTVW_LOCATION FROM PS_HRS_INT_SCHED A , PS_HRS_RCM_INT B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND A.HRS_RCM_INT_ID = B.HRS_RCM_INT_ID

# 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_INT_ID Number(15,0) DECIMAL(15) NOT NULL Interview ID
4 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment 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_INT_DT_END Date(10) DATE Used to store the ending date of the interview in the base time zone.
9 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
10 HRS_INTVW_LEVEL Character(1) VARCHAR2(1) NOT NULL Interview Level

Prompt Table: HRS_INT_LVL_TBL

11 INTVW_LOCATION Character(254) VARCHAR2(254) NOT NULL Interview Location