HR_LBR_GRP_DEFN

(SQL Table)
Index Back

Labor Group Definition

Labor Relations (Layoff/Recall): Used in the user interface to Group Build to define a build a Group Build group definition.

  • Related Language Record: HR_LBR_GRP_LANG
  • Parent Record Of HR_LBR_GRP_JOBS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 ASOFDATE Date(10) DATE NOT NULL As of Date
    5 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: HR_BARG_UNIT

    6 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
    7 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    8 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID

    Prompt Table: HR_LBR_FAC_VW

    9 LBR_EVENT_TYPE Character(1) VARCHAR2(1) NOT NULL Labor event type
    L=Layoff
    R=Recall

    Default Value: L