ssdb_loan_app_escrow_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_loan_app_escrow_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 | |
| loanappescrowkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| loanappkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| escrowtype | This field stores a code defined by your financial institution in the Escrow Type parameters to indicate the type of funds being escrowed | NULLABLE | INTEGER | |
| nextdistribdate | This field contains the date of the next anticipated escrow distribution | NULLABLE | DATE | |
| lastdistribdate | This field stores the date of the last distribution made for the Escrow record. When new Loan Escrow records are created this field may remain blank | NULLABLE | DATE | |
| lastdisbursdate | This field contains the value copied from the Loan Escrow record Next Distribution Date field | NULLABLE | DATE | |
| prevdisbursdate | This field contains the value copied from the Loan Escrow record Last Disbursement Date field | NULLABLE | DATE | |
| policyorigdate | This field stores the date the insurance policy originated. This field must be populated with a date for the PMI notices and disclosures to function properly | NULLABLE | DATE | |
| policyexpiredate | This field stores the date the insurance policy expires | NULLABLE | DATE | |
| distribfrequency | When an escrow disbursement is processed using the Daily Posting batch program, the value at this field is used to update the Next Distribution Date field | NULLABLE | INTEGER | |
| lastdisbursfreq | This field contains the value from the Distribution Frequency field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| prevdisbursfreq | This field contains the value from the Last Disbursement Frequency field | NULLABLE | INTEGER | |
| printdistribnotice | This field indicates whether an escrow distribution notice should be printed each time funds relating to the Escrow record are disbursed | NULLABLE | INTEGER | |
| forcedplacedins | This field indicates whether the credit union has had to acquire an insurance policy for a mortgaged property. Force-placed insurance is necessary when the borrower fails to provide the required insurance protection | NULLABLE | INTEGER | |
| trackingonly | This field indicates whether you track items without collecting any escrow funds and without including the Loan Escrow record in escrow analysis | NULLABLE | INTEGER | |
| floodinstracking | This field enables you to track mortgage loans that require flood insurance | NULLABLE | INTEGER | |
| paydividend | This field stores whether dividends are paid on the escrow type | NULLABLE | INTEGER | |
| lastnbrpmtsdue | This field stores how many escrow payments are due, based on the value in the Current Payment Frequency field | NULLABLE | INTEGER | |
| prevnbrpmtsdue | This field stores the previous number of escrow payments due, based on the value in the Last Number Pmts Due in Period field | NULLABLE | INTEGER | |
| vendornumber | This field (from the Vendor record) stores the vendor identification that is used to pay recipients through the GL Posting batch program using the (2) Accounts Payable Posting option | NULLABLE | STRING | |
| invoicenumber | This field stores the invoice number as it appears on the vendor's invoice. This field can contain any characters, including blanks | NULLABLE | STRING | |
| realestateowner | This field stores the name or names of the owners of the real estate held as collateral. The owners may also be the borrowers, but occasionally property owned by one person is pledged to the mortgage loan of another | NULLABLE | STRING | |
| taxrefnumber | This field stores the real estate tax reference number or identification number issued by the taxing authority and used to help identify the real property being taxed | NULLABLE | STRING | |
| parcelnumber | This field stores the real estate parcel number issued by some taxing authorities that is used to help identify the real estate property being taxed | NULLABLE | STRING | |
| legaldescription | This field stores the legal description of the real estate | NULLABLE | STRING | |
| policyowner | This field stores the name (or names) of the insurance policy owners | NULLABLE | STRING | |
| policynumber | This field stores the insurance policy number that the insurance premium is being paid on | NULLABLE | STRING | |
| nextdistribamount | This field stores the amount of the next distribution for an Escrow record | NULLABLE | INTEGER | |
| lastdistribamount | This field stores the amount of the last distribution made for the Escrow record. When new Loan Escrow records are created this field may remain blank | NULLABLE | INTEGER | |
| lastdisbursamt | This field stores the value from the Next Distribution Amount field in the same Loan Escrow record if the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| prevdisbursamt | This field stores the amount from the Last Disbursement Amount field of the Loan Escrow record, during escrow analysis | NULLABLE | INTEGER | |
| lastdateanacalc | If values in a Loan Escrow record are used during escrow analysis, this field stores the system date the analysis was run. This date is used when the last escrow analysis is being recreated | NULLABLE | DATE | |
| paymentportion | This field contains the part of the total escrow payment for one mortgage loan that applies to the Escrow Type field value in the Escrow record | NULLABLE | INTEGER | |
| prevdateanacalc | This field stores the amount from the Last Date Analysis Calculated field of the Loan Escrow record, during escrow analysis | NULLABLE | DATE | |
| policyamount | This field stores the amount of the insurance policy | NULLABLE | INTEGER | |
| lastamtneededpmt | This field contains the amount calculated based on the value of the Last Total Annual Disbursemnts field divided by the value at the Last Number Pmts Due in Period | NULLABLE | INTEGER | |
| prevamtneededpmt | This field stores the amount from the Last Amt Needed From Each Pmt field of the Loan Escrow record, during escrow analysis | NULLABLE | INTEGER | |
| lasttotanndisburs | This field contains a value calculated by multiplying the Last Disbursement Amount in the Loan Escrow record by the frequency of the disbursement as defined by the Last Disbursement Frequency field | NULLABLE | INTEGER | |
| prevtotanndisburs | This field stores the amount from the Last Total Annual Disbursemnts field of the Loan Escrow record, during escrow analysis | NULLABLE | INTEGER | |
| lastmonthcushion | This field contains the cushion amount needed to offset any shortages for the last month of escrow | NULLABLE | INTEGER | |
| prevmonthcushion | This field stores the amount from the Last Month of Cushion field of the Loan Escrow record, during escrow analysis | NULLABLE | INTEGER | |
| locator | Symitar Quest stores a unique number within each member account in this field that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| day1 | This field stores the day of the month (1-31) on which the first escrow payment is due for semi-monthly escrow payments or the day of the month on which all escrow payments are due for annual, semi-annual, quarterly, or monthly escrow payments | NULLABLE | INTEGER | |
| day2 | This field stores the day of the month (1-31) on which the second escrow payment is due for semi-monthly escrow payments. This field is not used for annual, semi-annual, quarterly, or monthly escrow payments | NULLABLE | INTEGER | |
| lastdisburseday1 | This field stores the value from the Day 1 field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| lastdisburseday2 | This field stores the value from the Day 2 field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| prevdisburseday1 | This field stores the value from the Last Disbursement Day 1 field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| prevdisburseday2 | This field stores the value from the Last Disbursement Day 2 field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | INTEGER | |
| recordchangedate | NULLABLE | DATE | ||
| pmidisclosuredate | This field stores the date when the next annual PMI disclosure is to be generated for all residential mortgages | NULLABLE | DATE | |
| pmicancelnotice | This field indicates whether a PMI cancellation notice is generated for the corresponding loan | NULLABLE | INTEGER | |
| pmicanceldate | This field stores the date PMI was canceled on the loan. This date is manually entered when the PMI is canceled | NULLABLE | DATE | |
| pmitermdate | This field contains the date when the lender generally must terminate the PMI | NULLABLE | DATE | |
| pmimidtermdate | This field stores the date the loan is halfway through the period between the first day of the amortization period and the ending when the mortgage is scheduled to be amortized | NULLABLE | DATE | |
| pmielignotices | This field stores the type of eligibility notice assigned to the corresponding loan | NULLABLE | INTEGER | |
| expirationdate | This field stores the date the Escrow record expires. Symitar Quest uses this field to determine whether the Escrow record is included in escrow projections and escrow disbursements. See Escrow Analysis Calculations for a detailed explanation | NULLABLE | DATE | |
| lastexpirationdate | This field stores the value from the Expiration Date field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | DATE | |
| prevexpirationdate | This field stores the value from the Last Expiration Date field in the same Loan Escrow record when the Loan Escrow record is used in the escrow analysis | NULLABLE | DATE | |
| savedadjustpayment | This field stores whether you have saved the value for the Adjust Payment Portion field from Escrow Type Parameters that was used during the last analysis | NULLABLE | INTEGER | |
| pmicancelreason | This field indicates the reason the PMI was canceled on the loan. A non-zero value is required for MIS loans with a cancellation date | 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