ssdb_external_loan_note_cdc

Pipelined Data Sets > Symitar > ssdb_external_loan_note_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
externalloannotekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
externalloankey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
id	This field stores the share or loan ID	NULLABLE	STRING
idtype	This field determines which Note record type is affected	NULLABLE	INTEGER
code	This field indicates whether the Note record contains free-form text or predefined text	NULLABLE	INTEGER
text_1	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_2	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_3	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_4	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_5	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_6	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_7	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_8	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_9	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_10	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_11	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_12	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_13	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_14	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_15	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_16	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_17	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_18	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_19	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_20	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_21	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_22	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_23	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_24	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_25	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_26	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_27	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_28	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_29	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_30	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_31	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_32	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_33	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_34	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_35	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_36	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_37	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_38	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_39	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_40	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_41	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_42	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_43	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_44	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_45	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_46	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_47	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_48	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_49	Each Text Line # field stores one line of note text	NULLABLE	STRING
text_50	Each Text Line # field stores one line of note text	NULLABLE	STRING
userid	This field stores the user number of the user who created the Note record	NULLABLE	INTEGER
enterdate	This field stores the date on which the Note record was created	NULLABLE	DATE
entertime	This field records the time the Note record was created (HHMM)	NULLABLE	INTEGER
voidflag	This field is set to 1 when you void a Collection Note record; otherwise, this field is set to 0	NULLABLE	INTEGER
voidedby	This field stores the user ID of the person who voids the Collection Note record	NULLABLE	INTEGER
expirationdate	This field stores an expiration date for the Note record	NULLABLE	DATE
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
recordchangedate	This field stores the system date when you create change, or save the Note record	NULLABLE	DATE

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