GPDE_RP_TX05_2(SQL Table) |
Index Back |
---|---|
Temp Record for RepotingTemp Record for Repoting |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
6 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
7 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
8 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
9 | GPDE_TX_UNIT1 | Character(6) | VARCHAR2(6) NOT NULL | Tax Unit |
10 | GPDE_TX_NUMBER | Character(13) | VARCHAR2(13) NOT NULL | Tax Number |
11 | GPDE_AL_FINANCE_CD | Character(4) | VARCHAR2(4) NOT NULL | Tax Office |
12 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
13 | GPDE_AL_CPAY_ENDDT | Date(10) | DATE | Current Pay End Date |
14 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
15 | GPDE_TX_RELIGION | Character(3) | VARCHAR2(3) NOT NULL |
Religion
00=No confession 01=Roman Catholic 02=Old Catholic 03=Evangical Lutheran 04=Evangical Ref. 05=French Reform i.0. 06=Free Religion Baden 07=Israelite 08=Religion Tax Rheinland Pfalz 09=Free Religion Offenbach 10=Free Religion Mainz 11=Israelite Religion Baden 12=Israelite Religion Wurttemberg 13=Israelite Religion Frankfurt/M 14=Israelite Religion Country 15=Free Religion Pfalz 16=Free Religion Comunity Alzey 17=Jewish Culture Tax HH 18=Jewish Culture Tax SH |
16 | GPDE_TX_CHRCHSTATE | Character(2) | VARCHAR2(2) NOT NULL |
Church State
01=Schleswig-Holstein 02=Hamburg 03=Niedersachsen 9 % 04=Bremen 05=Nordrhein-Westfalen 06=Hessen 07=Rheinland-Pfalz 08=Baden-Wurtemberg 09=Bayern 10=Saarland 11=Berlin 12=Brandenburg 13=Mecklenburg-Vorpommern 14=Sachsen 15=Sachsen-Anhalt 16=Thuringen 17=Stadt Bremerhaven 18=Oberfinanzdirektion Kiel 93=Niedersachsen 8 % |
17 | GPDE_TX_SPOUSE_REL | Character(3) | VARCHAR2(3) NOT NULL |
Religion Spouse
00=No confession 01=Roman Catholic 02=Old Catholic 03=Evangical Lutheran 04=Evangical Ref 05=French Reform i.O. 06=Free Religion Baden 07=Israelite 08=Religion Tax Rheinland Pfalz 09=Free Religion Offenbach 10=Free Religion Mainz 11=Israelite Religion Baden 12=Israelite Religion Wurttemberg 13=Israelite Religion Frankfurt/M 14=Israelite Religion Country 15=Free Religion Pfalz 16=Free Religion Comunity Alzey 17=Jewish Culture Tax HH 18=Jewish Culture Tax SH |
18 | GPDE_TX_CHAMBSTATE | Character(2) | VARCHAR2(2) NOT NULL |
Chamber State
00=none 01=Bremen 02=Saarland 03=Bremen BC |
19 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
21 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
22 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
23 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
24 | GPDE_RP_TAX_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
25 | GPDE_RP_SLDRTY_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
26 | GPDE_RP_CHTXEE_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
27 | GPDE_RP_CHTXSP_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
28 | GPDE_RP_CHTXLE_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
29 | GPDE_RP_CHTXLC_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
30 | GPDE_RP_CHTXLJ_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
31 | GPDE_RP_CHMBBR_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
32 | GPDE_RP_CHMBSA_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
33 | GPDE_TX_UNIT | Character(6) | VARCHAR2(6) NOT NULL | Tax Unit |
34 | GPDE_TX_CHAMBER_BR | Character(6) | VARCHAR2(6) NOT NULL | Tax Chamber Bremen |
35 | GPDE_TX_CHAMBER_SA | Character(6) | VARCHAR2(6) NOT NULL | Tax Chamber Saarland |
36 | GPDE_RP_CHTX_LMPS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
37 | GPDE_RP_LMP_TOT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Taxfree Travel Expenses YTD |
38 | GPDE_RP_LMP_TXPMKN | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Lumpsum Tax Payment in Kind |