HRS_INT_EVL_AET

(SQL Table)
Index Back

Intvw Eval Reminder Temp Table

Temp table for interview evaluation reminder process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 FROMDATE Date(10) DATE From Date
5 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
6 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
7 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
8 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID
9 HRS_INT_ID Number(15,0) DECIMAL(15) NOT NULL Interview ID
10 HRS_EVAL_ID Number(15,0) DECIMAL(15) NOT NULL Evaluation ID
11 HRS_INTERVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Interviewer
12 HRS_INT_DT Date(10) DATE Interview date
13 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
14 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
15 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
16 HRS_TODATE Date(10) DATE To Date
17 HRS_DAYS_PRIOR_FR Number(5,0) INTEGER NOT NULL Days Prior From
18 HRS_DAYS_PRIOR_TO Number(5,0) INTEGER NOT NULL Days Prior To
19 HRS_SEND_EVL_REM Character(1) VARCHAR2(1) NOT NULL Send Evaluation Reminders

Y/N Table Edit

Default Value: N

20 HRS_START_TM Time(15) TIMESTAMP Recruiting Solutions Start Time
21 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
22 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone