agreement_raw
Pipelined Data Sets
>
Symitar
>
agreement_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 | |
| agreementuuid | This field stores a JH Platform unique identifier for an agreement | 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 | |
| agreementkey | 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 | |
| id | This field contains a unique numeric identifier for the agreement within the participation | NULLABLE | STRING | |
| participantnumber | This field contains an identifier of the financial institution participant associated with this agreement | NULLABLE | STRING | |
| certificatenumber | You can optionally enter the certificate number for the agreement in this field | NULLABLE | STRING | |
| lastfmdate | This field stores the date file maintenance was last performed on the Agreement record. Whenever you revise the Agreement record, the system updates this field with the system date | NULLABLE | DATE | |
| opendate | This field stores the creation date for the agreement | NULLABLE | DATE | |
| closedate | This field stores the date the agreement was closed out | NULLABLE | DATE | |
| lastpurgedate | This field stores the date of the last purge for agreement transactions | NULLABLE | DATE | |
| feecalcmethod | The system calculates participation service fees based on your selection in this field | NULLABLE | INTEGER | |
| fundingseqnum | This field indicates the order in which the system applies funding to the participant for participation loans containing single loans | NULLABLE | INTEGER | |
| ownershippercent | This field stores the percentage of the participation owned by this agreement | NULLABLE | NUMERIC | |
| interestrate | This field stores the interest rate for the agreement | NULLABLE | NUMERIC | |
| fixedfeepercent | This field stores the percentage of the fee charged | NULLABLE | NUMERIC | |
| fundingmaxamount | This field indicates the maximum funding for the participant | NULLABLE | NUMERIC | |
| principalpaid | This field stores the total amount of principal paid to the agreement for the life of the agreement | NULLABLE | NUMERIC | |
| interestpaid | This field stores the total amount of interest paid to the participant of this agreement for the life of the agreement | NULLABLE | NUMERIC | |
| feespaid | This field stores the total amount of service fees paid on the agreement for the life of the agreement | NULLABLE | NUMERIC | |
| balance | This field stores the balance of the portion of the loan included in the agreement | NULLABLE | NUMERIC | |
| principalfunded | This field stores the total principal funded by the participant through the life of the agreement | NULLABLE | NUMERIC | |
| interestdate | This field stores the most recent date through which interest was accrued for the portion of the loan owned by the agreement | NULLABLE | DATE | |
| interestunpaid | This field stores the unpaid interest for the portion of the loan owned by the agreement | NULLABLE | NUMERIC | |
| fundingdate | The system sets this field to the current system date when the agreement is funded. Under normal circumstances, you should not revise this field | NULLABLE | DATE | |
| owneraccrinterest | This field contains the amount of interest due for the associated loan as of the date the agreement is funded | NULLABLE | NUMERIC | |
| distlatechg | This field determines whether to distribute late charges collected from the member to the participant | NULLABLE | INTEGER | |
| proratefund | When an agreement is added to a participation and funded, the associated member loans may be in mid-cycle of their payment. This field controls whether the participant should get the full interest or if that interest should be prorated | NULLABLE | INTEGER | |
| latechgpaid | When the system distributes late charges or lease termination fees to the participant from the member's payment, it adds the amount distributed to this field | NULLABLE | NUMERIC | |
| chgoffamt | When the system posts GL entries for charged-off loans, it adds the amount distributed to this field. This field holds the total amount charged off for the life of the agreement | 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 | NULLABLE | NUMERIC | |
| chgoffremoved | When the system removes a charged-off loan from the participation, it adds the amount of principal applicable to the agreement to this field | NULLABLE | NUMERIC | |
| origfeepercent | This field contains the percentage value the system uses to calculate all or a portion of the one-time origination fee assessed to the participant | NULLABLE | NUMERIC | |
| origfeeamt | This field contains the fixed amount the system uses to calculate all or a portion of the one-time origination fee assessed to the participant | NULLABLE | NUMERIC | |
| origfeepd | This field contains the calculated origination fee value the system uses to assess the fee to the participant when funding an agreement | NULLABLE | NUMERIC | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the Agreement record | NULLABLE | DATE | |
| distloanadv | This field specifies whether loan advances should be distributed to participants | NULLABLE | INTEGER | |
| distribroundmethod | This field determines the distribution rounding calculation method for participation loan payments and advances | 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