View: Employee Garnishment

RotoID: UP0118
Table: UPEMCS
Protocol: Detail, Ordered revisions
DLL:UPEMCS

Compositions: 1

RotoID Tables Title DLL

UP0014 UPEMPL Employees UPEMPL

Keys: 1

Title Fields

Employee, Deduction Code EMPLOYEEDEDCODE

Fields: 19

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
DEDCODE 2 String*6 Deduction Code E A K R  Mask: %-6N
DEDDESC 3 String*60 Deduction's Description E A C 
EFTSTATUS 4 Integer EFT Status E A P  List:3 entries
0 = Pre-notification
1 = Deposit
2 = Inactive
INSTITUTID 5 String*9 SDU Routing Number E A 
ACCTNUM 6 String*18 SDU Account Number E A  Mask: %-17c
TRANSCODE 7 Integer Transcation Code E A P  List:2 entries
22 = 22 - Checking
32 = 32 - Savings
TRNSFRNAME 8 String*30 SDU Name E A  Mask: %-22c
REFERENCE 9 String*19 Reference E A  Mask: %-15c
DISCREDATA 10 String*2 Discretionary Data E A 
CASEID 11 String*20 Case Identifier E A 
CASESTATE 12 String*2 Case State E A P  Mask: %-2A
JURISDICTN 13 String*30 Case Jurisdiction E A 
FIPSCODE 14 String*7 FIPS Code E A  Mask: %-7d
CUSTPARENT 15 String*30 Custodial Parent E A 
MEDINSUAVL 16 Boolean Is family health insurance available? E A  List:2 entries
0 = No
1 = Yes
MEDINSUREQ 17 Boolean Is family health insurance required? E A  List:2 entries
0 = No
1 = Yes
ORDERDATE 18 Date Date of Order E A 
ERNDEDDESC 101 String*60 Deduction's Description A