GPCHPK011_TMP

(SQL Table)
Index Back

WA for Download Process

WA 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