ssdb_ctr_person_ctr_tran_info_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_ctr_person_ctr_tran_info_cdc
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| 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 | |
| ctrpersonctrtraninfokey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| ctrpersonkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| ctrkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| drt | NULLABLE | INTEGER | ||
| status | NULLABLE | INTEGER | ||
| ctrnumber | This field stores the ctr number | NULLABLE | STRING | |
| inversedate | NULLABLE | STRING | ||
| accountnumber | This field stores the system account number affected by the transaction for the related Currency Transaction Report (CTR) Person record | NULLABLE | STRING | |
| slidtype | This field stores a code identifying the type of record associated with a transaction in the related CTR Person record | NULLABLE | INTEGER | |
| slid | This field stores the identification of a Share or Loan record associated with a transaction in the related CTR Person record | NULLABLE | STRING | |
| source | This field stores the source of funds associated with a transaction for the related CTR Person record | NULLABLE | INTEGER | |
| amount | This field stores the amount of funds associated with a transaction for the related CTR Person record | NULLABLE | INTEGER | |
| 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 |
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.
Did this page help you?
Last updated Tue Sep 15 2026