ssdb_portfolio_hold_cdc

Pipelined Data Sets > Symitar > ssdb_portfolio_hold_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
portfolioholdkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
portfoliokey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
accountnumberinternal		NULLABLE	STRING
type	This field identifies the purpose of the Hold record	NULLABLE	INTEGER
effectivedate	this field stores the date the hold should take effect or the date the hold was created for hold types 1-12 and 14-21, and for hold type (13) Loan Draft, it stores the date a preapproved loan draft form was issued to the member	NULLABLE	DATE
expirationdate	This field stores the expiration date of the hold	NULLABLE	DATE
reference1	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
reference2	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
amount	This field stores the amount of money held	NULLABLE	INTEGER
payeename	The value in this field varies depending on the hold type	NULLABLE	STRING
expirationtime	This field stores the time when a hold should be released	NULLABLE	INTEGER
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
memberbranch	This field is used by corporate credit unions only and it stores the branch number if available	NULLABLE	STRING
stoppaycode	This field stores the reason given for a stop	NULLABLE	INTEGER
reference3	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
reference4	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
matchdate	This field stores the date of an authorization hold	NULLABLE	DATE
matchtime	This field stores the time of an authorization hold	NULLABLE	INTEGER
feecode	This field stores the code that determines the fee placed on the transaction	NULLABLE	INTEGER
recordchangedate	This field stores the system date when you create, change or save the Hold record	NULLABLE	DATE
achrecurringstop	This field indicates whether the Hold record is used to stop multiple ACH items	NULLABLE	INTEGER
transactiontype	This field identifies the transaction type for ATM and PIN authorization transactions for preauthorized Loan holds only	NULLABLE	INTEGER
holdcreationdate	This field stores the AIX date (mm/dd/yyyy) that you created the hold record	NULLABLE	DATE
holdcreationtime	This field stores the AIX time (hh:mm:ss) that you created the hold record	NULLABLE	STRING
availablebalance	This field stores the value calculated by an ATM to authorize a transaction	NULLABLE	INTEGER
ledgerbalance	This field stores the balance that the ATM software uses when it creates a PIN authorization or signature authorization Hold record	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