GPES_LBR_AGRMNT

(SQL Table)
 Index Back

Labor agreement general data

Labor agreement general data

  • Parent Record Of GPES_LBR_AT_VW GPES_LBR_BNF_AT GPES_LBR_BNF_CU GPES_LBR_BNF_IT GPES_LBR_BNF_MT GPES_LBR_BNF_PT GPES_LBR_BNF_RE GPES_LBR_BNF_RL GPES_LBR_RE_VW GPES_LBR_SEN GPES_LBR_XTRPER GPES_LBR_XTR_PD GPES_NRP_XT1_VW GPES_PRTAPXTAVW GPES_SEN_BSE_ER UPG_LBRXER_GPES

    • # 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

    Prompt Table: EMPL_CTG

    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 GPES_SEN_CONSL Character(1) VARCHAR2(1) NOT NULL Seniority consolidation flag

    Y/N Table Edit

    Default Value: N

    6 GPES_NEXT_EFFDT Date(10) DATE Effective date value of the next row
    7 GPES_ENT_TYPE_SE1 Character(3) VARCHAR2(3) NOT NULL Seniority duration entry type

    Prompt Table: GPES_ENT_SE1_VW

    8 GPES_PIN_SE1_NUM Number(8,0) INTEGER NOT NULL Seniority Calculation rule Pin Number

    Prompt Table: %GP_EDIT_FLD3

    9 GPES_PIN_SS1_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.

    Prompt Table: %GP_EDIT_FLD5

    10 GPES_PIN_TR1_NUM Number(8,0) INTEGER NOT NULL Pre-advised Daily Salary

    Prompt Table: GP_PIN_AC0_VW

    11 GPES_PIN_TR2_NUM Number(8,0) INTEGER NOT NULL Severance Daily Salary

    Prompt Table: GP_PIN_AC0_VW

    12 GPES_PIN_TR3_NUM Number(8,0) INTEGER NOT NULL Job Litigation Daily Salary

    Prompt Table: GP_PIN_AC0_VW