Provides code descriptions for values of UNIT_CD (i.e., Bargaining Unit Code), as well as additional data pertaining to each UCB union.
Published in:- HRBAIRS .
Contains fields:
| EFF_STATUS |
A code describing the effective status of the code (or other element) described by a row of Data Warehouse data. "A" if this row is active; "I" if row is inactive. |
| DESCR |
The full description (name) of a code. |
| CITY |
The City component of an address. |
| UNIT_CD |
Code representing a campus bargaining unit. Examples include: 99 (Non-represented), CX (Clerical Unit), RX (Staff Research Profession Unit), SX (Service Unit). In summary views, this field indicates the bargaining unit summarized in a row of data. |
| CALLBACK_MIN_HOURS |
Minimum callback hours for the union described by this row of lookup table data. |
| CALLBACK_RATE |
Callback rate (factor) for the union described by this row of lookup table data. |
| CERTIFIED |
Indicator regarding whether the union described by this row of lookup data is certified. "Y" if certified; otherwise "N." |
| CLOSED_SHOP |
Indicator regarding whether the union described by this row of lookup data has a closed-shop clause in its contract with UC Berkeley. "Y" if closed shop; otherwise "N". |
| CONTRACT_BEGIN_DT |
Contract begin date for the union described by this row of lookup table data. |
| CONTRACT_END_DT |
Contract end date for the union described by this row of lookup table data. |
| DESCR_SHORT |
The short-description of the code described by this row of lookup table data. |
| DISABILITY_INS |
Disability insurance plan for the union described by this row of lookup table data. |
| LIFE_INS |
Life insurance plan for the union described by this row of lookup table data. |
| SICK_PLAN |
Sick leave plan for the union described by this row of lookup table data. |
| TUITION_LIMIT |
Tuition limit for the union described by this row of lookup table data. |
| UNION_STEWARD_NAME |
The name of the steward for the union described by this row of lookup table data. |
| VACATION_PLAN |
Vacation leave plan for the union described by this row of lookup table data. |
| ADDRESS1 |
The first line of an address. |
| ADDRESS2 |
The second line of an address. |
| CONTACT_NAME |
The name of a contact person described by a row of data. |
| COUNTRY |
The Country component of an address. |
| COUNTY |
The County component of an address. |
| EFF_DT |
The effective date of this row of data. "Effective date" in PeopleSoft data sets means "the date this row of data took effect." |
| PHONE |
A telephone number. |
| STATE |
The State in an address. |
| ZIP_CODE |
The postal Zip Code in an address. |