GPAR_NRP_PRC_VW

(SQL View)
 Index Back

View Get Complement Elements A

View Get Complement Elements ARG

SELECT A.GPAR_PRCS_TYPE , A.EFFDT , A.GPAR_LGL_CODE , A.PIN_NUM + 50000000 , A.GPAR_CONTRIB_TP , A.GPAR_AFIP_BASES , A.EFF_STATUS , A.GPAR_REPEAT_MARK FROM PS_GPAR_PRC_TP_DTL A

  • Parent record: GPAR_PRC_TP_DFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPAR_PRCS_TYPE Character(20) VARCHAR2(20) NOT NULL Process Type ARG
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 GPAR_LGL_CODE Character(6) VARCHAR2(6) NOT NULL Legal Codes Argentina

    Prompt Table: GPAR_LGL_CODE

    4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GP_PIN_ED0_VW

    5 GPAR_CONTRIB_TP Character(1) VARCHAR2(1) NOT NULL Contribution Type Argentina
    A=Investment
    B=Both
    C=Contribution
    N=None
    6 GPAR_AFIP_BASES Character(4) VARCHAR2(4) NOT NULL Afip Bases Argentina
    001=Pension System - SIPA
    002=INSSJyP
    003=Social Bennefits
    004=Solidarity Redis Fund exANSSAL
    005=Family assignments
    006=National Employment Fund
    007=Work Risk Law
    008=Mandatory Collec Life Insurace
    009=Differential Regimes
    010=Special Regimes
    011=RENATEA (ex RENATRE)
    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    8 GPAR_REPEAT_MARK Character(1) VARCHAR2(1) NOT NULL Repetition Mark Argentina

    Y/N Table Edit

    Default Value: N