GPCH_RP_PK012(SQL Table) |
Index Back |
|---|---|
Staging Table for DownloadStaging Table for Download Process. It is a copy of WA GPCH_RP_PK011. |
| # | 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 5 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CALENDAR |
| 6 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Original Calendar Group ID
Prompt Table: GP_CAL_RUN |
| 7 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | SEG_BGN_DT |
Date(10) | DATE NOT NULL | Payee Process Segment's Begin Date |
| 9 | SEQUENCENO |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 10 | GPCH_RP_RETRO_CURR | Character(1) | VARCHAR2(1) NOT NULL |
Calc Reconciliation Retro/Current identifier.
C=Current Period R=Retro Period |
| 11 | GPCH_PK_LASAZ | Character(2) | VARCHAR2(2) NOT NULL | Record (always LA) |
| 12 | GPCH_PK_LASTS | Character(1) | VARCHAR2(1) NOT NULL | Status (always 0) |
| 13 | GPCH_PK_LAKAS_W | Character(7) | VARCHAR2(7) NOT NULL | Pension Fund No. |
| 14 | GPCH_PK_LAVBN_W | Character(11) | VARCHAR2(11) NOT NULL | Insurance No. |
| 15 | GPCH_PK_LANAM | Character(30) | VARCHAR2(30) NOT NULL | Name |
| 16 | GPCH_PK_LAVNA_W | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 17 | GPCH_PK_LANA2_W | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 18 | GPCH_PK_LASTR_W | Character(55) | VARCHAR2(55) NOT NULL | Street |
| 19 | GPCH_PK_LALAN | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 20 | GPCH_PK_LAPLZ_W | Character(12) | VARCHAR2(12) NOT NULL | Postal Code |
| 21 | GPCH_PK_LAORT | Character(30) | VARCHAR2(30) NOT NULL | City |
| 22 | GPCH_PK_LAANC | Character(1) | VARCHAR2(1) NOT NULL |
Prefix
1=Mister 2=Mrs 3=Miss 4=Doctor Male 6=Doctor Female 9=Ms |
| 23 | GPCH_PK_LAANC_W | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 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_W | Character(24) | VARCHAR2(24) NOT NULL | Internal phone number |
| 64 | GPCH_PK_LAETE_W | Character(24) | VARCHAR2(24) 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_W | Character(10) | VARCHAR2(10) NOT NULL | Department ID |
| 71 | GPCH_PK_LAKTX | Character(30) | VARCHAR2(30) NOT NULL | Department description |
| 72 | GPCH_PK_LAABT_W | Character(55) | VARCHAR2(55) NOT NULL | Internal address |
| 73 | GPCH_PK_LAAON_W | Character(10) | VARCHAR2(10) 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_W | Number(15,2) | DECIMAL(14,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_W | Number(15,2) | DECIMAL(14,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 |