WRK_TAX(SQL Table) |
Index Back |
|---|---|
Work Record - U.S. Pay TaxThis work record contains employee paycheck tax information. It is used later in the process for PAY_TAX record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | PAY_END_DT | Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
| 5 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 6 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 7 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 9 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 10 | TAX_CLASS | Character(1) | VARCHAR2(1) NOT NULL | Tax Balance Class |
| 11 | WORK_PSD_CD | Character(6) | VARCHAR2(6) NOT NULL | Locality |
| 12 | RES_PSD_CD | Character(6) | VARCHAR2(6) NOT NULL | Locality |
| 13 | RESIDENT | Character(1) | VARCHAR2(1) NOT NULL |
Resident
Y/N Table Edit |
| 14 | NLGRS_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current No Limit Gross |
| 15 | TXGRS_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Taxable Gross |
| 16 | TAX_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tax |
| 17 | TXGRS_AGG | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Gross Aggregate |
| 18 | TAX_AGG | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Aggregate |
| 19 | TAX_SUPP_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Supp Tax |
| 20 | TAX_NOT_TAKEN | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Tax Not Taken |
| 21 | TIPS_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tips subject to tax |
| 22 | TIPS_DELAYED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tips Delayed for W/H |
| 23 | GVT_SCHEDULE_NO | Character(14) | VARCHAR2(14) NOT NULL | Schedule Number |
| 24 | GVT_PAY_ID_LINE_1 | Character(40) | VARCHAR2(40) NOT NULL | Payment ID Line 1 |
| 25 | GVT_PAY_ID_LINE_2 | Character(40) | VARCHAR2(40) NOT NULL | Payment ID Line 2 |
| 26 | GVT_ECS_LTD_INDIC | Character(1) | VARCHAR2(1) NOT NULL | LTD Pay Indicator |
| 27 | GVT_ECS_OFF_ACCT | Character(16) | VARCHAR2(16) NOT NULL | Account Symbol |
| 28 | GVT_RITS_DT | Date(10) | DATE | Track processing date of Occ Cycle RITS deductions |
| 29 | GVT_TSP_SEQ_YR | Number(2,0) | SMALLINT NOT NULL | TSP Voucher Number |
| 30 | GVT_TSP_SEQ_NO | Number(4,0) | SMALLINT NOT NULL | Voucher Seq No |