loanapp_finance_raw

Pipelined Data Sets > Symitar > loanapp_finance_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
loanappfinanceuuid	This field stores a JH Platform unique identifier for a loan app finance	NULLABLE	STRING
loanappuuid	This field stores a JH Platform unique identifier for a loan app	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
loanappid	This field stores the parent, 4 digit Loan Application ID	NULLABLE	STRING
loanappfinancekey	Internal use only; SSDB field	NULLABLE	INTEGER
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
ownercode	This field stores a code that identifies the owner of the asset, liability, or expense in this Finance record	NULLABLE	INTEGER
itemtype	This field stores the kind of asset, income, or liability item in this Finance record	NULLABLE	STRING
description	This field stores the description of the finance item or the name of the creditor	NULLABLE	STRING
address	This field stores the address of the creditor	NULLABLE	STRING
reference	This field stores any reference information about this Finance record	NULLABLE	STRING
assetvalue	This field stores the dollar value of an asset outside the credit union	NULLABLE	NUMERIC
monthlyincome	This field stores the monthly income of an income outside the credit union	NULLABLE	NUMERIC
liabilitystatus	This field stores a code that represents the status of a liability	NULLABLE	INTEGER
assetstatus	This field stores a code that represents the status of an asset	NULLABLE	INTEGER
liabilitybalance	This field stores the total liability balance of a liability outside the credit union	NULLABLE	NUMERIC
monthlyexpense	This field stores the monthly expense amount of an expense outside the credit union	NULLABLE	NUMERIC
creditlimit	This field stores the amount of the credit limit of a credit card or a line of credit outside the credit union	NULLABLE	NUMERIC
debtratiousecode	This field stores a code that specifies whether the system should include this Finance record in debt ratio calculations	NULLABLE	INTEGER
type	This field stores a code that categorizes the contents of this Finance record	NULLABLE	INTEGER
locator	This field stores a unique number within each member account that can be used as a unique identification of this record	NULLABLE	INTEGER
interestrate	This field stores the interest rate that is currently being applied to the item in this record	NULLABLE	NUMERIC
userpledgecode	This field stores a code that provides information about whether an item is pledged for another purpose	NULLABLE	INTEGER
recordchangedate	This field stores the date when you create, change, or save the Application Finance record	NULLABLE	DATE

Have a Question?

Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026