ssdb_irs_distribution_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_irs_distribution_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 | |
| irsdistributionkey | 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 | |
| type | This field stores a code that determines how the system uses the IRS Distribution record for dividends, maturity, or teller transactions | NULLABLE | INTEGER | |
| effectivedate | This field stores the date on which the IRS Distribution record should take effect | NULLABLE | DATE | |
| expirationdate | This field stores the date to expire this IRS Distribution record | NULLABLE | DATE | |
| amount | This field stores the required distribution amount based on the IRA Required Minimum Distribution (RMD) edit run calculation | NULLABLE | INTEGER | |
| distributioncode | This field stores a code that identifies the distribution code to use for the withdrawal | NULLABLE | INTEGER | |
| fedwholdcode | This field stores a code that determines how the system handles federal withholding for this distribution | NULLABLE | INTEGER | |
| fedwholdpercent | This field stores the percentage the system should withhold for federal withholding | NULLABLE | INTEGER | |
| fedwholdamount | This field stores a dollar amount for how much the system should withhold federal withholding | NULLABLE | INTEGER | |
| statewholdcode | This field stores a code that determines how the system handles state withholding for this distribution | NULLABLE | INTEGER | |
| statewholdpercent | This field stores the percentage the system should withhold for state withholding | NULLABLE | INTEGER | |
| statewholdamount | This field stores a dollar amount for how much the system should withhold state withholding | NULLABLE | INTEGER | |
| distributionmethod | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. This field stores a code that indicates how the distribution should be handled | NULLABLE | INTEGER | |
| destinationaccount | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution and a value of (1) Transfer in the Distribution Method field. This field stores the account number associated with the share to which you are transferring funds | NULLABLE | STRING | |
| destinationid | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution and a value of (1) Transfer in the Distribution Method field. This field stores the share ID to which you are transferring funds | NULLABLE | STRING | |
| distributionfreq | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. This field stores a code that defines how often the distribution should occur | NULLABLE | INTEGER | |
| distributionday1 | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. This field stores the day of the month on which you want the automatic distribution to take place for annual, semiannual, quarterly, monthly, or semimonthly transfers | NULLABLE | INTEGER | |
| distributionday2 | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. This field stores the day of the month on which you want a second distribution day within a month for semimonthly transfers | NULLABLE | INTEGER | |
| rege | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution and the Distribution Method field set to (1) Transfer. This field stores a code that indicates if the transfer be flagged as Reg E or not | NULLABLE | INTEGER | |
| nextdistributndate | This field is used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. This field stores the date of the next automatic share distribution | NULLABLE | DATE | |
| lastdistributnamt | This field stores the total amount of the distribution whenever the system performs certain distributions | NULLABLE | INTEGER | |
| lastdistributndate | This field stores the transaction posting date of the distribution whenever the system performs certain distributions | NULLABLE | DATE | |
| locator | This field stores a unique number within each member account that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| sourceid_1 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_2 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_3 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_4 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_5 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_6 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_7 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_8 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_9 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_10 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_11 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_12 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_13 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_14 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_15 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_16 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_17 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_18 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_19 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| sourceid_20 | These fields are used only for IRS Distribution records that have the IRS Distribution Type field set to (0) Auto Distribution. These fields store share IDs in the same account that you can use as source shares for IRS distributions | NULLABLE | STRING | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the IRS Distribution 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 |
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