loan_hold_raw

Pipelined Data Sets > Symitar > loan_hold_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
loanholduuid	This field stores a JH Platform unique identifier for a loan hold	NULLABLE	STRING
loanuuid	This field stores a JH Platform unique identifier for a loan	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
loanid	This field stores the 4 digit Loan ID	NULLABLE	STRING
loanholdkey	Internal use only; SSDB field	NULLABLE	INTEGER
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
type	This field identifies the purpose of the Hold record	NULLABLE	INTEGER
effectivedate	this field stores the date the hold should take effect or the date the hold was created for hold types 1-12 and 14-21, and for hold type (13) Loan Draft, it stores the date a preapproved loan draft form was issued to the member	NULLABLE	DATE
expirationdate	This field stores the expiration date of the hold	NULLABLE	DATE
reference1	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
reference2	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
amount	This field stores the amount of money held	NULLABLE	NUMERIC
payeename	The value in this field varies depending on the hold type	NULLABLE	STRING
expirationtime	This field stores the time when a hold should be released	NULLABLE	INTEGER
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
memberbranch	This field is used by corporate credit unions only and it stores the branch number if available	NULLABLE	STRING
stoppaycode	This field stores the reason given for a stop	NULLABLE	INTEGER
reference3	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
reference4	All the Reference # fields, store reference information that is related to the hold	NULLABLE	STRING
matchdate	This field stores the date of an authorization hold	NULLABLE	DATE
matchtime	This field stores the time of an authorization hold	NULLABLE	INTEGER
feecode	This field stores the code that determines the fee placed on the transaction	NULLABLE	INTEGER
recordchangedate	This field stores the system date when you create, change or save the Hold record	NULLABLE	DATE
achrecurringstop	This field indicates whether the Hold record is used to stop multiple ACH items	NULLABLE	INTEGER
transactiontype	This field identifies the transaction type for ATM and PIN authorization transactions for preauthorized Loan holds only	NULLABLE	INTEGER
holdcreationdate	This field stores the AIX date (mm/dd/yyyy) that you created the hold record	NULLABLE	DATE
holdcreationtime	This field stores the AIX time (hh:mm:ss) that you created the hold record	NULLABLE	STRING
availablebalance	This field stores the value calculated by an ATM to authorize a transaction	NULLABLE	NUMERIC
ledgerbalance	This field stores the balance that the ATM software uses when it creates a PIN authorization or signature authorization Hold record	NULLABLE	NUMERIC

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