ssdb_ctr_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_ctr_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 | |
| ctrkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| inversedate | NULLABLE | STRING | ||
| drt | NULLABLE | INTEGER | ||
| number | This field stores a unique number identifying a specific Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| transeq | This field stores a sequential number for each Currency Transaction Report (CTR) record in a file sent to the Financial Crimes Enforcement Network (FinCEN) | NULLABLE | STRING | |
| trandate | This field stores the date of the currency transaction for each Currency Transaction Report (CTR) record | NULLABLE | DATE | |
| status | This field stores a code indicating the current status of the Currency Transaction Report (CTR) record | NULLABLE | INTEGER | |
| statusdate | This field stores the date the status changed to the current status | NULLABLE | DATE | |
| createbyuser | This field stores the name of the user who created the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| createdate | This field stores the current system date when the Currency Transaction Report (CTR) record was created | NULLABLE | DATE | |
| incompletebyuser | This field stores the name of the user who changed the status to Incomplete | NULLABLE | STRING | |
| incompletedate | This field stores the date the status was changed to Incomplete | NULLABLE | DATE | |
| exemptbyuser | This field stores the name of the user who changed the status in the Currency Transaction Report (CTR) record to Exempt | NULLABLE | STRING | |
| exemptdate | This field stores the date the status field in the Currency Transaction Report (CTR) record was changed to Exempt | NULLABLE | DATE | |
| nonreportbyuser | This field stores the name of the user who changed the status to Non-Reportable | NULLABLE | STRING | |
| nonreportdate | This field stores the date that the status field in the Currency Transaction Report (CTR) record was changed to Non-Reportable | NULLABLE | DATE | |
| verifybyuser | This field stores the name of the user who verified the information in the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| verifydate | This field stores the date the Currency Transaction Report (CTR) record was verified | NULLABLE | DATE | |
| verifyamendbyuser | This field stores the name of the user who changed the status to Verified Amendment | NULLABLE | STRING | |
| verifyamenddate | This field stores the date the status changed to Verified Amendment | NULLABLE | DATE | |
| tcc | This field stores the eight-character Transmitter Control Code (TCC) assigned by FinCEN that you entered at the Transmitter TCC prompt in the CTR Processing batch program | NULLABLE | STRING | |
| fitype | This field stores the code associated with the financial institution type you selected at the Type of Financial Institution prompt in the CTR Processing batch program | NULLABLE | STRING | |
| approvebyuser | This field stores the name of the user who approved the information in the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| approvedate | This field stores the date that the Currency Transaction Report (CTR) record was approved | NULLABLE | DATE | |
| approveamendbyuser | This field stores the name of the user who approved the amendment to the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| approveamenddate | This field stores the date that an amendment to the Currency Transaction Report (CTR) record was approved | NULLABLE | DATE | |
| fiothertype | If you select "Z - Other" at the Type of Financial Institution prompt, this field stores a brief description of the institution type you entered at the Financial Institution Type Other Description prompt in the CTR Processing batch program | NULLABLE | STRING | |
| fiidnumbertype | This field stores the financial institution's identification number from the Financial Institution ID Number Type prompt in CTR Processing batch program | NULLABLE | STRING | |
| submitbyuser | This field stores the name of the user who changed the status to Submitted | NULLABLE | STRING | |
| submitdate | This field stores the date the status changed to Submitted | NULLABLE | DATE | |
| resubamendbyuser | This field stores the name of the user who changed the status to Resub Amendment | NULLABLE | STRING | |
| resubamenddate | This field stores the date the status changed to Resub Amendment | NULLABLE | DATE | |
| fiidnumber | This field stores the financial institution's identification number from the Financial Institution ID Number prompt in the CTR Processing batch program | NULLABLE | STRING | |
| filingtype | This field stores the code that identifies the type of filing | NULLABLE | STRING | |
| ackbyuser | This field stores the name of the user who changed the Currency Transaction Report (CTR) record status to Acknowledged | NULLABLE | STRING | |
| ackdate | This field stores the date the Currency Transaction Report (CTR) record status was acknowledged | NULLABLE | DATE | |
| ackerrorbyuser | This field stores the name of the user who changed the Currency Transaction Report (CTR) record status to Ack w/Errors | NULLABLE | STRING | |
| ackerrordate | This field stores the date the Currency Transaction Report (CTR) record status was changed to Ack w/Errors | NULLABLE | DATE | |
| filingdate | This field stores the filing date from the Date Filed prompt in the CTR Processing batch program | NULLABLE | DATE | |
| cashintotal | This field stores the total aggregate amount of the cash-in currency involved in the transaction | NULLABLE | INTEGER | |
| cashouttotal | This field stores the total aggregate amount of the cash-out currency involved in the transaction | NULLABLE | INTEGER | |
| rsnarmcarflag | This field stores a code indicating whether the currency transaction in the Currency Transaction Report (CTR) record was done by an armored car service | NULLABLE | INTEGER | |
| rsnmailshipflag | This field stores a code indicating whether this currency transaction was performed via mail deposit or shipment | NULLABLE | INTEGER | |
| rsnshbrflag | This field stores a code indicating whether the currency transaction in the Currency Transaction Report (CTR) record was made through shared branching | NULLABLE | INTEGER | |
| rsnaggregateflag | This field stores a code indicating whether you have identified the transaction type as part of aggregated transactions in the Currency Transaction Report (CTR) | NULLABLE | INTEGER | |
| backfileflag | This field stores a code indicating whether the Currency Transaction Report (CTR) record is being backfiled | NULLABLE | INTEGER | |
| dcnumber | This field stores a unique number provided by the Financial Crimes Enforcement Network (FinCEN) which allows amended records to be matched in their system | NULLABLE | STRING | |
| preparer | This field stores the name of the person who prepared the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| approver | This field stores the name of the person who approved the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| approvertitle | This field stores the title of the person who approved the Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| contactoffice | This field stores the name of the person or office to contact for information concerning the CTR | NULLABLE | STRING | |
| contactphone | This field stores the phone number of the person or office who should be contacted about this Currency Transaction Report (CTR) record | NULLABLE | STRING | |
| branchrouting | This field stores the branch routing number where the transaction in this Currency Transaction Report (CTR) record takes place | NULLABLE | STRING | |
| federalregulator | This field stores the federal regulator or Bank Secrecy Act (BSA) examiner code with primary responsibility for enforcing the institution's Bank Secrecy Act compliance | NULLABLE | INTEGER | |
| lastfmdate | This field stores the date of the last file maintenance associated with the Currency Transaction Report (CTR) record | NULLABLE | DATE | |
| fmpurgedate | This field stores the date through which file maintenance history was purged using the Purge Transaction Processing batch program | NULLABLE | DATE | |
| recordchangedate | This field stores the system date whenever you create, change, or save a record | NULLABLE | DATE | |
| rsnatmflag | This field stores a code indicating whether a currency transaction occurred through an ATM | NULLABLE | INTEGER | |
| rsnngtdepflag | This field stores a code indicating whether a currency transaction occurred through a night deposit | NULLABLE | INTEGER | |
| batchsequence | Batch Sequence is populated in the CTR Record with the Batch Sequence number of the CTR Processing batch program | NULLABLE | INTEGER | |
| lastsubmitdate | The CTR Processing batch program updates this field when a CTR record was last submitted to FinCEN | NULLABLE | DATE | |
| cashindeposit | This field stores the total cash deposited by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinpayment | This field stores the total cash received for by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinfundsxfer | This field stores the total cash received for funds to be transferred by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinnegins | This field stores the total cash received for the purchase of negotiable instruments by persons involved in the CTR | NULLABLE | INTEGER | |
| cashincurrxchng | This field stores the cash received as part of currency exchange by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinprepaid | This field stores the cash received as part of prepaid access by persons involved in the CTR | NULLABLE | INTEGER | |
| cashingamingins | This field stores the cash received for gaming instruments (casino chips, tokens, etc) by persons involved in the CTR | NULLABLE | INTEGER | |
| cashincurrwager | This field stores the cash received for betting wagers by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinbillsinsert | This field stores the cash (bills) inserted in gaming machines by persons involved in the CTR | NULLABLE | INTEGER | |
| cashinotherdesc | A description for the type of transaction that occurred relating to the funds contained in the Cash-In Other amount field | NULLABLE | STRING | |
| cashinother | This field stores the cash received as part of a transaction described as Other by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutwithdraw | This field stores the total cash withdrawn by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutadvoncred | This field stores the total cash-out amount for advances on credit (including markers) by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutfundsxfer | This field stores the total cash-out amount from funds transferred to the credit union by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutnegins | This field stores the total cash out amount from negotiable instruments cashed by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutcurrxchng | This field stores the cash out amount as part of currency exchange by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutprepaid | This field stores the cash out amount from prepaid access by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutgamingins | This field stores the cash out amount from the redemption of casino chips, tokens, TITO tickets, and other gaming instruments by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutpayonwagers | This field stores the cash out amount for payment on wagers (including race book and OTB or sports pool) by persons involved in the CTR | NULLABLE | INTEGER | |
| cashouttravel | This field stores the cash out amount for travel and complimentary expenses and gaming incentives by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutpromo | This field stores the cash out amount for payment for tournament, contest or other promotions by persons involved in the CTR | NULLABLE | INTEGER | |
| cashoutotherdesc | A description for the type of transaction that occurred relating to the funds contained in the Cash-Out Other amount field | NULLABLE | STRING | |
| cashoutother | This field stores the cash out amount as part of a transaction described as Other by persons involved in the CTR | NULLABLE | INTEGER | |
| contactphoneext | This field stores the phone number extension of the person or office who should be contacted about this Currency Transaction Report (CTR) record | 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.
Did this page help you?
Last updated Tue Sep 15 2026