GPCH_SI_VARIAN2

(SQL Table)
 Index Back

Social Insurance Table

Social Insurance Table

  • Parent record: GPCH_SI_VARIAN1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: GPCH_SI_VARIAN1.EFFDT

    4 GPCH_SI_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Insurance Type ID
    5 GPCH_SI_ALT_ID Character(8) VARCHAR2(8) NOT NULL Insurance Alternative ID

    Prompt Table: GPCH_SI_ADDTNL2

    6 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
    0=Identify
    1=Others
    2=UVG-LAA
    3=KTG-AMC
    4=UVGZ-LAAC
    5=FAK-CAF
    6=BVG-LPP
    7=AHV-AVS
    8=LAW-CDS
    9=BFS-OFS
    A=QST-IS
    B=Write File
    C=Base AL08
    D=GRFI-FRFI
    E=EO-APG
    I=BNK_BNQ

    Prompt Table: GPCH_SI_ADDTNL1

    7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    8 GPCH_CALCULATE Character(1) VARCHAR2(1) NOT NULL Calculate
    A=Active
    I=Inactive

    Default Value: A

    9 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CHF

    Prompt Table: CURRENCY_CD_TBL