GPCHAEZV1_VW(SQL View) |
Index Back |
---|---|
Social Insurance TableSocial 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 |
# | 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 |