| # |
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
|