REG_REGIONY/N Table Edit
HRS_ONLOFR_R_VW(SQL View) |
Index Back |
|---|---|
Regulatory Region Interf ViewRegulatory Region Interface View |
| SELECT A.REG_REGION , A.DESCR50 , 'N' AS HRS_ONLN_OFR_REG FROM PS_REG_REGION_TBL A WHERE A.REG_REGION NOT IN ( SELECT X.REG_REGION FROM PS_HRS_ONLOFR_REGS X) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REG_REGION |
Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | HRS_ONLN_OFR_REG | Character(1) | VARCHAR2(1) NOT NULL |
Multiple job or positions flag.
Y/N Table Edit |