View: EFT Run History Details

RotoID: UP0205
Table: UPETRN
Protocol: Detail, Ordered revisions
DLL:UPETRN

Compositions: 1

RotoID Tables Title DLL
UP0204 UPEREG EFT Run History Header UPEREG

Keys: 3

Title 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: 29

Field Index Type Title Attributes Presentation
EFTRUNSEQ 1 Long EFT Run Sequence E A K R 
RERUNSEQ 2 Long EFT Rerun Sequence E A K R 
EMPLOYEE 3 String*12 Employee E A K R 
TRANSNO 4 Long Unique Key Field E A K R 
LASTNAME 5 String*20 Last Name E A 
FIRSTNAME 6 String*15 First Name E A 
MIDDLENAME 7 String*15 Middle Name E A 
TRNSFRNAME 8 String*30 Bank Transfer Name E A 
REFERENCE 9 String*19 Reference E A 
DISCREDATA 10 String*2 Discretionary Data E A 
BKACCTCODE 11 String*6 Employee EFT Bank ID E A 
BKACCTDESC 12 String*15 Employee EFT Bank Description E A 
INSTITUTID 13 String*9 Receiving DFI ID E A 
ACCTNUM 14 String*18 Account Number E A 
TRANSCODE 15 String*2 Transaction Code E A 
DEPOSITAMT 16 BCD*10.3 Deposit Amount E A 
ENTRYDATE 17 Date EFT Entry Effective Date E A 
CHECKNUM 18 BCD*5.0 Check Number E A 
CASEID 19 String*20 Case Identifier E A 
CASESTATE 20 String*2 Case State E A 
JURISDICTN 21 String*30 Case Jurisdiction E A 
FIPSCODE 22 String*7 FIPS Code E A 
CUSTPARENT 23 String*30 Custodial Parent E A 
MEDINSUAVL 24 Boolean Family Health Insurance is Available? E A 
MEDINSUREQ 25 Boolean Family Health Insurance is Required? E A 
ORDERDATE 26 Date Date of Order E A 
CHECKDATE 27 Date Check Date/Cheque Date E A 
SSN 28 String*9 Non-Custodial Parent Social Security Number E A 
TERMINATED 29 Boolean Employment Termination Indicator E A 

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).