LABOR_AGREEMENTSETID_JOBCODEHR_JC_BU_VW(SQL View) |
Index Back |
|---|---|
Job code BU view |
| SELECT DISTINCT B.LABOR_AGREEMENT , B.SETID_JOBCODE , A.SETCNTRLVALUE FROM PS_SET_CNTRL_REC A , PS_HR_LBR_JOBCODE B WHERE A.RECNAME = 'JOBCODE_TBL' AND A.SETCNTRLVALUE IN ( SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_HR) AND A.SETID = B.SETID_JOBCODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 2 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 3 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |