ssdb_excp_item_cdc

Pipelined Data Sets > Symitar > ssdb_excp_item_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
excpitemkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
typefilter		NULLABLE	STRING
excptype	The system sets this field depending on which process created the item	NULLABLE	INTEGER
excpitemaccount	This field stores the account number (up to 10 digits) of the member whose item was returned	NULLABLE	STRING
idtype	This field stores a code that specifies what type of account the exception item is drawn on (share, loan, etc.)	NULLABLE	INTEGER
id	This field stores the ID of the Share or Loan record	NULLABLE	STRING
transferaccount	This field stores the account number of the account to which the system should transfer the funds	NULLABLE	STRING
transferidtype	This field stores a code that indicates if the distribution item is a share or loan transfer	NULLABLE	INTEGER
transferid	This field stores the ID of the share or loan receiving the funds	NULLABLE	STRING
processoraccount	This field stores the draft or ACH account number (up to 20 characters) that is reported to the processor	NULLABLE	STRING
batchid	This field stores a user-assigned number (up to six digits) that identifies the exception item batch that includes the item in this Exception Item record	NULLABLE	STRING
transactioncode	This field stores the ACH transaction code (from the detail record) for this item in the original ACH file	NULLABLE	INTEGER
branch	This field contains the number of the branch where the exception item originated (0-9999)	NULLABLE	INTEGER
reasoncode	This field stores a code to identify the reason the item was classified as an exception or to send a request to a processor	NULLABLE	INTEGER
achexcpreason	This field contains the reason the ACH item was classified as an exception	NULLABLE	STRING
editrecord_1	The Edit Record 1 through Edit Record 3 fields contain the unformatted contents of the 132-character Exception record, broken into chunks of 40 characters; the Edit Record 4 field contains the remaining 12 characters	NULLABLE	STRING
editrecord_2	The Edit Record 1 through Edit Record 3 fields contain the unformatted contents of the 132-character Exception record, broken into chunks of 40 characters; the Edit Record 4 field contains the remaining 12 characters	NULLABLE	STRING
editrecord_3	The Edit Record 1 through Edit Record 3 fields contain the unformatted contents of the 132-character Exception record, broken into chunks of 40 characters; the Edit Record 4 field contains the remaining 12 characters	NULLABLE	STRING
editrecord_4	The Edit Record 1 through Edit Record 3 fields contain the unformatted contents of the 132-character Exception record, broken into chunks of 40 characters; the Edit Record 4 field contains the remaining 12 characters	NULLABLE	STRING
date_1	This field contains the date the exception item was processed by the processor	NULLABLE	DATE
date_2	This field stores the actual date corresponding to the settlement date from the Batch Header record for the item in the original ACH file	NULLABLE	DATE
date_3	This field contains the settlement date of an incoming return entry	NULLABLE	DATE
date_4	This field contains the settlement date of an incoming dishonored return entry	NULLABLE	DATE
date_5	This field stores the original settlement date from the original entry in the MMDDYY format	NULLABLE	DATE
date_6	This field stores the date the Receiving Depository Financial Institution (RDFI) initiated the original return	NULLABLE	DATE
code_1	This field is used for draft exceptions (only the Chase format), memo posting exceptions, and ACH exceptions	NULLABLE	INTEGER
code_2	This field stores the transaction code or the value in the Gateway Operator OFAC Screening Indicator field of the IAT Entry Detail Record	NULLABLE	INTEGER
code_3	This field indicates the type of account or the value in the Secondary OFAC Screening Indicator field of the IAT Entry Detail Record	NULLABLE	INTEGER
code_4	This field generates IAT NOC entries or it stores the transfer account code	NULLABLE	INTEGER
code_5	This field returns additional information when a return reason code of R17 is entered in the ACH Exception Reason field in the ACH Exception Item record	NULLABLE	INTEGER
amount_1	This field contains the amount of the exception item. An amount is usually required for all exception items except ACH or draft stop payment requests	NULLABLE	INTEGER
amount_2	For payroll exception items, this field stores the standard amount of the payroll exception item. For distribution exception items, this field stores the remaining amount of the payroll at the time the exception occurred	NULLABLE	INTEGER
ch1_1	This field stores the source code of the exception item. For ACH exception items, this field can be blank or it can be set to O. If it is set to O, the ACH exception item was originated at the credit union	NULLABLE	STRING
ch1_2	This field is only used for Miscellaneous Posting and Memo Posting exceptions. It contains the subaction code of the Miscellaneous Posting or Memo Posting exception item	NULLABLE	STRING
ch1_3	This field is used for Miscellaneous Posting exception items only. It contains a value of Y if the Miscellaneous Posting exception item uses comment continuation	NULLABLE	STRING
ch1_4	This field is reserved for future use	NULLABLE	STRING
ch2_1	This field stores the individual discretionary data from the detail record for the item in the original ACH file. This field is not case sensitive	NULLABLE	STRING
ch2_2	This field contains positions 71-92 of the ATM location	NULLABLE	STRING
ch3_1	This field stores the Service Class Code from the ACH BatchHheader record for the item in the original ACH file	NULLABLE	STRING
ch3_2	This field stores the Standard Entry Class (SEC) code from the Batch Header record for the item in the original ACH file	NULLABLE	STRING
ch3_3	This field stores the code that explains the reason an ACH item was returned	NULLABLE	STRING
ch3_4	This field stores a standard code that the Originating Depository Financial Institution (ODFI) uses to describe the reason for dishonoring a return entry	NULLABLE	STRING
ch6_1	This field stores the value from the Company Descriptive Date field in the Batch Header record for the item in the original ACH file	NULLABLE	STRING
ch6_2	This field stores the value from the Effective Entry Date field in the Batch Header record for the item in the original ACH file	NULLABLE	STRING
ch8_1	This field stores the value from the Originating DFI Identification in the batch header record for the item in the original ACH file	NULLABLE	STRING
ch8_2	This field stores the receiving DFI identification number from the Batch Header record for the item in the original ACH file (your institution's routing and transit number)	NULLABLE	STRING
ch8_3	This field is used as a selection criteria for the ACH Reports and ACH Posting batch programs	NULLABLE	STRING
ch10_1	This field stores the value from the Company ID field in the Batch Header record (for the item in the original ACH file)	NULLABLE	STRING
ch10_2	This field contains positions 113-122 of the ATM location	NULLABLE	STRING
ch10_3	This field contains positions 123-132 of the ATM location	NULLABLE	STRING
ch15_1	This field stores the value from the Individual ID field in the detail record (for the item in the original ACH file)	NULLABLE	STRING
ch15_2	This field stores the original ACH trace number from the ACH Detail record (for the item in the original ACH file)	NULLABLE	STRING
ch15_3	This field stores the return trace number	NULLABLE	STRING
ch15_4	This field stores the dishonored return trace number	NULLABLE	STRING
ch16	This field stores the value from the Company Name field from the batch header record (for the item in the original ACH file.)	NULLABLE	STRING
ch20_1	This field contains positions 93-112 of the ATM location	NULLABLE	STRING
ch20_2	This field matches the value in the Processor Account field in the Exception Item record when the draft is an exception, unless custom coding requires it to be different	NULLABLE	STRING
ch22	This field contains positions 71-92 of the ATM location	NULLABLE	STRING
ch30	This field contains positions 41-70 of the ATM location	NULLABLE	STRING
ch40	The contents of this field are determined by the type of exception item	NULLABLE	STRING
reviewstatus	This field stores a value that indicates whether this field has been reviewed	NULLABLE	INTEGER
adjustmentcode	The system uses this field for many exception types to indicate that the original transaction was an adjustment transaction and to enable adjustment transaction exceptions to be successfully resubmitted for posting	NULLABLE	INTEGER
globalsequencedate	This field contains a unique number for each global sequence date. The system assigns this number automatically. You cannot change the value of this field	NULLABLE	DATE
globalsequence		NULLABLE	INTEGER
regcode	This field appears for every exception type except payroll exceptions (the Exception Type field is set to (7) Payroll Exception)	NULLABLE	INTEGER
glaccount	This field corresponds to the GL account number for an ACH GL transaction	NULLABLE	STRING
glreference	This field stores the reference for the GL transaction	NULLABLE	STRING
glreference1	This field stores the reference for the GL transaction	NULLABLE	STRING
glcomment	This field stores the comment for the GL transaction	NULLABLE	STRING
glcode	The system does not currently use this field. It does not appear on any exception screen	NULLABLE	INTEGER
glcode1	The system sets this field to -1 for system-created ACH GL transaction exceptions. If you use the ACH Reports batch program to move items to an edit file for posting, the system sets this field to -1 if the ACH transaction code indicates that it is a GL transaction. Otherwise, the system sets this field to 0	NULLABLE	INTEGER
glcategory	This field appears only for SymConnect when the Exception Type field is set to (9) Memo Exception	NULLABLE	INTEGER
extloanaccount	This field stores the external loan account number from the External Loan record	NULLABLE	STRING
commentcode	If a transaction contains key code transaction comments, this field contains the comment code from the Comment and Note Definition parameters associated with that transaction	NULLABLE	INTEGER
memberbranch	This field is blank for all exception items unless the posting process sets it to some other value	NULLABLE	STRING
exceptioncode	This field stores the exception code that corresponds to the exception description on the exception report	NULLABLE	INTEGER
subtrancode	This field supports the same values as the Sub Source Code field in the Transaction record and it stores the value when an item is an exception for any reason	NULLABLE	INTEGER
ch35_1	If the ACH Exception Reason field stores a correction code beginning with C, you must enter the corrected data in this field (for example, if the ACH Exception Reason field is set to C04 - Incorrect Individual Name, enter the correct individual name in this field)	NULLABLE	STRING
ch35_2	This field stores the U.S. receiver's account number	NULLABLE	STRING
batchachorignum	This field stores the Locator number from the related Batch ACH Origination record	NULLABLE	INTEGER
otheraction	This field stores a code that determines where a fee transaction comment is posted	NULLABLE	INTEGER
otheridtype	This field stores a code for the other ID type	NULLABLE	INTEGER
otherid	This field stores the four-digit ID of the Share or Loan associated with the Other Action field	NULLABLE	STRING
originatorstatus	This field identifies where the ACH file originated and must be retained for NACHA requirements	NULLABLE	STRING
deathdate	This field allows the date of death to be included with a return reason code of R14 or R15 (payee, beneficiary, or account holder deceased)	NULLABLE	DATE
draftnumber	If the draft processor supports stop payment requests, you can enter a single draft number in this field to stop payment on a single draft, or you can enter the low draft number in a range of draft numbers to stop payment on a range of drafts	NULLABLE	STRING
rangenumber	This field stores the high draft number of a range of drafts	NULLABLE	STRING

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