loan_raw

Pipelined Data Sets > Symitar > loan_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
loanuuid	This field stores a JH Platform unique identifier for a loan	NULLABLE	STRING
accountuuid	This field stores a JH Platform unique identifier for an account	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
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
rectypeoverride		NULLABLE	INTEGER
id	This field stores a unique two or four-character ID that identifies the Loan record	NULLABLE	STRING
checkdigits	This field stores check digits that you may use to help Symitar Quest verify account numbers when processing drafts, ATM transactions, or outside processor transactions. Both the account number and the check digits must be valid, or Symitar Quest reports the transaction as an exception	NULLABLE	STRING
notenumber	This field stores a credit union-defined number associated with this loan	NULLABLE	STRING
type	This field stores a credit union-defined code to identify the type of loan	NULLABLE	INTEGER
lastfmdate	Symitar Quest stores the date of the last file maintenance of this Loan record or a child record of this Loan record in this field	NULLABLE	DATE
lasttrandate	Symitar Quest stores the date of the last teller or batch transaction that affected this Loan record in this field	NULLABLE	DATE
originaldate	This field stores the date the loan was originally disbursed	NULLABLE	DATE
opendate	This field stores the date when the Loan record is created	NULLABLE	DATE
chargeoffdate	This field stores the date that the loan was charged off	NULLABLE	DATE
closedate	This field stores the date the loan is closed	NULLABLE	DATE
reference	This field stores any loan-related reference information for an auto loan	NULLABLE	STRING
warningcode_1	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_2	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_3	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_4	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_5	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_6	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_7	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_8	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_9	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_10	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_11	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_12	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_13	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_14	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_15	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_16	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_17	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_18	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_19	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
warningcode_20	These fields each store a warning code to apply that warning to a loan	NULLABLE	INTEGER
service_1	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_2	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_3	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_4	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_5	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_6	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_7	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
service_8	These fields each store a credit union-defined service offered with a loan	NULLABLE	INTEGER
loancode	This field stores a code that defines certain characteristics of the loan and determines how Symitar Quest processes the loan	NULLABLE	INTEGER
collateralcode	This field stores the credit union-defined code to identify the collateral, if any, for the loan	NULLABLE	INTEGER
collateraldate	This field stores the date the collateral, if any, was pledged for the loan	NULLABLE	DATE
approvalcode	This field stores a user number or a credit union-defined code to indicate who approved the loan, depending on credit union policy	NULLABLE	INTEGER
approvaldate	This field stores the date the loan was approved	NULLABLE	DATE
purposecode	This field stores the credit union-defined code to indicate the purpose of the loan	NULLABLE	INTEGER
ecoacode	This field stores an Equal Credit Opportunity Act (ECOA) code that indicates how Symitar Quest should report the loan to credit bureaus	NULLABLE	INTEGER
creditreportingcode	This field stores a code that specifies how the loan should be reported to credit bureaus	NULLABLE	INTEGER
paymenttype	This field stores a code to indicate how the system should calculate loan payments	NULLABLE	INTEGER
paymentmethod	This field stores a code that specifies how loan payments are to be made	NULLABLE	INTEGER
couponcode	This field stores a code that specifies how Symitar Quest handles loans with the Payment Method field set to (1) Coupon	NULLABLE	INTEGER
paymentfrequency	This field stores a code that specifies when the member makes a payment	NULLABLE	INTEGER
paymentskips	This field specifies a code that specifies the number of loan payments the member is allowed to skip	NULLABLE	INTEGER
paymentcalctype	This field stores a credit union-defined payment calculation type that defines how Symitar Quest should calculate the loan payment	NULLABLE	INTEGER
partialpayment	Symitar Quest stores the amount of any partial payments made to the loan in this field	NULLABLE	NUMERIC
payment	This field stores the amount of the standard loan payment	NULLABLE	NUMERIC
lastpaymentdate	The system stores the date of the last loan payment in this field	NULLABLE	DATE
paymentcount	Symitar Quest stores the total number of payments in the term of the loan in this field	NULLABLE	INTEGER
paymenthistory_1	Symitar Quest stores the number of payments made during the term of the loan in this field	NULLABLE	INTEGER
paymenthistory_2	Symitar Quest stores the number of times loan payments have been late by the number of days specified in the Payment History Day Cutoff 1 parameter defined in the Miscellaneous Parameters	NULLABLE	INTEGER
paymenthistory_3	Symitar Quest stores the number of times loan payments have been late by the number of days specified in the Payment History Day Cutoff 2 parameter defined in the Miscellaneous Parameters	NULLABLE	INTEGER
paymenthistory_4	Symitar Quest stores the number of times loan payments have been late by the number of days specified in the Payment History Day Cutoff 3 parameter defined in the Miscellaneous Parameters	NULLABLE	INTEGER
paymenthistory_5	Symitar Quest stores the number of times loan payments have been late by the number of days specified in the Payment History Day Cutoff 4 parameter defined in the Miscellaneous Parameters	NULLABLE	INTEGER
paymenthistory_6	Symitar Quest stores the number of times loan payments have been late by the number of days specified in the Payment History Day Cutoff 5 parameter defined in the Miscellaneous Parameters	NULLABLE	INTEGER
newloanduedatecode	This field stores a code that specifies how Symitar Quest advances the due date for an add-on to a zero-balance loan	NULLABLE	INTEGER
duedateadvancecode	This field stores a code that specifies how Symitar Quest advances the Due Date field when a payment is made to the loan	NULLABLE	INTEGER
dueday1	This field stores the day of the month on which the first payment is due for semimonthly loans, or the day of the month on which all payments are due for annual, semiannual, quarterly, bimonthly, or monthly loans	NULLABLE	INTEGER
dueday2	This field stores the day of the month on which the second payment is due for semimonthly payment loans	NULLABLE	INTEGER
duedate	Symitar Quest stores the date the next loan payment is due	NULLABLE	DATE
balloondate	This field stores the date any balloon loan payment comes due	NULLABLE	DATE
refundpostcode	This field stores how portions of the interest payments may be refunded, used mainly for real estate loans	NULLABLE	INTEGER
refundytd	Symitar Quest stores the total of all interest refunds in this field during the current year to date	NULLABLE	NUMERIC
refundlastyear	Symitar Quest stores the total amount of all interest refunded to the member in this field during the previous year	NULLABLE	NUMERIC
interestytd	Symitar Quest stores the total of all interest paid on the loan in this field during the current year to date	NULLABLE	NUMERIC
interestlastyear	Symitar Quest stores the total of all interest paid on the loan in this field during the previous year	NULLABLE	NUMERIC
interestfromopen	Symitar Quest stores the total of all interest paid on the loan in this field since the loan was opened	NULLABLE	NUMERIC
interesttype	This field stores either a system-defined or a credit union-defined code that indicates the method Symitar Quest uses to calculate interest on the loan	NULLABLE	INTEGER
interestrate	This field stores the interest rate charged for the loan	NULLABLE	NUMERIC
splitrate	To encourage members to carry a higher loan balance, some credit unions charge a lower interest rate once the loan balance reaches or exceeds a specified amount. This field stores that lower interest rate	NULLABLE	NUMERIC
splitratebalance	To encourage members to carry a higher loan balance, some credit unions charge a lower interest rate once the loan balance reaches or exceeds a specified amount. This field stores the loan balance that triggers the lower interest rate	NULLABLE	NUMERIC
interestdate	Symitar Quest stores the most recent date from which interest accrues in this field, which means interest has been calculated on this loan through the previous day (but not including today)	NULLABLE	DATE
interestunpaid	Symitar Quest stores the amount of unpaid interest due on the loan in this field as of the day before the loan's Interest Date field value	NULLABLE	NUMERIC
dqnoticenumber	This field stores the total number of delinquent notices generated for this loan. The field can also indicate if Symitar Quest should not generate delinquent notices for this loan	NULLABLE	INTEGER
dqnoticedate	Symitar Quest stores the last date a delinquent notice was generated for this loan in this field	NULLABLE	DATE
dqcarddate	Symitar Quest stores the last date a delinquent card was generated for this loan in this field	NULLABLE	DATE
latechargetype	This field stores a credit union-defined code that indicates which late charge type definition Symitar Quest should use to calculate late charges for this loan	NULLABLE	INTEGER
latechargeaccrued	Symitar Quest stores an amount in this field related to late charges. The meaning of that amount differs depending on the late charge calculation formula referenced by the Late Charge Type field	NULLABLE	NUMERIC
latechargeunpaid	Symitar Quest stores the total amount in this field of all unpaid late charges for this loan	NULLABLE	NUMERIC
latechargeytd	Symitar Quest stores the total amount in this field of late charges assessed for this loan during the current year	NULLABLE	NUMERIC
latechargelastyear	Symitar Quest stores the total amount in this field of late charges assessed for this loan during the previous year	NULLABLE	NUMERIC
balance	This field stores the current principal balance of the loan	NULLABLE	NUMERIC
originalbalance	This field stores the original balance of the loan or the balance after an add-on to the loan	NULLABLE	NUMERIC
creditlimit	This field stores the credit limit for line of credit or credit card loans	NULLABLE	NUMERIC
principalytd	Symitar Quest stores the total amount applied to the principal of this loan during the current year to date	NULLABLE	NUMERIC
principallastyear	Symitar Quest stores the total amount applied to the principal of this loan in this field during the previous year	NULLABLE	NUMERIC
chargeofftype	This field stores a credit union-defined code to indicate why this loan was charged off or what type of loan was charged off	NULLABLE	INTEGER
chargeoffamount	This field stores the amount charged-off	NULLABLE	NUMERIC
securedcode	This field stores a code that indicates how this loan is secured	NULLABLE	INTEGER
securedamount	This field stores the total amount secured for this loan	NULLABLE	NUMERIC
insurancetype	This field stores a credit union-defined code that identifies the type of insurance	NULLABLE	INTEGER
insurancemax	This field stores the maximum insurable loan balance	NULLABLE	NUMERIC
insurancebalance	Symitar Quest stores the loan balance in this field currently insured for this loan	NULLABLE	NUMERIC
availcreditcalc	This field stores a code that determines how available credit is calculated only for line of credit loans	NULLABLE	INTEGER
lastpurgedate	Symitar Quest stores the date in this field of the last loan history purge for this loan type	NULLABLE	DATE
statementgroup	This field stores a credit union-defined statement group number that can be used to specify groups to categorize loans for reports, displays, and statement printing	NULLABLE	INTEGER
statementdate	Symitar Quest stores the date of the most recent statement cutoff for this loan in this field	NULLABLE	DATE
statementmailcode	This field stores a credit union-defined non-mail codes to categorize reasons for not mailing statements	NULLABLE	INTEGER
regecount	Symitar Quest stores the total number of Regulation E transactions in this field that affected this loan during the current statement period	NULLABLE	INTEGER
description	This field stores a loan description that appears in inquiries and on statements	NULLABLE	STRING
statementprevdate	Symitar Quest stores the date the previous statement was produced for this loan in this field	NULLABLE	DATE
paymentskipstartday	This field stores a code that represents the due date of the first payment the member can skip	NULLABLE	INTEGER
credlimitexpiration	This field stores the expiration date of the credit limit for line of credit or credit card loans	NULLABLE	DATE
interestrateindex	This field stores a code that identifies the rate index to specify the base rate and frequency of changes	NULLABLE	INTEGER
interestratemargin	This field stores the points to be added to the base rate in the rate index to determine the value in the Interest Rate field	NULLABLE	NUMERIC
interestratemax	This field stores the maximum rate Symitar Quest should use to calculate interest for this loan	NULLABLE	NUMERIC
interestratemin	This field indicates the minimum interest rate that Symitar Quest uses to calculate the loan	NULLABLE	NUMERIC
creditreportnumber	This account number in this field is sent to the credit bureaus the last time that the credit reporting tape runs	NULLABLE	STRING
warningexpiration_1	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_2	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_3	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_4	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_5	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_6	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_7	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_8	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_9	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_10	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_11	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_12	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_13	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_14	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_15	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_16	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_17	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_18	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_19	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
warningexpiration_20	These fields each store a date after which the corresponding warning code should no longer apply to the loan	NULLABLE	DATE
nsfmonthtodate	Symitar Quest stores the total number of times an NSF condition affected this loan in this field during the current month	NULLABLE	INTEGER
nsfytd	Symitar Quest stores the total number of times an NSF condition affected this loan in this field during the current year	NULLABLE	INTEGER
nsflastyear	Symitar Quest stores the total number of times an NSF condition affected this loan in this field during the previous year	NULLABLE	INTEGER
dqcalculationmethod	This field stores a code that indicates if Symitar Quest should calculate the values for the payment buckets each month	NULLABLE	INTEGER
pmtbucketamount_1	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_2	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_3	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_4	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_5	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_6	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_7	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketamount_8	Each of these eight fields stores a history of payment amounts, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
pmtbucketduedate_1	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_2	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_3	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_4	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_5	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_6	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_7	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
pmtbucketduedate_8	Symitar Quest stores a payment date in each of these eight fields for the payments in the corresponding Pmt Bucket Amt x fields	NULLABLE	DATE
purcholdbalance_1	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_2	Symitar Quest stores the principal purchase balance in each of these fields made at an old interest rate in these fields. Current purchases do not affect this field	NULLABLE	NUMERIC
purcholdbalance_3	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_4	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_5	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_6	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_7	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_8	Symitar Quest stores the principal balance in this field for current purchases at the end of the previous statement period	NULLABLE	NUMERIC
purcholdbalance_9	Symitar Quest stores the principal purchase balance in each of these fields made at an old interest rate in these fields. Current purchases do not affect this field	NULLABLE	NUMERIC
puoldintunpaid	Symitar Quest stores the total amount in this field of interest due on current purchases at the end of the previous statement period	NULLABLE	NUMERIC
puintcharge	Symitar Quest stores the amount in this field of interest calculated on purchases at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_1	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_2	Symitar Quest stores the purchase principal balance in each of these fields related to the alternate interest rate at the end of the statement period just completed. Current purchases do not affect this field	NULLABLE	NUMERIC
purchnewbalance_3	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_4	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_5	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_6	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_7	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_8	Symitar Quest stores the current purchase principal balance in this field at the end of the statement period just completed	NULLABLE	NUMERIC
purchnewbalance_9	Symitar Quest stores the purchase principal balance in each of these fields related to the alternate interest rate at the end of the statement period just completed. Current purchases do not affect this field	NULLABLE	NUMERIC
punewintunpaid	Symitar Quest stores the total amount in this field of interest due on current purchases at the end of the statement period just completed	NULLABLE	NUMERIC
cashadvoldbalance_1	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_2	Symitar Quest stores the cash advances in these fields made at an old rate. Current cash advances do not affect this field	NULLABLE	NUMERIC
cashadvoldbalance_3	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_4	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_5	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_6	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_7	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_8	Symitar Quest stores the principal balance in this field for current cash advances at the end of the previous statement period	NULLABLE	NUMERIC
cashadvoldbalance_9	Symitar Quest stores the cash advances in these fields made at an old rate. Current cash advances do not affect this field	NULLABLE	NUMERIC
caoldintunpaid	Symitar Quest stores the total amount in this field of interest due on cash advances at the end of the previous statement period	NULLABLE	NUMERIC
caintcharge	Symitar Quest stores the amount in this field of interest calculated on cash advances at the end of the statement period just completed	NULLABLE	NUMERIC
catransintcharge	Symitar Quest stores the amount in this field of the cash advances transaction finance charges for the statement period just completed	NULLABLE	NUMERIC
cashadvnewbalance_1	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_2	Symitar Quest stores the cash advance principal balance in these fields related to the alternate interest rate at the end of the statement period just completed. Current cash advances do not affect this field	NULLABLE	NUMERIC
cashadvnewbalance_3	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_4	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_5	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_6	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_7	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_8	Symitar Quest stores the cash advance principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
cashadvnewbalance_9	Symitar Quest stores the cash advance principal balance in these fields related to the alternate interest rate at the end of the statement period just completed. Current cash advances do not affect this field	NULLABLE	NUMERIC
canewintunpaid	Symitar Quest stores the total amount in this field of interest due on cash advances at the end of the statement period just completed	NULLABLE	NUMERIC
feeoldbalance	Symitar Quest stores the fee balance in this field at the end of the previous statement period	NULLABLE	NUMERIC
feenewbalance	Symitar Quest stores the ending fee balance in this field for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_1	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_2	Symitar Quest stores the average daily principal balance in these fields of current purchases of promotion # for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_3	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_4	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_5	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_6	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_7	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_8	Symitar Quest stores the average daily principal balance in this field of current purchases for the statement period just completed	NULLABLE	NUMERIC
purchavgbalance_9	Symitar Quest stores the average daily principal balance in these fields of current purchases of promotion # for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_1	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_2	Symitar Quest stores the average daily principal balance in these fields of current cash advances of promotion # for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_3	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_4	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_5	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_6	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_7	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_8	Symitar Quest stores the average daily principal balance in this field of current cash advances for the statement period just completed	NULLABLE	NUMERIC
cashadvavgbalance_9	Symitar Quest stores the average daily principal balance in these fields of current cash advances of promotion # for the statement period just completed	NULLABLE	NUMERIC
effectiveapr	This field stores the current effective APR (Annual Percentage Rate) for the loan	NULLABLE	NUMERIC
originalrate	This field stores the original effective APR (Annual Percentage Rate) when the loan was opened	NULLABLE	NUMERIC
unamortizedfees	This field stores the total amount of fees to be amortized over the term of the loan, according to FASB 91	NULLABLE	NUMERIC
maturitydate	This field stores the date the loan will be paid off	NULLABLE	DATE
pointsytd	This field stores the total number of points the borrower paid for this loan during the current year	NULLABLE	NUMERIC
pointslastyear	Symitar Quest stores the total number of points the borrower paid for this loan during the previous year	NULLABLE	NUMERIC
feecount_1	These fields store the number of times in each of these fields that a specific fee has been assessed for this loan, or the number of times a specified transaction has occurred (for the purpose of calculating or charging a fee)	NULLABLE	INTEGER
feecount_2	These fields store the number of times in each of these fields that a specific fee has been assessed for this loan, or the number of times a specified transaction has occurred (for the purpose of calculating or charging a fee)	NULLABLE	INTEGER
feecount_3	These fields store the number of times in each of these fields that a specific fee has been assessed for this loan, or the number of times a specified transaction has occurred (for the purpose of calculating or charging a fee)	NULLABLE	INTEGER
feecount_4	These fields store the number of times in each of these fields that a specific fee has been assessed for this loan, or the number of times a specified transaction has occurred (for the purpose of calculating or charging a fee)	NULLABLE	INTEGER
escrowamount	This field stores the periodic escrow amount for the loan	NULLABLE	NUMERIC
escrowid	This field stores the ID of the Share record to which the escrow amount should be posted whenever the member makes a loan payment	NULLABLE	STRING
latechargedate	Symitar Quest stores a date in this field related to late charges. The meaning of that date differs depending on the late charge calculation formula referenced by the Late Charge Type field	NULLABLE	DATE
cutotalsusecode	This field stores a code that identifies whether include the loan balance in the credit union totals calculations or not	NULLABLE	INTEGER
periodiccap	This field stores a limit on changes for variable rate loans	NULLABLE	NUMERIC
periodicstartrate	Symitar Quest stores the interest rate in this field as of the value in the Periodic Cap Start Date field	NULLABLE	NUMERIC
periodicstartdate	Symitar Quest stores the starting date in this field from which the current period cap starts	NULLABLE	DATE
singlepremiumlife	Symitar Quest stores the amount in this field of the single premium for any credit life insurance calculated for the loan	NULLABLE	NUMERIC
singlepremiumdisability	Symitar Quest stores the amount in this field of the single premium for any credit disability insurance calculated for the loan	NULLABLE	NUMERIC
fasb91alternateterm	This field stores a credit union-determined term that is shorter than the term of the loan calculated for the Payment Count field	NULLABLE	INTEGER
origunamortizedfees	This field stores the original amount of unamortized fees	NULLABLE	NUMERIC
creditreporttransferindicator	This field stores a code indicating whether the CR Transfer Name field contains the name of the company from which the loan was purchased or to which it was sold	NULLABLE	INTEGER
creditreporttransferdate	This field stores either the date the loan was transferred (purchased or sold) or the date that your financial institution decided to send the removal code	NULLABLE	DATE
creditreporttransfername	This field stores the name of the company from which the portfolio or partial portfolio was purchased or to which the portfolio was sold	NULLABLE	STRING
feeschargespostingoption	This field stores a code that determines how billed fees and late charges are collected after a loan payment is applied	NULLABLE	INTEGER
minbalance	This field stores the minimum balance for the loan	NULLABLE	NUMERIC
minadvance	This field stores the minimum advance amount for line of credit or credit card loans	NULLABLE	NUMERIC
balloonamount	This field stores the amount of the final payment (including principal and interest) of a loan	NULLABLE	NUMERIC
interestratemarginsign	This field stores a code that specifies that a loan interest rate is a specific percentage above or below the index rate	NULLABLE	INTEGER
branch	This field stores the number of the branch that "owns" the loan. When you create a loan record, the default is the branch at which you create the Loan record	NULLABLE	INTEGER
creditreportoccurdate	Symitar Quest stores the last Metro Credit Reporting date in this field of occurrence reported to the credit bureau	NULLABLE	DATE
creditreportlaststatus	Symitar Quest stores the last Metro Credit Reporting Status Code reported to the credit bureau in this field	NULLABLE	INTEGER
creditreportcomment	This field stores the comment code reported to credit reporting agencies in the Metro Credit Reporting Special Comments field	NULLABLE	STRING
fasb91code	This field stores a credit union-defined code used in conjunction with loan type codes to create combinations that post to designated General Ledger accounts	NULLABLE	INTEGER
studentloancode	This field stores a code that identifies whether this loan is a student loan	NULLABLE	INTEGER
studentcoveredperiodend	This field stores the date the "covered period" ends for the student loan	NULLABLE	DATE
riskrate	This field stores a value that increases the calculated 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
discountrate	This field stores a value that decreases the calculated 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
apr	Symitar Quest stores the calculated APR (Annual Percentage Rate) for the loan	NULLABLE	NUMERIC
prepaidfinancechg	This field stores any additional amounts included in a loan	NULLABLE	NUMERIC
creditlimitgroup	This field stores a code that identifies the credit limit group with which this Loan record is associated	NULLABLE	INTEGER
alternatepayment	This field stores an amount greater than the standard payment that the member would like to pay between the dates in the Alternate Pmt Effective and the Alternate Pmt Expiration fields	NULLABLE	NUMERIC
altpmteffective	This field stores the date on which the value in the Alternate Payment field becomes effective	NULLABLE	DATE
altpmtexpiration	This field stores the date on which the value in the Alternate Payment field expires	NULLABLE	DATE
intunpaidbilled	Symitar Quest stores the total amount of unpaid interest in this field for which the member has been billed	NULLABLE	NUMERIC
promotype_1	These fields each store a credit union-defined code that identifies a promotion type for this loan	NULLABLE	INTEGER
promotype_2	These fields each store a credit union-defined code that identifies a promotion type for this loan	NULLABLE	INTEGER
promoeffectdate_1	These fields each store a date when the corresponding promotion is effective for advances taken on or after that date and before the date in the corresponding Promo # Expiration Date field	NULLABLE	DATE
promoeffectdate_2	These fields each store a date when the corresponding promotion is effective for advances taken on or after that date and before the date in the corresponding Promo # Expiration Date field	NULLABLE	DATE
promoexpiredate_1	These fields each store a date when the corresponding promotion should end	NULLABLE	DATE
promoexpiredate_2	These fields each store a date when the corresponding promotion should end	NULLABLE	DATE
promoratetype_1	These fields each store a code that indicates if the corresponding promotion uses a fixed or variable rate	NULLABLE	INTEGER
promoratetype_2	These fields each store a code that indicates if the corresponding promotion uses a fixed or variable rate	NULLABLE	INTEGER
promorate_1	Symitar Quest stores in each of these fields the actual interest rate for the corresponding promotion	NULLABLE	NUMERIC
promorate_2	Symitar Quest stores in each of these fields the actual interest rate for the corresponding promotion	NULLABLE	NUMERIC
promorateoffset_1	These fields each store an offset rate for the corresponding promotion	NULLABLE	NUMERIC
promorateoffset_2	These fields each store an offset rate for the corresponding promotion	NULLABLE	NUMERIC
promoratemin_1	These fields each store a minimum rate for the corresponding promotion	NULLABLE	NUMERIC
promoratemin_2	These fields each store a minimum rate for the corresponding promotion	NULLABLE	NUMERIC
promoratemax_1	These fields each store a maximum rate for the corresponding promotion	NULLABLE	NUMERIC
promoratemax_2	These fields each store a maximum rate for the corresponding promotion	NULLABLE	NUMERIC
promototaladvances_1	These fields each store the total amount of advances on this loan during the corresponding promotion, not including insurance or fees	NULLABLE	NUMERIC
promototaladvances_2	These fields each store the total amount of advances on this loan during the corresponding promotion, not including insurance or fees	NULLABLE	NUMERIC
promoadvancecutoff_1	These fields each store the total amount of advances that must be taken during the corresponding promotion before the corresponding promotion "kicks in"	NULLABLE	NUMERIC
promoadvancecutoff_2	These fields each store the total amount of advances that must be taken during the corresponding promotion before the corresponding promotion "kicks in"	NULLABLE	NUMERIC
promobalance_1	Symitar Quest stores in each of these fields that portion of the total loan Balance field value subject to the corresponding promotion	NULLABLE	NUMERIC
promobalance_2	Symitar Quest stores in each of these fields that portion of the total loan Balance field value subject to the corresponding promotion	NULLABLE	NUMERIC
applicationid	This field stores the ID of the loan application used when granting this loan	NULLABLE	STRING
creditreportconsumerinfo	This field stores consumer information indicators (CII) for the Metro 2® Format for credit reports	NULLABLE	STRING
creditreportcompliance	This field stores consumer information for the Metro 2® Format for credit reports	NULLABLE	STRING
lesseestate	This field stores the 2-character state code where the car is registered as part of the information required to compute the sales tax	NULLABLE	STRING
lesseecounty	This field stores the county where the car is registered as part of the information required to compute the sales tax	NULLABLE	STRING
lesseecity	This field stores the city where the car is registered as part of the information required to compute the sales tax	NULLABLE	STRING
dealerstate	This field stores the 2-character state code where the car was leased as part of the information required to compute the sales tax	NULLABLE	STRING
dealercounty	This field stores the county where the car was leased as part of the information required to compute the sales tax	NULLABLE	STRING
dealercity	This field stores the city where the car was leased as part of the information required to compute the sales tax	NULLABLE	STRING
salestaxstateindicator	This field stores a code that determines how state sales tax will be used as part of the information required to compute the sales tax	NULLABLE	INTEGER
salestaxcountyindicator	This field stores a code that determines how county sales tax will be used as part of the information required to compute the sales tax	NULLABLE	INTEGER
salestaxcityindicator	This field stores a code that determines how city sales tax will be used as part of the information required to compute the sales tax	NULLABLE	INTEGER
leaseterminatedate	This field stores the date when the member terminates a lease loan by surrendering the vehicle	NULLABLE	DATE
leaseterminatefee	This field stores the fee amount to be charged if a lease loan is paid off	NULLABLE	NUMERIC
dealerreserve	This field stores the amount of the dealer reserve for a lease loan	NULLABLE	NUMERIC
dealercode	This field stores the dealer code for a lease loan	NULLABLE	STRING
activitydate	Symitar Quest stores the date of the previous monetary transaction that affected the Loan record in this field	NULLABLE	DATE
feebillingdate	This field stores the billing date in this field for the value in the Fee Billing Amount field	NULLABLE	DATE
feebillingamount	This field stores the fee amount billed on the date in the Fee Billing Date field	NULLABLE	NUMERIC
billedfeeunpaid	Symitar Quest stores billed fees in this field that are currently unpaid on this loan	NULLABLE	NUMERIC
billedfeeytd	Symitar Quest stores the amount in this field of billed fees collected during payment processing this year	NULLABLE	NUMERIC
billedfeelastyear	Symitar Quest stores the amount in this field of billed fees collected during payment processing last year	NULLABLE	NUMERIC
billedfeebucketamount_1	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_2	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_3	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_4	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_5	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_6	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_7	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
billedfeebucketamount_8	Symitar Quest stores a history of billed fee amounts in each of these eight fields in parallel with the Pmt Bucket Amt x and Pmt Bucket Due Date x fields	NULLABLE	NUMERIC
ccpromoeffectdate_2	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_3	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_4	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_5	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_6	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_7	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_8	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
ccpromoeffectdate_9	These fields each store a date when the corresponding credit card promotion is effective for purchases, cash advances, and balance transfers taken on or before the date in the Promo # Expiration Date parameter (or before the number of days in the Promo # Expiration Days parameter have passed)	NULLABLE	DATE
latechgwaivedytd	Symitar Quest stores the total amount in this field of waived late charges for this loan during the current year	NULLABLE	NUMERIC
latechgwaivedlastyear	Symitar Quest stores the total amount in this field of waived late charges for this loan during the previous year	NULLABLE	NUMERIC
latechgwaivedfromopen	Symitar Quest stores the total of all waived late charges in this field on the loan since the loan was opened	NULLABLE	NUMERIC
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
glaccrualstatusoption	This field stores a code that is used by the Dividend/Interest Accrual Report batch program to determine whether a loan should have GL interest accrued	NULLABLE	INTEGER
creditscore	This field stores the results of credit score calculations	NULLABLE	INTEGER
creditscoretype	This field stores a credit union-defined code that specifies the type of credit score to be calculated	NULLABLE	INTEGER
lastadvancedate	Symitar Quest stores the last date an advance was taken against the loan	NULLABLE	DATE
advanceamount	Symitar Quest stores the total amount of advances against the loan in this field	NULLABLE	NUMERIC
firstpaymentdate	The system stores the date of the first scheduled payment date for this loan	NULLABLE	DATE
schdratechangedate	This field stores the date for a future effective rate change from the Future Effective Date prompt in Rate Change Processing	NULLABLE	DATE
schdrate	This field stores the rate to be used when a scheduled future rate change is implemented	NULLABLE	NUMERIC
schdsplitbalance	This field stores the new split balance to be used when a scheduled future rate change is implemented	NULLABLE	NUMERIC
schdsplitrate	This field stores the new split rate to be used when a scheduled future rate change is implemented	NULLABLE	NUMERIC
schdperiodstartrate	This field stores the value in the Periodic Cap Start Rate field to be used when a scheduled future rate change is implemented	NULLABLE	NUMERIC
schdperiodstartdate	This field stores the date in the Periodic Cap Start Date field which Symitar Quest uses as a starting point for determining when to implement a scheduled future rate change	NULLABLE	DATE
periodicfrequency	This field stores the frequency associated with the Periodic Cap field	NULLABLE	INTEGER
amortizationschd	This field stores the numeric value of the set of Amortization Schedules parameters	NULLABLE	INTEGER
amortizationschdtype	This field stores a code that indicates whether the set of Amortization Schedules parameters is global or local	NULLABLE	INTEGER
callitemschd	Primarily for users of the corporate interface: This field stores the numeric value of the set of Call/Put Item Schedules parameters used for call items	NULLABLE	INTEGER
callitemschdtype	Primarily for users of the corporate interface: This field stores a code that indicates whether the set of Call Item Schedules parameters specified in the Call Item Schedule field is global or local	NULLABLE	INTEGER
memberusertransfercode	For users of the corporate interface: This field stores a code that indicates which type of Corporate Transfer Parameters apply to this loan when a member user is making a transfer using the corporate interface	NULLABLE	INTEGER
corporateusertransfercode	For users of the corporate interface: This field indicates which type of Corporate Transfer Parameters apply to this loan when a corporate user is making a transfer using the corporate interface on behalf of a member user	NULLABLE	INTEGER
participationnumber	Symitar Quest stores the participation number from the associated Participation record in this field	NULLABLE	STRING
vin	Symitar Quest stores a member's Vehicle Identification Number	NULLABLE	STRING
userchar1	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar2	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar3	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar4	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
useramount1	These two custom fields can store any credit union-defined cash amount	NULLABLE	NUMERIC
useramount2	These two custom fields can store any credit union-defined cash amount	NULLABLE	NUMERIC
userdate1	These two custom fields can store any credit union-defined date	NULLABLE	DATE
userdate2	These two custom fields can store any credit union-defined date	NULLABLE	DATE
bureauscore_1	This field stores the most recent credit score received from the Experian credit bureau for the main applicant for the loan	NULLABLE	INTEGER
bureauscore_2	This field stores the most recent credit score received from the Equifax credit bureau for the main applicant for the loan	NULLABLE	INTEGER
bureauscore_3	This field stores the most recent credit score received from the Transunion® credit bureau for the main applicant for the loan	NULLABLE	INTEGER
bureauscore_4	This field stores the most recent credit score received from the ChexSystems® credit bureau for the main applicant for the loan	NULLABLE	INTEGER
studentloanorigfeeytd	This field stores the loan origination fee in this field for the current year, if any, for a student loan	NULLABLE	NUMERIC
studentloanorigfeelastyear	Symitar Quest stores the loan origination fee in this field for last year for a student loan	NULLABLE	NUMERIC
studentloancapintytd	This field stores the loan capitalized interest, if any, for a student loan	NULLABLE	NUMERIC
studentloancapintlastyear	Symitar Quest stores the loan capitalized interest in this field for last year for a student loan	NULLABLE	NUMERIC
putitemschd	Primarily for users of the corporate interface: This field stores the numeric value of the set of Call/Put Item Schedules parameters used for put items	NULLABLE	INTEGER
putitemschdtype	Primarily for users of the corporate interface: This field stores a code that indicates whether the set of Call/Put Item Schedules parameters specified in the Put Item Schedule field is global or local	NULLABLE	INTEGER
ledgeraccrual	Symitar Quest stores the ledger accrual amount for this loan in this field	NULLABLE	NUMERIC
ledgeraccrualdate	Symitar Quest stores the date in this field on which the accrual batch process updates the ledger accrual for this loan during daily accruals	NULLABLE	DATE
currintpayable	Symitar Quest stores the total in this field of all outstanding interest that has been accrued, but unpaid, regardless of month from which it is outstanding	NULLABLE	NUMERIC
mtdaccruedint	Symitar Quest stores the total in this field of all outstanding interest (for the current calendar month) that has accrued, but has not been paid, since the last date interest was paid	NULLABLE	NUMERIC
mtdpaidint	Symitar Quest stores the total in this field of all interest paid in the current month	NULLABLE	NUMERIC
mtdaccumulatedint	Symitar Quest stores the total of all accumulated interest for the current calendar month, regardless of payment of the interest or accrual	NULLABLE	NUMERIC
premthintaccumltd_1	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_2	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_3	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_4	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_5	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_6	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_7	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_8	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_9	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_10	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_11	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccumltd_12	Symitar Quest stores the total in each of these fields of all accumulated interest, unpaid and paid, for the previous calendar month indicated, regardless of payment of the interest or accrual in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccrued_1	Symitar Quest stores the total in each of these fields of all outstanding accrued unpaid interest in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccrued_2	Symitar Quest stores the total in each of these fields of all outstanding accrued unpaid interest in each of the indicated previous months	NULLABLE	NUMERIC
premthintaccrued_3	Symitar Quest stores the total in each of these fields of all outstanding accrued unpaid interest in each of the indicated previous months	NULLABLE	NUMERIC
premthintpaid_1	Symitar Quest stores the total in each of these fields of all interest paid in each of the indicated previous months	NULLABLE	NUMERIC
premthintpaid_2	Symitar Quest stores the total in each of these fields of all interest paid in each of the indicated previous months	NULLABLE	NUMERIC
premthintpaid_3	Symitar Quest stores the total in each of these fields of all interest paid in each of the indicated previous months	NULLABLE	NUMERIC
lastaccrupdatedate	Symitar Quest stores the last date in this field on which the accruals for the Loan record were updated	NULLABLE	DATE
mtdpriorrateaccrual	This field stores the dividend accrual in this field for the current calendar month	NULLABLE	NUMERIC
micracctnumber	This field stores the account number portion of a draft's MICR line	NULLABLE	STRING
currmonthpaidint	Symitar Quest stores the total interest paid in this field on the loan during the current calendar month	NULLABLE	NUMERIC
indirectdealernum	This field stores the dealer number	NULLABLE	STRING
indirectplanid	This field stores the reserve plan ID associated with this indirect loan	NULLABLE	STRING
crpmtcurrent	Symitar Quest stores the payment status in this field for the current month when you run the Trial Balance Reports batch program	NULLABLE	STRING
crpmthistory_1	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_2	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_3	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_4	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_5	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_6	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_7	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_8	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_9	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_10	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_11	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_12	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_13	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_14	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_15	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_16	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_17	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_18	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_19	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_20	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_21	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_22	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_23	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crpmthistory_24	Symitar Quest stores values in these fields that represents the payment status from one month to 24 months before the current calendar month	NULLABLE	STRING
crhighbal	Symitar Quest stores the highest balance ever attained on a loan in this field	NULLABLE	NUMERIC
lastcrreportdate	Symitar Quest stores the date in this field when the first payment is due for a deferred loan (usually a student loan)	NULLABLE	DATE
refinancebalance	Symitar Quest stores the balance of the refinance when the next Loan Refinance (LR) transaction is processed	NULLABLE	NUMERIC
refinancedate	Symitar Quest stores the date of the refinance when the next Loan Refinance (LR) transaction is processed	NULLABLE	DATE
refinancecounter	This field stores the number of Loan Refinance (LR) transactions that occurred	NULLABLE	INTEGER
paymentapplicationmethod	This field stores a system or credit union-defined code that defines how Symitar Quest should apply loan payments for this loan	NULLABLE	INTEGER
sbagpnumber	This field stores the SBA-assigned loan identification number	NULLABLE	STRING
intpaidtodate	Symitar Quest stores the date in this field that interest was paid for the most recently collected interest payment	NULLABLE	DATE
intpaidpartialdayamt	Symitar Quest stores the amount of any partial day's interest, relating to the entire principal balance of the loan that has been collected and reported to SBA as of the last date an interest payment was received	NULLABLE	NUMERIC
creditreportconsumerinfodate	This field stores the date you last performed file maintenance on the Credit Report Consumer Info field	NULLABLE	DATE
currstmtfees	Symitar Quest stores the accrued amounts of fees paid on the loan in this field for the current statement period	NULLABLE	NUMERIC
prevstmtfees	Symitar Quest stores the accrued amounts of fees paid on the loan in this field for the previous statement period	NULLABLE	NUMERIC
currstmtintaccrd	Symitar Quest stores the total interest charged or accrued for the current statement period in this field	NULLABLE	NUMERIC
prevstmtintaccrd	Symitar Quest stores the total interest charged or accrued for the previous statement period in this field	NULLABLE	NUMERIC
nickname	This field stores a nickname for a loan	NULLABLE	STRING
firstinsbirthdate	Symitar Quest stores the first insured's date of birth in this field	NULLABLE	DATE
secondinsbirthdate	Symitar Quest stores the second insured's date of birth in this field	NULLABLE	DATE
originsurancetype	Symitar Quest stores the original insurance type in this field on a loan	NULLABLE	INTEGER
pmiytd	This field stores the year-to-date totals for private mortgage insurance (PMI)	NULLABLE	NUMERIC
pmilastyear	Symitar Quest stores the previous year's totals in this field for private mortgage insurance (PMI)	NULLABLE	NUMERIC
recordchangedate	Symitar Quest stores the system date in this field when you create, change, or save the Loan record. Sometimes Symitar Quest updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
pmioriginalvalue	This field stores the original value of the collateral for the loan	NULLABLE	NUMERIC
pmipurchaseprice	This field stores the purchase price or sales price of the property securing the mortgage, as reflected in the purchase contract	NULLABLE	NUMERIC
pmiappraisedvalue	This field stores the value of the residence when it was appraised during a mortgage application	NULLABLE	NUMERIC
highriskcode	This field stores a code that specifies whether a loan is to be considered high risk	NULLABLE	INTEGER
dqnoticetype	This field stores a code that identifies which set of delinquency notices are to be used for the loan	NULLABLE	INTEGER
comboseg0pmtorder	This field stores a code that indicates if Segment 0 is to be paid first or last when used with the Combo Payment Order Method field for SymChoice Loans	NULLABLE	INTEGER
combopmtordermeth	This field stores a code that determines the order in which to pay segments for SymChoice Loans	NULLABLE	INTEGER
combolnsegmentmax	This field stores the maximum number of segments (including Segment 0) that can be added to a SymChoice Loan	NULLABLE	INTEGER
seg0description	This field stores a description of the segment for SymChoice Loans	NULLABLE	STRING
seg0paymentorder	This field stores a number to indicate the order in which Segment 0 will be paid for a SymChoice Loan Payment (LP) transaction	NULLABLE	INTEGER
seg0levelprinpmt	This field stores the amount of principal to apply to each payment for Segment 0 if the Payment Type field value is set to (1) Level Principal for SymChoice Loans	NULLABLE	NUMERIC
cappedfeesamtperiod	This field stores the sum of the capped fees charged by batch programs, online transaction processing, and teller transactions to the loan during a time period you specify	NULLABLE	NUMERIC
cappedfeesamountcap	This field stores the dollar amount your financial institution sets for its capped fees amount	NULLABLE	NUMERIC
cappedfeescntperiod	This field stores the number of occurrences of capped fees, incrementing by one each time a capped fee is charged to the loan	NULLABLE	INTEGER
cappedfeescountcap	This field stores the number of fee occurrences at which your financial institution stops charging capped fees for the loan during a time period you specify	NULLABLE	INTEGER
mortginscollytd	This field stores the total dollar amount collected during the current calendar year to pay mortgage insurance	NULLABLE	NUMERIC
mortginscolllastyr	Symitar Quest stores the total dollar amount in this field collected during the current calendar year to pay mortgage insurance	NULLABLE	NUMERIC
creditrptdeferredpmtstart	This field stores the date when the first payment is due for a deferred loan (usually a student loan)	NULLABLE	DATE
btoldintunpaid	Symitar Quest stores the total amount in this field of interest due on balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
btintcharge	Symitar Quest stores the amount in this field of interest calculated on balance transfers at the end of the statement period just completed	NULLABLE	NUMERIC
bttransintcharge	Symitar Quest stores the amount in this field of the balance transfer transaction finance charges for the statement period just completed	NULLABLE	NUMERIC
balxfrnewbalance_1	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_2	Symitar Quest stores the balance transfer principal balance in these fields related to the alternate interest rate at the end of the statement period just completed. Current balance transfers do not affect this field	NULLABLE	NUMERIC
balxfrnewbalance_3	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_4	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_5	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_6	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_7	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_8	Symitar Quest stores the balance transfer principal balance in this field at the end of the statement period just completed. Under normal circumstances, you should not revise this field	NULLABLE	NUMERIC
balxfrnewbalance_9	Symitar Quest stores the balance transfer principal balance in these fields related to the alternate interest rate at the end of the statement period just completed. Current balance transfers do not affect this field	NULLABLE	NUMERIC
btnewintunpaid	Symitar Quest stores the total amount in this field of interest due on balance transfers at the end of the statement period just completed	NULLABLE	NUMERIC
balxfravgbalance_1	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_2	Symitar Quest stores the average daily principal balance in these fields of current balance transfers of promotion # for the statement period just completed	NULLABLE	NUMERIC
balxfravgbalance_3	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_4	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_5	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_6	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_7	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_8	Symitar Quest stores the average daily principal balance in this field of current balance transfers for the statement period just completed. Under normal circumstances	NULLABLE	NUMERIC
balxfravgbalance_9	Symitar Quest stores the average daily principal balance in these fields of current balance transfers of promotion # for the statement period just completed	NULLABLE	NUMERIC
balxfroldbalance_1	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_2	Symitar Quest stores the balance transfers in these fields made at an old rate. Current balance transfers do not affect this field	NULLABLE	NUMERIC
balxfroldbalance_3	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_4	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_5	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_6	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_7	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_8	Symitar Quest stores the principal balance in this field for current balance transfers at the end of the previous statement period	NULLABLE	NUMERIC
balxfroldbalance_9	Symitar Quest stores the balance transfers in these fields made at an old rate. Current balance transfers do not affect this field	NULLABLE	NUMERIC
createdbyuser	Symitar Quest stores the user ID in this field and is populated when this Loan record is created	NULLABLE	INTEGER
createdatbranch	Symitar Quest stores the branch ID in this field of the branch where the Loan record is created	NULLABLE	INTEGER
origriskgrade	This field stores the original risk grade assigned to the note when it was originated	NULLABLE	STRING
escrowunpaid	Symitar Quest stores the total amount in this field of all unpaid escrow that was deferred from payments applied to this loan once the due date advanced	NULLABLE	NUMERIC
stmtlatechgunpaid	Symitar Quest stores the balance in the Late Charge Unpaid field in this field as of the date in the Statement Date field	NULLABLE	NUMERIC
stmtescrowunpaid	Symitar Quest stores the balance in the Escrow Unpaid field in this field as of the date in the Statement Date field	NULLABLE	NUMERIC
crinttypeind	This field stores the interest rate indicator reported to the credit reporting bureaus using the Metro 2® Format (Symitar v.2)	NULLABLE	STRING
feesytd	Symitar Quest stores the amount in this field of total fees charged to this loan this year	NULLABLE	NUMERIC
feeslastyear	Symitar Quest stores the amount in this field of total fees charged to this loan during the previous year	NULLABLE	NUMERIC
stmtfeesytd	Symitar Quest stores the amount in this field to be printed on statements of total fees charged to this loan this year	NULLABLE	NUMERIC
insuranceytd	This field stores the amount of total insurance added to the principal loan balance this year	NULLABLE	NUMERIC
insurancelastyear	Symitar Quest stores the amount in this field of total insurance added to the principal loan balance during the previous year	NULLABLE	NUMERIC
cabttransintchargebilledytd	Symitar Quest stores the amount in this field of total cash advance and balance transfer transaction interest charges billed to the loan this year	NULLABLE	NUMERIC
ccintbilledytd	Symitar Quest stores the amount in this field of total interest charged to this credit card loan this calendar year	NULLABLE	NUMERIC
ccintbilledlastyear	Symitar Quest stores the amount in this field of total interest charged to this credit card loan during the previous year	NULLABLE	NUMERIC
stmtccintbilledytd	Symitar Quest stores the amount in this field to be printed on statements of total interest billed to this credit card loan this year	NULLABLE	NUMERIC
stmtmaxlatefee	This field stores value of the maximum late fee to be printed in the Late Payment Warning disclosure on member statements for credit card loans	NULLABLE	NUMERIC
variablerateindicator	This field stores a code to identify variable rate loans with an interest type of 0-9 in the interest rate calculation section on member statements	NULLABLE	INTEGER
lastaccrualreversal	Symitar Quest stores the amount in this field of accrued income that was reversed the last time this loan went to nonaccrual status	NULLABLE	NUMERIC
mfoelid	This field stores the credit union-defined code to identify a loan that is part of a Multi-Featured, Open-End Lending (MFOEL) plan	NULLABLE	INTEGER
latechgpdfromopen	Symitar Quest stores the amount in this field of total late charges paid on the loan	NULLABLE	NUMERIC
stmtltchgpdfrmopn	Symitar Quest stores the amount in the Late Charge Paid from Open field in this field at the time of statement cutoff	NULLABLE	NUMERIC
stmtintfromopen	Symitar Quest stores the amount in the Interest From Open field at the time of statement cutoff	NULLABLE	NUMERIC
prinpaidfromopen	Symitar Quest stores the total amount of principal paid on a loan in this field	NULLABLE	NUMERIC
stmtprinpdfromopen	Symitar Quest stores the amount in the Principal Paid From Open field in this field at the time of statement cutoff	NULLABLE	NUMERIC
escrowapplied	Symitar Quest stores the portion of the loan payment in this field that applies to escrow without the due date advancing	NULLABLE	NUMERIC
escrowbucketamount_1	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_2	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_3	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_4	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_5	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_6	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_7	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
escrowbucketamount_8	Symitar Quest stores a history of escrow amounts in each of these eight fields, each due on the effective date specified in the corresponding Pmt Bucket Due Date x field	NULLABLE	NUMERIC
unappliedpartialpmt	Symitar Quest stores and accumulates the unapplied partial payments made to loans with the Interest Type field value set to (1) Monthly 360 day or (8) Scheduled/364, through loan payment and Loan Payment Adjustment (LPZ) transactions until a full payment can be posted to the loan	NULLABLE	NUMERIC
allowunappliedpmt	This field stores a code that specifies if unapplied partial payments are allowed to accumulate in the Unapplied Partial Payment field for loans with the Interest Type field value set to (1) Monthly 360 day or (8) Scheduled/364	NULLABLE	INTEGER
stmtunappliedpartialpmt	Symitar Quest stores the loan balance in this field from the Unapplied Partial Payment field as of the Statement Date field value	NULLABLE	NUMERIC
stmtmaxpenaltyapr	Symitar Quest stores the maximum penalty Annual Percentage Rate (APR) on a loan in this field to print in the Late Payment Warning section on statements	NULLABLE	NUMERIC
ovloptin	This field stores a code to indicate whether the member has chosen (opted-in) to use the OVL service	NULLABLE	INTEGER
ovlauthfee	This field stores a code that determines whether to authorize or assess a fee for credit card over-the-limit transactions	NULLABLE	INTEGER
ovlauthfeeeffdate	This field stores the effective date of the OVL Auth/Fee Option field setting	NULLABLE	DATE
ovlprevauthfee	Symitar Quest stores a code in this field that specifies the previous setting of the OVL Auth/Fee Option field	NULLABLE	INTEGER
ovlcyclecount_1	Symitar Quest stores the count in these fields of over-the-limit transactions that occurred during each of the last three billing cycles	NULLABLE	INTEGER
ovlcyclecount_2	Symitar Quest stores the count in these fields of over-the-limit transactions that occurred during each of the last three billing cycles	NULLABLE	INTEGER
ovlcyclecount_3	Symitar Quest stores the count in these fields of over-the-limit transactions that occurred during each of the last three billing cycles	NULLABLE	INTEGER
ovlstmtdisclfee	This field stores the fee amount that the Statement Generation batch program reads and prints on the revocation disclosure expressing the member's right to revoke any consent for opting into the over-the-limit transaction services for credit card loans	NULLABLE	NUMERIC
cardactoverlimitfeeeventdate	This field stores the date Fee Posting or Miscellaneous Posting batch programs post the first overlimit fee for the loan	NULLABLE	DATE
cardactlatefeeeventdate	This field stores the date Fee Posting or Miscellaneous Posting batch programs post the first late fee for the loan	NULLABLE	DATE
cardactdeclchkaxsfeeeventdate	This field stores the date Fee Posting, Miscellaneous Posting, or Check posting batch programs post the first declined access check fee for the loan	NULLABLE	DATE
cardactreturnitemfeeeventdate	This field stores the date Fee Posting or Miscellaneous Posting batch programs post the first return payment fee for the loan	NULLABLE	DATE
newsegcutoffoption	This field stores a code that identifies how Symitar Quest calculates the Due Date field in the projections screen of a Segment record	NULLABLE	INTEGER
newsegcutoffdays	This field stores the number of days used to calculate the segment cutoff date	NULLABLE	INTEGER
stmtprincipalytd	Symitar Quest stores the amount in the Principal YTD field in this field at the time of statement cutoff	NULLABLE	NUMERIC
stmtprincipallastyear	Symitar Quest stores the amount contained in the Principal Last Year field in this field at the time of statement cutoff	NULLABLE	NUMERIC
stmtlatechargeytd	Symitar Quest stores the amount in the Late Charge YTD field in this field at the time of statement cutoff	NULLABLE	NUMERIC
stmtlatechargelastyear	Symitar Quest stores the amount in the Late Charge Last Yr field in this field at the time of statement cutoff	NULLABLE	NUMERIC
capercent	This field stores the percentage of the overall credit limit that can be allocated to cash advances by multiplying the percent value in this field by the Credit Limit field value	NULLABLE	NUMERIC
calimitmax	This field stores the maximum amount that can be allocated to cash advances from the overall credit limit	NULLABLE	NUMERIC
btpercent	When balance transfers are allowed, this field stores the percentage of the overall credit limit to be allocated to balance transfers by multiplying the percent value in this field by the Credit Limit field value	NULLABLE	NUMERIC
btlimitmax	This field stores the maximum amount that can be allocated to balance transfers from the overall credit limit	NULLABLE	NUMERIC
combinedcabtpercent	When balance transfers are allowed, this field stores the percentage of the overall credit limit to be allocated to cash advances and balance transfers combined by multiplying the percent value in this field by the Credit Limit field value	NULLABLE	NUMERIC
combinedcabtlimitmax	This field stores the maximum amount that can be allocated to combined cash advances and balance transfers from the overall credit limit	NULLABLE	NUMERIC
feeaddonsincelaststmt	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card fee	NULLABLE	NUMERIC
puaddonsincelaststmt_1	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_2	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_3	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_4	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_5	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_6	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_7	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_8	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at the standard rate	NULLABLE	NUMERIC
puaddonsincelaststmt_9	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card purchase at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_1	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_2	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_3	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_4	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_5	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_6	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_7	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_8	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at the standard rate	NULLABLE	NUMERIC
caaddonsincelaststmt_9	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card cash advance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_1	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_2	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_3	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_4	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_5	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_6	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_7	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_8	Symitar Quest stores loan add-on transactions in this field that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at the standard rate	NULLABLE	NUMERIC
btaddonsincelaststmt_9	Symitar Quest stores loan add-on transactions in these fields that have occurred since the last statement cutoff processing date and that are being charged as a credit card balance transfer at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
feepmtsincelaststmt	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's fee balance	NULLABLE	NUMERIC
pupmtsincelaststmt_1	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_2	Symitar Quest stores loan payment transactions for each field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_3	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_4	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_5	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_6	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_7	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_8	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at the standard rate	NULLABLE	NUMERIC
pupmtsincelaststmt_9	Symitar Quest stores loan payment transactions for each field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's purchase balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_1	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_2	Symitar Quest stores loan payment transactions for each field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_3	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_4	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_5	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_6	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_7	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_8	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at the standard rate	NULLABLE	NUMERIC
capmtsincelaststmt_9	Symitar Quest stores loan payment transactions for each field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's cash advance balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_1	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_2	Symitar Quest stores loan payment transactions for these fields that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_3	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_4	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_5	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_6	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_7	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_8	Symitar Quest stores loan payment transactions in this field that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at the standard rate	NULLABLE	NUMERIC
btpmtsincelaststmt_9	Symitar Quest stores loan payment transactions for these fields that have occurred since the last statement cutoff processing date and that apply to the credit card loan's balance transfer balance at an alternate interest rate from the standard rate	NULLABLE	NUMERIC
maxduedateadvanceperiod	This field stores a code that defines the maximum number of periods the due date can be advanced into the future	NULLABLE	INTEGER
seg0beginningcycledate	This field stores the beginning cycle date for the current payment period for a SymChoice Loan	NULLABLE	DATE
initialbcdsettingoption	This field stores a code that determines how the beginning cycle date will be set for non-billed loans and loans that use the (1) Use Loan Due Date (One when due) option	NULLABLE	INTEGER
bcdday1	This field stores the day that each billing cycle starts for a loan	NULLABLE	INTEGER
bcdday2	This field stores the loan's beginning cycle date only for loans that have the Payment Frequency field value set to (5) Semimonthly	NULLABLE	INTEGER
intpayoffcalc	This field is reserved for future use	NULLABLE	INTEGER
stmtfeeslastyear	Symitar Quest stores the sum of all fields that make up the Stmt Fees YTD field for this loan during the previous year in this field	NULLABLE	NUMERIC
insuranceytdnoadj	Symitar Quest stores the total amount in this field of insurance billed to the principal loan balance during the current year, not including adjustments	NULLABLE	NUMERIC
insurancelstyrnoadj	Symitar Quest stores the total amount in this field of insurance billed to the principal loan balance during the previous year, not including adjustments	NULLABLE	NUMERIC
latechgytdnoadj	Symitar Quest stores the total amount in this field of late charges billed to the loan during the current year, not including adjustments	NULLABLE	NUMERIC
latechglastyrnoadj	Symitar Quest stores the total amount in this field of late charges billed to the loan during the previous year, not including adjustments	NULLABLE	NUMERIC
feesytdnoadj	Symitar Quest stores the total amount in this field of transaction fees charged to a loan during the current year, not including adjustments	NULLABLE	NUMERIC
feeslastyrnoadj	Symitar Quest stores the amount in this field of fees assessed on the loan the previous year, not including adjustments	NULLABLE	NUMERIC
billedfeeytdnoadj	Symitar Quest stores the amount in this field of billed fees collected during payment processing during the current year, not including adjustments	NULLABLE	NUMERIC
billedfeelstyrnoadj	Symitar Quest stores the amount in this field of billed fees billed to the loan during payment processing for the previous year, not including adjustments	NULLABLE	NUMERIC
prepaymentpenalty	This field stores a code that indicates whether information appears on periodic mortgage statements or mortgage coupons	NULLABLE	INTEGER
nextratechangedate	This field stores the date when the rate may next change	NULLABLE	DATE
ratechangecyclemonths	This field stores the number of months before the rate can change	NULLABLE	INTEGER
totalaccrualreversal	Symitar Quest stores the total amount in this field of accrued interest that was reversed on this loan	NULLABLE	NUMERIC
lastaccrreversaldate	Symitar Quest stores the date in this field of the most recent reversal of accrued interest because of delinquency	NULLABLE	DATE
accrreinstatementdate	This field stores the date when the loan returns to accrual status	NULLABLE	DATE
accrualstatus	Symitar Quest stores a code in this field that specifies the current accrual status of the loan	NULLABLE	INTEGER
armnotice	This field stores a code that determines whether the Rate Change Processing batch program creates ARM notices for this loan	NULLABLE	INTEGER
initialarmnotice	This field stores a code that determines whether the Rate Change Processing batch program creates a one-time initial ARM notice for this loan	NULLABLE	INTEGER
initarmnoticecreationdate	Symitar Quest stores the date in this field on which the Rate Change Processing batch program created the initial ARM notice	NULLABLE	DATE
lastarmnoticecreationdate	Symitar Quest stores the most recent date in this field on which Symitar Quest sent out a payment disclosure ARM notice	NULLABLE	DATE
occupancytype	This field stores a code that specifies the occupancy status of the property the borrower purchased with this loan	NULLABLE	INTEGER
amortizationterm	This field stores the number of months for which your financial institution amortized this loan	NULLABLE	INTEGER
prepaymentpenaltyexpdate	This field stores the date on which the prepayment penalty expires	NULLABLE	DATE
rateroundingmethod	This field stores a code that indicates how Symitar Quest performs rate-rounding when your entry at the Round Rate To field requires the calculation of a new interest rate for this loan	NULLABLE	INTEGER
roundrateto	This field stores a value between 0.000 and 999.999 that you want to round the interest rate when Symitar Quest calculates a new interest	NULLABLE	NUMERIC
propertyaddresstype	This field stores a code that indicates how Symitar Quest stores the property address information that secures a mortgage loan	NULLABLE	INTEGER
propertyjurisdiction	This field stores the property's jurisdiction	NULLABLE	STRING
assessorparcelnumber	This field stores the property's Assessor Parcel Number (APN)	NULLABLE	STRING
beginningyearbalance	Symitar Quest stores the balance of the loan at the start of the current calendar year in this field	NULLABLE	NUMERIC
prevbeginningyearbalance	Symitar Quest stores the balance of the loan at the start of the previous calendar year in this field	NULLABLE	NUMERIC
militaryaprloan	This field stores a code that indicates whether the loan qualifies for the military APR program	NULLABLE	INTEGER
seg0currstmtintaccrd	This field stores the total interest paid in the current statement period for Segment 0 of a SymChoice Loan	NULLABLE	NUMERIC
seg0prevstmtintaccrd	This field stores the total interest paid in the previous statement period for Segment 0 of a SymChoice Loan	NULLABLE	NUMERIC
agencyidentifier	This field stores a code that indicates if a secondary agency is identified	NULLABLE	INTEGER
agencyacctnumber	This field stores a unique identifier issued by one of the secondary agencies: Fannie Mae or Freddie Mac	NULLABLE	STRING
mortgageidnumber	This field stores the mortgage identification number assigned to a mortgage loan and remains with that loan regardless of the lender that currently owns it	NULLABLE	STRING
lossmiteffectdate	This field stores the effective date on which you add the loan to a loss mitigation program	NULLABLE	DATE
lossmitexpiredate	This field stores the date on and after which the loan is no longer included in a loss mitigation program	NULLABLE	DATE
lossmitstmtmsgcode	This field stores a code for the mitigation statement message code that you set up in the Statement Messages parameters in Parameter Manager	NULLABLE	INTEGER
foreclosureeffectdate	This field stores the effective date on which your financial institution made the first notice or filing required for foreclosure	NULLABLE	DATE
foreclosureexpiredate	This field stores the date that the loan is no longer in foreclosure	NULLABLE	DATE
foreclosurestmtmsgcode	This field stores a code for the foreclosure statement message code that you set up in the Statement Messages parameters in Parameter Manager	NULLABLE	INTEGER
sendfinalchgoffstmt	This field stores a code that indicates whether you want Symitar Quest to produce a periodic mortgage statement for a final charge-off the next time you run the Statement Generation batch program	NULLABLE	INTEGER
finalchgoffstmtdate	Symitar Quest stores the system date in this field when you run the Statement Cutoff Processing batch program for the periodic mortgage statement	NULLABLE	DATE
finalchgoffstmtmsgcode	This field stores a code for the charge-off statement message based on your entry in the Statement Messages parameters in Parameter Manager	NULLABLE	INTEGER
originationbalance	Symitar Quest stores the opening day balance of the loan. This information is used on IRS form 1098 for the Outstanding Mortgage Principal (box 2)	NULLABLE	NUMERIC
earlyintervntnnoticedate	This field stores the last date that you sent an Early Intervention Notice to the member	NULLABLE	DATE
acquisitiondate	This field stores the date the loan was acquired from a third party	NULLABLE	DATE
acquisitionbalance	This field stores the outstanding loan principal balance as of the date of acquisition from a third party	NULLABLE	NUMERIC
stmtnotestartdate	Symitar Quest stores the value of the Enter Date field of the oldest active Statement Note record in this field that appears on the periodic mortgage statement as of the system date you run the Statement Cutoff Processing batch program	NULLABLE	DATE
maprcurrstmtintaccrd	Symitar Quest stores the total interest charged or accrued for the current statement period in this field, beginning on the day following the date in the Statement Date field	NULLABLE	NUMERIC
lossmitpayment	This field stores the temporary loss mitigation payment amount that the member agreed to for the loan	NULLABLE	NUMERIC
lossmitpmtstmtmsgcode	This field stores a code for the mitigation payment statement message code that you set up in the Statement Messages parameters in Parameter Manager	NULLABLE	INTEGER
regpaymentstmtmsgcode	This field stores a code for the regular statement message code that you set up in the Statement Messages parameters in Parameter Manager	NULLABLE	INTEGER
accelerationgoodthrudate	This field stores the final date (called the "good-through date") after which the value that you entered in the Acceleration Amount field is no longer valid	NULLABLE	DATE
accelerationamt	This field stores the payment amount that a borrower must pay by a specified date	NULLABLE	NUMERIC
accelerationstmtmsgcode	This field stores the acceleration statement message code that you defined in Statement Messages parameters	NULLABLE	INTEGER
reinstatementgoodthrudate	This field stores the final date (called the "good-through date") after which a payment in the Reinstatement Amount field no longer reinstates the loan	NULLABLE	DATE
reinstatementamt	This field stores the amount that your borrower must pay to reinstate their loan by a specified date	NULLABLE	NUMERIC
reinstatementstmtmsgcode	This field stores the reinstatement statement message code that you defined in Statement Messages parameters	NULLABLE	INTEGER
currstmtlossmitamtdue	Symitar Quest stores the total amount due in this field for an active temporary loss mitigation plan as of the most recent statement cutoff for this loan	NULLABLE	NUMERIC
prevstmtlossmitamtdue	Symitar Quest stores the total amount due in this field for the temporary loss mitigation plan from the previous statement produced for this loan	NULLABLE	NUMERIC
mtgnumprop	This field stores the number of properties that secure this mortgage loan	NULLABLE	INTEGER
bkchapterreported	This field stores a code that identifies the Bankruptcy Chapter reported	NULLABLE	INTEGER
hmdauniversalloanidentifier1	This field is used for HMDA reporting; it stores the unique loan identifier (ULI) of the covered loan	NULLABLE	STRING
hmdauniversalloanidentifier2	This field is used for HMDA reporting; it stores up to five additional universal loan identifier (ULI) characters, if the ULI was previously established outside of Symitar Quest and is more than the 40 characters allowed in the Universal Loan Identifier 1 field	NULLABLE	STRING
leasedispositiondate	This field stores the date when the disposition fee is charged when a vehicle is turned back in at the end of a lease	NULLABLE	DATE
leasedispositionfee	This field stores the fee amount to be charged when a vehicle is turned back in at the end of a lease	NULLABLE	NUMERIC
fixedlesseestatetaxrate	This field stores a fixed state sales tax rate for the lessee state	NULLABLE	NUMERIC
fixedlesseecountytaxrate	This field stores a fixed county sales tax rate for the lessee county	NULLABLE	NUMERIC
fixedlesseecitytaxrate	This field stores a fixed city sales tax rate for the lessee city	NULLABLE	NUMERIC
fixeddealerstatetaxrate	This field stores a fixed state sales tax rate for the dealer state	NULLABLE	NUMERIC
fixeddealercountytaxrate	This field stores a fixed county sales tax rate for the dealer county	NULLABLE	NUMERIC
fixeddealercitytaxrate	This field stores a fixed city sales tax rate for the dealer city	NULLABLE	NUMERIC
positivepaydraft	This field stores a code that allows the user to add the loan to the Positive Pay Draft module using PowerOn specfiles or SymConnect	NULLABLE	INTEGER
cancelable	This field sets a line-of-credit (LOC) loan as cancelable, meaning it can be revoked under the terms of the loan's agreements	NULLABLE	INTEGER
investor		NULLABLE	INTEGER
remittancetype		NULLABLE	INTEGER
versionid		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