participationloan_raw
Pipelined Data Sets
>
Symitar
>
participationloan_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 | |
| participationloanuuid | This field stores a JH Platform unique identifier for a participation loan | NULLABLE | STRING | |
| participationuuid | This field stores a JH Platform unique identifier for a participation | NULLABLE | STRING | |
| participationnumber | This field stores the participation number | NULLABLE | STRING | |
| participationloankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| participationkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | 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 | |
| accountnumber | This field stores the Account Number from the Account record to which the loan belongs. You cannot access this field for file maintenance | NULLABLE | STRING | |
| id | This field stores the Loan ID of the Loan record affected by the transaction. You cannot access this field for file maintenance | NULLABLE | STRING | |
| lastfmdate | This field stores the date of the last file maintenance of the Participation Loan record. Whenever you revise this Participation Loan record, Symitar updates this field with the system date. You cannot access this field for file maintenance | NULLABLE | DATE | |
| opendate | This field stores the date the loan was first associated with the participation | NULLABLE | DATE | |
| removedate | This field stores the date the loan is no longer associated with the participation. When you remove the loan from the participation, Symitar sets this field to the system date. You cannot access this field for file maintenance | NULLABLE | DATE | |
| locator | The Locator field value in each record is unique within each participation. This means that the Locator can be used as a unique identification of a specific record. The system automatically assigns the Locator value when the record is created, and you cannot change it. The value is a positive number greater than zero and up to about two billion | NULLABLE | INTEGER | |
| owneraccrinterest | This field stores the amount of interest due for the associated loan as of the date the agreement is funded. It is used only if the Pool Code field in the Participation record is set to Yes. The participant will not begin to receive interest until the amount of interest accrued for the loan when the agreement is funded has been paid. This is the interest due to the owner before the agreement was funded. Under normal circumstances, you should not revise this field | NULLABLE | NUMERIC | |
| chargedoffamount | When the system handles charged-off loans, it adds the amount distributed to this field. This field holds the total agreement amount charged off for this loan. If the Pool Code field in the Participation record is set to (1) Pool, the system uses this field to calculate principal amounts to reverse a charge-off or to remove a loan from the participation | NULLABLE | NUMERIC | |
| chgoffrecovered | When the system receives a payment on a charged-off loan, it adds the amount of principal applicable to the agreement to this field. This field holds the total agreement amount of principal recovered for this loan. If the Pool Code field in the Participation record is set to (1) Pool, the system uses this field to calculate principal amounts to reverse a charge-off or to remove a loan from the participation | NULLABLE | NUMERIC | |
| chgoffprocessdate | When the system processes charged-off loans, it places the date into this field. The system needs the field because the actual charge-off of a member loan occurs at a different time than when the system processes the charge-off for participations and because the system needs to know whether or not the charge-off has been processed yet | NULLABLE | DATE | |
| recordchangedate | The system stores the system date in the Record Change Date field when you create, change, or save the Participation Loan record | NULLABLE | DATE | |
| loanfundingdate | When an agreement is funded, the system populates this field with the system date for those Participation Loan records added to an agreement within a participation | 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