GPIT_770_RP_006

(SQL Table)
Index Back

Tax Data for 770

Tax Data for 770

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPIT_TAX_CD_1 Character(16) VARCHAR2(16) NOT NULL Tax Code

Prompt Table: GPIT_PROV

3 GPIT_FILE_NBR4 Number(4,0) SMALLINT NOT NULL File Number
4 COMP_CODE_ITA Character(30) VARCHAR2(30) NOT NULL Company Codes ITA
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 GPIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
7 GPIT_PRE_TAX_CD Character(16) VARCHAR2(16) NOT NULL Previous Employer Tax Code
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
10 GPIT_PDL_REA Character(1) VARCHAR2(1) NOT NULL Reason for Changing
11 GPIT_DD_CODE Character(1) VARCHAR2(1) NOT NULL Deductions Code
12 GPIT_PRE_INCOME Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer Income
13 GPIT_PRE_TAX Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer Taxes
14 GPIT_PRE_TAXFRO Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer frozen Taxes
15 GPIT_PRE_TAXCNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer County Taxes
16 GPIT_PRE_TAXFROCNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer County frozen Taxes
17 GPIT_PRE_TAXCTY Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer City Taxes
18 GPIT_PRE_TAXFROCTY Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Employer City frozen Taxes
19 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company