HRS_SITE_IDPrompt Table: HRS_RES_TMPL
A=External Applicant
E=Employee
N=Non-Employee
Prompt Table: HRS_COUNTRY_VW
Prompt Table: HRS_EXTRCTR_I
Prompt Table: SET_VLD_HR_01
Prompt Table: PORTAL_NAME_VW
HRS_SITE_SRCH(SQL View) |
Index Back |
|---|---|
RS Site TableRS Site Table |
| SELECT HRS_SITE_ID , DESCR , DESCRSHORT , HRS_RES_TMPL_ID , APP_PER_STATUS , COUNTRY , HRS_EXTRACTOR_ID , SETID , PORTAL_NAME FROM PS_HRS_SITE_ID |
| # | 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_EXTRACTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used to store the extractor in Source.
Prompt Table: HRS_EXTRCTR_I |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_01 |
| 9 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: PORTAL_NAME_VW |