| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_SITE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Site ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 4 |
HRS_RES_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume Template ID
Prompt Table:
HRS_RES_TMPL
|
| 5 |
APP_PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant
E=Employee
N=Non-Employee
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
HRS_COUNTRY_VW
|
| 7 |
HRS_DIS_SELF_IDFY |
Character(1) |
VARCHAR2(1) NOT NULL |
OFCCP Self - Identify
B=Disability and Veteran
D=Disability
N=Not Applicable
V=Veteran
Default Value: N
|
| 8 |
HRS_SIMP_VET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Simplified Veteran Page
Y/N Table Edit
Default Value: N
|
| 9 |
HRS_EXTRACTOR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Used to store the extractor in Source.
Prompt Table:
HRS_EXTRCTR_I
|
| 10 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SET_VLD_HR_01
|
| 11 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table:
PORTAL_NAME_VW
|
| 12 |
HRS_EXT_ERP_SITE |
Number(15,0) |
DECIMAL(15) NOT NULL |
External ERP Site
Prompt Table:
HRS_EXTSITE_PT
|
| 13 |
HRS_SHO_APPLY_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
setting to indicate when Apply Without Selecting a Job is allowed.
B=Display Both Top and Bottom
N=Not Displayed
T=Display Top Only
Y=Display Bottom Only
Default Value: Y
|
| 14 |
HRS_JOB_SRCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Default setting for Job Search criteria for Candidate Gateway
A=Advanced Search
B=Basic Search
Default Value: B
|
| 15 |
HRS_WELCOME_DISPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Welcome Page setting field
N=No
Y=Yes
Default Value: N
|
| 16 |
HRS_WELCOME_PG |
Long Character |
CLOB |
Welcome Page contents edited by RTE
|
| 17 |
HRS_SSIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Start Step Instruction
N=No
Y=Yes
Default Value: Y
|
| 18 |
HRS_SSACT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Start Step Administrator
N=No
Y=Yes
Default Value: N
|
| 19 |
HRS_SSGP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Guided Process Instru
N=No
Y=Yes
|
| 20 |
HRS_ATAG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Application Terms and Agreements
N=No
Y=Yes
Default Value: Y
|
| 21 |
HRS_PTAG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Prequalification Terms and Agreements
N=No
Y=Yes
Default Value: Y
|
| 22 |
HRS_REQ_ANS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Answers to Online Questionare
N=No
Y=Yes
Default Value: Y
|
| 23 |
HRS_SHO_HOT_JOBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Hot Jobs
N=No Show
Y=Show
Default Value: N
|
| 24 |
HRS_SHO_BUS_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
show Business Unit in job search grid
Y/N Table Edit
Default Value: N
|
| 25 |
HRS_SHO_JOB_FAM |
Character(1) |
VARCHAR2(1) NOT NULL |
show Job Family as one of search criteria for Job search
Y/N Table Edit
Default Value: Y
|
| 26 |
HRS_SHO_JOB_FN |
Character(1) |
VARCHAR2(1) NOT NULL |
show Job Function as one of search criteria for Job search
Y/N Table Edit
Default Value: N
|
| 27 |
HRS_SHO_MULTI_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator for Candidate gateway to show multiple selections on Job search Page.
Default Value: N
|
| 28 |
HRS_SHO_ALT_CHAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Display Alternate Character
1NON=None
2NAM=Name
3ADD=Address
4BTH=Name & Address
5ORG=Organization
Default Value: 1NON
|
| 29 |
HRS_SHO_NAME_FMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Name Format
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 30 |
HRS_SHO_RES_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Resume Language
Y/N Table Edit
Default Value: N
|
| 31 |
HRS_REGISTER_NOTFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to check if email notification for registration is turned on.
Y/N Table Edit
Default Value: N
|
| 32 |
HRS_REG_TEMPLT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template to be used in Registration Notification.
Default Value: HRS_APP_NOTIF_REG
Prompt Table:
WL_TEMPLATE_GEN
|
| 33 |
HRS_DRAFTAPP_NOTFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to check if email notification for unsubmitted/drafted applications is turned on.
Y/N Table Edit
Default Value: N
|
| 34 |
HRS_USUB_TEMPLT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template to be used in Registration Notification.
Default Value: HRS_APP_NOTIF_UNS
Prompt Table:
WL_TEMPLATE_GEN
|
| 35 |
HRS_STOP_NOTFY_HRS |
Number(3,0) |
SMALLINT NOT NULL |
Field to store number of hours before job close date when the notification need to be stopped for unsubmitted/draft notifications.
|
| 36 |
HRS_REMINDER_DAYS |
Number(2,0) |
SMALLINT NOT NULL |
Field to store number of days after which a repeat reminder to be sent.
|
| 37 |
HRS_APPL_ACK3_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Application Acknowledgement ID
Prompt Table:
HRS_ESIGN_DVW
|
| 38 |
HRS_APPL_ACK1_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Application Acknowledgement ID
Prompt Table:
HRS_ESIGN_DVW
|
| 39 |
HRS_APPL_ACK2_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Application Acknowledgement ID
Prompt Table:
HRS_ESIGN_DVW
|
| 40 |
HRS_APPL_PREQ_ACK |
Character(5) |
VARCHAR2(5) NOT NULL |
Prequalification Acknowledgement ID
Prompt Table:
HRS_ESIGN_DVW
|
| 41 |
HRS_REG_ACK_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Registration Acknowledgement ID
Prompt Table:
HRS_ESIGN_DVW
|
| 42 |
HRS_LIST_VW |
Character(1) |
VARCHAR2(1) NOT NULL |
Default List View
G=Grid View
L=List View
Default Value: L
|
| 43 |
HRS_GRID_VW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Search Results Display
B=Both
G=Grid View
L=List View
Default Value: L
|
| 44 |
HRS_SAVE_BUTTON |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Save button
N=No
Y=Yes
Default Value: N
|
| 45 |
HRS_CB_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Chat Bot Enabled Field
N=No
Y=Yes
Default Value: N
|
| 46 |
HRS_CNT_BT_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Us Button Enabled Field
N=No
Y=Yes
Default Value: N
|
| 47 |
HRS_CNT_BT_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Us Button Enabled Field
N=No
Y=Yes
Default Value: N
|
| 48 |
HRS_FAQ_BT_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
FAQs Button Enabled Field
N=No
Y=Yes
Default Value: N
|
| 49 |
HRS_FAQ_BT_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Us Button Enabled Field
I=Show Icon
L=Show Label
Default Value: I
|
| 50 |
HRS_WCD_BT_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
FAQs Button Enabled Field
N=No
Y=Yes
Default Value: N
|
| 51 |
HRS_WCD_BT_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Us Button Enabled Field
I=Show Icon
L=Show Label
Default Value: L
|
| 52 |
HRS_EMAIL_ADDR |
Character(200) |
VARCHAR2(200) NOT NULL |
Email Address
|
| 53 |
HRS_PHONE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Phone
|
| 54 |
HRS_SPLIT_MULTI_JO |
Character(1) |
VARCHAR2(1) NOT NULL |
PSFTREC-10724 - Breakout Multiple Applications on My Application page
N=No
Y=Yes
Default Value: N
|
| 55 |
HRS_ACCESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
enable screen reader mode
N=No
Y=Yes
Default Value: N
|
| 56 |
HRS_GENDER_LBL_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Gender Field Label
Default Value: N
|
| 57 |
HRS_GEND_LBL_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Gender Field Label Description
|
| 58 |
HRS_DSPL_ACC_HELP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Accessibility Help
Y/N Table Edit
|