GPCHPK012_TMP

(SQL Table)
Index Back

Table for Download Process

Table for Download Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
9 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
10 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
11 SEG_BGN_DT Date(10) DATE NOT NULL Payee Process Segment's Begin Date
12 GPCH_PK_LASAZ Character(2) VARCHAR2(2) NOT NULL Record (always LA)
13 GPCH_PK_LASTS Character(1) VARCHAR2(1) NOT NULL Status (always 0)
14 GPCH_PK_LAKAS Character(3) VARCHAR2(3) NOT NULL Pension Fund No.
15 GPCH_PK_LAVBN Character(9) VARCHAR2(9) NOT NULL Insurance No.
16 GPCH_PK_LANAM Character(30) VARCHAR2(30) NOT NULL Name
17 GPCH_PK_LAVNA Character(15) VARCHAR2(15) NOT NULL First Name
18 GPCH_PK_LANA2 Character(30) VARCHAR2(30) NOT NULL Name 2
19 GPCH_PK_LASTR Character(30) VARCHAR2(30) NOT NULL Street
20 GPCH_PK_LALAN Character(3) VARCHAR2(3) NOT NULL Country
21 GPCH_PK_LAPLZ Character(5) VARCHAR2(5) NOT NULL Postal Code
22 GPCH_PK_LAORT Character(30) VARCHAR2(30) NOT NULL City
23 GPCH_PK_LAANC Character(1) VARCHAR2(1) NOT NULL Prefix
1=Mister
2=Mrs
3=Miss
4=Doctor Male
6=Doctor Female
9=Ms
24 GPCH_PK_LASPR Character(1) VARCHAR2(1) NOT NULL Language
25 GPCH_PK_LAPFL Character(2) VARCHAR2(2) NOT NULL Postal Code - following number
26 GPCH_PK_LAUNT Character(3) VARCHAR2(3) NOT NULL Pay Company
27 GPCH_PK_LALEE Character(5) VARCHAR2(5) NOT NULL Blank field-E (always blank)
28 GPCH_PK_LATX1 Character(30) VARCHAR2(30) NOT NULL Free text-1
29 GPCH_PK_LATX2 Character(30) VARCHAR2(30) NOT NULL Free text-2
30 GPCH_PK_LATX3 Character(30) VARCHAR2(30) NOT NULL Free text-3
31 GPCH_PK_LALEA Character(10) VARCHAR2(10) NOT NULL Blank field-A (always blank)
32 GPCH_PK_LASEX Character(1) VARCHAR2(1) NOT NULL Sex
33 GPCH_PK_LAZCD Character(1) VARCHAR2(1) NOT NULL Marital status
34 GPCH_PK_LAAHV Character(15) VARCHAR2(15) NOT NULL AHV No. (NID)
35 GPCH_PK_LANAT Character(3) VARCHAR2(3) NOT NULL Nationality (ISO Norm)
36 GPCH_PK_LAGJ1_W Date(10) DATE Birthdate
37 GPCH_PK_LATJ1_W Date(10) DATE Date of Death
38 GPCH_PK_LAFC1 Character(4) VARCHAR2(4) NOT NULL Free Code 1
39 GPCH_PK_LAFC2 Character(4) VARCHAR2(4) NOT NULL Free Code 2
40 GPCH_PK_LANBU Character(1) VARCHAR2(1) NOT NULL Code Note-book
41 GPCH_PK_LATVD Character(1) VARCHAR2(1) NOT NULL Code technical data insured person
42 GPCH_PK_LATBD Character(1) VARCHAR2(1) NOT NULL Code technical data beneficiary
43 GPCH_PK_LAIAP Character(1) VARCHAR2(1) NOT NULL Code usage int. Address (identification card)
44 GPCH_PK_LAIAN Character(1) VARCHAR2(1) NOT NULL Code usage int. Address (note-book)
45 GPCH_PK_LALEB Character(1) VARCHAR2(1) NOT NULL Incident code (always blank)
46 GPCH_PK_LAZNA Character(30) VARCHAR2(30) NOT NULL Payment Address - Name (always blank)
47 GPCH_PK_LAZN2 Character(30) VARCHAR2(30) NOT NULL Payment Address - Name 2 (always blank)
48 GPCH_PK_LAZST Character(30) VARCHAR2(30) NOT NULL Payment Address - Street (always blank)
49 GPCH_PK_LAZLA Character(3) VARCHAR2(3) NOT NULL Payment Address - Country (always blank)
50 GPCH_PK_LAZPL_0 Number(5,0) INTEGER NOT NULL Payment Address - Postal Code (always blank)
51 GPCH_PK_LAZOR Character(30) VARCHAR2(30) NOT NULL Payment Address - City (always blank)
52 GPCH_PK_LACNR Character(12) VARCHAR2(12) NOT NULL Payment Address - Clearing Bank (always blank)
53 GPCH_PK_LAKTO Character(21) VARCHAR2(21) NOT NULL Payment Address - Bank Account (always blank)
54 GPCH_PK_LABER Character(3) VARCHAR2(3) NOT NULL Pay area number (P400)
55 GPCH_PK_LAPCN Character(9) VARCHAR2(9) NOT NULL Blank field (always blank)
56 GPCH_PK_LALVC Character(3) VARCHAR2(3) NOT NULL Interface code to payroll system
57 GPCH_PK_LALNR Character(3) VARCHAR2(3) NOT NULL Pay company
58 GPCH_PK_LAPNR_0 Number(6,0) INTEGER NOT NULL Payroll - EMPLID
59 GPCH_PK_LASFA Character(1) VARCHAR2(1) NOT NULL Stoppage code
60 GPCH_PK_LAVKA_0 Number(3,0) SMALLINT NOT NULL Blank field (fill with 0)
61 GPCH_PK_LAVPN_0 Number(9,0) DECIMAL(9) NOT NULL Blank field (fill with 0)
62 GPCH_PK_LASNA Character(20) VARCHAR2(20) NOT NULL Search item Name /first name (fill with blank)
63 GPCH_PK_LAITE Character(10) VARCHAR2(10) NOT NULL Internal phone number
64 GPCH_PK_LAETE Character(20) VARCHAR2(20) NOT NULL External phone number
65 GPCH_PK_LAZPS Character(30) VARCHAR2(30) NOT NULL Responsible HR-Area
66 GPCH_PK_LALEC Character(6) VARCHAR2(6) NOT NULL Life canton (country code plate) - left aligned
67 GPCH_PK_LAPCA Character(20) VARCHAR2(20) NOT NULL PC number for payment address (for insured person = blank)
68 GPCH_PK_LAMJ1_W Date(10) DATE Last Change Date century (creation date of record)
69 GPCH_PK_LAOJ1_W Date(10) DATE Opening date century (creation date of record)
70 GPCH_PK_LAKST Character(9) VARCHAR2(9) NOT NULL Department ID
71 GPCH_PK_LAKTX Character(30) VARCHAR2(30) NOT NULL Department description
72 GPCH_PK_LAABT Character(30) VARCHAR2(30) NOT NULL Internal address
73 GPCH_PK_LAAON Character(9) VARCHAR2(9) NOT NULL Location ID
74 GPCH_PK_LAATX Character(30) VARCHAR2(30) NOT NULL Location description
75 GPCH_PK_LALED Character(52) VARCHAR2(52) NOT NULL Blank field D (always blank)
76 GPCH_PK_LAALN Character(3) VARCHAR2(3) NOT NULL Blank field (always blank)
77 GPCH_PK_LAAPN_0 Number(6,0) INTEGER NOT NULL Sequence number (always 0)
78 GPCH_PK_LAPIB_0 Number(9,0) DECIMAL(9) NOT NULL Payroll - EMPLID
79 GPCH_PK_LASPE Character(4) VARCHAR2(4) NOT NULL Change control code for transfer from PIS
80 GPCH_PK_LADSA Character(3) VARCHAR2(3) NOT NULL Pay out code SAD/DTA
81 GPCH_PK_LASTA Character(1) VARCHAR2(1) NOT NULL Group Status for FLZ
82 GPCH_PK_LAVPA Character(2) VARCHAR2(2) NOT NULL Group Plan
83 GPCH_PK_LALEF Character(14) VARCHAR2(14) NOT NULL Blank field F (always blank)
84 GPCH_PK_LAKP1 Character(2) VARCHAR2(2) NOT NULL Entry date techn. Balance sheet century (else blank)
85 GPCH_PK_LAKP2 Character(2) VARCHAR2(2) NOT NULL Entry date techn. Balance sheet year (else blank)
86 GPCH_PK_LAKPM Character(2) VARCHAR2(2) NOT NULL Entry date techn. Balance sheet month (else blank)
87 GPCH_PK_LAKPT Character(2) VARCHAR2(2) NOT NULL Entry date techn. Balance sheet day (else blank)
88 GPCH_PK_LAVST Character(1) VARCHAR2(1) NOT NULL Insurance status
89 GPCH_PK_LAVPL Character(2) VARCHAR2(2) NOT NULL Insurance plan
90 GPCH_PK_LAEJ1_W Date(10) DATE Entry date in pension fund
91 GPCH_PK_LAAU1_W Date(10) DATE Term. Date in pension fund
92 GPCH_PK_LABBS Character(1) VARCHAR2(1) NOT NULL BVG possession status for coord. Salary
93 GPCH_PK_LANGB_0 Number(8,4) DECIMAL(7,4) NOT NULL BVG FTE in % ( 0 = 100%)
94 GPCH_PK_LALEG Character(2) VARCHAR2(2) NOT NULL Blank field G (always blank)
95 GPCH_PK_LABPK_0 Number(8,4) DECIMAL(7,4) NOT NULL BVG-coordination-%-quota (0=100%)
96 GPCH_PK_LABPJ_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG obligatory salary per year (at 100%)
97 GPCH_PK_LABBB_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG annual salary
98 GPCH_PK_LANKB_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG correction annual gross salary
99 GPCH_PK_LANVB_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG coord. Salary per year (calculated by PEKA)
100 GPCH_PK_LAA50_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG old age assets as of age 50
101 GPCH_PK_LAFBS Character(1) VARCHAR2(1) NOT NULL Free possession status for insured salary
102 GPCH_PK_LANGF_0 Number(8,4) DECIMAL(7,4) NOT NULL Free FTE % (0 = 100%)
103 GPCH_PK_LALEI Character(2) VARCHAR2(2) NOT NULL Blank field I (always blank)
104 GPCH_PK_LAFPK_0 Number(8,4) DECIMAL(7,4) NOT NULL Free coordination-%-quota (0=100%)
105 GPCH_PK_LAFPJ_0 Number(10,2) DECIMAL(9,2) NOT NULL Free obligatory salary per year (at 100%)
106 GPCH_PK_LANAF_0 Number(10,2) DECIMAL(9,2) NOT NULL Free annual gross salary
107 GPCH_PK_LANKF_0 Number(10,2) DECIMAL(9,2) NOT NULL Free correction annual gross salary
108 GPCH_PK_LANVF_0 Number(10,2) DECIMAL(9,2) NOT NULL Free insured salary per year (calculated by PEKA)
109 GPCH_PK_LAF50_0 Number(10,2) DECIMAL(9,2) NOT NULL Free old age assets as of age 50
110 GPCH_PK_LAAJ1_W Date(10) DATE Effective date of new salary
111 GPCH_PK_LAVBG_0 Number(8,4) DECIMAL(7,4) NOT NULL BVG FTE % previous year
112 GPCH_PK_LAVBM_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG obligatory salary per month ( at 100% - previous year)
113 GPCH_PK_LAVBJ_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG obligatory salary per year ( at 100% - previous year)
114 GPCH_PK_LAVBB_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG annual gross salary (previous year)
115 GPCH_PK_LAVBK_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG correction annual gross salary (previous year)
116 GPCH_PK_LAVBL_0 Number(10,2) DECIMAL(9,2) NOT NULL BVG coord. Salary per year (previous year)
117 GPCH_PK_LAVFG_0 Number(8,2) DECIMAL(7,2) NOT NULL Free FTE % (previous year)
118 GPCH_PK_LAVFM_0 Number(10,2) DECIMAL(9,2) NOT NULL Free obligatory salary per year (at 100% - previous year)
119 GPCH_PK_LAVFJ_0 Number(10,2) DECIMAL(9,2) NOT NULL Free obligatory salary per year ( at 100% - previous year)
120 GPCH_PK_LAVFB_0 Number(10,2) DECIMAL(9,2) NOT NULL Free annual gross salary (previous year)
121 GPCH_PK_LAVFK_0 Number(10,2) DECIMAL(9,2) NOT NULL Free correction annual gross salary (previous year)
122 GPCH_PK_LAVFL_0 Number(10,2) DECIMAL(9,2) NOT NULL Free insured salary per year (previous year)
123 GPCH_PK_LALEH Character(30) VARCHAR2(30) NOT NULL Blank field H (always blank)
124 GPCH_PK_LABEG Character(9) VARCHAR2(9) NOT NULL Beneficiary ID
125 GPCH_PK_LABST Character(1) VARCHAR2(1) NOT NULL Beneficiary status
126 GPCH_PK_LAAKJ_W Date(10) DATE Entry Date insured event
127 GPCH_PK_LAHEJ_W Date(10) DATE Date of marriage
128 GPCH_PK_LASDJ_W Date(10) DATE Acceptance in pension fund
129 GPCH_PK_LAWHJ_W Date(10) DATE Birthdate spouse
130 GPCH_PK_LAUBJ_W Date(10) DATE Date eligible for benefits till year
131 GPCH_PK_LALAJ_W Date(10) DATE Date eligible for benefits from year
132 GPCH_PK_LAINJ_W Date(10) DATE Date of invalidity (beneficiary)
133 GPCH_PK_LAPAF Character(7) VARCHAR2(7) NOT NULL invalidity-% (beneficiary)
134 GPCH_PK_LAAH1 Character(15) VARCHAR2(15) NOT NULL AHV No. Without points (beneficiary)
135 GPCH_PK_LAAH2 Character(15) VARCHAR2(15) NOT NULL File ID of insured person (AHV No.)
136 GPCH_PK_LAAH3 Character(2) VARCHAR2(2) NOT NULL Serial number of insured person
137 GPCH_PK_LAVPR Character(2) VARCHAR2(2) NOT NULL Payments plan pensioner according VL table
138 GPCH_PK_LAAD1 Character(40) VARCHAR2(40) NOT NULL Additional address
139 GPCH_PK_LAAD2 Character(40) VARCHAR2(40) NOT NULL Additional address
140 GPCH_PK_LAAD3 Character(40) VARCHAR2(40) NOT NULL Additional address
141 GPCH_PK_LAAD4 Character(40) VARCHAR2(40) NOT NULL Additional address
142 GPCH_PK_LAAD5 Character(40) VARCHAR2(40) NOT NULL Additional address
143 GPCH_PK_LAAD6 Character(40) VARCHAR2(40) NOT NULL Additional address
144 GPCH_PK_LAAD7 Character(40) VARCHAR2(40) NOT NULL Additional address
145 GPCH_PK_LAASO Character(40) VARCHAR2(40) NOT NULL Sortfield for additional address
146 GPCH_PK_LAANR Character(50) VARCHAR2(50) NOT NULL Salutation
147 GPCH_PK_LATE1 Character(25) VARCHAR2(25) NOT NULL Phone (business/private/mobile)
148 GPCH_PK_LATE2 Character(25) VARCHAR2(25) NOT NULL Fax (business/private)
149 GPCH_PK_LAMA1 Character(50) VARCHAR2(50) NOT NULL Email address
150 GPCH_PK_LAMAL Character(1) VARCHAR2(1) NOT NULL Code for email address for mailing (1 = yes, else blank)
151 GPCH_PK_LATPJ_W Date(10) DATE Part pensioning date
152 GPCH_PK_LATPZ Character(7) VARCHAR2(7) NOT NULL Perc of part pensioning
153 GPCH_PK_LATBV Character(7) VARCHAR2(7) NOT NULL Perc FTE before part pensioning
154 GPCH_PK_LATBN Character(7) VARCHAR2(7) NOT NULL Perc FTE after part pensioning
155 GPCH_PK_LAPEJ_W Date(10) DATE Effective pensioning year (YYYY)
156 GPCH_PK_LAIVG Character(7) VARCHAR2(7) NOT NULL IV degree of pensioner
157 GPCH_PK_LAIVJ Character(4) VARCHAR2(4) NOT NULL IV year of pensioner
158 GPCH_PK_LAIVM Character(2) VARCHAR2(2) NOT NULL IV month of pensioner
159 GPCH_PK_LAIVT Character(2) VARCHAR2(2) NOT NULL IV day of pensioner