View: Employee Garnishment

RotoID: CP0118
Table: CPEMCS
Protocol: Detail, Ordered revisions
DLL:CPEMCS

Compositions: 1

RotoID Tables Title DLL

CP0014 CPEMPL Employees CPEMPL

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 Institution ID E A 
ACCTNUM 6 String*18 Account Number E A  Mask: %-18c
TRANSCODE 7 Integer Transcation Code E A P  List:2 entries
22 = 22 - Checking
32 = 32 - Savings
TRNSFRNAME 8 String*30 Bank Account Holder E A  Mask: %-30c
REFERENCE 9 String*19 Reference E A  Mask: %-19c
DISCREDATA 10 String*2 RESERVED - US Only E A 
CASEID 11 String*20 RESERVED - US Only E A 
CASESTATE 12 String*2 RESERVED - US Only E A P  Mask: %-2A
JURISDICTN 13 String*30 RESERVED - US Only E A 
FIPSCODE 14 String*7 RESERVED - US Only E A  Mask: %-7d
CUSTPARENT 15 String*30 RESERVED - US Only E A 
MEDINSUAVL 16 Boolean RESERVED - US Only E A  List:2 entries
0 = No
1 = Yes
MEDINSUREQ 17 Boolean RESERVED - US Only E A  List:2 entries
0 = No
1 = Yes
ORDERDATE 18 Date RESERVED - US Only E A 
ERNDEDDESC 101 String*60 Deduction's Description A