BARG_UNIT1=Bargaining Unit 1
2=Bargaining Unit 2
LANGUAGE_CDHR_BARGUPMT_LNG(SQL View) |
Index Back |
|---|---|
Bargaining Unit Prompt ViewRelated Lang - Bargaining Unit Prompt View |
| SELECT BARG.BARG_UNIT ,BARG.LANGUAGE_CD ,BARG.DESCR FROM PS_HR_BARG_U_LANG BARG WHERE BARG.BARG_UNIT NOT IN ( SELECT LBR.BARG_UNIT FROM PS_HR_LABOR_AGRMNT LBR WHERE LBR.EFF_STATUS='A' AND LBR.EFFDT >= ( SELECT MAX(EFFDT) FROM PS_HR_LABOR_AGRMNT LBR2 WHERE LBR.SETID = LBR2.SETID AND LBR.LABOR_AGREEMENT = LBR2.LABOR_AGREEMENT AND LBR2.EFFDT <=%CurrentDateIn)) AND BARG.EFFDT= ( SELECT MAX(EFFDT) FROM PS_HR_BARG_UNIT BARG2 WHERE BARG.BARG_UNIT = BARG2.BARG_UNIT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BARG_UNIT |
Character(4) | VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1 2=Bargaining Unit 2 |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |