GPCHPK011_TMP(SQL Table) |
Index Back |
---|---|
WA for Download ProcessWA for Download Process |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPCH_PK_LASAZ | Character(2) | VARCHAR2(2) NOT NULL | Record (always LA) |
2 | GPCH_PK_LASTS | Character(1) | VARCHAR2(1) NOT NULL | Status (always 0) |
3 | GPCH_PK_LAKAS | Character(3) | VARCHAR2(3) NOT NULL | Pension Fund No. |
4 | GPCH_PK_LAVBN | Character(9) | VARCHAR2(9) NOT NULL | Insurance No. |
5 | GPCH_PK_LANAM | Character(30) | VARCHAR2(30) NOT NULL | Name |
6 | GPCH_PK_LAVNA | Character(15) | VARCHAR2(15) NOT NULL | First Name |
7 | GPCH_PK_LANA2 | Character(30) | VARCHAR2(30) NOT NULL | Name 2 |
8 | GPCH_PK_LASTR | Character(30) | VARCHAR2(30) NOT NULL | Street |
9 | GPCH_PK_LALAN | Character(3) | VARCHAR2(3) NOT NULL | Country |
10 | GPCH_PK_LAPLZ | Character(5) | VARCHAR2(5) NOT NULL | Postal Code |
11 | GPCH_PK_LAORT | Character(30) | VARCHAR2(30) NOT NULL | City |
12 | GPCH_PK_LAANC | Character(1) | VARCHAR2(1) NOT NULL |
Prefix
1=Mister 2=Mrs 3=Miss 4=Doctor Male 6=Doctor Female 9=Ms |
13 | GPCH_PK_LASPR | Character(1) | VARCHAR2(1) NOT NULL | Language |
14 | GPCH_PK_LAPFL | Character(2) | VARCHAR2(2) NOT NULL | Postal Code - following number |
15 | GPCH_PK_LAUNT | Character(3) | VARCHAR2(3) NOT NULL | Pay Company |
16 | GPCH_PK_LALEE | Character(5) | VARCHAR2(5) NOT NULL | Blank field-E (always blank) |
17 | GPCH_PK_LATX1 | Character(30) | VARCHAR2(30) NOT NULL | Free text-1 |
18 | GPCH_PK_LATX2 | Character(30) | VARCHAR2(30) NOT NULL | Free text-2 |
19 | GPCH_PK_LATX3 | Character(30) | VARCHAR2(30) NOT NULL | Free text-3 |
20 | GPCH_PK_LALEA | Character(10) | VARCHAR2(10) NOT NULL | Blank field-A (always blank) |
21 | GPCH_PK_LASEX | Character(1) | VARCHAR2(1) NOT NULL | Sex |
22 | GPCH_PK_LAZCD | Character(1) | VARCHAR2(1) NOT NULL | Marital status |
23 | GPCH_PK_LAAHV | Character(15) | VARCHAR2(15) NOT NULL | AHV No. (NID) |
24 | GPCH_PK_LANAT | Character(3) | VARCHAR2(3) NOT NULL | Nationality (ISO Norm) |
25 | GPCH_PK_LAGJ1 | Character(2) | VARCHAR2(2) NOT NULL | Birthdate - century |
26 | GPCH_PK_LAGJ2 | Character(2) | VARCHAR2(2) NOT NULL | Birthdate - year |
27 | GPCH_PK_LAGMO | Character(2) | VARCHAR2(2) NOT NULL | Birthdate - months |
28 | GPCH_PK_LAGTG | Character(2) | VARCHAR2(2) NOT NULL | Birthdate - day |
29 | GPCH_PK_LATJ1 | Character(2) | VARCHAR2(2) NOT NULL | Date of Death - century |
30 | GPCH_PK_LATJ2 | Character(2) | VARCHAR2(2) NOT NULL | Date of Death - year |
31 | GPCH_PK_LATJ3 | Character(2) | VARCHAR2(2) NOT NULL | Date of Death - months |
32 | GPCH_PK_LATJ4 | Character(2) | VARCHAR2(2) NOT NULL | Date of Death - day |
33 | GPCH_PK_LAFC1 | Character(4) | VARCHAR2(4) NOT NULL | Free Code 1 |
34 | GPCH_PK_LAFC2 | Character(4) | VARCHAR2(4) NOT NULL | Free Code 2 |
35 | GPCH_PK_LANBU | Character(1) | VARCHAR2(1) NOT NULL | Code Note-book |
36 | GPCH_PK_LATVD | Character(1) | VARCHAR2(1) NOT NULL | Code technical data insured person |
37 | GPCH_PK_LATBD | Character(1) | VARCHAR2(1) NOT NULL | Code technical data beneficiary |
38 | GPCH_PK_LAIAP | Character(1) | VARCHAR2(1) NOT NULL | Code usage int. Address (identification card) |
39 | GPCH_PK_LAIAN | Character(1) | VARCHAR2(1) NOT NULL | Code usage int. Address (note-book) |
40 | GPCH_PK_LALEB | Character(1) | VARCHAR2(1) NOT NULL | Incident code (always blank) |
41 | GPCH_PK_LAZNA | Character(30) | VARCHAR2(30) NOT NULL | Payment Address - Name (always blank) |
42 | GPCH_PK_LAZN2 | Character(30) | VARCHAR2(30) NOT NULL | Payment Address - Name 2 (always blank) |
43 | GPCH_PK_LAZST | Character(30) | VARCHAR2(30) NOT NULL | Payment Address - Street (always blank) |
44 | GPCH_PK_LAZLA | Character(3) | VARCHAR2(3) NOT NULL | Payment Address - Country (always blank) |
45 | GPCH_PK_LAZPL | Character(5) | VARCHAR2(5) NOT NULL | Payment Address - Postal Code (always blank) |
46 | GPCH_PK_LAZOR | Character(30) | VARCHAR2(30) NOT NULL | Payment Address - City (always blank) |
47 | GPCH_PK_LACNR | Character(12) | VARCHAR2(12) NOT NULL | Payment Address - Clearing Bank (always blank) |
48 | GPCH_PK_LAKTO | Character(21) | VARCHAR2(21) NOT NULL | Payment Address - Bank Account (always blank) |
49 | GPCH_PK_LABER | Character(3) | VARCHAR2(3) NOT NULL | Pay area number (P400) |
50 | GPCH_PK_LAPCN | Character(9) | VARCHAR2(9) NOT NULL | Blank field (always blank) |
51 | GPCH_PK_LALVC | Character(3) | VARCHAR2(3) NOT NULL | Interface code to payroll system |
52 | GPCH_PK_LALNR | Character(3) | VARCHAR2(3) NOT NULL | Pay company |
53 | GPCH_PK_LAPNR | Character(6) | VARCHAR2(6) NOT NULL | Payroll - EMPLID |
54 | GPCH_PK_LASFA | Character(1) | VARCHAR2(1) NOT NULL | Stoppage code |
55 | GPCH_PK_LAVKA | Character(3) | VARCHAR2(3) NOT NULL | Blank field (fill with 0) |
56 | GPCH_PK_LAVPN | Character(9) | VARCHAR2(9) NOT NULL | Blank field (fill with 0) |
57 | GPCH_PK_LASNA | Character(20) | VARCHAR2(20) NOT NULL | Search item Name /first name (fill with blank) |
58 | GPCH_PK_LAITE | Character(10) | VARCHAR2(10) NOT NULL | Internal phone number |
59 | GPCH_PK_LAETE | Character(20) | VARCHAR2(20) NOT NULL | External phone number |
60 | GPCH_PK_LAZPS | Character(30) | VARCHAR2(30) NOT NULL | Responsible HR-Area |
61 | GPCH_PK_LALEC | Character(6) | VARCHAR2(6) NOT NULL | Life canton (country code plate) - left aligned |
62 | GPCH_PK_LAPCA | Character(20) | VARCHAR2(20) NOT NULL | PC number for payment address (for insured person = blank) |
63 | GPCH_PK_LAMJ1 | Character(2) | VARCHAR2(2) NOT NULL | Last Change Date century (creation date of record) |
64 | GPCH_PK_LAMJ2 | Character(2) | VARCHAR2(2) NOT NULL | Last Change Date year (creation date of record) |
65 | GPCH_PK_LAMMO | Character(2) | VARCHAR2(2) NOT NULL | Last Change Date month (creation date of record) |
66 | GPCH_PK_LAMTG | Character(2) | VARCHAR2(2) NOT NULL | Last Change Date day (creation date of record) |
67 | GPCH_PK_LAOJ1 | Character(2) | VARCHAR2(2) NOT NULL | Opening date century (creation date of record) |
68 | GPCH_PK_LAOJ2 | Character(2) | VARCHAR2(2) NOT NULL | Opening date year (creation date of record) |
69 | GPCH_PK_LAOMO | Character(2) | VARCHAR2(2) NOT NULL | Opening date month (creation date of record) |
70 | GPCH_PK_LAOTG | Character(2) | VARCHAR2(2) NOT NULL | Opening date day (creation date of record) |
71 | GPCH_PK_LAKST | Character(9) | VARCHAR2(9) NOT NULL | Department ID |
72 | GPCH_PK_LAKTX | Character(30) | VARCHAR2(30) NOT NULL | Department description |
73 | GPCH_PK_LAABT | Character(30) | VARCHAR2(30) NOT NULL | Internal address |
74 | GPCH_PK_LAAON | Character(9) | VARCHAR2(9) NOT NULL | Location ID |
75 | GPCH_PK_LAATX | Character(30) | VARCHAR2(30) NOT NULL | Location description |
76 | GPCH_PK_LALED | Character(52) | VARCHAR2(52) NOT NULL | Blank field D (always blank) |
77 | GPCH_PK_LAALN | Character(3) | VARCHAR2(3) NOT NULL | Blank field (always blank) |
78 | GPCH_PK_LAAPN | Character(6) | VARCHAR2(6) NOT NULL | Sequence number (always 0) |
79 | GPCH_PK_LAPIB | Character(9) | VARCHAR2(9) NOT NULL | Payroll - EMPLID |
80 | GPCH_PK_LASPE | Character(4) | VARCHAR2(4) NOT NULL | Change control code for transfer from PIS |
81 | GPCH_PK_LADSA | Character(3) | VARCHAR2(3) NOT NULL | Pay out code SAD/DTA |
82 | GPCH_PK_LASTA | Character(1) | VARCHAR2(1) NOT NULL | Group Status for FLZ |
83 | GPCH_PK_LAVPA | Character(2) | VARCHAR2(2) NOT NULL | Group Plan |
84 | GPCH_PK_LALEF | Character(14) | VARCHAR2(14) NOT NULL | Blank field F (always blank) |
85 | GPCH_PK_LAKP1 | Character(2) | VARCHAR2(2) NOT NULL | Entry date techn. Balance sheet century (else blank) |
86 | GPCH_PK_LAKP2 | Character(2) | VARCHAR2(2) NOT NULL | Entry date techn. Balance sheet year (else blank) |
87 | GPCH_PK_LAKPM | Character(2) | VARCHAR2(2) NOT NULL | Entry date techn. Balance sheet month (else blank) |
88 | GPCH_PK_LAKPT | Character(2) | VARCHAR2(2) NOT NULL | Entry date techn. Balance sheet day (else blank) |
89 | GPCH_PK_LAVST | Character(1) | VARCHAR2(1) NOT NULL | Insurance status |
90 | GPCH_PK_LAVPL | Character(2) | VARCHAR2(2) NOT NULL | Insurance plan |
91 | GPCH_PK_LAEJ1 | Character(2) | VARCHAR2(2) NOT NULL | Entry date in pension fund century |
92 | GPCH_PK_LAEJ2 | Character(2) | VARCHAR2(2) NOT NULL | Entry date in pension fund year |
93 | GPCH_PK_LAEMO | Character(2) | VARCHAR2(2) NOT NULL | Entry date in pension fund month |
94 | GPCH_PK_LAETG | Character(2) | VARCHAR2(2) NOT NULL | Entry date in pension fund day |
95 | GPCH_PK_LAAU1 | Character(2) | VARCHAR2(2) NOT NULL | Term. Date in pension fund century |
96 | GPCH_PK_LAAU2 | Character(2) | VARCHAR2(2) NOT NULL | Term. Date in pension fund year |
97 | GPCH_PK_LAAUM | Character(2) | VARCHAR2(2) NOT NULL | Term. Date in pension fund month |
98 | GPCH_PK_LAAUT | Character(2) | VARCHAR2(2) NOT NULL | Term. Date in pension fund day |
99 | GPCH_PK_LABBS | Character(1) | VARCHAR2(1) NOT NULL | BVG possession status for coord. Salary |
100 | GPCH_PK_LANGB | Character(7) | VARCHAR2(7) NOT NULL | BVG FTE in % ( 0 = 100%) |
101 | GPCH_PK_LALEG | Character(2) | VARCHAR2(2) NOT NULL | Blank field G (always blank) |
102 | GPCH_PK_LABPK | Character(7) | VARCHAR2(7) NOT NULL | BVG-coordination-%-quota (0=100%) |
103 | GPCH_PK_LABPJ | Character(9) | VARCHAR2(9) NOT NULL | BVG obligatory salary per year (at 100%) |
104 | GPCH_PK_LABBB | Character(9) | VARCHAR2(9) NOT NULL | BVG annual salary |
105 | GPCH_PK_LANKB | Character(9) | VARCHAR2(9) NOT NULL | BVG correction annual gross salary |
106 | GPCH_PK_LANVB | Character(9) | VARCHAR2(9) NOT NULL | BVG coord. Salary per year (calculated by PEKA) |
107 | GPCH_PK_LAA50 | Character(9) | VARCHAR2(9) NOT NULL | BVG old age assets as of age 50 |
108 | GPCH_PK_LAFBS | Character(1) | VARCHAR2(1) NOT NULL | Free possession status for insured salary |
109 | GPCH_PK_LANGF | Character(7) | VARCHAR2(7) NOT NULL | Free FTE % (0 = 100%) |
110 | GPCH_PK_LALEI | Character(2) | VARCHAR2(2) NOT NULL | Blank field I (always blank) |
111 | GPCH_PK_LAFPK | Character(7) | VARCHAR2(7) NOT NULL | Free coordination-%-quota (0=100%) |
112 | GPCH_PK_LAFPJ | Character(9) | VARCHAR2(9) NOT NULL | Free obligatory salary per year (at 100%) |
113 | GPCH_PK_LANAF | Character(9) | VARCHAR2(9) NOT NULL | Free annual gross salary |
114 | GPCH_PK_LANKF | Character(9) | VARCHAR2(9) NOT NULL | Free correction annual gross salary |
115 | GPCH_PK_LANVF | Character(9) | VARCHAR2(9) NOT NULL | Free insured salary per year (calculated by PEKA) |
116 | GPCH_PK_LAF50 | Character(9) | VARCHAR2(9) NOT NULL | Free old age assets as of age 50 |
117 | GPCH_PK_LAAJ1 | Character(2) | VARCHAR2(2) NOT NULL | Effective date of new salary century |
118 | GPCH_PK_LAAJ2 | Character(2) | VARCHAR2(2) NOT NULL | Effective date of new salary year |
119 | GPCH_PK_LAAMO | Character(2) | VARCHAR2(2) NOT NULL | Effective date of new salary month |
120 | GPCH_PK_LAATG | Character(2) | VARCHAR2(2) NOT NULL | Effective date of new salary day |
121 | GPCH_PK_LAVBG | Character(7) | VARCHAR2(7) NOT NULL | BVG FTE % previous year |
122 | GPCH_PK_LAVBM | Character(9) | VARCHAR2(9) NOT NULL | BVG obligatory salary per month ( at 100% - previous year) |
123 | GPCH_PK_LAVBJ | Character(9) | VARCHAR2(9) NOT NULL | BVG obligatory salary per year ( at 100% - previous year) |
124 | GPCH_PK_LAVBB | Character(9) | VARCHAR2(9) NOT NULL | BVG annual gross salary (previous year) |
125 | GPCH_PK_LAVBK | Character(9) | VARCHAR2(9) NOT NULL | BVG correction annual gross salary (previous year) |
126 | GPCH_PK_LAVBL | Character(9) | VARCHAR2(9) NOT NULL | BVG coord. Salary per year (previous year) |
127 | GPCH_PK_LAVFG | Character(7) | VARCHAR2(7) NOT NULL | Free FTE % (previous year) |
128 | GPCH_PK_LAVFM | Character(9) | VARCHAR2(9) NOT NULL | Free obligatory salary per year (at 100% - previous year) |
129 | GPCH_PK_LAVFJ | Character(9) | VARCHAR2(9) NOT NULL | Free obligatory salary per year ( at 100% - previous year) |
130 | GPCH_PK_LAVFB | Character(9) | VARCHAR2(9) NOT NULL | Free annual gross salary (previous year) |
131 | GPCH_PK_LAVFK | Character(9) | VARCHAR2(9) NOT NULL | Free correction annual gross salary (previous year) |
132 | GPCH_PK_LAVFL | Character(9) | VARCHAR2(9) NOT NULL | Free insured salary per year (previous year) |
133 | GPCH_PK_LALEH | Character(30) | VARCHAR2(30) NOT NULL | Blank field H (always blank) |
134 | GPCH_PK_LABEG | Character(9) | VARCHAR2(9) NOT NULL | Beneficiary ID |
135 | GPCH_PK_LABST | Character(1) | VARCHAR2(1) NOT NULL | Beneficiary status |
136 | GPCH_PK_LAAKJ | Character(4) | VARCHAR2(4) NOT NULL | Entry Date insured event year |
137 | GPCH_PK_LAAKM | Character(2) | VARCHAR2(2) NOT NULL | Entry Date insured event month |
138 | GPCH_PK_LAAKT | Character(2) | VARCHAR2(2) NOT NULL | Entry Date insured event day |
139 | GPCH_PK_LAHEJ | Character(4) | VARCHAR2(4) NOT NULL | Date of marriage year |
140 | GPCH_PK_LAHEM | Character(2) | VARCHAR2(2) NOT NULL | Date of marriage month |
141 | GPCH_PK_LAHET | Character(2) | VARCHAR2(2) NOT NULL | Date of marriage day |
142 | GPCH_PK_LASDJ | Character(4) | VARCHAR2(4) NOT NULL | Acceptance in pension fund year |
143 | GPCH_PK_LASDM | Character(2) | VARCHAR2(2) NOT NULL | Acceptance in pension fund month |
144 | GPCH_PK_LASDT | Character(2) | VARCHAR2(2) NOT NULL | Acceptance in pension fund day |
145 | GPCH_PK_LAWHJ | Character(4) | VARCHAR2(4) NOT NULL | Birthdate spouse year |
146 | GPCH_PK_LAWHM | Character(2) | VARCHAR2(2) NOT NULL | Birthdate spouse month |
147 | GPCH_PK_LAWHT | Character(2) | VARCHAR2(2) NOT NULL | Birthdate spouse day |
148 | GPCH_PK_LAUBJ | Character(4) | VARCHAR2(4) NOT NULL | Date eligible for benefits till year |
149 | GPCH_PK_LAUBM | Character(2) | VARCHAR2(2) NOT NULL | Date eligible for benefits till month |
150 | GPCH_PK_LAUBT | Character(2) | VARCHAR2(2) NOT NULL | Date eligible for benefits till day |
151 | GPCH_PK_LALAJ | Character(4) | VARCHAR2(4) NOT NULL | Date eligible for benefits from year |
152 | GPCH_PK_LALAM | Character(2) | VARCHAR2(2) NOT NULL | Date eligible for benefits from month |
153 | GPCH_PK_LALAT | Character(2) | VARCHAR2(2) NOT NULL | Date eligible for benefits from day |
154 | GPCH_PK_LAINJ | Character(4) | VARCHAR2(4) NOT NULL | Date of invalidity year (beneficiary) |
155 | GPCH_PK_LAINM | Character(2) | VARCHAR2(2) NOT NULL | Date of invalidity month (beneficiary) |
156 | GPCH_PK_LAINT | Character(2) | VARCHAR2(2) NOT NULL | Date of invalidity day (beneficiary) |
157 | GPCH_PK_LAPAF | Character(7) | VARCHAR2(7) NOT NULL | invalidity-% (beneficiary) |
158 | GPCH_PK_LAAH1 | Character(15) | VARCHAR2(15) NOT NULL | AHV No. Without points (beneficiary) |
159 | GPCH_PK_LAAH2 | Character(15) | VARCHAR2(15) NOT NULL | File ID of insured person (AHV No.) |
160 | GPCH_PK_LAAH3 | Character(2) | VARCHAR2(2) NOT NULL | Serial number of insured person |
161 | GPCH_PK_LAVPR | Character(2) | VARCHAR2(2) NOT NULL | Payments plan pensioner according VL table |
162 | GPCH_PK_LAAD1 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
163 | GPCH_PK_LAAD2 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
164 | GPCH_PK_LAAD3 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
165 | GPCH_PK_LAAD4 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
166 | GPCH_PK_LAAD5 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
167 | GPCH_PK_LAAD6 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
168 | GPCH_PK_LAAD7 | Character(40) | VARCHAR2(40) NOT NULL | Additional address |
169 | GPCH_PK_LAASO | Character(40) | VARCHAR2(40) NOT NULL | Sortfield for additional address |
170 | GPCH_PK_LAANR | Character(50) | VARCHAR2(50) NOT NULL | Salutation |
171 | GPCH_PK_LATE1 | Character(25) | VARCHAR2(25) NOT NULL | Phone (business/private/mobile) |
172 | GPCH_PK_LATE2 | Character(25) | VARCHAR2(25) NOT NULL | Fax (business/private) |
173 | GPCH_PK_LAMA1 | Character(50) | VARCHAR2(50) NOT NULL | Email address |
174 | GPCH_PK_LAMAL | Character(1) | VARCHAR2(1) NOT NULL | Code for email address for mailing (1 = yes, else blank) |
175 | GPCH_PK_LATPJ | Character(4) | VARCHAR2(4) NOT NULL | Part pensioning date year (YYYY) |
176 | GPCH_PK_LATPM | Character(2) | VARCHAR2(2) NOT NULL | Part pensioning month (MM) |
177 | GPCH_PK_LATPT | Character(2) | VARCHAR2(2) NOT NULL | Part pensioning day (TT) |
178 | GPCH_PK_LATPZ | Character(7) | VARCHAR2(7) NOT NULL | Perc of part pensioning |
179 | GPCH_PK_LATBV | Character(7) | VARCHAR2(7) NOT NULL | Perc FTE before part pensioning |
180 | GPCH_PK_LATBN | Character(7) | VARCHAR2(7) NOT NULL | Perc FTE after part pensioning |
181 | GPCH_PK_LAPEJ | Character(4) | VARCHAR2(4) NOT NULL | Effective pensioning year (YYYY) |
182 | GPCH_PK_LAPEM | Character(2) | VARCHAR2(2) NOT NULL | Effective pensioning month (MM) |
183 | GPCH_PK_LAPET | Character(2) | VARCHAR2(2) NOT NULL | Effective pensioning day (TT) |
184 | GPCH_PK_LAIVG | Character(7) | VARCHAR2(7) NOT NULL | IV degree of pensioner |
185 | GPCH_PK_LAIVJ | Character(4) | VARCHAR2(4) NOT NULL | IV year of pensioner |
186 | GPCH_PK_LAIVM | Character(2) | VARCHAR2(2) NOT NULL | IV month of pensioner |
187 | GPCH_PK_LAIVT | Character(2) | VARCHAR2(2) NOT NULL | IV day of pensioner |