ssdb_card_access_cdc

Pipelined Data Sets > Symitar > ssdb_card_access_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
cardaccesskey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
cardkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
accesstype	This field stores a code that indicates what the member can do. There are different access types for Preference Access and Card Access records	NULLABLE	INTEGER
accountnumber	This field stores the number of an account the member can access	NULLABLE	STRING
idtype	This field stores a code that specifies what access is allowed to or from any share or loan	NULLABLE	INTEGER
id	This field stores the ID of the Share or Loan record the member can access	NULLABLE	STRING
enablewithdrawal	This field stores a code that specifies whether withdrawals are allowed	NULLABLE	INTEGER
enabledeposit	This field stores a code that specifies whether deposits are allowed	NULLABLE	INTEGER
enableinquiry	This field stores a code that specifies whether inquiries are allowed	NULLABLE	INTEGER
locator	The system stores a unique number within each member account in this field that can be used as a unique identification of this record	NULLABLE	INTEGER
enablefm	This field stores a code that specifies whether inquiries are allowed	NULLABLE	INTEGER
qualifier	This field stores a cross-reference to a share or loan in a network processor's database to shares or loans in the system	NULLABLE	STRING
recordchangedate	This field stores the system date when you create, change, or save the Access 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
extloanaccount	This field stores the number of an external loan account the member can access	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