ssdb_western_union_ofacdetails_cdc

Pipelined Data Sets > Symitar > ssdb_western_union_ofacdetails_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
westernunionofacdetailskey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
westernunionkey	Internal use only; SSDB field	NULLABLE	INTEGER
text_1	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_2	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_3	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_4	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_5	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_6	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_7	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_8	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_9	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_10	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_11	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_12	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_13	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_14	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_15	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_16	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_17	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_18	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_19	These fields indicate the reason a Western Union record failed the OFAC check	NULLABLE	STRING
text_20	These fields indicate the reason a Western Union record failed the OFAC check	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