HRS_RCM_INT_VW

(SQL View)
 Index Back

Applicant Interview

View over the base table for Applicant Interviews

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_RCM_INT_ID , A.HRS_INT_DT , A.HRS_START_TM , A.HRS_INT_DT_END , A.HRS_END_TM , A.TIMEZONE , A.HRS_SEQ_NUM , A.HRS_INTVW_LEVEL , A.HRS_INTVW_STATUS , A.INTVW_LOCATION , A.HRS_INT_STTS , A.HRS_INT_STTS_RSN , A.HRS_INT_STTS_DT , A.HRS_DISPL_HMPG , A.HRS_SCHD_APP_VWD , A.HRS_SCHDAPP_DEL_HM , A.HRS_INT_APP_AP_ST , A.EODI_APT_GROUP , %subrec(HRS_AUDIT_SBR, A) , A.RECRUITER_COMMENTS FROM PS_HRS_RCM_INT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

Prompt Table: HRS_APPLICANT_I

2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID

Default Value: 999999999999999

Prompt Table: HRS_RCMNT

3 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID

Default Value: 999999999999999

4 HRS_INT_DT Date(10) DATE Interview date
5 HRS_START_TM Time(15) TIMESTAMP Recruiting Solutions Start Time
6 HRS_INT_DT_END Date(10) DATE Used to store the ending date of the interview in the base time zone.
7 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

9 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
10 HRS_INTVW_LEVEL Character(1) VARCHAR2(1) NOT NULL Interview Level

Prompt Table: HRS_INT_LVL_TBL

11 HRS_INTVW_STATUS Character(1) VARCHAR2(1) NOT NULL Interview Status
C=Completed
F=Confirmed
S=Scheduled
U=Unconfirmed
X=Canceled

Default Value: U

12 INTVW_LOCATION Character(254) VARCHAR2(254) NOT NULL Interview Location
13 HRS_INT_STTS Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_INT_I

14 HRS_INT_STTS_RSN Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_INT_I

15 HRS_INT_STTS_DT Date(10) DATE Status Date

Default Value: %date

16 HRS_DISPL_HMPG Character(1) VARCHAR2(1) NOT NULL Display Schedule to Applicant

Y/N Table Edit

Default Value: N

17 HRS_SCHD_APP_VWD Character(1) VARCHAR2(1) NOT NULL Viewed on Applicant Homepage

Y/N Table Edit

Default Value: N

18 HRS_SCHDAPP_DEL_HM Character(1) VARCHAR2(1) NOT NULL Delete from HomePage

Y/N Table Edit

Default Value: N

19 HRS_INT_APP_AP_ST Character(1) VARCHAR2(1) NOT NULL Translate field for applicant appointment status
A=Accepted
D=Declined
N=None
T=Tentative

Default Value: N

20 EODI_APT_GROUP Character(5) VARCHAR2(5) NOT NULL Apt Group
21 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
22 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
23 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
24 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
25 RECRUITER_COMMENTS Long Character CLOB Recruiter Comments