ssdb_batch_ach_orig_cdc

Pipelined Data Sets > Symitar > ssdb_batch_ach_orig_cdc

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
sourceeventtime	The timestamp of the change event from the source system (e.g., Debezium's ts_ms field).	NULLABLE	INTEGER
sourceeventdate	The UTC date of the change event, derived from sourceeventtime.	NULLABLE	DATE
operation	The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field.	NULLABLE	STRING
batchachorigkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
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	INTEGER
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