GPCN_TXRSLT_TMP(SQL Table) |
Index Back |
---|---|
Tax report data Temp table.Tax report data Temp table. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
|
3 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
4 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
5 | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | |
6 | Character(18) | VARCHAR2(18) NOT NULL | calendar id | |
7 | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID | |
8 | Number(4,0) | SMALLINT NOT NULL | Result Segment Number | |
9 | Character(22) | VARCHAR2(22) NOT NULL | Output Result Key | |
10 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
11 | Character(30) | VARCHAR2(30) NOT NULL | Tax Area | |
12 | Character(2) | VARCHAR2(2) NOT NULL | Income category | |
13 | Character(3) | VARCHAR2(3) NOT NULL |
Employee Type
1=Local Employee Only 2=Expatriate Only 3=Intern Employee Only 4=All |
|
14 | GPCN_TAX_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Tax Rate |
15 | GPCN_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month Code (along with translate values)
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
16 | GPCN_YEARCD | Character(4) | VARCHAR2(4) NOT NULL | Year Code (along with translate values) |
17 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
18 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
19 | PYMT_DT | Date(10) | DATE | Payment Date |
20 | GPCN_TAX_TOT_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Tax Total Gross |
21 | GPCN_TAX_EXEMPTION | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Tax exempt amount |
22 | GPCN_TOT_TAXABLE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Taxable Income |
23 | GPCN_TAX_QUICK_CAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Quick Calculation Deduction |
24 | GPCN_TAX_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Tax Amount |