HRS_SITE_ID(SQL Table) |
Index Back |
|---|---|
RS Site TableRS Site Table |
| # | 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 |