GPBR_MIXED_PARM

(SQL Table)
Index Back

Mixed Parm

Mixed Parm

  • Parent record: GPBR_MIXED_EFF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    6 GPBR_FIELD_OPTION Character(2) VARCHAR2(2) NOT NULL Level Option
    10=Position
    20=Jobcode

    Default Value: 20

    7 GPBR_UNHEALTHY_IND Character(2) VARCHAR2(2) NOT NULL Unhealthy Ind
    00=Default
    01=Minimum Grade
    02=Middle Grade
    04=Maximum Grade
    05=Not Applicable

    Default Value: 05

    8 GPBR_SEFIP_RIS_LVL Character(2) VARCHAR2(2) NOT NULL SEFIP risk lever Brazil
    00=Default
    01=Non Exp.Harmful Agent
    02=Exp. Ret. at 15 years
    03=Exp. Ret. at 20 years
    04=Exp. Ret. at 25 years
    05=Non Exp. Harmful Agent M.Jobs
    06=Exp. Ret. at 15 years M.Jobs
    07=Exp. Ret. at 20 years M.Jobs
    08=Exp. Ret. at 25 years M.Jobs
    09=Not Applicable

    Default Value: 09

    9 GPBR_RISK_IND Character(2) VARCHAR2(2) NOT NULL Hazardous Indicator Brazil
    00=Default
    01=Applicable
    02=Not Applicable

    Default Value: 02