loan_schedule_raw

Pipelined Data Sets > Symitar > loan_schedule_raw

Column name	Description	Mode	Type
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
loanscheduleuuid	This field stores a JH Platform unique identifier for a loan schedule	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
loanschedulekey	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	The system uses this field to keep the Schedule records in order visually. The order of the Schedule records imported into the Loan record is actually based on the Beginning Date field	NULLABLE	STRING
beginningdate	This field stores the date when this particular Schedule record becomes effective	NULLABLE	DATE
expiration	This field stores the date when this particular Schedule record should expire	NULLABLE	DATE
paymentcalctype	While the selection is valid, this field is generally not used for credit card loan types	NULLABLE	INTEGER
payment	An entry in this field is required	NULLABLE	NUMERIC
paymenttype	The amount applied to the loan principal changes each period, since the amount of interest due each period depends on the loan balance and the number of days in the loan period. This is the normal option for most daily interest loans	NULLABLE	INTEGER
dqcalculationmethod		NULLABLE	INTEGER
interesttype		NULLABLE	INTEGER
repeatcode	This field stores the code indicating how often you want the system to import the Schedule record	NULLABLE	INTEGER
dueday1	This stores the day of the month (1-31) on which the first payment is due for semimonthly loans, or the day of the month on which all loan payments are due for annual, semiannual, quarterly, or monthly loans	NULLABLE	INTEGER
dueday2	This stores the day of the month (2-31) on which the second payment is due for semimonthly payment loans. This field is not used for annual, semiannual, quarterly, monthly, or biweekly loans	NULLABLE	INTEGER
recordchangedate	This field contains the system date from the last time any changes were made to this record. When a record is first created, this field carries the system date on which the record is created	NULLABLE	DATE
exceedlevelpmtamt		NULLABLE	INTEGER
billingmethod		NULLABLE	INTEGER
billingdefaultdays		NULLABLE	INTEGER
billingnotice		NULLABLE	INTEGER
applyasbilled		NULLABLE	INTEGER
percentprincipal		NULLABLE	NUMERIC
levelpaymentamt		NULLABLE	NUMERIC
levelprincipalamt		NULLABLE	NUMERIC
minimumpayment		NULLABLE	NUMERIC
billingnoticemin		NULLABLE	NUMERIC
useratechangeprocessing	When you run the Rate Change Processing batch program, the value in this field determines whether the system updates the Payment field value for this Schedule record	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.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026