externalloan_raw
Pipelined Data Sets
>
Symitar
>
externalloan_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| externalloanuuid | This field stores a JH Platform unique identifier for an external loan | NULLABLE | STRING | |
| accountuuid | This field stores a JH Platform unique identifier for an account | NULLABLE | STRING | |
| accountnumber | This field stores the account number of the external loan on the third-party system | NULLABLE | STRING | |
| externalloankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| rownumber | Internal use only; SSDB field | NULLABLE | INTEGER | |
| symdate | Internal use only; SSDB field | NULLABLE | INTEGER | |
| systemcreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odscreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sym | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odsdeleteflag | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| type | This field stores a credit union-defined code that the system bases the rules associated with the loan | NULLABLE | INTEGER | |
| description | This field stores a description of the loan | NULLABLE | STRING | |
| balance | This field stores the principal balance of the loan on the date it was last updated | NULLABLE | NUMERIC | |
| princintpayment | This field stores the amount of the member's scheduled principal and interest payment for the date entered in the Next Payment Due Date field | NULLABLE | NUMERIC | |
| escrowpayment | This field stores the amount of the member's escrow payment for the date entered in the Next Payment Due Date field | NULLABLE | NUMERIC | |
| impoundpayment | This field stores the impound payment amount for the mortgage loan | NULLABLE | NUMERIC | |
| latechargedue | This field stores the amount of any late charges the member must pay on the date entered in the Next Payment Due Date field | NULLABLE | NUMERIC | |
| paymentdue | This field stores the total payment amount for the loan | NULLABLE | NUMERIC | |
| duedate | This field stores the due date for the total payment amount stored in the Payment Due field | NULLABLE | DATE | |
| lastupdatedate | This field stores the date on which the External Loan record was last updated by an edit run | NULLABLE | DATE | |
| statementgroup | This field stores the credit union-defined statement group for the loan | NULLABLE | INTEGER | |
| statementmailcode | This field stores a code that defines how the statement should be sent to the member | NULLABLE | INTEGER | |
| statementdate | This field stores the statement cutoff date for the loan | NULLABLE | DATE | |
| statementprevdate | This field stores the date of the last statement for the external loan | NULLABLE | DATE | |
| warningcode_1 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_2 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_3 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_4 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_5 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_6 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_7 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_8 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_9 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_10 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_11 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_12 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_13 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_14 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_15 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_16 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_17 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_18 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_19 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningcode_20 | These 20 fields can each contain a code that identifies a different credit union-defined warning to apply to this loan | NULLABLE | INTEGER | |
| warningexpiration_1 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_2 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_3 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_4 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_5 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_6 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_7 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_8 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_9 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_10 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_11 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_12 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_13 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_14 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_15 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_16 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_17 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_18 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_19 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| warningexpiration_20 | These 20 fields can each contain a date after which the corresponding warning should no longer apply to the loan | NULLABLE | DATE | |
| closedate | This field stores the date a loan is closed | NULLABLE | DATE | |
| activitydate | This field stores the date of the previous monetary transaction that affected the External Loan record | NULLABLE | DATE | |
| creditlimit | This field stores the credit limit of the external loan. This field is for informational use only. It is up to the third-party processor to use this field | NULLABLE | NUMERIC | |
| availcredit | This field stores the available credit amount provided by the external loan provider | NULLABLE | NUMERIC | |
| advance | This field stores the accumulated amount of all advances since the core FICS® server program last updated the status of the External Loan record | NULLABLE | NUMERIC | |
| lastadvdate | This field stores the last time an advance was taken against the loan | NULLABLE | DATE | |
| lastfmdate | This field stores the date of the last file maintenance of this External Loan record | NULLABLE | DATE | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the 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 | |
| lasttrandate | This field stores the date of the last teller or batch transaction that affected the External Loan record | NULLABLE | DATE | |
| service_1 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_2 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_3 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_4 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_5 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_6 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_7 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| service_8 | The eight Service # fields can each contain a code that identifies a different credit union-defined credit union services offered with an external loan (for example, an ATM card, a debit card, or access to the audio response system) | NULLABLE | INTEGER | |
| locator | This field stores a unique number within each member account that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| status | This field stores a code that indicates if the external loan is active or inactive | NULLABLE | INTEGER | |
| cashadvancelimit | This field stores the cash advance credit limit of the external loan | NULLABLE | NUMERIC | |
| availablecashadvance | This field stores the available cash advance provided by the external loan provider | NULLABLE | NUMERIC |
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