batchachorig_raw

Pipelined Data Sets > Symitar > batchachorig_raw

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
eventtime	Internal use only	NULLABLE	INTEGER
sourcetype	Internal use only; SSDB field	NULLABLE	STRING
operation	Internal use only; SSDB field	NULLABLE	STRING
extractdate	Internal use only	NULLABLE	DATE
processdatetime	Internal use only; SSDB field	NULLABLE	TIMESTAMP
batchachoriguuid	This field stores a JH Platform unique identifier for a batch ach orig	NULLABLE	STRING
accountuuid	This field stores a JH Platform unique identifier for an account	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
batchachorigkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	NULLABLE	INTEGER
companyname	This field stores the source of the entry and provides a description for the receiver containing the originator's name	NULLABLE	STRING
companydiscretionarydata	This optional field stores significant codes used by originators	NULLABLE	STRING
companyid	This field stores the originator's unique identification number	NULLABLE	STRING
standardentryclasscode	This field stores a character code that distinguishes the various types of ACH entries	NULLABLE	STRING
companyentrydescription	This field stores a description of the entry for the receiver	NULLABLE	STRING
effectiveentrydate	This field stores the date specified by the originator as the day on which a batch of entries is to be settled	NULLABLE	DATE
status	This field stores the status of the Batch ACH Origination record	NULLABLE	INTEGER
depositsettlementdate	This field stores the settlement date for all originated deposits	NULLABLE	DATE
paysettlementdate	This field stores the settlement date for all originated withdrawals	NULLABLE	DATE
expiration	This field stores the date used by the Purge Account Processing batch job to purge Batch ACH Origination records	NULLABLE	DATE
origamount	This field stores the total dollar amount of the EFT items linked to the Batch ACH Origination record through the Batch ACH Origination Number field in the EFT record	NULLABLE	NUMERIC
locator	This field stores a unique number within each member account that can be used as a unique identification of this record	NULLABLE	INTEGER
recordchangedate	The system stores the system date in this field when you create, change, or save the Batch ACH Origination record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
groupnumber	This field stores the credit union-defined number used by ACH Posting to identify what items to post	NULLABLE	STRING
idtype	This field stores a code that specifies whether the record is used to deposit or withdraw funds by ACH Origination from the member's shares or loans	NULLABLE	INTEGER
id	This field stores the share or loan ID	NULLABLE	STRING
postmethod	This field store a code that specifies if the posting program should post all the ACH items together or separately	NULLABLE	INTEGER
totaloriginationcount	This field stores the total number of ACH items included in the ACH batch	NULLABLE	INTEGER
totalpostedcount	This field stores the total number of ACH items included in the batch posting	NULLABLE	INTEGER

Have a Question?

Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026