The translation list of valid bargaining unit names. While each job title code has an
associated bargaining unit, the employee is represented by the bargaining unit of the job
title on the appointment with the largest percentage of time. The Bargaining unit is
referenced by several different names, all meaning basically the same thing: Title Unit
Code (TUC), Employee Unit Code (EUC), Bargaining Unit Code (BUC) and Collective Bargaining
Unit Code (CBUC). The data originates from the Payroll Control Table (CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| BUT_BARG_AGT_ADDR1 | BARGAINING AGENT ADDRESS LINE 1 | VARCHAR2(30) | NOT USED. The first line of the address designated by the bargaining agent. |
| BUT_BARG_AGT_ADDR2 | BARGAINING AGENT ADDRESS LINE 2 | VARCHAR2(30) | NOT USED. The second line of the address designated by the bargaining agent. |
| BUT_BARG_AGT_ADDR3 | BARGAINING AGENT ADDRESS LINE 3 | VARCHAR2(30) | NOT USED. The third line of the address designated by the bargaining agent. |
| BUT_BARG_AGT_ADDR4 | BARGAINING AGENT ADDRESS LINE 4 | VARCHAR2(30) | NOT USED. The fourth line of the address designated by the bargaining agent. |
| BUT_BARG_AGT_ADDR5 | BARGAINING AGENT ADDRESS LINE 5 | VARCHAR2(30) | NOT USED. The fifth line of the address designated by the bargaining agent. |
| BUT_BARG_AGT_CODE | BARGAINING AGENT NAME ABBREVIATED | VARCHAR2(6) | The abbreviated name of the bargaining agent that exclusively represents the bargaining unit. |
| BUT_BARG_AGT_NAME | BARGAINING AGENT NAME | VARCHAR2(38) | The full name of the bargaining agent. |
| BUT_BARG_AGT_NUMB | BARGAINING AGENT LOCAL NUMBER | VARCHAR2(9) | A number identifying a local branch of the bargaining agent. |
| BUT_BUC | BARGAINING UNIT CODE | VARCHAR2(2) | The code indicating the type of bargaining unit.(primary key) |
| BUT_BUC_DESCRIP | BARGAINING UNIT NAME | VARCHAR2(32) | The description of the bargaining unit. |
| BUT_EXCLSV_REP_SW | EXCLUSIVE REPRESENTATION FLAG | VARCHAR2(1) | The code indicating whether a bargaining unit is exclusively represented. |
| BUT_LAST_ACTION | LAST ACTION | VARCHAR2(1) | The code indicating the most recent action. |
| BUT_LAST_ACTION_DT | LAST ACTION DATE | DATE | The effective date of the most recent action. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: April 8, 1999