ssdb_savings_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_savings_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 | |
| savingskey | 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 | |
| id | This field stores a unique two- or four-character ID that identifies the Share record | NULLABLE | STRING | |
| checkdigits | This field stores check digits that your financial institution may use to help the system verify account numbers when processing drafts, ATM transactions, or outside processor transactions. Both the account number and the check digits must be valid, or the system reports the transaction as an exception | NULLABLE | STRING | |
| type | This field stores a credit union-defined code to identify the type of share | NULLABLE | INTEGER | |
| lastfmdate | This field stores the date of the last file maintenance of this Share record or a child record of this Share record | NULLABLE | DATE | |
| lasttrandate | This field stores the posting date of the last monetary transaction that affected this Share record | NULLABLE | DATE | |
| opendate | This field stores the date the share was opened | NULLABLE | DATE | |
| closedate | This field stores the date the Share record was closed | NULLABLE | DATE | |
| reference | This field stores any share-related reference information, such as an employment date | NULLABLE | STRING | |
| warningcode_1 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_2 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_3 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_4 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_5 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_6 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_7 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_8 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_9 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_10 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_11 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_12 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_13 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_14 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_15 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_16 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_17 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_18 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_19 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| warningcode_20 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this share | NULLABLE | INTEGER | |
| service_1 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_2 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_3 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_4 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_5 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_6 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_7 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_8 | The eight service number fields can each contain a code that identifies a different credit union-defined credit union services offered with a share (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| sharecode | This field stores a code that defines the share type description for this record | NULLABLE | INTEGER | |
| irscode | This field stores a code that defines how this share should be reported to the IRS | NULLABLE | INTEGER | |
| divpostcode | This field stores a code that determines how earned dividends are paid | NULLABLE | INTEGER | |
| lastdivdate | This field stores the date dividends were last posted for this share | NULLABLE | DATE | |
| lastdivamount | This field stores the amount of the last dividend posted for this share | NULLABLE | INTEGER | |
| divytd | This field stores the total amount of all dividends posted for the share during the current year with the SV transaction code and the Dividend Posting batch program | NULLABLE | INTEGER | |
| divlastyear | This field stores the total amount of all dividends posted for the share during the previous year | NULLABLE | INTEGER | |
| divfromopen | This field stores the total amount of all dividends posted for the share since it was opened | NULLABLE | INTEGER | |
| divtype | This field stores a credit union-defined code (defined with the Dividend Type Definitions parameters) to identify the type of dividend calculation performed for this share | NULLABLE | INTEGER | |
| divrate | This field stores the rate used to calculate dividends for this share | NULLABLE | INTEGER | |
| divaccrualdate | This field stores the date that dividends were last accrued for this share | NULLABLE | DATE | |
| divaccrual | This field stores the total amount of any dividends accrued for this share, but not posted to the share | NULLABLE | INTEGER | |
| withholdingcode | This field stores a code that indicates whether the system takes federal backup withholding from dividends | NULLABLE | INTEGER | |
| withholdingytd | This field stores the combined total of the amounts withheld for federal taxes during the current year from dividend payments and distributions | NULLABLE | INTEGER | |
| withholdinglastyear | This field stores the combined total of the amounts withheld from dividend payments and distributions of IRA shares for federal taxes during the previous year | NULLABLE | INTEGER | |
| penaltytype | This field stores a code that specifies how penalties should be assessed for early withdrawal of a certificate. It provides ceilings on the penalty period | NULLABLE | INTEGER | |
| penaltyytd | This field stores the total amount of penalties assessed for early withdrawal of certificates during the current year | NULLABLE | INTEGER | |
| penaltylastyear | This field stores the total amount of penalties assessed for early withdrawal of certificates during the previous year | NULLABLE | INTEGER | |
| balance | The current balance of the share is stored in this field | NULLABLE | INTEGER | |
| originalbalance | This field stores the amount deposited during the first Share Deposit (SD) teller transaction to this share | NULLABLE | INTEGER | |
| minimumbalance | This field stores the minimum balance required for this share | NULLABLE | INTEGER | |
| insurancetype | This field stores a credit union-defined code that identifies the type of insurance | NULLABLE | INTEGER | |
| insurancemaximum | This field stores the maximum share balance covered by insurance | NULLABLE | INTEGER | |
| insurancebalanceage_1 | This field stores the amount of the highest share balance less than or equal to the value in the Insurance Maximum field left in the share since the member reached age 55 | NULLABLE | INTEGER | |
| insurancebalanceage_2 | This field stores the amount of the highest share balance less than or equal to the value in the Insurance Maximum field left in the share since the member reached age 60 | NULLABLE | INTEGER | |
| insurancebalanceage_3 | This field stores the amount of the highest share balance less than or equal to the value in the Insurance Maximum field left in the share since the member reached age 65 | NULLABLE | INTEGER | |
| insurancebalanceage_4 | This field stores the amount of the highest share balance less than or equal to the value in the Insurance Maximum field left in the share since the member reached age 70 | NULLABLE | INTEGER | |
| minimumdeposit | This field stores the minimum amount that can be deposited to the share in a single transaction | NULLABLE | INTEGER | |
| minimumwithdrawal | This field stores the minimum amount that can be withdrawn from the share in a single transaction | NULLABLE | INTEGER | |
| withdrawallimit | This field stores the maximum number of withdrawals allowed from the share | NULLABLE | INTEGER | |
| withdrawalcount | This field stores the number of withdrawals to date from this share | NULLABLE | INTEGER | |
| withdrawnfromopen | This field stores the total amount withdrawn from the share since it was opened except in the case when a share certificate is renewed by the Daily Posting batch program | NULLABLE | INTEGER | |
| withdrawalfeetype | This field stores a credit union-defined code that specified how the system assesses withdrawal fees | NULLABLE | INTEGER | |
| withdrawalfeecount | This field stores the number of lobby visits, teller uses, or withdrawals that have been made by a member that qualify under the Withdrawal Fee Type parameters for a fee | NULLABLE | INTEGER | |
| lastpurgedate | This field stores the date of the last share history purge for this Share record | NULLABLE | DATE | |
| statementgroup | This field stores a credit union-defined statement group number that can be used to specify groups to be processed in batch programs | NULLABLE | INTEGER | |
| statementdate | This field stores the most recent date statements were produced for this share | NULLABLE | DATE | |
| statementmailcode | This field stores a code that indicates if statements for this share should be mailed to the member or, if not, why not | NULLABLE | INTEGER | |
| regecount | This field stores the number of Regulation E transactions posted to this share since the last statement cutoff date | NULLABLE | INTEGER | |
| regdcheckcount | This field stores the number of Regulation D automatic transfers posted to this share during the current month | NULLABLE | INTEGER | |
| regdtransfercount | This field stores the number of Regulation D telephone transfers for this share during the current month | NULLABLE | INTEGER | |
| maturitypostcode | This field is used only for shares with a Share record that has the Share Code field set to (2) Certificate or (3) Club. This field stores a code that determines how the balance of the certificate or club share is paid at maturity | NULLABLE | INTEGER | |
| maturitydate | This field stores the date the certificate or club share matures | NULLABLE | DATE | |
| termfrequency | This field stores a code that determines how the term of the certificate or club share is calculated | NULLABLE | INTEGER | |
| termperiod | This field stores the period for the term of a certificate or club share | NULLABLE | INTEGER | |
| certificatenumber | This field stores a specific number to identify a certificate or the last unique certificate number used in a series | NULLABLE | STRING | |
| description | This field stores a share description that displays in inquiries and on statements | NULLABLE | STRING | |
| loanpaymenthold | This field stores the total amount held in reserve to cover pledged loan payments for loans in the account that reference this share | NULLABLE | INTEGER | |
| statementprevdate | This field stores the previous date statements were produced for this share | NULLABLE | DATE | |
| bondintytd | This field stores the amount of interest earned on bonds during the current year | NULLABLE | INTEGER | |
| bondintlastyear | This field stores the amount of interest earned on bonds during the previous year | NULLABLE | INTEGER | |
| nsfmonthtodate | This field stores the number of times during the current month that this share had insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| nsfytd | This field stores the number of times during the current year that this share had insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| nsflastyear | This field stores the number of times during the previous year that this share had insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| xfrmonthtodate | This field stores the number of transfers to this share during the current month | NULLABLE | INTEGER | |
| xfrytd | This field stores the number of transfers to this share during the current year | NULLABLE | INTEGER | |
| xfrlastyear | This field stores the number of transfers to this share during the previous year | NULLABLE | INTEGER | |
| warningexpiration_1 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_2 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_3 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_4 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_5 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_6 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_7 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_8 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_9 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_10 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_11 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_12 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_13 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_14 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_15 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_16 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_17 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_18 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_19 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| warningexpiration_20 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the share | NULLABLE | DATE | |
| feecount_1 | These fields store the number of times a specific fee has been assessed for this share, or the number of times a specified transaction has occurred (for calculating or charging a fee) | NULLABLE | INTEGER | |
| feecount_2 | These fields store the number of times a specific fee has been assessed for this share, or the number of times a specified transaction has occurred (for calculating or charging a fee) | NULLABLE | INTEGER | |
| feecount_3 | These fields store the number of times a specific fee has been assessed for this share, or the number of times a specified transaction has occurred (for calculating or charging a fee) | NULLABLE | INTEGER | |
| feecount_4 | These fields store the number of times a specific fee has been assessed for this share, or the number of times a specified transaction has occurred (for calculating or charging a fee) | NULLABLE | INTEGER | |
| statewithholdingcode | This field stores a code that indicates whether the system takes state backup withholding from dividends. This field affects teller transactions only and has no effect on batch transactions | NULLABLE | INTEGER | |
| statewithholdingytd | This field stores the combined total of all amounts withheld for state taxes from distributions of a tax-deferred share during the current year | NULLABLE | INTEGER | |
| statewithholdinglastyear | This field stores the combined total of all amounts withheld for state taxes from distributions from a tax-deferred share during the previous year | NULLABLE | INTEGER | |
| cutotalsusecode | This field stores a code that specifies if the share balance is included in credit union totals calculations | NULLABLE | INTEGER | |
| divperiodstart | This field stores the starting date for the dividend period | NULLABLE | DATE | |
| divperiodbaldays | This field stores the sum of the balances for each day between the values in the Dividend Period Start and the Dividend Accrual Date fields if you perform a rate change in the middle of the dividend period | NULLABLE | INTEGER | |
| chargeoffamount | This field stores the amount charged off | NULLABLE | INTEGER | |
| chargeoffdate | This field stores the date the share was charged off | NULLABLE | DATE | |
| chargeofftype | This field stores the credit union-defined code indicating why this share was charged off or the type of share that was charged off | NULLABLE | INTEGER | |
| creditreportingcode | This field stores a code that specifies how the share should be reported to credit bureaus | NULLABLE | INTEGER | |
| creditreportnumber | This field stores the number used for reporting about this share to the credit bureaus. You cannot access this field for file maintenance | NULLABLE | STRING | |
| branch | This field stores the number of the branch that "owns" the share. When you create a Share record, the default is the branch at which you create the Share record | NULLABLE | INTEGER | |
| creditreportoccurdate | This field stores the last Metro Credit Reporting date of occurrence reported to the credit bureau | NULLABLE | DATE | |
| creditreportlaststatus | This field stores the last Metro credit reporting status code reported to the credit bureau | NULLABLE | INTEGER | |
| creditreportcomment | This field stores a character code that indicates information reported to credit reporting agencies in the Metro Credit Reporting Special Comments field | NULLABLE | STRING | |
| bumprate | This field stores the percentage to add to the "normal" rate during dividend calculations for the period specified between the values in the Bump Effective Date and the Bump Expiration Date fields. The "normal" rate is the rate that would otherwise be used for dividend purposes | NULLABLE | INTEGER | |
| bumpeffectivedate | This field stores the date on which the value in the Bump Rate field becomes effective | NULLABLE | DATE | |
| bumpexpirationdate | This field stores the date on which the value in the Bump Rate field expires | NULLABLE | DATE | |
| irsplan | This field specifies a code that the system uses, along with the IRS Code field in this record and the SSN/TIN field in the related Member record, to connect specific Share records to a specific IRS record | NULLABLE | INTEGER | |
| originaldepositdate | This field stores the date of the first deposit to this share | NULLABLE | DATE | |
| originaldeposit | This field stores the amount of the first deposit to the share | NULLABLE | INTEGER | |
| creditreportconsumerinfo | This field stores a character code that provides consumer information for the Metro 2® Format for credit reports | NULLABLE | STRING | |
| creditreportcompliance | This field stores a character code that provides compliance information for the Metro 2® Format for credit reports | NULLABLE | STRING | |
| activitydate | This field store the date of the previous monetary transaction that affected the Share record | NULLABLE | DATE | |
| courtesypaymonthtodate | This field stores the number of courtesy pays charged during the current month | NULLABLE | INTEGER | |
| courtesypayytd | This field stores the number of courtesy pays and alternate courtesy pays charged during the current year | NULLABLE | INTEGER | |
| courtesypaylastyear | This field stores the number of courtesy pays charged during the previous year | NULLABLE | INTEGER | |
| overdrafttolerance | This field specifies the dollar limit a share can go negative beyond the existing overdraft options | NULLABLE | INTEGER | |
| cddivaccrytd | This field stores the certificate dividend accrued during the current year | NULLABLE | INTEGER | |
| cddivaccrlastyr | This field stores the certificate dividend accrued during the last year | NULLABLE | INTEGER | |
| amortizationschd | Primarily for users of the corporate interface: This field stores the numeric value of the set of Amortization Schedules parameters (Amortization Global Schedules or Amortization Local Schedules defined in the Parameter Manager) | NULLABLE | INTEGER | |
| amortizationschdtype | Primarily for users of the corporate interface: This field stores a code that indicates the nature of the set of Amortization Schedules parameters | NULLABLE | INTEGER | |
| dividendratemarginsign | This field specifies a positive (+) or negative (-) sign to be associated with the value in the Dividend Rate Margin field | NULLABLE | INTEGER | |
| dividendrateperioddate | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores the last anniversary date, or semi-annual anniversary date, for the cap (depending on your periodic cap frequency) | NULLABLE | DATE | |
| dividendrateperiodfreq | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores a code indicating the frequency associated with the Periodic Cap field | NULLABLE | INTEGER | |
| dividendratemargin | This field stores the rate margin that, when added to the base rate, produces a variable dividend rate for the current date | NULLABLE | INTEGER | |
| dividendratemax | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores a maximum dividend rate for variable rate dividend calculations | NULLABLE | INTEGER | |
| dividendratemin | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores a minimum dividend rate for variable rate dividend calculations | NULLABLE | INTEGER | |
| periodiccap | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field affects only shares with variable dividend rates and contains the maximum dividend rate change allowed | NULLABLE | INTEGER | |
| periodicstartrate | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores the dividend rate as of the Periodic Cap Start Date field value | NULLABLE | INTEGER | |
| callitemschd | Primarily for users of the corporate interface: This field stores the numeric value of the set of Call Item Schedules parameters (Call/Put Item Global Schedules or Call/Put Item Local Schedules defined in the Parameter Manager) | NULLABLE | INTEGER | |
| callitemschdtype | Primarily for users of the corporate interface: This field stores a code that indicates the nature of the set of Call Item Schedules parameters | NULLABLE | INTEGER | |
| memberusertransfercode | For users of the corporate interface only: This field stores a code that indicates which type of Corporate Transfer Parameters applies to this share when a member user is making a transfer using the corporate interface. This type number is the rule set for this share | NULLABLE | INTEGER | |
| corporateusertransfercode | For users of the corporate interface only: This field stores a code that indicates which type of Corporate Transfer Parameters applies to this share when a corporate user is making a transfer using the corporate interface on behalf of a member user. This type number is the rule set for this share | NULLABLE | INTEGER | |
| memberbranchsupport | For users of the corporate interface only: If we have configured your institution as a corporate credit union, this field stores a code that indicates if you want member branch support for this share | NULLABLE | INTEGER | |
| mcdivytd | This field stores the year-to-date dividends for a certificate share. It is only populated for mature certificates | NULLABLE | INTEGER | |
| mcdivlastyear | This field stores the dividends accrued in the previous year for a certificate share. It is only populated for matured certificates | NULLABLE | INTEGER | |
| userchar1 | These four custom fields can store any credit union-defined character data | NULLABLE | STRING | |
| userchar2 | These four custom fields can store any credit union-defined character data | NULLABLE | STRING | |
| userchar3 | These four custom fields can store any credit union-defined character data | NULLABLE | STRING | |
| userchar4 | These four custom fields can store any credit union-defined character data | NULLABLE | STRING | |
| useramount1 | These two custom fields can store any credit union-defined cash amount | NULLABLE | INTEGER | |
| useramount2 | These two custom fields can store any credit union-defined cash amount | NULLABLE | INTEGER | |
| userdate1 | These two custom fields can store any credit union-defined date | NULLABLE | DATE | |
| userdate2 | These two custom fields can store any credit union-defined date | NULLABLE | DATE | |
| putitemschd | Primarily for users of the corporate interface: This field stores the numeric value of the set of Put Item Schedules parameters used to put items (Call/Put Item Global Schedules or Call/Put Item Local Schedules defined in the Parameter Manager) | NULLABLE | INTEGER | |
| putitemschdtype | Primarily for users of the corporate interface: This field stores a code that indicates the nature of the set of Put Item Schedules parameters | NULLABLE | INTEGER | |
| ledgeraccrual | This field stores the ledger accrual amount for this share. The accrual batch process updates this field. This is a protected field, but not a required one | NULLABLE | INTEGER | |
| ledgeraccrualdate | This field stores the date on which the accrual batch process updates the ledger accrual for this share during daily accruals. This is a protected field, but not a required one | NULLABLE | DATE | |
| currdivpayable | This field stores the total of all outstanding dividends that have been accrued, but unpaid, regardless of the month from which they are outstanding (the accrued dividends from the value in the Last Dividend Date field) | NULLABLE | INTEGER | |
| currmonthpaiddiv | This field stores the total of all dividends earned and paid in the current month | NULLABLE | INTEGER | |
| mtdpaiddivs | This field stores the total of all dividends paid in the current month, regardless of when the dividend was earned | NULLABLE | INTEGER | |
| mtdaccrueddivs | This field stores the total outstanding accrued unpaid dividends for the current calendar month | NULLABLE | INTEGER | |
| mtdearneddivs | This field stores the total of all dividends earned (both unpaid and paid) for the current calendar month, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivpaid_1 | These three fields store the total of all dividends paid in three previous months | NULLABLE | INTEGER | |
| premthdivpaid_2 | These three fields store the total of all dividends paid in three previous months | NULLABLE | INTEGER | |
| premthdivpaid_3 | These three fields store the total of all dividends paid in three previous months | NULLABLE | INTEGER | |
| premthdivaccrued_1 | These three fields store the total of all outstanding accrued unpaid dividends in three previous months | NULLABLE | INTEGER | |
| premthdivaccrued_2 | These three fields store the total of all outstanding accrued unpaid dividends in three previous months | NULLABLE | INTEGER | |
| premthdivaccrued_3 | These three fields store the total of all outstanding accrued unpaid dividends in three previous months | NULLABLE | INTEGER | |
| premthdivearned_1 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_2 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_3 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_4 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_5 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_6 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_7 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_8 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_9 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_10 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_11 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| premthdivearned_12 | These fields store the total of all dividends earned, unpaid and paid, for 12 previous calendar months, regardless of dividend payment or accrual | NULLABLE | INTEGER | |
| mtdpriorrateaccrual | This field stores the dividend accrual for the current calendar month | NULLABLE | INTEGER | |
| lastaccrualupdatedate | This field stores the last date on which the accruals for the Share record were updated. You cannot access this field for file maintenance | NULLABLE | DATE | |
| micracctnumber | This field stores the account number portion of a draft's MICR line | NULLABLE | STRING | |
| unpaidfeeytd | This field stores the total amount of unpaid item fees assessed during the current year | NULLABLE | INTEGER | |
| unpaidfeelastyear | This field stores the total amount of unpaid item fees assessed during the previous year | NULLABLE | INTEGER | |
| overdraftfeeytd | This field stores the total amount of overdraft item fees assessed during the current year | NULLABLE | INTEGER | |
| overdraftfeelastyr | This field stores the total amount of overdraft item fees assessed during the previous year | NULLABLE | INTEGER | |
| lastcrreportdate | This field is for informational use only and may be used in the future | NULLABLE | DATE | |
| creditreportconsumerinfodate | This field stores the date of the last file maintenance to the Credit Report Consumer Info field | NULLABLE | DATE | |
| extachxfrdailylimitin | This field stores the maximum daily dollar limit for home banking account-to-account transfers into this share | NULLABLE | INTEGER | |
| extachxfrdailylimitout | This field stores the maximum daily dollar limit for home banking account-to-account transfers out of this share | NULLABLE | INTEGER | |
| statewithholdingqtd | This field stores the total amount withheld for state taxes from distributions of tax-deferred shares during the current quarter | NULLABLE | INTEGER | |
| statewithholdinglastqtr | This field stores the total amount withheld for state taxes from distributions of tax-deferred shares during the previous quarter | NULLABLE | INTEGER | |
| analysisgroupprimaryacct | Used with the MBS Account Analysis module. This field stores the primary account number in this field, which links all the shares to the account number entered | NULLABLE | STRING | |
| analysisgroupprimaryid | Used with the MBS Account Analysis module. This field stores the primary ID in this field, which links all the shares to the ID entered | NULLABLE | STRING | |
| analysispmtacct | Used with the MBS Account Analysis module. This field stores the number of the account to be charged the monthly Account Analysis fee | NULLABLE | STRING | |
| analysispmtslid | Used with the MBS Account Analysis module. This field stores the share ID to charge the monthly Account Analysis fee | NULLABLE | STRING | |
| analysispmtidtype | Used with the MBS Account Analysis module. This field stores a code that identifies whether a share or loan is to be charged the monthly Account Analysis fee | NULLABLE | INTEGER | |
| nickname | This field stores a nickname for a share | NULLABLE | STRING | |
| renewsharetype | When a user begins to update share defaults for the first time, the initial value for this field is 00 or 0000. However, when the default value in the Share Type field is changed, the system automatically populates this field with the same value. The user can then change that value as desired | NULLABLE | INTEGER | |
| renewtermfreq | When a user begins to update share defaults for the first time, the initial value for this field is (0) Months. You can also select (1) Days. If the Term Frequency field is populated in the share type defaults, the system automatically also populates this field, perform file maintenance on the field if a different renew value should be used | NULLABLE | INTEGER | |
| renewtermperiod | When a user begins to update share defaults for the first time, the initial value for this field is 0000. If the Term Period field is populated in the share defaults, the system automatically also populates this field with the same value, and this field requires file maintenance if a different renew value should be used | NULLABLE | INTEGER | |
| divdisbupdtactvtyd | This field stores a code to indicate whether Dividend Posting or Daily Posting batch programs should update the Activity Date field | NULLABLE | INTEGER | |
| sweepbalancetype | Used with MBS Share Sweeps. This field stores a code that identifies whether the available or ledger balance for a share will be used to calculate the balance for the shares involved in the sweep relationship | NULLABLE | INTEGER | |
| sweeptargetminimum | Used with MBS Share Sweeps. This field stores the minimum balance for shares involved in a sweep transfer | NULLABLE | INTEGER | |
| sweeptargetmaximum | Used with MBS Share Sweeps. This field stores the maximum balance for shares involved in a sweep transfer | NULLABLE | INTEGER | |
| sweeppriority | Used with MBS Share Sweeps. This field stores a code that identifies the order in which share sweep transfers should be reviewed for processing. For example, one share requires funds, and the share from which the system is taking funds does not have enough funds, so that share looks to a third share for the required funds | NULLABLE | INTEGER | |
| lastdirectdepdate | This field stores the date the last direct deposit transaction occurred for an account | NULLABLE | DATE | |
| lastdirectdepamt | This field stores the amount of the last deposit transaction posted to an account | NULLABLE | INTEGER | |
| regdctrstartday | This field stores a code that resets the Reg D Check Count and Reg D Transfer Count fields in the Share record to a day of the month, as determined by your credit union's policies and procedures | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date when you create, change, or save the Share 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 | |
| cappedfeesamtperiod | This field stores the sum of the capped fees charged by batch programs, teller transactions, and online transaction processing to the share during a time period you specify | NULLABLE | INTEGER | |
| cappedfeesamountcap | This field stores the dollar amount your credit union sets for its capped fees amount | NULLABLE | INTEGER | |
| cappedfeescntperiod | This field stores the number of occurrences of capped fees, incrementing by one, each time a capped fee is charged to the share | NULLABLE | INTEGER | |
| cappedfeescountcap | This field stores the number of fee occurrences at which your credit union stops charging capped fees for the share during a time period you specify | NULLABLE | INTEGER | |
| createdbyuser | The user ID is stored in this field, and it is populated when this Share record is created | NULLABLE | INTEGER | |
| createdatbranch | This field stores the branch ID of the branch where the Share record is created | NULLABLE | INTEGER | |
| escrowedloanid | This field stores the ID of the Loan record to which the escrow portion of the share relates | NULLABLE | STRING | |
| authfeeoption_1 | These fields each contain a code that determines whether to authorize ODT funds, assess a courtesy pay fee, or assess an NSF fee for all overdrawn transactions | NULLABLE | INTEGER | |
| authfeeoption_2 | These fields each contain a code that determines whether to authorize ODT funds, assess a courtesy pay fee, or assess an NSF fee for all overdrawn transactions | NULLABLE | INTEGER | |
| authfeeoption_3 | These fields each contain a code that determines whether to authorize ODT funds, assess a courtesy pay fee, or assess an NSF fee for all overdrawn transactions | NULLABLE | INTEGER | |
| authfeeoption_4 | These fields each contain a code that determines whether to authorize ODT funds, assess a courtesy pay fee, or assess an NSF fee for all overdrawn transactions | NULLABLE | INTEGER | |
| authfeeoption_5 | This field is used for transactions identified as recurring (based on an indicator provided by the Network/Merchant) and also for transactions that are not specified in the ODT Source Code List 1-ODT Source Code List 4. and it determines whether to authorize ODT funds, assess a courtesy pay fee, or assess an NSF fee for all overdrawn transactions | NULLABLE | INTEGER | |
| odtauthfeesrccodelist_1 | This field is used to enter the transaction source codes, or credit union-defined source codes used for other types of Share withdrawal transactions, that corresponds to the setting in the ODT Auth/Fee Option 1-ODT Auth/Fee Option 4 fields | NULLABLE | STRING | |
| odtauthfeesrccodelist_2 | This field is used to enter the transaction source codes, or credit union-defined source codes used for other types of Share withdrawal transactions, that corresponds to the setting in the ODT Auth/Fee Option 1-ODT Auth/Fee Option 4 fields | NULLABLE | STRING | |
| odtauthfeesrccodelist_3 | This field is used to enter the transaction source codes, or credit union-defined source codes used for other types of Share withdrawal transactions, that corresponds to the setting in the ODT Auth/Fee Option 1-ODT Auth/Fee Option 4 fields | NULLABLE | STRING | |
| odtauthfeesrccodelist_4 | This field is used to enter the transaction source codes, or credit union-defined source codes used for other types of Share withdrawal transactions, that corresponds to the setting in the ODT Auth/Fee Option 1-ODT Auth/Fee Option 4 fields | NULLABLE | STRING | |
| feeexemptcrtsybal | This field stores the sum of all courtesy amounts applied minus deposits with a value in the Share Transaction record's Source Code field designated to not charge a courtesy pay fee | NULLABLE | INTEGER | |
| nsffeemtd | This field stores the number of times during the current month that a fee was charged for insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| nsffeeytd | This field stores the number of times during the current year that a fee was charged for insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| nsffeely | This field stores the number of times during the previous year that a fee was charged for insufficient funds for a requested transaction | NULLABLE | INTEGER | |
| courtesyfeemtd | This field stores the number of times during the current month that a courtesy pay fee was charged for a requested transaction | NULLABLE | INTEGER | |
| courtesyfeeytd | This field stores the number of times during the current calendar year that a courtesy pay fee was charged for a requested transaction | NULLABLE | INTEGER | |
| courtesyfeely | This field stores the number of times during the previous calendar year that a courtesy pay fee was charged for a requested transaction | NULLABLE | INTEGER | |
| negativebalancedate | This field stores the first date when the share balance went into its current negative state | NULLABLE | DATE | |
| creditreportoriginalamountrptd | This field stores the amount the share is overdrawn at the time of initial reporting to the bureaus for the current delinquency | NULLABLE | INTEGER | |
| negativebalancenoticetype | This field stores the negative balance notice type code defined in the Negative Balance Notice Messages parameters | NULLABLE | INTEGER | |
| negativebalancenoticenumber | This field stores the total number of negative balance notices generated for this share | NULLABLE | INTEGER | |
| negativebalancenoticedate | This field stores the last date a negative balance notice was generated for this share | NULLABLE | DATE | |
| escrowytd | This field stores the total amount of escrow paid to this share during the current year | NULLABLE | INTEGER | |
| escrowlastyear | This field stores the total amount of escrow paid to this share during the previous year | NULLABLE | INTEGER | |
| chapter4withholdingcode | This field stores a code that determines whether the system withholds Chapter 4 tax withholding from paid dividends | NULLABLE | INTEGER | |
| chapter4withheldytd | This field stores the total amount of Chapter 4 withholding during the current year | NULLABLE | INTEGER | |
| chapter4withheldlstyr | This field stores the total amount of Chapter 4 withholding from the previous year | NULLABLE | INTEGER | |
| yearendbalance | This field stores the year-end balance of the share | NULLABLE | INTEGER | |
| irs1042sufid | This field stores a unique form identifier that specifies which form the withholding agent is correcting or amending when filing multiple returned forms for the same recipient | NULLABLE | INTEGER | |
| positivepaydraft | This field allows the user to add the share to the Positive Pay Draft module | NULLABLE | INTEGER | |
| versionid | 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