HRS_PERSON_IDHRS_HIRE_ETHNIC(SQL View) |
Index Back |
|---|---|
PersonDiv EthnicHRS_HIRE_ETHNIC is a wrapper view for HRS_APP_DIV_ETH in PersonService class during Pull Data |
| SELECT HRS_PERSON_ID ,HRS_REG_REGION ,HRS_ETHNIC_GRP_CD ,SETID ,PRIMARY_INDICATOR FROM PS_HRS_APP_DIV_ETH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 3 | ETHNIC_GRP_CD | Character(8) | VARCHAR2(8) NOT NULL | Ethnic group code |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | PRIMARY_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Primary Indicator |