ssdb_irs_name_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_irs_name_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 | |
| irsnamekey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| irskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| namehdrlastaddrchgdate | NULLABLE | DATE | ||
| namehdrcrnamechgdate | NULLABLE | DATE | ||
| namehdrcraddrchgdate | NULLABLE | DATE | ||
| namehdrcrssnchgdate | NULLABLE | DATE | ||
| namehdrcurrmthpaychgdate | NULLABLE | DATE | ||
| dobssn | NULLABLE | STRING | ||
| emailinternal | NULLABLE | STRING | ||
| altemailinternal | NULLABLE | STRING | ||
| type | This field stores a code that identifies the type of name of this Name record | NULLABLE | INTEGER | |
| subtype | This field stores a credit union-defined code that further identifies the type of Name record | NULLABLE | INTEGER | |
| mailoverride | This field stores a code that specifies whether the address in the Name record should override the mailing address in the primary Name record | NULLABLE | INTEGER | |
| ssnoverride | This field stores a code that determines if the Social Security Number (SSN) or Individual Taxpayer Identification Number (TIN) in this Name record should override the SSN or TIN in the primary Name record or not | NULLABLE | INTEGER | |
| ssncertification | This field stores a code that helps ensure that your credit union handles dividend withholding correctly | NULLABLE | INTEGER | |
| effectivedate | This field stores the date that indicates when the information in this Name record should be used | NULLABLE | DATE | |
| expirationdate | This field stores the date that indicates when the information in this Name record should no longer be used | NULLABLE | DATE | |
| ssn | This field stores the individual SSN (Social Security Number), ITIN (Individual Taxpayer Identification Number), or the organizational EIN (Employer Identification Number) of the person identified in the Name record | NULLABLE | STRING | |
| lastfmdate | The system stores the date in this field of the last file maintenance to the Name record | NULLABLE | DATE | |
| beneficiarypercent | This field stores the percentage of funds allocated to the beneficiary identified in the Name record | NULLABLE | INTEGER | |
| irscorrection | This field stores a code that identifies the IRS type of error being corrected | NULLABLE | INTEGER | |
| ecoacode | This field contains an Equal Credit Opportunity Act (ECOA) code that indicates how the system should report loans to credit bureaus | NULLABLE | INTEGER | |
| locator | The system stores a unique number within each member account in this field that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| lastaddrverifdate | The system stores the date of the most recent address verification for the member | NULLABLE | DATE | |
| creditreportconsumerinfo | This field stores a 2-character code that identifies the individual bankruptcy status used for the Metro 2® Format Credit Reporting system | NULLABLE | STRING | |
| creditreportconsumerinfodate | This field stores the date when you last performed file maintenance on the Credit Report Consumer Info field | NULLABLE | DATE | |
| extrainfo | This field stores a character string related to the beneficiary | NULLABLE | STRING | |
| recordchangedate | The system stores the system date in this field when you create, change, or save this Name record if the change is made from this Name record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| nonacctnamenum | The system stores the unique value in this field assigned within each Non-Account Name record when it is created | NULLABLE | STRING | |
| membernumlink | The system stores a pointer in this field to the MBR Number field in the Member record linked with this Name record | NULLABLE | STRING | |
| mbraddrnumlink | The system stores a pointer in this field to the ADDR Number field in the Member Address record linked with this Name record | NULLABLE | STRING | |
| fmlastpurgedate | The system stores the date in this field through which file maintenance history for Name records was last purged by the Purge Transaction Processing batch program | NULLABLE | DATE | |
| membernumlinkchgdate | The system stores the current system date when the MBR Number Link field changes | NULLABLE | DATE | |
| mbraddrnumlinkchgdate | The system stores the current system date when the ADDR Number Link field changes | NULLABLE | DATE | |
| confidential | This field stores a code that indicates a member has an Account that they wish to keep private or not | NULLABLE | INTEGER | |
| marketingaddress | This field stores a code that specifies whether to use the address associated with this Name record for marketing a not | NULLABLE | INTEGER | |
| creditreportaddrindicator | This field stores a 1-character code that causes a Share or Loan Note record to be posted with information about the address reported in the Name record | NULLABLE | STRING | |
| creditreportaddrindicatordate | This field stores the date when the Credit Rpt Address Indicator field is updated with an address indicator value or any non-blank value | NULLABLE | DATE | |
| beneficialowner | This field stores a code that identifies if this person is a beneficial owner of a legal entity | NULLABLE | INTEGER | |
| beneficialpercent | This field stores the percentage of the equity interests of the legal entity customer that this person owns | NULLABLE | INTEGER | |
| irs1042samendnum | This field stores a code that identifies the number of times you submitted a corrected 1042-S form | 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