WRK_GARNISH(SQL Table) |
Index Back |
|---|---|
Work Record - Pay GarnishmentThis work record contains detail Garnishment information resulting from the Payroll Calculation Process at the pay line level. This information is used later for PAY_GARNISH 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 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Default Value: 00 |
| 9 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BEN_PROG_BENPLN |
| 10 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: BEN_PROG_BENDED |
| 11 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit Default Value: A |
| 12 | GARN_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Garnish Priority |
| 13 | GARNID | Character(6) | VARCHAR2(6) NOT NULL | Garnish ID |
| 14 | AUTO_CALC_STOP | Character(1) | VARCHAR2(1) NOT NULL |
Auto Calc Stop Date
Y/N Table Edit Default Value: N |
| 15 | AUT_CALC_STOP_DAYS | Number(3,0) | SMALLINT NOT NULL | Auto Calc Stop Days |
| 16 | STATE_GARN_LAW | Character(6) | VARCHAR2(6) NOT NULL |
Garnish Law Source
Prompt Table: STATE_ZGARN_VW |
| 17 | GARN_RULE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Garnish Rule ID
Prompt Table: GARN_RULE_TBL |
| 18 | GARN_EX_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Garnish Exempt Calc Routine
C=General Calculation D=Based on Standard Deduction E=General Calc with Entered Amt H=Based on Minimum Hourly Wage O=Exemption override on payline R=Garnish Exempt Calc Routine Default Value: C |
| 19 | GARN_DE_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Garn Disposable Earnings Amt |
| 20 | GARN_EX_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Garnishment exemption amount. |
| 21 | GARN_DED_OTH_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Garn Deduction Other Grn Amt |
| 22 | GARN_DED_MAX_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Garn Deduction Maximum Amount |
| 23 | GARN_DED_LIM_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Garn Deduction Limited Amount |
| 24 | GARN_DED_LIM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Garn Deduction Limited Type
A=Deduct Limited by Total Amount C=Deduct Limited by Calculation M=Deduct Limited by Monthly Amt N=Deduct Not Limited P=Deduct Limited by Net Amount R=Deduct Limited by Proration Default Value: N |
| 25 | INCLUDED_FEE_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Due To Included Fee?
Y/N Table Edit Default Value: N |
| 26 | DEDUCT_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Amount |
| 27 | DEDUCT_GARN_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Garnishment Amount |
| 28 | DEDUCT_CMPNY_FEE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Company Fee |
| 29 | DEDUCT_PAYEE_FEE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Payee Fee |
| 30 | GARN_REFUND | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Garnishment Refund |
| 31 | GARN_DE_TAXES | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | DE Taxes |
| 32 | STATE_GARN_PRORATE | Character(6) | VARCHAR2(6) NOT NULL | Proration Rule State |
| 33 | GARN_PRORATE_RL_ID | Character(6) | VARCHAR2(6) NOT NULL | Garnishment Proration Rule ID |
| 34 | PRORATE_INEFF_SW | Character(1) | VARCHAR2(1) NOT NULL | Garn proration-in-effect sw |
| 35 | GARN_SUPPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Garnishment Support Type
A=Arrears Order C=Current Order |
| 36 | GVT_SCHEDULE_NO | Character(14) | VARCHAR2(14) NOT NULL | Schedule Number |
| 37 | GVT_PAY_ID_LINE_1 | Character(40) | VARCHAR2(40) NOT NULL | Payment ID Line 1 |
| 38 | GVT_PAY_ID_LINE_2 | Character(40) | VARCHAR2(40) NOT NULL | Payment ID Line 2 |
| 39 | GVT_ECS_LTD_INDIC | Character(1) | VARCHAR2(1) NOT NULL | LTD Pay Indicator |
| 40 | GVT_ECS_OFF_ACCT | Character(16) | VARCHAR2(16) NOT NULL | Account Symbol |
| 41 | GVT_RITS_DT | Date(10) | DATE | Track processing date of Occ Cycle RITS deductions |
| 42 | GVT_TSP_SEQ_YR | Number(2,0) | SMALLINT NOT NULL | TSP Voucher Number |
| 43 | GVT_TSP_SEQ_NO | Number(4,0) | SMALLINT NOT NULL | Voucher Seq No |