GPCH_SI_ACC_INS

(SQL Table)
 Index Back

Company Social Insurance Date

Company Social Insurance Date

  • Parent record: GPCH_SI_COMPANY

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

    Prompt Table: COMPANY_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: COMPANY_TBL.EFFDT

    3 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
    E=EO-APG
    4 GPCH_TX_UV_PROV_CD Character(6) VARCHAR2(6) NOT NULL Accident Insurance Provider

    Prompt Table: GPCH_SI_PROV_VW

    5 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: GPCH_TX_CANT_VW

    6 GPCH_ALL_CANTONFLG Character(1) VARCHAR2(1) NOT NULL Flag for All cantons

    Y/N Table Edit

    7 GPCH_UV_PRIMARY Character(1) VARCHAR2(1) NOT NULL Primary Provider

    Y/N Table Edit

    Default Value: Y

    8 GPCH_SI_UV_MBR_ID Character(20) VARCHAR2(20) NOT NULL Accident Insurance ID
    9 GPCH_SI_MBR_SUBID Character(20) VARCHAR2(20) NOT NULL Sub ID /Contract
    10 GPCH_SI_COV_UV Character(1) VARCHAR2(1) NOT NULL Risk Group
    A=Risk Group A
    B=Risk Group B
    C=Risk Group C
    D=Risk Group D
    E=Risk Group E
    F=Risk Group F
    G=Risk Group G
    H=Risk Group H
    I=Risk Group I
    J=Risk Group J
    K=Risk Group K
    L=Risk Group L
    M=Risk Group M
    N=Risk Group N
    O=Risk Group O
    P=Risk Group P
    Q=Risk Group Q
    R=Risk Group R
    S=Risk Group S
    T=Risk Group T
    U=Risk Group U
    V=Risk Group V
    W=Risk Group W
    X=Risk Group X
    Y=Risk Group Y
    Z=Risk Group Z
    11 GPCH_TX_UV_STATUS Character(1) VARCHAR2(1) NOT NULL Accident Insurance Status
    0=0 None
    1=1 NBU Employee
    2=2 NBU Employer
    3=3 BU only