GPCH_SI_UV_PCT

(SQL Table)
 Index Back

Provider Table

for percentages per provider

  • Parent record: GPCH_SI_PROVIDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code

    Prompt Table: GPCH_SI_PROVIDR

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 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
    5 GPCH_SI_TOT_NBU_PC Number(8,4) DECIMAL(7,4) NOT NULL Total Contribution NBU %
    6 GPCH_SI_EE_NBU_PCT Number(8,4) DECIMAL(7,4) NOT NULL Employee Contribution NBU
    7 GPCH_SI_BU_PCT Number(8,4) DECIMAL(7,4) NOT NULL Employer Contribution BU %