loan_transfer_raw
Pipelined Data Sets
>
Symitar
>
loan_transfer_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 | |
| loantransferuuid | This field stores a JH Platform unique identifier for a loan transfer | NULLABLE | STRING | |
| loanuuid | This field stores a JH Platform unique identifier for a loan | NULLABLE | STRING | |
| accountnumber | This field indicates the account to or from which the funds are transferred | NULLABLE | STRING | |
| loanid | This field stores the 4 digit Loan ID | NULLABLE | STRING | |
| loantransferkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| loankey | 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 indicates the type of transfer performed | NULLABLE | INTEGER | |
| idtype | This field indicates which type of account is affected | NULLABLE | INTEGER | |
| id | This field indicates the ID of the account to or from which the funds are transferred | NULLABLE | STRING | |
| amount | This field indicates the amount that should be transferred | NULLABLE | NUMERIC | |
| percent | This field indicates the percentage of the dividend to be transferred | NULLABLE | NUMERIC | |
| effectivedate | This field stores the date on which the transfer record should take effect | NULLABLE | DATE | |
| expirationdate | This field stores the date on which the Transfer record is no longer valid | NULLABLE | DATE | |
| amountoption | This field is used only for Loan Transfer records to credit card loans that have the Transfer Type field set to (3) Automatic Payment | NULLABLE | INTEGER | |
| nextdate | This field stores the date of the next automatic share transfer | NULLABLE | DATE | |
| frequency | This field determines the frequency of the transfer | NULLABLE | INTEGER | |
| day1 | This fields determines the date on which automatic transfers should occur for annual, semiannual, quarterly, monthly, semimonthly, or bimonthly transfers | NULLABLE | INTEGER | |
| day2 | This fields determines the date on which automatic transfers should occur for semi-monthly transfers | NULLABLE | INTEGER | |
| locator | This field value in each record is unique for each member account | NULLABLE | INTEGER | |
| minimumbalance | This field is used for share sweeps; it stores the minimum balance the share can reach | NULLABLE | NUMERIC | |
| maximumbalance | This field is used for share sweeps; it stores the maximum balance the share can reach | NULLABLE | NUMERIC | |
| rege | This field indicates whether automatic share transfers and payroll EFT transfers are designated as governed by Reg E | NULLABLE | INTEGER | |
| lastdate | This field indicates the date on which you want the final transfer to be made | NULLABLE | DATE | |
| paymenttype | This field indicates how a payment should be handled when transferring funds from a share to a loan | NULLABLE | INTEGER | |
| sweepminimum | This field stores the minimum amount to transfer in a share sweep | NULLABLE | NUMERIC | |
| sweepfee | This field is used for MBS sweeps; it stores the amount you want to charge for sweeps | NULLABLE | NUMERIC | |
| sweepfeeidtype | This field is used for MBS sweeps; it determines whether the sweep will be charged to a share or loan | NULLABLE | INTEGER | |
| sweepfeeid | This field is used for MBS sweeps; it specified the ID of the Share or Loan record that will be charged for the sweep | NULLABLE | STRING | |
| recordchangedate | This field stores the system date when you create, change or save the Transfer record | NULLABLE | DATE | |
| extloanaccount | This field stores the number of the external loan account | NULLABLE | STRING | |
| maturitycheck | Used for Share records, this field indicates whether the system should issue a check when the certificate matures | 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