HR_WP_IDSETID_LBR_AGRMNTPrompt Table: HR_WP_LBR_ST_VW
LABOR_AGREEMENTPrompt Table: HR_WP_ID_LBR_VW
1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table: HR_BARG_UNIT
HR_WP_ID_LABOR(SQL Table) |
Index Back |
|---|---|
WP Run ID Labor AgreementsThis table contains all the labor agreements for a Wage Progression Run ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_WP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Wage Progression Run ID |
| 2 | SETID_LBR_AGRMNT |
Character(5) | VARCHAR2(5) NOT NULL |
Labor Agreement SetID
Prompt Table: HR_WP_LBR_ST_VW |
| 3 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: HR_WP_ID_LBR_VW |
| 4 | BARG_UNIT | Character(4) | VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: HR_BARG_UNIT |