Table: Employee Garnishment

Table: UPEMCS
View: UP0118
Record Length: 282

Flags: A 

Keys: 1

Title Flags Fields

Employee, Deduction Code EMPLOYEEDEDCODE

Fields: 22

Field Type Title Presentation

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