ssdb_western_union_cdc

Pipelined Data Sets > Symitar > ssdb_western_union_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
westernunionkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
sequencenumber	This field stores a unique number that the system assigns when you enter a Western Union transfer	NULLABLE	INTEGER
status	This field stores the status of the Western Union transfer	NULLABLE	INTEGER
ofacstatus	This field stores the status of the Western Union transfer relative to its OFAC (Office of Foreign Assets Control) check	NULLABLE	INTEGER
accountnumber	This field stores the account number of the member making the transfer	NULLABLE	STRING
effectivedate	This field stores the effective date of the transfer posting	NULLABLE	DATE
entereddate	This field stores the date the transfer was entered	NULLABLE	DATE
enteredtime	This field stores the time the transfer was entered	NULLABLE	INTEGER
enteredbymemberuser	This field stores the user number of the member who entered the transfer	NULLABLE	INTEGER
enteredbycorporateuser	This field stores the user number of the corporate user who entered the transfer	NULLABLE	INTEGER
enteredvalidationmethod	This field stores the method used to authenticate the member who requested the transfer entry	NULLABLE	STRING
verificationmembercontact	This field stores the user number of the member who can be contacted regarding the transfer entry	NULLABLE	INTEGER
verifieddate	This field stores the date the transfer was verified	NULLABLE	DATE
verifiedtime	This field stores the time the transfer was verified	NULLABLE	INTEGER
verifiedbymemberuser	This field stores the user number of the member who verified the transfer	NULLABLE	INTEGER
verifiedbycorpuser	This field stores the user number of the corporate user who verified the transfer	NULLABLE	INTEGER
verifiedvalidationmethod	This field indicates the method used to authenticate the member who verified the transfer	NULLABLE	STRING
verifiedvalidationreason	This field stores the reason (other than OFAC failure) that this transfer was rejected or the reason any release option was selected for a transfer that failed the OFAC check	NULLABLE	STRING
releaseddate	This field stores the date the transfer was released for posting	NULLABLE	DATE
releasedtime	This field stores the time the transfer was released for posting	NULLABLE	INTEGER
releasedbycorporateuser	This field stores the user number of the corporate user who released this transfer for posting	NULLABLE	INTEGER
releasedreason	This field stores the user number of the member who entered this transfer	NULLABLE	STRING
amount	This field stores the amount of the transfer	NULLABLE	INTEGER
originatorname	This field stores the name of the person who originated the transfer	NULLABLE	STRING
originatoraddress_1	This field stores the first line of the address of the originator of the transfer	NULLABLE	STRING
originatoraddress_2	This field stores the second line of the address of the originator of the transfer	NULLABLE	STRING
originatorcity	This field stores the city of the originator of this transfer	NULLABLE	STRING
originatorstate	This field stores the state of the originator of this transfer	NULLABLE	STRING
originatorzip	This field stores the ZIP Code for the originator of this transfer	NULLABLE	STRING
originatorphone	This field stores the phone number of the originator of this transfer	NULLABLE	STRING
originatoraccount	This field indicates whether you have notified a member about an incoming member-to-member transfer	NULLABLE	STRING
beneficiaryname	This field stores the name of the person receiving the transfer	NULLABLE	STRING
beneficiarycity	This field stores the city the beneficiary lives in	NULLABLE	STRING
beneficiarystate	This field stores the state the beneficiary lives in	NULLABLE	STRING
beneficiarycountry	This field stores the country the beneficiary lives in	NULLABLE	STRING
pictureidavailable	This field indicates whether a picture ID is available for the beneficiary	NULLABLE	INTEGER
codeword	This field stores a code word for further beneficiary authentication	NULLABLE	STRING
testquestion	This field stores a test question used with the Answer field, for further beneficiary authentication	NULLABLE	STRING
answer	This field stores the answer to the Test Question field, for further beneficiary authentication	NULLABLE	STRING
physicaldescription	This field stores a description of the beneficiary, for further authentication	NULLABLE	STRING
commentcode	This field stores a code that determines where data appears on statements, billing extracts, and reports	NULLABLE	INTEGER
statementdescription	This field stores a description for billing and statement disclosure if different from default comment code verbiage; otherwise this field is blank	NULLABLE	STRING
transactionsequencenumber	This field stores the share transaction sequence number from the transfer posting	NULLABLE	INTEGER
shareid	This field stores the share ID of the share that is the source of funds for this transfer posting	NULLABLE	STRING
gloffset	This field stores the account number of the GL account credited during this transfer posting	NULLABLE	STRING
postingerror	This field stores a description of the error (if any) that occurred during this transfer posting	NULLABLE	STRING
transfercontrolnumber	This field stores the money transfer control number that was returned during the process of entering the transfer at the Western Union terminal	NULLABLE	STRING
ofacdetails	This field stores the details of Western Union transfers that fail the OFAC (Office of Foreign Assets Control) check	NULLABLE	INTEGER
birthdate	This optional field contains the birth date (MMDDYYYY) for the person who initiated the transaction	NULLABLE	DATE
photoidtype	This optional field contains your selection (from a drop-down menu) for the photo ID of the person who initiated the transaction	NULLABLE	STRING
idnumber	This optional field contains the number related to the photo ID of the person who initiated the transaction. An example is a driver's license number	NULLABLE	STRING
idstatecountry	This optional field contains the state or country that issued the ID used by the person who initiated the transaction	NULLABLE	STRING
secondidtype	This optional field contains your selection (from a drop-down menu) of secondary identification used by the person who initiated the transaction	NULLABLE	STRING
secondidnumber	This optional field contains the number related to a second form of ID for the person who initiated the transaction. An example is a passport number	NULLABLE	STRING
occupation	This optional field contains the job performed by the person who initiated the transaction	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