participation_raw

Pipelined Data Sets > Symitar > participation_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
participationuuid	This field stores a JH Platform unique identifier for a participation	NULLABLE	STRING
participationkey	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
number	This field stores a number to uniquely identify the participation	NULLABLE	STRING
poolname	This field stores the name of the participation	NULLABLE	STRING
type	This field stores a numeric group identifier for the participation. You can assign each participation its own unique type to use when you purge file maintenance history	NULLABLE	INTEGER
lastfmdate	This field stores the date of the last file maintenance of the Participation record	NULLABLE	DATE
opendate	This field stores the date the Participation record was created	NULLABLE	DATE
closedate	This field stores the date a participation was closed out	NULLABLE	DATE
intcalcmethod	This field stores the method used to calculate interest, late charge, and lease termination fee distributions to participants	NULLABLE	INTEGER
princalcmethod	This field stores the principal calculation method for the participation	NULLABLE	INTEGER
fundingseqnum	This field indicates the order in which Symitar Quest applies funding to the owner for participations containing single loans. This field is used only if there is a single loan in the participation	NULLABLE	INTEGER
retentionpercent	The owning credit union retains this amount of the participation. Symitar Quest does not sell this percentage of the loan	NULLABLE	NUMERIC
fundingmaxamount	This field indicates the maximum funding for the owner if the owner funds a loan before the participants, based on the Funding Seq Number	NULLABLE	NUMERIC
fmlastpurgedate	This field stores the date through which you last purged file maintenance history for the participation type with the Purge Transaction Processing batch program	NULLABLE	DATE
poolcode	This field stores a code that indicates whether this participation contains a single loan or a pool of loans	NULLABLE	INTEGER
allowchargeoff	The value in this field determines whether or not you can charge off loans placed in this participation without first removing the loan	NULLABLE	INTEGER
recordchangedate	This field stores the system date when you create, change, or save the Participation record. There are times when Symitar Quest updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
allowaddloantopool	This field indicates whether you allow new loans to be added to funded pooled participations	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.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026