collateral_raw

Pipelined Data Sets > Symitar > collateral_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
collateraluuid	This field stores a JH Platform unique identifier for a collateral	NULLABLE	STRING
collateralkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	NULLABLE	INTEGER
type	This field stores a credit union-defined code identifying the type of collateral	NULLABLE	INTEGER
lastfmdate	This field stores the current system date whenever there is any file maintenance of a Collateral record	NULLABLE	DATE
fmlastpurgedate	This field stores the date through which file maintenance history for the value in the Collateral Type field was last purged by the Purge Transaction Processing batch program	NULLABLE	DATE
createdate	This field stores the current system date when you create the Collateral record	NULLABLE	DATE
expiredate	This field stores the date the Collateral record expires	NULLABLE	DATE
valuedate	This field stores the date that the value in the Collateral Value field was obtained	NULLABLE	DATE
number	This field stores a unique identifier defined when you create a Collateral record	NULLABLE	STRING
collateralowner	This field stores the name of the collateral owner	NULLABLE	STRING
description	This field stores the description of the collateral defined in the Collateral Type Parameters for the type of collateral	NULLABLE	STRING
valuesource	This field stores the source used to value the collateral	NULLABLE	STRING
value	This field stores the dollar value of the collateral described in the Collateral record	NULLABLE	NUMERIC
userchar1	This field can store the first custom information defined for the Collateral record	NULLABLE	STRING
userchar2	This field can store the second custom information defined for the Collateral record	NULLABLE	STRING
userchar3	This field can store the third custom information defined for the Collateral record	NULLABLE	STRING
userchar4	This field can store the fourth custom information defined for the Collateral record	NULLABLE	STRING
userchar5	This field can store the fifth custom information defined for the Collateral record	NULLABLE	STRING
userchar6	This field can store the sixth custom information defined for the Collateral record	NULLABLE	STRING
requireddocumentlist	This field stores the list of required documents for the collateral for the corresponding collateral type defined in the Collateral Type parameters	NULLABLE	STRING
recordchangedate	This field stores the system date in this field when you create, change, or save the Collateral 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

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