GPMX_SUB_CALC

(SQL Table)
Index Back

Subsidy Factor Calculation

Subsidy Factor Calculation

  • Parent record: GPMX_SUB_FACTOR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPMX_BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balance Year GP Mexico
    3 GPMX_TOT_EARN_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Earnings Amount
    4 GPMX_TAXABLE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxable Amount
    5 GPMX_OTH_PAY_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Earnings Amount
    6 GPMX_PROPORTION Signed Number(20,6) DECIMAL(18,6) NOT NULL Proportion Amount
    7 GPMX_SUB_NON_ACR Signed Number(20,6) DECIMAL(18,6) NOT NULL Non Creditable Subsidy Amount
    8 GPMX_SUB_ACRED_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Creditable Subsidy Amount