GPCHPK012_TMP(SQL Table) |
Index Back |
---|---|
Table for Download ProcessTable 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 |