R_TAX002MN

(SQL Table)
Index Back

Temp Table - SQR Tax002MN

Temp Table - SQR Tax002MN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EMPLOYER_ID Character(20) VARCHAR2(20) NOT NULL Employer ID
3 EMPLOYER_ID_EXT Character(5) VARCHAR2(5) NOT NULL Employer ID Extension
4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
5 STATE Character(6) VARCHAR2(6) NOT NULL State
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
11 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
12 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
13 TXGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross QTD
14 NLGRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL No Limit Gross QTD