loan_lnsegment_raw
Pipelined Data Sets
>
Symitar
>
loan_lnsegment_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 | |
| loanlnsegmentuuid | This field stores a JH Platform unique identifier for a loan segment | NULLABLE | STRING | |
| loanuuid | This field stores a JH Platform unique identifier for a loan | NULLABLE | STRING | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| loanid | This field stores the 4 digit Loan ID | NULLABLE | STRING | |
| loanlnsegmentkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| loankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | 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 stores the four-character ID that identifies the Segment record | NULLABLE | STRING | |
| description | This field stores a description of the Segment record. You cannot create a Segment record without entering a description in this field. If you do not enter a description, the system displays an error message and does not let you save the Segment record until you have entered a description | NULLABLE | STRING | |
| type | This field stores a credit union-defined code to identify the type of loan segment | NULLABLE | INTEGER | |
| opendate | The system updates this field with the system date when the Segment record is created. Under normal circumstances, you should not revise this field | NULLABLE | DATE | |
| closedate | This field stores the date a segment is closed. The system updates this field with the effective date of any Loan Payment (LP) teller transaction that pays off a closed-end segment (all segments in the Segment records are closed-end) | NULLABLE | DATE | |
| originaldate | This field stores the date the segment was originally disbursed. The system updates this field with the effective date of the most recent Loan Segment Transfer (LG) teller transaction to the segment. Under normal circumstances, you should not revise this field | NULLABLE | DATE | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Loan Segment 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 | |
| paymentorder | The field contains a number from 0-9999 to indicate the order in which this segment will be paid for a Loan Payment (LP) transaction | NULLABLE | INTEGER | |
| paymenttype | This field stores the payment type the system should use to calculate segment payments | NULLABLE | INTEGER | |
| lastpaymentdate | This field stores the date of the last segment payment. The system updates this field with the effective date of each Loan Payment (LP) teller transaction posted to the segment | NULLABLE | DATE | |
| balloondate | This field contains the date a balloon segment payment comes due. Once the system date reaches this date, the system resets the Payment field to the remaining segment balance and resets the Payment Type field to (1) Level Principal | NULLABLE | DATE | |
| maturitydate | This field contains the date the segment will be paid off | NULLABLE | DATE | |
| interesttype | This field contains the interest type used to calculate the loan segment interest | NULLABLE | INTEGER | |
| interestrate | This field contains the interest rate charged for the segment. If you pull this value from a loan calculation, the system updates this field with the value in the Interest Rate field of the Loan Calc screen | NULLABLE | NUMERIC | |
| intytd | This field stores the total of all interest paid on the loan during the current year to date. Whenever a loan payment is posted to the segment, the system adds the interest amount to the value in this field | NULLABLE | NUMERIC | |
| interestlastyear | This field stores the total of all interest paid on the segment during the previous year. The first time you run the Close Day Processing batch program in a new calendar year, the system transfers the amount in the Interest Paid YTD field to this field | NULLABLE | NUMERIC | |
| interestunpaid | This field stores the amount of unpaid interest charged to the segment | NULLABLE | NUMERIC | |
| intunpaidbilled | This field stores the total amount of unpaid interest billed daily to the segment | NULLABLE | NUMERIC | |
| interestrateindex | The drop-down list for this field initially offers a value of (00) Fixed Rate. The other options in the list show the Description settings for each of the Interest Rate Index Parameters that has a Defined Code field set to (1) Defined Interest Rate Index | NULLABLE | INTEGER | |
| interestratemarginsign | This field specifies whether a segment interest rate is a specific percentage above or below the index rate. The value stored in this field affects the Rate Change Processing batch program if you change rates based on a segment's interest rate index | NULLABLE | INTEGER | |
| interestratemargin | This field and the Interest Rate Index field work together to control how the system determines variable interest rates based on a credit union-defined index. This field contains the points to be added to the base rate in the rate index to determine the variable interest rate | NULLABLE | NUMERIC | |
| interestratemax | This field contains the maximum interest rate that can be used for variable rate interest calculations | NULLABLE | NUMERIC | |
| interestratemin | This field contains the minimum interest rate that can be used for variable rate interest calculations | NULLABLE | NUMERIC | |
| periodiccap | This field indicates whether this segment has a periodic cap, and if so, how much it is. This field affects variable rate segments only | NULLABLE | NUMERIC | |
| periodicstartrate | This field contains the interest rate as of the date in the Periodic Cap Start Date field | NULLABLE | NUMERIC | |
| periodicstartdate | This field stores the last anniversary date for the cap. The system maintains this field for loans with a periodic cap | NULLABLE | DATE | |
| periodicfrequency | This field stores the frequency associated with the Periodic Cap field | NULLABLE | INTEGER | |
| riskrate | This value increases the margin rate when the Rate Change Processing batch program calculates the new interest rate for segments tied to an interest rate index | NULLABLE | NUMERIC | |
| discountrate | This value decreases the margin rate when the Rate Change Processing batch program calculates the new interest rate for non-credit card loans tied to an interest rate index | NULLABLE | NUMERIC | |
| firstpaymentdate | This field contains the first scheduled payment date for a segment | NULLABLE | DATE | |
| schdratechangedate | This field contains the date a future rate change has been scheduled for this segment. See the Future Loan Rate Changes topic for more information | NULLABLE | DATE | |
| schdrate | This field contains the value of the rate to be used when a scheduled future rate change is implemented. See the Future Loan Rate Changes topic for more information | NULLABLE | NUMERIC | |
| schdperiodstartrate | This field contains the value from the Periodic Cap Start Rate field to be used when a scheduled future rate change is implemented. See Future Loan Rate Changes for more information | NULLABLE | NUMERIC | |
| schdperiodstartdate | This field contains the value from the Periodic Cap Start Date field, which the system uses as a starting point for determining when to implement a scheduled future rate change. See Future Loan Rate Changes for more information | NULLABLE | DATE | |
| balance | This field stores the current principal balance of the segment. The system updates this field with the current principal balance whenever a Loan Payment (LP), New Loan (LN), Loan Addon (LA), or Loan Segment Transfer (LG) teller transaction affects the loan | NULLABLE | NUMERIC | |
| originalbalance | This field stores the original balance of the segment or the balance after a balance transfer to the segment | NULLABLE | NUMERIC | |
| balloonamount | This field contains the balloon amount for a loan segment | NULLABLE | NUMERIC | |
| payment | This field stores the amount of the standard segment payment | NULLABLE | NUMERIC | |
| partialpayment | This field contains the partial payment amount that applies to the segment | NULLABLE | NUMERIC | |
| pmtbucketamount_1 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_2 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_3 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_4 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_5 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_6 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_7 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| pmtbucketamount_8 | The eight Pmt Bucket Amt fields store a history of payment amounts for the segment, each due on the effective date specified in the corresponding Pmt Bucket Due Date field in the Loan record. The system stores payment amounts in reverse chronological order, with the most recent payment in the Pmt Bucket Amt 1 field and the oldest payment in the Pmt Bucket Amt 8 field | NULLABLE | NUMERIC | |
| variablerateindicator | This field stores a code to identify variable rate loans with an Interest Typefield value of 0-9 in the interest rate calculation box on member statements | NULLABLE | INTEGER | |
| exceedlevelpmtamt | NULLABLE | INTEGER | ||
| billingmethod | NULLABLE | INTEGER | ||
| billingdefaultdays | NULLABLE | INTEGER | ||
| applyasbilled | NULLABLE | INTEGER | ||
| percentprincipal | NULLABLE | NUMERIC | ||
| levelpaymentamt | NULLABLE | NUMERIC | ||
| levelprincipalamt | NULLABLE | NUMERIC | ||
| minimumpayment | NULLABLE | NUMERIC | ||
| paymentcalctype | NULLABLE | INTEGER | ||
| beginningcycledate | This field is updated by the Statement Cutoff or Daily Posting batch program and contains the beginning cycle date for the current payment period due | 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