ssdb_eft_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_eft_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 | |
| eftkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| type | This field identifies the purpose of the EFT record | NULLABLE | INTEGER | |
| groupnumber | This field stores the credit union-defined number (up to six digits) of the payroll group or bill payment group referenced by the EFT record | NULLABLE | STRING | |
| idtype | This field determines whether the share, loan, or GL account is affected | NULLABLE | INTEGER | |
| id | This field stores the share or loan ID from which the funds will be withdrawn | NULLABLE | STRING | |
| payee | This field identifies the payee ID, payee name, or a portion of the payee name for this EFT record | NULLABLE | STRING | |
| reference | This field stores the external account number from the EFT record | NULLABLE | STRING | |
| effectivedate | This field indicates the date the funds transfers should start | NULLABLE | DATE | |
| expirationdate | This field stores the date after which the funds transfers should no longer occur | NULLABLE | DATE | |
| lasttrandate | This field stores the date of the last transaction | NULLABLE | DATE | |
| lasttranamount | This field stores the amount of the last transaction | NULLABLE | INTEGER | |
| postamount | This field indicates the amount posted to the member's account | NULLABLE | INTEGER | |
| standardamount | This field stores the standard dollar amount of the deposit, deduction, or distribution and is used for inquiries only | NULLABLE | INTEGER | |
| specificamount | This field stores the specific dollar amount for bill payments and is useful to change the bill payment amount temporarily | NULLABLE | INTEGER | |
| amountytd | This field stores the total amount of all funds transferred during the current year | NULLABLE | INTEGER | |
| creditlimit | This field stores the member's credit limit with the bill payment processor | NULLABLE | INTEGER | |
| countytd | This field stores the total number of funds transfers during the current year | NULLABLE | INTEGER | |
| audioid | This field controls audio response access for on-demand bill payment EFT records only | NULLABLE | STRING | |
| balance | For bill payment records only, this field stores the balance owed by the payee | NULLABLE | INTEGER | |
| federalwithholding | This field indicates the amount that should be withheld for federal taxes from an automated distribution of a tax-deferred share that has the IRS Code field set to (01) IRA, (02) Deferred Comp, (03) SEP, (04) Keogh, or (05) 401K | NULLABLE | INTEGER | |
| statewithholding | This field indicates the amount that should be withheld for state taxes from an automated distribution of a tax-deferred share that has the IRS Code field set to (01) IRA, (02) Deferred Comp, (03) SEP, (04) Keogh, or (05) 401K | NULLABLE | INTEGER | |
| dqcount | For bill payment EFT records only, this field indicates the total number of times the member has been delinquent with bill payments | NULLABLE | INTEGER | |
| amountcode | This field stores an optional credit-union defined code to indicate how bill payments should be calculated | NULLABLE | INTEGER | |
| status | This field stores a credit union-defined character that indicates the status of the EFT record | NULLABLE | STRING | |
| postfreq | This field is for information purposes only; it indicates the posting frequency of payrolls for inquiry purposes | NULLABLE | INTEGER | |
| matchcode1 | This field contains a code that specifies the ACH field to be matched with the information entered in the Match ID 1 field | NULLABLE | INTEGER | |
| matchid1 | This field stores the information to be matched to the ACH field that is specified in the Match Code 1 field | NULLABLE | STRING | |
| matchcode2 | This field contains a code that specifies the ACH field to be matched with the information entered in Match ID 2 field | NULLABLE | INTEGER | |
| matchid2 | This field specifies the information to be matched to the ACH field that is specified in the Match Code 2 field | NULLABLE | STRING | |
| distributionratio | This field indicates the amount to post | NULLABLE | INTEGER | |
| matchcode3 | This field contains a code that specifies the ACH field to be matched with the information entered in Match ID 3 field | NULLABLE | INTEGER | |
| matchid3 | This field specifies the information to be matched to the ACH field that is specified in the Match Code 3 field | NULLABLE | STRING | |
| nextdate | This field is used for scheduled bill payment EFT records (the EFT Type field is set to 1) posted by the Bill Payment Posting batch program or for ACH origination records (the EFT Type field is set to 3) handled by ACH Reports | NULLABLE | DATE | |
| frequency | This field is used for scheduled bill payment EFT records (the EFT Type field is set to 1) posted by Bill Payment Posting or for ACH origination (the EFT Type field is set to 3) handled by ACH Reports | NULLABLE | INTEGER | |
| day1 | This field stores the day of the month (1-31) on which the first scheduled bill payment or ACH origination should occur for annual, semiannual, quarterly, monthly, or semimonthly payments (the Frequency field is set to 1, 2, 3, 4, or 5) | NULLABLE | INTEGER | |
| day2 | This field stores the day of the month (1-31) on which the second scheduled bill payment or ACH origination should occur for semimonthly payments (the Frequency field is set to 5) | NULLABLE | INTEGER | |
| deferdate | This field stores the first date that scheduled bill payments or ACH origination should occur | NULLABLE | DATE | |
| locator | This field value in each record is unique for each member account | NULLABLE | INTEGER | |
| regdcode | This field indicates whether this EFT record is used to post a withdrawal that is subject to Regulation D limiting | NULLABLE | INTEGER | |
| reference2 | This field is used only when the EFT Type field is set to (3) ACH Origination. During the ACH origination process, for applicable SEC entries this information is in the ACH file as the individual identification number | NULLABLE | STRING | |
| prenotesentdate | This field stores the date that the pre-note or micro transaction amount is sent to the external financial institution (for ACH origination) | NULLABLE | DATE | |
| matchcode4 | This field stores a code that specifies the ACH field to be matched with the information entered in Match ID 4 field | NULLABLE | INTEGER | |
| matchid4 | This field specifies the information to be matched to the ACH field that is specified in the Match Code 4 field | NULLABLE | STRING | |
| matchcode5 | This field stores a code that specifies the ACH field to be matched with the information entered in Match ID 5 field | NULLABLE | INTEGER | |
| matchid5 | This field specifies the information to be matched to the ACH field that is specified in the Match Code 5 field | NULLABLE | STRING | |
| matchcode6 | This field stores a code that specifies the ACH field to be matched with the information entered in Match ID 6 field | NULLABLE | INTEGER | |
| matchid6 | This field specifies the information to be matched to the ACH field that is specified in the Match Code 6 field | NULLABLE | STRING | |
| recordchangedate | This field stores the system date when you create, change, or save the EFT record | NULLABLE | DATE | |
| batchachorignum | Each time NetTeller creates a new Batch ACH Origination number, this field stores a system-generated number for all EFT records that are related to the Batch ACH Origination record | NULLABLE | INTEGER | |
| glcode | This field specifies the GL code you are performing an ACH origination for when the ID Type field is set to GL Account | 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