| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
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
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ
Default Value: 6
|
| 5 |
GPCH_SI_PROV_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Provider Code
Prompt Table:
GPCH_SI_PRV_VW1
|
| 6 |
GPCH_PK_INS_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
PK Insurance Plan
Prompt Table:
GPCH_PK_PLANS
|
| 7 |
GPCH_PK_INS_STATUS |
Character(8) |
VARCHAR2(8) NOT NULL |
PK Insurance Status
Prompt Table:
GPCH_PK_STATUS
|
| 8 |
GPCH_PK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PK Status
0=Yes
1=No
2=Default
|
| 9 |
GROUP_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group List
Prompt Table:
GP_GRP_LIST
|
| 10 |
GPCH_PK_ID_INS |
Character(11) |
VARCHAR2(11) NOT NULL |
PK Insurance ID
|
| 11 |
GPCH_PK_ID_ALT |
Number(9,0) |
DECIMAL(9) NOT NULL |
PK Alternate ID
|
| 12 |
GPCH_PK_VALIDASOF |
Date(10) |
DATE |
PK Exit Date
Default Value: GPCH_PK_DAT.EFFDT
|
| 13 |
GPCH_PK_EXIT_DATE |
Date(10) |
DATE |
PK Exit Date
|
| 14 |
GPCH_PK_SALARY |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
PK Salary
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CHF
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
GPCH_PK_IMPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Import
0=Yes
1=No
2=Default
|