GPMX_NRP_INT_VW

(SQL View)
 Index Back

Inter-company Parameter Detail

Inter-company Transfer Parameters Detail

SELECT COMPANY , EFFDT , ENTRY_TYPE_ELEM , GPMX_PIN_ANNL_NUM + 50000000 , GPMX_ERNDED_CD FROM PS_GPMX_INT_P_DTL

  • Parent record: GPMX_INT_PARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
    4 GPMX_PIN_ANNL_NUM Number(8,0) INTEGER NOT NULL Multiple Information Pin Number

    Prompt Table: GP_PIN_ACB_VW

    5 GPMX_ERNDED_CD Character(4) VARCHAR2(4) NOT NULL Earning or Deduction Code for Other Employer Table
    0010=Total Earnings
    0020=Non Taxable Christmas Bonus
    0030=Non Taxable Vacation Premium
    0040=Non Taxable Profit Sharing
    0050=Other Non Taxable
    0060=Creditable Subsidy Portion
    0070=Subsidy
    0080=Subsidy NA
    0090=Withheld Tax
    0100=Cash Salary Credit
    0110=Termination Earnings
    0120=Non Taxable Termination
    0130=Taxable Termination Earnings
    0140=Withheld Termination Tax
    0170=Employment Subsidy