| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
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
Prompt Table:
GPCH_SI_ADDTNL1
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
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
|
| 5 |
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
|
| 6 |
GPCH_RATE_M |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Total Premium Rate Male
|
| 7 |
GPCH_RATE_F |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Total Premium Rate Female
|
| 8 |
GPCH_RATE2_M |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Total Premium/Person Male
|
| 9 |
GPCH_RATE2_F |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Total Premium/Person Female
|
| 10 |
GPCH_LOW_SALARY |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Salary Lower Limit
|
| 11 |
GPCH_HIGH_SALARY |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Salary Higher Level
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CHF
Prompt Table:
CURRENCY_CD_TBL
|
| 13 |
GPCH_PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
GP_PIN_ER0_VW
|
| 14 |
GPCH_PIN_NUM01 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
GP_PIN_ER0_VW
|
| 15 |
GPCH_PIN_NUM02 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
GP_PIN_AC0_VW
|
| 16 |
GPCH_PIN_NUM03 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 17 |
GPCH_PIN_NUM04 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 18 |
GPCH_PIN_NUM05 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 19 |
GPCH_PIN_NUM06 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 20 |
GPCH_PIN_NUM07 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 21 |
GPCH_PIN_NUM08 |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 22 |
GPCH_ZV_DFLT_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
GPCH_ZV_DFLT_GRP
Y/N Table Edit
|
| 23 |
GPCH_ZV_DFLT_SPLIT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default Split
Prompt Table:
GPCH_SI_GRD_VW
|