loanapp_pledge_raw
Pipelined Data Sets
>
Symitar
>
loanapp_pledge_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 | |
| loanapppledgeuuid | This field stores a JH Platform unique identifier for a loan app pledge | NULLABLE | STRING | |
| loanappuuid | This field stores a JH Platform unique identifier for a loan app | NULLABLE | STRING | |
| accountnumber | The field stores the account number associated with the application, if any | NULLABLE | STRING | |
| loanappid | This field stores the parent, 4 digit Loan Application ID | NULLABLE | STRING | |
| loanapppledgekey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| loanappkey | 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 | |
| sortrank | 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 code that identifies the purpose of the Application Pledge record | NULLABLE | INTEGER | |
| id | The field stores the value in the ID field of the loan in the account associated with the application, if any | NULLABLE | STRING | |
| collateralcode | The field stores the value in the Collateral Code field of the associated Application record | NULLABLE | INTEGER | |
| percent | The field is not used for Application Pledge records | NULLABLE | NUMERIC | |
| amount | The field is not used for Application Pledge records | NULLABLE | NUMERIC | |
| locator | This field stores a unique number within each member account that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| collateralnumber | This field stores the reference to the Collateral record associated with this Application Pledge record | NULLABLE | STRING | |
| priority | This field stores a code that indicates the priority of the collateral associated with this Application Pledge record | NULLABLE | INTEGER | |
| effectivedate | This field stores the creation date of the Application Pledge record or, if entered manually, the date this Pledge record can be used | NULLABLE | DATE | |
| expirationdate | This field stores the date this Application Pledge record should expire | NULLABLE | DATE | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Application Pledge 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