EMPL_CTG(SQL View) |
Index Back |
|---|---|
Labor AgreementLabor Agreement |
| SELECT SETID , LABOR_AGREEMENT , EFFDT , EFF_STATUS , UNION_CD , BARG_UNIT , DESCR , DESCRSHORT , CONTRACT_BEGIN_DT , CONTRACT_END_DT , CNTRCT_RATIFY_DT , LBR_EXPIRY_RULE_ID , CARRYOVR_ACCR_TIME , CARRYOVR_WP_STEP , CARRYOVR_WP_STP_DT , COMMENTS , JOBCODE_FLG , SENIORITY_RULE_FLG , FACILITY_FLG FROM PS_HR_LABOR_AGRMNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_14 |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 6 | BARG_UNIT | Character(4) | VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: HR_BARG_UNIT |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 9 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 10 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 11 | CNTRCT_RATIFY_DT | Date(10) | DATE | Contract Ratified Date |
| 12 | LBR_EXPIRY_RULE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Labor Recall Expiry Rule ID
Prompt Table: HR_RCL_EXP_TBL |
| 13 | CARRYOVR_ACCR_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Wage Progression Hours Worked
Y/N Table Edit |
| 14 | CARRYOVR_WP_STEP | Character(1) | VARCHAR2(1) NOT NULL |
Step ID
Y/N Table Edit |
| 15 | CARRYOVR_WP_STP_DT | Character(1) | VARCHAR2(1) NOT NULL |
Step Entry Date
Y/N Table Edit |
| 16 | COMMENTS | Long Character | CLOB | Comment |
| 17 | JOBCODE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Job Codes |
| 18 | SENIORITY_RULE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Seniority Rules |
| 19 | FACILITY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Facilities |