loan_bankruptcy_raw

Pipelined Data Sets > Symitar > loan_bankruptcy_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
loanbankruptcyuuid	This field stores a JH Platform unique identifier for a loan bankruptcy	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
loanbankruptcykey	Internal use only; SSDB field	NULLABLE	INTEGER
loankey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	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
id	This field stores the four-character ID that identifies the Bankruptcy record. The bankruptcy ID is assigned when creating the Bankruptcy record	NULLABLE	STRING
description	You cannot create a Bankruptcy record without entering a description. If you leave the field blank, an error message appears, and you cannot save the Bankruptcy record until you have entered a description	NULLABLE	STRING
type	This field stores the reason for the Bankruptcy record	NULLABLE	INTEGER
opendate	The system updates this field with the system date when the Bankruptcy record is created	NULLABLE	DATE
closedate	This field stores the date when the Bankruptcy record is closed	NULLABLE	DATE
recordchangedate	This field stores the system date when you create, change, or save the Bankruptcy record	NULLABLE	DATE
effectdate	This field stores the date the bankruptcy begins, or takes effect	NULLABLE	DATE
expiredate	This field stores the date the bankruptcy expires, or is no longer in effect	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