Table: EFT Run History Details

Table: UPETRN
View: UP0205
Record Length: 333

Flags: A R 

Keys: 3

Title Flags Fields
EFT Run/Rerun Sequence EFTRUNSEQ, RERUNSEQ, EMPLOYEE, TRANSNO
EFT Entry Effective Date EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, TRANSNO
EFT Bank Account Code EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, BKACCTCODE, TRANSNO

Fields: 33

Field Type Title Presentation
EFTRUNSEQ Long EFT Run Sequence
RERUNSEQ Long EFT Rerun Sequence
EMPLOYEE String*12 Employee
TRANSNO Long Unique Key Field
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LASTNAME String*20 Last Name
FIRSTNAME String*15 First Name
MIDDLENAME String*15 Middle Name
TRNSFRNAME String*30 Bank Transfer Name
REFERENCE String*19 Reference
DISCREDATA String*2 Discretionary Data
BKACCTCODE String*6 Employee EFT Bank ID
BKACCTDESC String*15 Employee EFT Bank Description
INSTITUTID String*9 Receiving DFI ID
ACCTNUM String*18 Account Number
TRANSCODE String*2 Transaction Code
DEPOSITAMT BCD*10.3 Deposit Amount
ENTRYDATE Date EFT Entry Effective Date
CHECKNUM BCD*5.0 Check Number
CASEID String*20 Case Identifier
CASESTATE String*2 Case State
JURISDICTN String*30 Case Jurisdiction
FIPSCODE String*7 FIPS Code
CUSTPARENT String*30 Custodial Parent
MEDINSUAVL Boolean Family Health Insurance is Available?
MEDINSUREQ Boolean Family Health Insurance is Required?
ORDERDATE Date Date of Order
CHECKDATE Date Check Date/Cheque Date
SSN String*9 Non-Custodial Parent Social Security Number
TERMINATED Boolean Employment Termination Indicator

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).