GPMX_SDI_WA_AET

(SQL Table)
Index Back

SDI AET

SDI Process by Anniversary and SMG Change

  • Parent record: PERSONAL_DTA_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    3 GPMX_SRTY Number(8,3) DECIMAL(7,3) NOT NULL Seniority GP Mexico
    4 GPMX_MINWG_EZN Number(15,2) DECIMAL(14,2) NOT NULL Minimum Wage Employee Zone GP Mexico
    5 GPMX_CEIL_DAY_EM Number(15,2) DECIMAL(14,2) NOT NULL Ceiling Days Maternity & Illness GP Mexico
    6 GPMX_CEIL_DAY_IV Number(15,2) DECIMAL(14,2) NOT NULL Ceiling Days Disability and Life GP Mexico
    7 GPMX_MAX_EM Number(15,2) DECIMAL(14,2) NOT NULL Max Ceiling Maternity & Illness GP Mexico
    8 GPMX_MAX_IV Number(15,2) DECIMAL(14,2) NOT NULL Max Ceiling Disability and Life GP Mexico
    9 GPMX_SDI_FACTOR Number(19,6) DECIMAL(18,6) NOT NULL SDI Factor GP Mexico
    10 GPMX_MIN_SAL_DIF Number(15,2) DECIMAL(14,2) NOT NULL Difference SMG and Daily Rate GP Mexico
    11 GPMX_MINWG_AZN Number(15,2) DECIMAL(14,2) NOT NULL Minimum Wage A Zone GP Mexico
    12 GPMX_SDI_FIX Number(15,2) DECIMAL(14,2) NOT NULL Fixed SDI GP Mexico
    13 GPMX_SDI_VAR Number(15,2) DECIMAL(14,2) NOT NULL Variable SDI GP Mexico
    14 GPMX_SDI_TOT Number(15,2) DECIMAL(14,2) NOT NULL SDI Total GP Mexico
    15 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number