LABOR_AGREEMENTSETIDHR_REGREGION_VW(SQL View) |
Index Back |
|---|---|
Labor Agreement RegRegion ViewView to select the Reg Regions for the Labor Agreement |
| SELECT C.LABOR_AGREEMENT , C.SETID , A.REG_REGION FROM PS_REG_TRX_REGION A , PS_HR_LABOR_AGRMNT C WHERE A.REG_TRX = 'STANDARD' AND A.REG_REGION IN ( SELECT B.SETCNTRLVALUE FROM PS_SET_CNTRL_REC B WHERE B.RECNAME = 'HR_LABOR_AGRMNT' AND B.SETID = C.SETID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |