HRS_SITE_IDA=External Applicant
E=Employee
N=Non-Employee
Prompt Table: HRS_COUNTRY_VW
Prompt Table: HRS_EXTRCTR_I
HRS_SITE_ID_I(SQL View) |
Index Back |
|---|---|
Site ID InterfaceThis is an interface view into HRS_SITE_ID, which contains all of the Sites that a customer sets up for the recruiting implementation. |
| SELECT HRS_SITE_ID , DESCR , DESCRSHORT , APP_PER_STATUS , COUNTRY , HRS_EXTRACTOR_ID , SETID , PORTAL_NAME , HRS_EXT_ERP_SITE 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 | 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 |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: HRS_COUNTRY_VW |
| 6 | HRS_EXTRACTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used to store the extractor in Source.
Prompt Table: HRS_EXTRCTR_I |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 9 | HRS_EXT_ERP_SITE | Number(15,0) | DECIMAL(15) NOT NULL | External ERP Site |