GPCHAEZV1_VW

(SQL View)
Index Back

Social Insurance Table

Social Insurance Table

SELECT PROCESS_INSTANCE ,EMPLID ,EMPL_RCD ,EFFDT ,GPCH_SI_TYPE_ID ,GPCH_SI_ALT_ID ,GPCH_SI_PROV_TYPE ,STATUS ,GPCH_CALCULATE ,AMOUNT ,CURRENCY_CD ,BEGIN_DT ,END_DT ,ENDING_DT_PERIOD ,HIRE_DT ,TERMINATION_DT ,GPCH_RP_AMOUNT1 ,GPCH_RP_AMOUNT2 ,GPCH_RP_AMOUNT3 ,GPCH_RP_AMOUNT4 ,GPCH_RP_AMOUNT5 FROM PS_GPCHAEZV1_TMP

  • Parent record: GPCH_SI_VARIAN1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: GPCH_SI_VARIAN1.EFFDT

    5 GPCH_SI_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Insurance Type ID
    010=010-UVG
    030=030 UV CureCost
    040=040 UV Special Risk
    050=050 UV-Daily Pay 80%
    060=060 UV Invalidity Fund
    061=061 UV Invalidity Fund 100'000
    070=070 Death Fund
    071=071 Death Fund 10'000
    080=080 Health Daily 80%
    090=090 Health Base EE
    100=100 Health Additional EE
    110=110 Health Dependends
    999=999 Additional Ins N/A
    K00=Health Insurance 00
    U00=Add. Accident Insurance 00
    6 GPCH_SI_ALT_ID Character(8) VARCHAR2(8) NOT NULL Insurance Alternative ID
    00=Group 0
    01=Group 1
    02=Group 2
    03=(03) from 91st Day
    06=(06) from 181st Day
    09=(09) from 271st Day
    10=(10)Group 1 Category 0
    11=(11)Group 1 Category 1
    12=(12)Group 1 Category 2
    20=(20)Group 2 Category 0
    21=(21)Group 2 Category 1
    22=(22)Group 2 Category 2
    51=(51) 1-times Annual Rate
    52=(52) 2-times Annual Rate
    53=(53) 3-times Annual Rate
    54=(54) 4-times Annual Rate
    55=(55) 5-times Annual Rate
    99=(99) No Alternatives
    A0=Group A Category 0
    A1=Group A Category 1
    A2=Group A Category 2
    B0=Group B Category 0
    B1=Group B Category 1
    B2=Group B Category 2
    C0=Group C Category 0
    C1=Group C Category 1
    C2=Group C Category 2
    F0=Group F Category 0
    7 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
    8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: A

    10 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    12 BEGIN_DT Date(10) DATE Begin Date
    13 END_DT Date(10) DATE end date
    14 ENDING_DT_PERIOD Date(10) DATE Ending date of period
    15 HIRE_DT Date(10) DATE First Start Date
    16 TERMINATION_DT Date(10) DATE Termination Date
    17 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    18 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    19 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    20 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    21 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value