loanapp_raw
Pipelined Data Sets
>
Symitar
>
loanapp_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| loanappuuid | This field stores a JH Platform unique identifier for a loan app | 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 | |
| loanappkey | 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 | |
| id | This field stores the ID you assign to the Application record when you create it | NULLABLE | STRING | |
| type | This field stores a credit union-defined code to identify the kind of application | NULLABLE | INTEGER | |
| subtype | This field stores a credit union-defined code that identifies the application type | NULLABLE | INTEGER | |
| formtype | This field stores a credit union-defined code to identify the type of form used for the application | NULLABLE | INTEGER | |
| branch | This field stores the number of the branch where the application originated | NULLABLE | INTEGER | |
| lastfmdate | This field stores the current system date whenever there is any file maintenance of an Application record or child record field | NULLABLE | DATE | |
| creationdate | This field stores the current system date when you create the Application record | NULLABLE | DATE | |
| effectivedate | This field stores the effective date of the Application record | NULLABLE | DATE | |
| expirationdate | This field stores the date the Application record expires | NULLABLE | DATE | |
| applicationdate | This field stores the current system date when you create the Application record | NULLABLE | DATE | |
| denialreason_1 | These fields each store a credit union-defined code to indicate the reason for denying or canceling the application or for making a counter offer | NULLABLE | INTEGER | |
| denialreason_2 | These fields each store a credit union-defined code to indicate the reason for denying or canceling the application or for making a counter offer | NULLABLE | INTEGER | |
| denialreason_3 | These fields each store a credit union-defined code to indicate the reason for denying or canceling the application or for making a counter offer | NULLABLE | INTEGER | |
| denialreason_4 | These fields each store a credit union-defined code to indicate the reason for denying or canceling the application or for making a counter offer | NULLABLE | INTEGER | |
| denialreason_5 | These fields each store a credit union-defined code to indicate the reason for denying or canceling the application or for making a counter offer | NULLABLE | INTEGER | |
| denialdate | This field stores the date you denied the application | NULLABLE | DATE | |
| debtratiotype_1 | These fields each store a credit union-defined code to specify a debt ratio calculation based on the definition of that Debt Ratio Type field | NULLABLE | INTEGER | |
| debtratiotype_2 | These fields each store a credit union-defined code to specify a debt ratio calculation based on the definition of that Debt Ratio Type field | NULLABLE | INTEGER | |
| debtratiotype_3 | These fields each store a credit union-defined code to specify a debt ratio calculation based on the definition of that Debt Ratio Type field | NULLABLE | INTEGER | |
| debtratiotype_4 | These fields each store a credit union-defined code to specify a debt ratio calculation based on the definition of that Debt Ratio Type field | NULLABLE | INTEGER | |
| debtratiotype_5 | These fields each store a credit union-defined code to specify a debt ratio calculation based on the definition of that Debt Ratio Type field | NULLABLE | INTEGER | |
| debtratio_1 | These fields each store a debt ratio calculated according to the credit union-defined debt ratio type in that Debt Ratio Type field | NULLABLE | NUMERIC | |
| debtratio_2 | These fields each store a debt ratio calculated according to the credit union-defined debt ratio type in that Debt Ratio Type field | NULLABLE | NUMERIC | |
| debtratio_3 | These fields each store a debt ratio calculated according to the credit union-defined debt ratio type in that Debt Ratio Type field | NULLABLE | NUMERIC | |
| debtratio_4 | These fields each store a debt ratio calculated according to the credit union-defined debt ratio type in that Debt Ratio Type field | NULLABLE | NUMERIC | |
| debtratio_5 | These fields each store a debt ratio calculated according to the credit union-defined debt ratio type in that Debt Ratio Type field | NULLABLE | NUMERIC | |
| creditscoretype | This field stores a credit union-defined code to specify the type of credit score to be calculated for the application | NULLABLE | INTEGER | |
| creditscore | This field stores the results of Symitar programmed credit score calculations | NULLABLE | INTEGER | |
| cutotalshares | This field stores the sum of all available balances in Share records in the member's account with a value in the Share Code field of (0) Share and a value in the IRS Code field of (0) Normal | NULLABLE | NUMERIC | |
| cutotaldrafts | This field stores the sum of all available balances in Share records in the member's account with a value in the Share Code field of (1) Draft and a value in the IRS Code field of (0) Normal | NULLABLE | NUMERIC | |
| cutotalcertiras | This field stores the sum of all available balances in Share records in the member's account with a value in the Share Code field of (2) Certificate or (3) Club, or any share with a non-zero value in the IRS Code field | NULLABLE | NUMERIC | |
| cutotalopenendloans | This field stores the sum of all loan balances in Loan records in the member's account with a value in the Loan Code field of (1) Open End, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalclosedendloans | This field stores the sum of all loan balances in Loan records in the member's account with a value in the Loan Code field of (0) Closed End, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotallocloans | This field stores the sum of all loan balances in Loan records in the member's account with a value in the Loan Code field of (2) Line of Credit, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalcreditcardloans | This field stores the sum of all loan balances, unpaid interest, and unpaid late charges in Loan records in the member's account with a value in the Loan Code field of (3) Credit Card, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalcreditlimit | This field stores the sum of all credit limits in all Loan records in the member's account with a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalopenendpayments | This field stores the sum of all standard payments for all Loan records in the member's account with a value in the Loan Code field of (1) Open End, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalclosedendpayments | This field stores the sum of all standard payments for all Loan records in the member's account with a value in the Loan Code field of (0) Closed End, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotallocpayments | This field stores the sum of all standard payments for all Loan records in the member's account with a value in the Loan Code field of (2) Line of Credit, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| cutotalcredcardpayments | This field stores the sum of all standard payments for all Loan records in the member's account with a value in the Loan Code field of (3) Credit Card, a blank in the Close Date field, and a blank in the Charge-off Date field | NULLABLE | NUMERIC | |
| totalincome | This field stores the combined total of the values in the Curr Gross Mo Pay fields in all Person records under the Application record and the values in the Monthly Income fields in all Finance records under the Application record | NULLABLE | NUMERIC | |
| totalexpenses | This field stores the combined total of the values in the CU Open End Pmts, CU Closed End Pmts, CU LOC Pmts, CU Credit Card Pmts, and payment fields in the Application record and the values in the Monthly Expense fields in all Finance records under the Application record | NULLABLE | NUMERIC | |
| totalassets | This field stores the combined total of the values in the CU Share Bal, CU Draft Bal, and CU Cert IRA Bal fields in the Application record and the values in the Asset Value fields in all Finance records under the Application record | NULLABLE | NUMERIC | |
| totalliabilities | This field stores the combined total of the values in the CU Opn End Loan Bal, CU Cls End Loan Bal, CU LOC Loan Bal, CU Cred Card Ln Bal, and Loan Amount fields in the Application record and the values in the Liability Balance fields in all Finance records under the Application record | NULLABLE | NUMERIC | |
| totalcreditlimits | This field stores the combined total of the value in the CU Total Credit Lim field in the Application record and the values in the Credit Limit fields in all Finance records under the Application record | NULLABLE | NUMERIC | |
| grossmonthlypay1 | This field stores the amount of the person's current monthly gross pay from the Curr Gross MO Pay field from the first Person record (record 00) under the Application record | NULLABLE | NUMERIC | |
| netmonthlypay1 | This field stores the amount of this person's current monthly net pay from the Curr Net MO Pay field from the first Person record (record 00) under the Application record | NULLABLE | NUMERIC | |
| grossmonthlypay2 | This field stores the amount of the person's current monthly gross pay from the Curr Gross MO Pay field from the second Person record (record 00) under the Application record | NULLABLE | NUMERIC | |
| netmonthlypay2 | This field stores the amount of this person's current monthly net pay from the Curr Net MO Pay field from the second Person record (record 00) under the Application record | NULLABLE | NUMERIC | |
| loantype | This field stores a credit union-defined code to identify the kind of loan the applicant is applying for | NULLABLE | INTEGER | |
| ecoacode | This field stores a code that indicates how the system populates the ECOA Code field in the Loan record if the loan is created automatically using the Loan Creation workflow action in Application Processing | NULLABLE | INTEGER | |
| approvalcode | This field stores a credit union-defined code or the user number of the person who approved the application | NULLABLE | INTEGER | |
| approvaldate | This field stores the date the application was approved | NULLABLE | DATE | |
| processorcode | This field stores the user number of the person who creates the application | NULLABLE | INTEGER | |
| existingloanid | If the member is applying for an add-on to an existing loan, this field stores the ID of the existing Loan record | NULLABLE | STRING | |
| existingloanbalance | This field stores the balance of the loan specified at the Existing Loan ID field | NULLABLE | NUMERIC | |
| paymentmethod | This field stores a code that specifies the method of payment for a loan | NULLABLE | INTEGER | |
| paymentfrequency | This field stores a code that specifies the frequency of loan payments | 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 loans | NULLABLE | INTEGER | |
| transferaccountnumber | If loan payments are by automatic transfer of funds from another account, this field stores the number of the other account | NULLABLE | STRING | |
| transferaccountid | If loan payments are by automatic transfer of funds from another account, this field stores the ID of the Share record | NULLABLE | STRING | |
| collateralcode | This field stores a code that indicates the collateral offered for the loan | NULLABLE | INTEGER | |
| collateraldate | This field stores the date the member offered the collateral for the loan | NULLABLE | DATE | |
| securedcode | This field stores a code that specifies the type of security, if any, for a loan | NULLABLE | INTEGER | |
| insurance1chosen | This field stores a code that indicates if the applicant has elected to purchase single credit life insurance | NULLABLE | INTEGER | |
| insurance2chosen | This field stores a code that indicates if the applicant has elected to purchase joint credit life insurance | NULLABLE | INTEGER | |
| insurance3chosen | This field stores a code that indicates if the applicant has elected to purchase credit disability insurance | NULLABLE | INTEGER | |
| insurancetype | This field stores a credit union-defined code that indicates whether the member has elected to purchase insurance | NULLABLE | INTEGER | |
| insurancemax | This field stores the maximum insurable balance for the insurance type selected | NULLABLE | NUMERIC | |
| purposecode | This field stores a credit union-defined code to indicate the purpose of the loan | NULLABLE | INTEGER | |
| creditlimit | This field stores the credit limit for line-of-credit or credit card loans | NULLABLE | NUMERIC | |
| limitexpirationdate | This field stores the expiration date of the loan's credit limit | NULLABLE | DATE | |
| loandescription | This field stores a description of the loan | NULLABLE | STRING | |
| borrowdate | This field stores the date you disburse funds for the loan | NULLABLE | DATE | |
| firstduedate | This field stores the date the first loan payment is due | NULLABLE | DATE | |
| payment | This field stores the amount of the loan payment | NULLABLE | NUMERIC | |
| loanamount | This field stores the total amount of the loan | NULLABLE | NUMERIC | |
| termmonths | This field stores the number of months in the term of the loan | NULLABLE | INTEGER | |
| balloondate | This field stores the date the balloon loan payment is due, if applicable | NULLABLE | DATE | |
| interestrate | This field stores the interest rate of the loan | NULLABLE | NUMERIC | |
| usernumber1 | In this case, this field stores a credit union-defined number that indicates the second application request type | NULLABLE | INTEGER | |
| usernumber2 | In this case, this field stores a credit union-defined number that indicates the interviewer or user ID | NULLABLE | INTEGER | |
| userrate1 | In this case, this field stores a credit union-defined rate approved | NULLABLE | NUMERIC | |
| userrate2 | In this case, this field stores a credit union-defined debt ratio | NULLABLE | NUMERIC | |
| userchar1 | In this case, this field stores a credit union-defined character indicating whether the current address is correct | NULLABLE | STRING | |
| userchar2 | In this case, this field stores a credit union-defined character indicating another source of income | NULLABLE | STRING | |
| userchar3 | In this case, this field stores a credit union-defined character indicating if there is a co-applicant | NULLABLE | STRING | |
| userchar4 | In this case, this field stores a credit union-defined character indicating the purpose of the loan | NULLABLE | STRING | |
| useramount1 | In this case, this field stores a credit union-defined amount of the applicant's income from another source | NULLABLE | NUMERIC | |
| useramount2 | In this case, this field stores a credit union-defined amount of the second loan application | NULLABLE | NUMERIC | |
| useramount3 | In this case, this field stores a credit union-defined amount of the applicant's rent or mortgage | NULLABLE | NUMERIC | |
| useramount4 | In this case, this field stores a credit union-defined amount of the applicant's new monthly payment for a new loan | NULLABLE | NUMERIC | |
| useramount5 | In this case, this field stores a credit union-defined amount of the co-applicant's rent or mortgage, if different than applicant's | NULLABLE | NUMERIC | |
| useramount6 | In this case, this field stores a credit union-defined amount of the co-applicant's other income from another source | NULLABLE | NUMERIC | |
| useramount7 | In this case, this field stores a credit union-defined amount of the applicant's taxes | NULLABLE | NUMERIC | |
| useramount8 | In this case, this field stores a credit union-defined amount of the applicant's insurance payments or home owners association payment | NULLABLE | NUMERIC | |
| useramount9 | In this case, this field stores a credit union-defined amount of the property's value or sales price | NULLABLE | NUMERIC | |
| useramount10 | In this case, this field stores a credit union-defined amount of the applicant's total income | NULLABLE | NUMERIC | |
| usercode1 | In this case, this field stores a credit union-defined code that indicates if there is any cross sell opportunities | NULLABLE | INTEGER | |
| usercode2 | In this case, this field stores a credit union-defined code that indicates any payment skips | NULLABLE | INTEGER | |
| usercode3 | In this case, this field stores a credit union-defined code that indicates the employee working with the applicant on a cross sell opportunity | NULLABLE | INTEGER | |
| usercode4 | In this case, this field stores a credit union-defined code that indicates the time (HHMM) the application was received | NULLABLE | INTEGER | |
| usercode5 | In this case, this field stores a credit union-defined code that indicates the time (HHMM) that the decision on the application was made | NULLABLE | INTEGER | |
| usercode6 | In this case, this field stores a credit union-defined code that indicates if the applicant is self-employed | NULLABLE | INTEGER | |
| usercode7 | In this case, this field stores a credit union-defined code that indicates the applicant's credit retrieval bureau score | NULLABLE | INTEGER | |
| usercode8 | In this case, this field stores a credit union-defined code that indicates the rate tier for this loan | NULLABLE | INTEGER | |
| usercode9 | In this case, this field stores a credit union-defined code that indicates if the housing for the co-applicant is the same as for the applicant | NULLABLE | INTEGER | |
| usercode10 | This field is a custom field that is not displayed unless you define it with the Application User Field Names parameters | NULLABLE | INTEGER | |
| userdate1 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate2 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate3 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate4 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate5 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate6 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate7 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate8 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate9 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| userdate10 | These fields are custom fields that are not displayed unless you define them with the Application User Field Names parameters | NULLABLE | DATE | |
| event | This field stores the number of the current application workflow event for the application | NULLABLE | INTEGER | |
| eventdate | This field stores the date the application workflow value in the Event Number field last changed | NULLABLE | DATE | |
| cancellationdate | This field stores the date you canceled the application | NULLABLE | DATE | |
| decisioncode | This field stores a user number or a credit union-defined code to identify the person making the application decision | NULLABLE | INTEGER | |
| decisiondate | This field stores the date of the decision to approve, deny, or cancel the application, make a counter offer, or place the application in pending mode | NULLABLE | DATE | |
| insurabilitycode | This field stores a credit union-defined code that indicates whether the loan applicant can be insured | NULLABLE | INTEGER | |
| counteredorigamt | This field stores the original amount for which the member applied | NULLABLE | NUMERIC | |
| counterofferexpiredate | This field stores the date the counter offer expires | NULLABLE | DATE | |
| secondapprequest | This field stores a description of a second application, if applicable | NULLABLE | STRING | |
| secondapppayment | This field stores the payment amount associated with the second application, if applicable | NULLABLE | NUMERIC | |
| thirdapprequest | This field stores a description of a third application, if applicable | NULLABLE | STRING | |
| thirdapppayment | This field stores the payment amount associated with the third application, if applicable | NULLABLE | NUMERIC | |
| cutotalsacctnumber_1 | These fields each store the account number of another account to be included in the credit union totals | NULLABLE | STRING | |
| cutotalsacctnumber_2 | These fields each store the account number of another account to be included in the credit union totals | NULLABLE | STRING | |
| cutotalsacctnumber_3 | These fields each store the account number of another account to be included in the credit union totals | NULLABLE | STRING | |
| cutotalsacctnumber_4 | These fields each store the account number of another account to be included in the credit union totals | NULLABLE | STRING | |
| cutotalsacctnumber_5 | These fields each store the account number of another account to be included in the credit union totals | NULLABLE | STRING | |
| loanreference | This field stores any reference information about the loan | NULLABLE | STRING | |
| loanmaturitydate | This field stores the date the loan matures | NULLABLE | DATE | |
| inforequestdate | This field stores the most recent date you sent the applicant a notice of incomplete application or a request for information | NULLABLE | DATE | |
| closingdate | This field stores the date you close this Application record | NULLABLE | DATE | |
| approvalamount | This field stores the approved loan amount | NULLABLE | NUMERIC | |
| creditbureau | This field stores a credit union-defined code to identify the credit bureau providing the credit report used to evaluate the application | NULLABLE | INTEGER | |
| vin | This field stores the vehicle identification number of any vehicle listed as collateral | NULLABLE | STRING | |
| censustract | This field stores the number of the census tract in which the applicant resides | NULLABLE | STRING | |
| pendingdate | This field stores the date you place an application in pending mode to await further action | NULLABLE | DATE | |
| secondapprequestamt | This field stores the amount the member requests in a second application, if applicable | NULLABLE | NUMERIC | |
| thirdapprequestamt | This field stores the amount the member requests in a third application, if applicable | NULLABLE | NUMERIC | |
| appraisedamount | This field stores the appraised amount of the collateral for the loan | NULLABLE | NUMERIC | |
| escrowamount | This field stores the amount of the payment to post to the share identified by the value in the Escrow ID field | NULLABLE | NUMERIC | |
| escrowid | This field stores the ID of the Share record to which the system should post the escrow amount whenever a member makes a loan payment | NULLABLE | STRING | |
| singlepremiumlife | This field stores the calculated amount of single premium life insurance | NULLABLE | NUMERIC | |
| singlepremiumdisability | This field stores the calculated amount of single premium disability insurance | NULLABLE | NUMERIC | |
| notepurgedate | This field is currently unused | NULLABLE | DATE | |
| balloonamount | This field stores the amount of a balloon payment, if applicable | NULLABLE | NUMERIC | |
| appraisaloffset | This field stores the offset value of the collateral for a second trust deed loan | NULLABLE | NUMERIC | |
| paymentskips | This field stores the number of loan payments the member can skip | NULLABLE | INTEGER | |
| paymentskipstartday | This field stores a code that represents the due date of the first payment the member can skip | NULLABLE | INTEGER | |
| fasb91code | This field stores the FASB 91 code used with loan type codes to create combinations that post to designated General Ledger accounts | NULLABLE | INTEGER | |
| effectiveapr | This field stores the current effective Annual Percentage Rate | NULLABLE | NUMERIC | |
| originalrate | This field stores the original effective Annual Percentage Rate | NULLABLE | NUMERIC | |
| unamortizedfees | This field stores the total amount of fees to be amortized over the loan term, according to FASB 91 | NULLABLE | NUMERIC | |
| 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 | This field stores the Annual Percentage Rate | NULLABLE | NUMERIC | |
| prepaidfinancechg | This field stores additional amounts, that can be included in a loan | NULLABLE | NUMERIC | |
| completedactions_1 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_2 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_3 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_4 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_5 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_6 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_7 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_8 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_9 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_10 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_11 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_12 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_13 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_14 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_15 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_16 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_17 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_18 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_19 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_20 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_21 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_22 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_23 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_24 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_25 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_26 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_27 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_28 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_29 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_30 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_31 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_32 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_33 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_34 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_35 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_36 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_37 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_38 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_39 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_40 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_41 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_42 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_43 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_44 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_45 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_46 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_47 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_48 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_49 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| completedactions_50 | These fields store a code that tracks whether the corresponding actions in the Application Processing workflow have been completed | NULLABLE | INTEGER | |
| amortizationschd | Primarily for users of the corporate interface: This field stores the numeric value of the set of Amortization Schedules parameters | NULLABLE | INTEGER | |
| amortizationschdtype | Primarily for users of the corporate interface: This field indicates whether the set of Amortization Schedules parameters specified in the Amortization Schedule field is local or global | 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 | Formerly for users of the corporate interface: This field indicated whether the set of Call/Put Item Schedules parameters specified in the Call Item Schedule field is local or global | NULLABLE | INTEGER | |
| bureauscore_1 | This field stores the most recent credit score from the Experian credit bureau for the main applicant for the loan | NULLABLE | INTEGER | |
| bureauscore_2 | This field stores the most recent credit score from the Equifax credit bureau for the main applicant for the loan | NULLABLE | INTEGER | |
| bureauscore_3 | This field stores the most recent credit score from the TransUnion® credit bureau for the main applicant for the loan | NULLABLE | INTEGER | |
| bureauscore_4 | This field stores the most recent credit score from the Experian credit bureau for the main applicant for the loan | NULLABLE | INTEGER | |
| cbilocator_1 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| cbilocator_2 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| cbilocator_3 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| cbilocator_4 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| cbilocator_5 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| cbilocator_6 | These fields each store a unique credit bureau information (CBI) request identifier for that request | NULLABLE | INTEGER | |
| preflocator | This field stores the system-defined locator number from the associated Preference record's Locator field | NULLABLE | INTEGER | |
| 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 indicated whether the set of Call/Put Item Schedules parameters specified in the Put Item Schedule field is local or global | NULLABLE | INTEGER | |
| indirectdealernum | If the Dealer Reserve Accounting module has been implemented, this field stores the indirect dealer number | NULLABLE | STRING | |
| indirectplanid | If the Dealer Reserve Accounting module has been implemented, this field stores the reserve plan ID associated with this indirect loan | NULLABLE | STRING | |
| firstinsbirthdate | This field stores the first insurer's date of birth | NULLABLE | DATE | |
| secondinsbirthdate | This field stores the second insurer's date of birth | NULLABLE | DATE | |
| paymenttype | This field stores a code that indicates the method for calculating the payment | NULLABLE | INTEGER | |
| dqcalculationmethod | This field stores a code that defines the method used to calculate delinquency | NULLABLE | INTEGER | |
| interesttype | This field stores a code that indicates the method for calculating loan interest that can be different for each Schedule record when using the MBS Multiple Repayment Programs Per Loan module | NULLABLE | INTEGER | |
| duedateadvancecode | This field stores a code that specifies how the system advances the due date when a payment is made to the loan | NULLABLE | INTEGER | |
| paymentcalctype | This field stores a credit union-defined code used for determining the calculation method for the loan | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Application record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| 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 at the time the subject residential mortgage transaction was completed | NULLABLE | NUMERIC | |
| highriskcode | This field stores a code that specifies whether a loan is considered high risk | NULLABLE | INTEGER | |
| accounttype | This field stores a credit union-defined code to identify the type of account | NULLABLE | INTEGER | |
| comboseg0pmtorder | This field stores a code that determines the order to set Segment 0 when used with the Combo Payment Order Method field for SymChoice Loans | NULLABLE | INTEGER | |
| combopmtordermeth | This field stores a code that determines the order to pay segments for SymChoice Loans | NULLABLE | INTEGER | |
| combolnsegmentmax | This field stores a value to identify the maximum number of segments (including Segment 0) that can be added to a combination loan | NULLABLE | INTEGER | |
| seg0description | This field stores the description of the segment for SymChoice Loans | NULLABLE | STRING | |
| seg0paymentorder | This field stores a code that indicates the order in which Segment 0 will be paid for a Loan Payment (LP) transaction | NULLABLE | INTEGER | |
| loancode | This field stores a code that defines certain characteristics of the loan and determines how the system processes the loan | NULLABLE | INTEGER | |
| userqueue | The field stores whose queue the application is residing in | NULLABLE | INTEGER | |
| queuepriority | This field stores the level of importance given to this application | NULLABLE | INTEGER | |
| queuedate | The field stores either the date the application was forwarded to the user or the date the last decision was assigned to the application | NULLABLE | DATE | |
| queuetime | The field stores either the time of day the application was forwarded to the user or the time of day the last decision was assigned to the application | NULLABLE | INTEGER | |
| createdbyuser | This field stores the User ID and is populated when the record is created | NULLABLE | INTEGER | |
| createdatbranch | This field stores the branch ID of the branch where the Application record is created | NULLABLE | INTEGER | |
| origriskgrade | This field stores the original risk grade assigned to the note when it was originated | NULLABLE | STRING | |
| ovloptin | This field stores a code that indicates if the credit union prints the revocation statement | NULLABLE | INTEGER | |
| ovlauthfee | This field stores a code that indicates whether to authorize or assess a fee for credit card over-the-limit transactions | NULLABLE | INTEGER | |
| newsegcutoffoption | This field stores a code that controls how the system calculates the Due Date field in the projections screen of a Segment record | NULLABLE | INTEGER | |
| newsegcutoffdays | This field stores the number of days to add to the Loan Date field in the projections screen to calculate the segment cutoff date | NULLABLE | INTEGER | |
| 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 | ||
| capercent | This field stores the percentage of the overall credit limit that can be allocated to cash advances | NULLABLE | NUMERIC | |
| calimitmax | This field stores the maximum amount that can be allocated to cash advances from the overall credit limit | NULLABLE | NUMERIC | |
| btpercent | This field stores the percentage of the overall credit limit that can be allocated to balance transfers | NULLABLE | NUMERIC | |
| btlimitmax | This field stores the maximum amount that can be allocated to balance transfers from the overall credit limit | NULLABLE | NUMERIC | |
| combinedcabtpercent | This field stores the percentage of the overall credit limit to be allocated to cash advances and balance transfers combined | NULLABLE | NUMERIC | |
| combinedcabtlimitmax | This field stores the maximum amount that can be allocated to cash advances and balance transfers from the overall credit limit | NULLABLE | NUMERIC | |
| maxduedateadvanceperiod | This field stores the maximum number of periods the due date can be advanced into the future | NULLABLE | INTEGER | |
| initialbcdsettingoption | This field stores a code that determines how the beginning cycle date will be set for non-billed loans and loans with a Loan record Payment Method of (2) Auto transfer | NULLABLE | INTEGER | |
| propertyaddresstype | This field stores a code that indicates how the system stores the property address information that secures a mortgage loan | NULLABLE | INTEGER | |
| propertyjurisdiction | This field stores the property's jurisdiction (county and state) | NULLABLE | STRING | |
| assessorparcelnumber | This field stores the property's Assessor Parcel Number or Numbers (APN) | NULLABLE | STRING | |
| hmdaapplicationdatena | This field stores a code that indicates whether the requirement to report the application date applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaloanpurpose | This field stores a code that indicates the purpose of the covered loan or application | NULLABLE | INTEGER | |
| hmdapreapproval | This field stores a code that indicates whether the covered loan or application involved a request for a preapproval of a home purchase loan under a preapproval program | NULLABLE | INTEGER | |
| hmdaconstructionmethod | This field stores a code that indicates the construction method for the dwelling | NULLABLE | INTEGER | |
| hmdaannualincome | This field stores the gross annual income (in dollars) used in making the credit decision | NULLABLE | NUMERIC | |
| hmdaannualincomena | This field stores a code that indicates whether the requirement to report the gross annual income of the borrower applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaratespread | This field stores the difference between the covered loan's annual percentage rate (APR) and the average prime offer rate (APOR) for a comparable transaction | NULLABLE | NUMERIC | |
| hmdaratespreadna | This field stores a code that indicates whether the requirement to report the rate spread applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdatotalloancosts | This field stores the total loan costs amount | NULLABLE | NUMERIC | |
| hmdatotalloancostsna | This field stores a code that indicates whether the requirement to report the total loan costs applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdatotalpointsfees | This field stores the total points and fees charged with the covered loan | NULLABLE | NUMERIC | |
| hmdatotalpointsfeesna | This field stores a code that indicates whether the requirement to report the total points and fees applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaoriginationcharges | This field stores the total of all itemized amounts that are designated borrower-paid at or before closing | NULLABLE | NUMERIC | |
| hmdaoriginationchargesna | This field stores a code that indicates whether the requirement to report the origination charges applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdadiscountpoints | This field stores the points paid to the creditor to reduce the interest rate | NULLABLE | NUMERIC | |
| hmdadiscountpointsna | This field stores a code that indicates whether the requirement to report the discount points applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdalendercredits | This field stores the amount of lender credits | NULLABLE | NUMERIC | |
| hmdalendercreditsna | This field stores a code that indicates whether the requirement to report the lender credits applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaoccupancytype | This field stores a code that indicates the occupancy type of the residence | NULLABLE | INTEGER | |
| hmdaactiontaken | This field stores a code that indicates the action taken on the covered loan or application | NULLABLE | INTEGER | |
| hmdaactiontakendate | This field stores the date of action taken | NULLABLE | DATE | |
| hmdapropertystreetaddress | This field stores the street address of the property | NULLABLE | STRING | |
| hmdapropertystreetaddressna | This field stores a code that indicates whether the requirement to report the property street address is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdapropertycity | This field stores the city of the property | NULLABLE | STRING | |
| hmdapropertycityna | This field stores a code that indicates whether the requirement to report the property city is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdapropertystate | This field stores the two-letter state code of the property | NULLABLE | STRING | |
| hmdapropertystatena | This field stores a code that indicates whether the requirement to report the property state is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdapropertyzipcode | This field stores the ZIP Code of the property | NULLABLE | STRING | |
| hmdapropertyzipcodena | This field stores a code that indicates whether the requirement to report the property ZIP Code is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdapropertycounty | This field stores the Federal Information Processing Standards (FIPS) numerical code for the county | NULLABLE | STRING | |
| hmdapropertycountyna | This field stores a code that indicates whether the requirement to report the property county is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdacensustract | This field stores the Federal Information Processing Standards (FIPS) numerical code and the census tract number as defined by the U.S. Census Bureau | NULLABLE | STRING | |
| hmdacensustractna | This field stores a code that indicates whether the requirement to report the property census tract is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdaprepaymentpenaltyterm | This field stores the term in months of any prepayment penalty | NULLABLE | INTEGER | |
| hmdaprepaymentpenaltytermna | This field stores a code that indicates whether the requirement to report the prepayment penalty term applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaintrorateperiod | This field stores the number of months, or proposed number of months in the case of an application, until the first date the interest rate may change after closing or account opening | NULLABLE | INTEGER | |
| hmdaintrorateperiodna | This field stores a code that indicates whether the requirement to report the introductory rate period applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdapropertyvalue | This field stores the value of the property securing the covered loan or in the case of an application, proposed to secure the covered loan used in making the credit decision | NULLABLE | NUMERIC | |
| hmdapropertyvaluena | This field stores a code that indicates whether the requirement to report the property value applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdamultifamilyaffordunits | This field stores the number of individual dwelling units related to any multifamily dwelling property securing the covered loan, that are income-restricted under federal, state, or local affordable housing programs | NULLABLE | INTEGER | |
| hmdamultifamilyaffordunitsna | This field stores a code that indicates whether the requirement to report the multifamily affordable units applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdanmlsrid | This field stores the Nationwide Mortgage Licensing System and Registry unique identifier (NMLSR ID) for the mortgage loan originator | NULLABLE | STRING | |
| hmdanmlsridna | This field stores a code that indicates whether the requirement to report the mortgage loan originator NMLSR ID is applicable to the covered loan or application | NULLABLE | INTEGER | |
| hmdaautounderwritingsys_1 | These fields each store a code that indicates an automated underwriting system (AUS) you use to evaluate the application | NULLABLE | INTEGER | |
| hmdaautounderwritingsys_2 | These fields each store a code that indicates an automated underwriting system (AUS) you use to evaluate the application | NULLABLE | INTEGER | |
| hmdaautounderwritingsys_3 | These fields each store a code that indicates an automated underwriting system (AUS) you use to evaluate the application | NULLABLE | INTEGER | |
| hmdaautounderwritingsys_4 | These fields each store a code that indicates an automated underwriting system (AUS) you use to evaluate the application | NULLABLE | INTEGER | |
| hmdaautounderwritingsys_5 | These fields each store a code that indicates an automated underwriting system (AUS) you use to evaluate the application | NULLABLE | INTEGER | |
| hmdaautounderwritingsysother_1 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_2 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_3 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_4 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_5 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_6 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingsysother_7 | These fields store text that defines the specific name of another automated underwriting system referred to when any of the Auto Underwriting System 1-5 fields are set to (5) Other | NULLABLE | STRING | |
| hmdaautounderwritingresult_1 | These fields each store a code that indicates the results generated by the automated underwriting system (AUS) indicated in the related Auto Underwriting System 1-5 field | NULLABLE | INTEGER | |
| hmdaautounderwritingresult_2 | These fields each store a code that indicates the results generated by the automated underwriting system (AUS) indicated in the related Auto Underwriting System 1-5 field | NULLABLE | INTEGER | |
| hmdaautounderwritingresult_3 | These fields each store a code that indicates the results generated by the automated underwriting system (AUS) indicated in the related Auto Underwriting System 1-5 field | NULLABLE | INTEGER | |
| hmdaautounderwritingresult_4 | These fields each store a code that indicates the results generated by the automated underwriting system (AUS) indicated in the related Auto Underwriting System 1-5 field | NULLABLE | INTEGER | |
| hmdaautounderwritingresult_5 | These fields each store a code that indicates the results generated by the automated underwriting system (AUS) indicated in the related Auto Underwriting System 1-5 field | NULLABLE | INTEGER | |
| hmdaautounderwritingresother_1 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_2 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_3 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_4 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_5 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_6 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdaautounderwritingresother_7 | These fields store text that defines other automated underwriting system results indicated when the related Auto Underwriting Results 1-5 field is set to (16) Other | NULLABLE | STRING | |
| hmdainterestratena | This field stores a code that indicates whether the requirement to report the interest rate applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdadebtrationa | This field stores a code that indicates whether the requirement to report the debt-to-income ratio applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaloantovaluena | This field stores a code that indicates whether the requirement to report the loan-to-value applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaloantermna | This field stores a code that indicates whether the requirement to report the loan term applies to the covered loan or application | NULLABLE | INTEGER | |
| hmdaintonlypmtind | This field stores a code that indicates whether the contractual terms include, or would have included, interest-only payments | NULLABLE | INTEGER | |
| hmdanegamortind | This field stores a code that indicates whether the contractual terms include, or would have included, a term that would cause the covered loan to be a negative amortization loan | NULLABLE | INTEGER | |
| hmdaothernonamortfeatures | This field stores a code that indicates whether the contractual terms include, or would have included, any term that would allow for payments other than fully amortizing payments during the loan term | NULLABLE | INTEGER | |
| hmdamfdhomesecproptype | This field stores a code that indicates whether the covered loan or application is, or would have been, secured by a manufactured home with land, or by just a manufactured home without land | NULLABLE | INTEGER | |
| hmdamfdhomelandpropint | This field stores a code that indicates the applicant's or borrower's property interest in the land on which a manufactured home is, or will be, located | NULLABLE | INTEGER | |
| hmdatotalunits | This field stores the number of individual dwelling units related to the property securing the covered loan, or proposed to secure the covered loan | NULLABLE | INTEGER | |
| hmdasubmissionofapmethod | This field stores a code that indicates whether the applicant or borrower submitted the application directly to your institution | NULLABLE | INTEGER | |
| hmdainitpayabletoinst | This field stores a code that indicates whether the obligation arising from the covered loan was, or in the case of an application, would have been, initially payable to your institution | NULLABLE | INTEGER | |
| hmdarevmortind | This field stores a code that indicates whether the obligation arising from the covered loan was, or in the case of an application, would have been, initially payable to your institution | NULLABLE | INTEGER | |
| hmdaoelocind | This field stores a code that indicates whether the covered loan or the application is for an open-end line of credit | NULLABLE | INTEGER | |
| hmdabusorcommpurposeind | This field stores a code that indicates whether the covered loan or the application is for a loan that will be made primarily for a business or commercial purpose | NULLABLE | INTEGER | |
| hmdaloantype | This field stores a code that indicates the type of covered loan or application | NULLABLE | INTEGER | |
| hmdapurchasertype | This field stores a code that indicates the type of entity purchasing a covered loan from your institution | NULLABLE | INTEGER | |
| hmdahoepastatus | This field stores a code that indicates whether to report the status of the covered loan for the Home Ownership and Equity Protection Act (HOEPA) as a high-cost mortgage | NULLABLE | INTEGER | |
| hmdalienstatus | This field stores a code that indicates the lien status of the property securing the covered loan | NULLABLE | INTEGER | |
| hmdauniversalloanidentifier1 | This field stores the unique identifier of the covered loan or application | NULLABLE | STRING | |
| hmdauniversalloanidentifier2 | This field stores up to five additional Universal Loan Identifier (ULI) characters if the ULI was previously established outside of the system | NULLABLE | STRING | |
| hmdadenialreasonother_1 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_2 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_3 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_4 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_5 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_6 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| hmdadenialreasonother_7 | These fields store text that defines the HMDA denial reason referred to when any of the Denial Reason 1-4 fields are set to (9) Other | NULLABLE | STRING | |
| militaryaprloan | This field stores a code that indicates whether the loan qualifies for the military APR program | NULLABLE | INTEGER | |
| mtgnumprop | This field stores the number of properties that secure this mortgage loan | NULLABLE | INTEGER | |
| lesseestate | This field stores the two-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 two-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 | |
| dealercode | This field stores the dealer code for a lease loan | NULLABLE | STRING | |
| dealerreserve | This field stores the amount of the dealer reserve for a lease loan | 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 | |
| leaseterminatefee | This field stores the fee amount to be charged for a loan paid off | NULLABLE | NUMERIC | |
| 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 | |
| leaseterminatedate | This field stores the date when the member terminates a lease loan by surrendering the vehicle | NULLABLE | DATE | |
| 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 | |
| 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 | |
| hmdaratespreadsign | This field stores a code that specifies a positive or negative for the value in the Rate Spread field | NULLABLE | INTEGER |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026