ssdb_ctr_person_cdc

Pipelined Data Sets > Symitar > ssdb_ctr_person_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
ctrpersonkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
ctrkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
drt		NULLABLE	INTEGER
status		NULLABLE	INTEGER
inversedate		NULLABLE	STRING
ctrnumber	This field stores the ctr number	NULLABLE	STRING
ctrpersonshortname		NULLABLE	STRING
type	This field stores a code to indicate the person conducting the transaction on the account for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	INTEGER
last	This field stores the last name of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
middle	This field stores the middle name or initial of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
first	This field stores the first name of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
suffix	This field stores any suffix that should follow the name of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record (JR, MD, etc.)	NULLABLE	STRING
dbalast	This field stores the Doing-Business-As last name or entity for the Owner of the account for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
dbamiddle	This field stores the Doing-Business-As middle name or entity for the Owner of the account for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
dbafirst	This field stores the Doing-Business-As first name or entity for the Owner of the account for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
dbasuffix	This field stores any Doing-Business-As suffix that should follow the name or entity for the Owner of the account for which a transaction occurs in the related Currency Transaction Report (CTR) record (JR, MD, etc.)	NULLABLE	STRING
address	This field stores the street address where the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
city	This field stores the city where the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
state	This field stores a code indicating the state where the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
zipcode	This field stores the zip code where the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
countrycode	This field stores a code indicating the country where the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
ssn	This field stores the Social Security Number (SSN) or Taxpayer Identification Number (TIN) of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
idverifymethod	This field stores the method of verifying the identification of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	INTEGER
idissuebystate	This field stores a code indicating the state where the verification ID for the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record was issued	NULLABLE	STRING
idnumber	This field stores the number associated with the verification ID of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
birthdate	This field stores the birth date of the person identified in the CTR Person record	NULLABLE	DATE
lastfmdate	This field stores the date of the last file maintenance associated with the CTR Person record	NULLABLE	DATE
recordchangedate	This field stores the system date whenever you create, change, or save a record	NULLABLE	DATE
locator	This field stores the unique identification of a specific record	NULLABLE	INTEGER
occupation	This field stores the occupation, profession, or business name that best describes the individual or entity for the CTR Person record	NULLABLE	STRING
multitransflag	This field stores a code indicating whether there are multiple transactions involving this person	NULLABLE	INTEGER
naicscode	This field stores the NAICS Code for the occupation or type of business of the person involved in the transaction	NULLABLE	STRING
entityflag	This field stores a code to indicate whether the person involved is an entity	NULLABLE	INTEGER
gender	This field stores the character for gender which a transaction occurs in the related Currency Transaction Report (CTR) record resides	NULLABLE	STRING
ssntintype	This field stores the Social Security Number (SSN) or Taxpayer Identification Number (TIN) type of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	INTEGER
phone	This field stores the phone number of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
phoneext	This field stores the phone number extension of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
email	This field stores the e-mail address of the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
idtypeotherdesc	This field stores the description of the Other ID type indicated in the Method of ID Verification field for which a transaction occurs in the related Currency Transaction Report (CTR) record	NULLABLE	STRING
idissuebycountry	This field stores a code indicating the country where the verification ID for the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record was issued	NULLABLE	STRING
cashin	This field stores the total amount of cash-in (including foreign) for the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record was issued	NULLABLE	INTEGER
cashout	This field stores the total amount of cash-out (including foreign) for the person or entity for which a transaction occurs in the related Currency Transaction Report (CTR) record was issued	NULLABLE	INTEGER
headquarters	This field indicates if the record pertains to the entity's main base of operations or headquarters	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