ssdb_savings_check_order_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_savings_check_order_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 | |
| savingscheckorderkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| savingskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| processor | This field identifies the check order processor | NULLABLE | INTEGER | |
| status | This field indicates the current status of the check order | NULLABLE | INTEGER | |
| opendate | This field stores the date the Check Order record was created | NULLABLE | DATE | |
| lastorderdate | This field stores the date a check order was last sent to the processor | NULLABLE | DATE | |
| statusdate | This field stores the date when you changed the value in the Status field | NULLABLE | DATE | |
| lastfmdate | This field stores the date of the last file maintenance of this Check Order record | NULLABLE | DATE | |
| checktype | This field specifies the type of checks being ordered | NULLABLE | INTEGER | |
| branch | This field stores a processor-assigned code that identifies your credit union | NULLABLE | INTEGER | |
| startnumber | This fields stores either the starting check number for new orders or the starting reorder number | NULLABLE | INTEGER | |
| quantity | This field specifies the number of checks being ordered | NULLABLE | INTEGER | |
| checkstyle | This field specifies the style of checks being ordered | NULLABLE | STRING | |
| coverstyle | This field specifies the style of the checkbook cover | NULLABLE | STRING | |
| cutnumber | This field is used by Clarke American, Harland, and Deluxe only, and it specifies the style of the cut (insignia) on the checks | NULLABLE | STRING | |
| billingcode | This field specifies how the check order should be billed | NULLABLE | INTEGER | |
| shipmethod | This field specifies how the check order should be shipped | NULLABLE | INTEGER | |
| shipto | This field is used by Clarke American, Deluxe, and Liberty only, and it specifies to whom the check order should be shipped | NULLABLE | INTEGER | |
| imprintfont | This field specifies the font for the imprint lines | NULLABLE | INTEGER | |
| imprintjustify | This field is used by Clarke American, Harland, and Liberty only, and it specifies the justification (alignment) of the imprint lines | NULLABLE | INTEGER | |
| imprintline_1 | This field specifies the first line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintline_2 | This field specifies the second line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintline_3 | This field specifies the third line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintline_4 | This field specifies the fourth line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintline_5 | This field specifies the fifth line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintline_6 | This field specifies the sixth line of name or address information to be imprinted on the checks | NULLABLE | STRING | |
| imprintphone | This field is used by Clarke American and Deluxe only, and it specifies the telephone number to be imprinted on the checks | NULLABLE | STRING | |
| imprintzipcode | This field is used by Clarke American and Deluxe only, and it specifies the ZIP Code to be imprinted on the checks | NULLABLE | STRING | |
| mailaddress_1 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailaddress_2 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailaddress_3 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailaddress_4 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailaddress_5 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailaddress_6 | These fields specify the mailing address for the check order | NULLABLE | STRING | |
| mailzipcode | This field is used by Clarke American and Harland only, and it specifies the ZIP Code the check order should be mailed to | NULLABLE | STRING | |
| oversigline_1 | This field specifies the information to be imprinted on the first line of text, over the signature line (or signature lines) | NULLABLE | STRING | |
| oversigline_2 | This field specifies the information to be imprinted on the second line of text, over the signature line (or signature lines) | NULLABLE | STRING | |
| oversigfont | This field is used by Clarke American, Harland, and Liberty only, and it specifies the font style for the Over Signature Line 1 and Over Signature Line 2 fields | NULLABLE | INTEGER | |
| numbersiglines | This field specifies the number of signature lines to be included on the checks | NULLABLE | INTEGER | |
| coverinitials | This field is used by Clarke American and Harland only, and it specifies the initials, if any, to be imprinted on the checkbook cover | NULLABLE | STRING | |
| specialinstr_1 | This field stores a line of special instructions for the processor | NULLABLE | STRING | |
| specialinstr_2 | This field is used by Clarke American, Deluxe, and Liberty only, and it stores a second line of special instructions | NULLABLE | STRING | |
| specialinstr_3 | These fields are used by Deluxe only, and they store the third through eighth lines of special instructions | NULLABLE | STRING | |
| specialinstr_4 | This field stores a line of special instructions for the processor | NULLABLE | STRING | |
| specialinstr_5 | This field stores a line of special instructions for the processor | NULLABLE | STRING | |
| specialinstr_6 | This field stores a line of special instructions for the processor | NULLABLE | STRING | |
| specialinstr_7 | This field stores a line of special instructions for the processor | NULLABLE | STRING | |
| specialinstr_8 | These fields are used by Deluxe only, and they store the third through eighth lines of special instructions | NULLABLE | STRING | |
| ssn_1 | This field is used by Deluxe only, and it specifies the Social Security Number or individual Taxpayer Identification Number to be imprinted on checks | NULLABLE | STRING | |
| ssn_2 | This field is used by Deluxe only, and it specifies the second Social Security Number or individual Taxpayer Identification Number to be imprinted on checks | NULLABLE | STRING | |
| license_1 | This field is used by Deluxe only, and it specifies the license number to imprint on the checks | NULLABLE | STRING | |
| license_2 | This field is used by Deluxe only, and it specifies a second license number to be imprinted on the checks | NULLABLE | STRING | |
| binding | This field is not currently used | NULLABLE | STRING | |
| design | This field is not currently used | NULLABLE | STRING | |
| businessserial | This field is used by Deluxe only, and it specifies the serial letters to be imprinted after the check number on the business checks | NULLABLE | STRING | |
| busnumcopies | This field is used by Deluxe only, and it indicates the number of carbonless check copies required (in addition to the original check) for business checks | NULLABLE | INTEGER | |
| busbindingstyle | This field is used by Deluxe only, and it specifies the binding style of the checkbook for business checks | NULLABLE | INTEGER | |
| busvouchernumber | This field is used by Deluxe only, and it indicates the voucher number that designates the purpose of the checks | NULLABLE | STRING | |
| buscaptions_1 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_2 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_3 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_4 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_5 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_6 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_7 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| buscaptions_8 | These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks | NULLABLE | STRING | |
| promonumber | This field is used by Clarke America, Harland, and Deluxe only, and it stores a promo number | NULLABLE | STRING | |
| acctaddrinkcolor | This field is used by Deluxe only, and it specifies the ink color for the account and address information imprinted on the business checks | NULLABLE | INTEGER | |
| titleinkcolor | This field is used by Deluxe only, and it specifies the ink color used for the title plate for business checks | NULLABLE | INTEGER | |
| cutinkcolor | This field is used by Deluxe only, and it specifies the ink color used for the cut (insignia) for business checks | NULLABLE | INTEGER | |
| taxexemptcode | This field is used by Harland only, and it specifies whether the check order is tax-exempt | NULLABLE | INTEGER | |
| rerunreason | This field is used by Harland only, and it specifies the reason a check order must be rerun | NULLABLE | INTEGER | |
| imprintlinesize_1 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| imprintlinesize_2 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| imprintlinesize_3 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| imprintlinesize_4 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| imprintlinesize_5 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| imprintlinesize_6 | These fields are used by Harland only, and they specify the font size for each imprint line | NULLABLE | INTEGER | |
| oversigjustify | This field is used by Clarke American and Harland only, and it specifies the alignment for the over signature lines | NULLABLE | INTEGER | |
| oversiglinesize | This field is used by Harland only, and it specifies the font size for the over signature lines | NULLABLE | INTEGER | |
| ponumber | This field is used by Harland only, and it stores the purchase number for the check order | NULLABLE | STRING | |
| chargeshipping | This field is used by Liberty only, and it specifies whom to charge the shipping costs to | NULLABLE | INTEGER | |
| imprintusage_1 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| imprintusage_2 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| imprintusage_3 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| imprintusage_4 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| imprintusage_5 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| imprintusage_6 | These fields are used by Liberty only, and they specifies how each imprint line is used | NULLABLE | INTEGER | |
| accent | This field is used by Liberty only, and it specifies the accent figure printed to the left of the name | NULLABLE | STRING | |
| phantom | This field is used by Liberty only, and it specifies the phantom figure printed in the center of the checks | NULLABLE | STRING | |
| sigfigure | This field is used by Liberty only, and it specifies the signature figure printed next to the signature line | NULLABLE | STRING | |
| checkinitials | This field is used by Clarke American only, and it specifies the initials, if any, to be imprinted on the checks | NULLABLE | STRING | |
| imprintcity | This field is used by Clarke American only, and it specifies the name of the city to be imprinted on the checks | NULLABLE | STRING | |
| imprintstate | This field is used by Clarke American only, and it specifies the two-character U.S. Postal Service state code to be imprinted on the checks | NULLABLE | STRING | |
| mailcity | This field is used by Clarke American only, and it specifies the name of the city to which the check order should be mailed | NULLABLE | STRING | |
| mailstate | This field is used by Clarke American only, and it specifies the two-character U.S. Postal Code for the state to which the check order should be mailed | NULLABLE | STRING | |
| micrline | This field stores the information to be imprinted magnetically on the MICR line at the bottom of the check | NULLABLE | STRING | |
| userid | This field stores the user number of the person who creates the Check Order record | NULLABLE | INTEGER | |
| lastfreeorder | This field records the date for a free or promotional check order | NULLABLE | DATE | |
| locator | This field value in each record is unique for each member account | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date when you create, change, or save the Check Order record | NULLABLE | DATE |
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