ssdb_gl_sub_account_cdc

Pipelined Data Sets > Symitar > ssdb_gl_sub_account_cdc

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
sourceeventtime	The timestamp of the change event from the source system (e.g., Debezium's ts_ms field).	NULLABLE	INTEGER
sourceeventdate	The UTC date of the change event, derived from sourceeventtime.	NULLABLE	DATE
operation	The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field.	NULLABLE	STRING
glsubaccountkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
glaccountkey	Internal use only; SSDB field	NULLABLE	INTEGER
id	This field stores the unique ID (up to 10 characters) you enter during creation of the GL Subaccount record	NULLABLE	STRING
type	This field stores a credit union-defined code that identifies the type of subaccount	NULLABLE	INTEGER
process	This field stores a code that specifies whether the offset GL account for the subaccount is an expense account or an income account	NULLABLE	INTEGER
method	This field stores the accrued expense calculation method	NULLABLE	INTEGER
name	This field stores a name for the subaccount	NULLABLE	STRING
lastfmdate	The system stores the date in this field of the last file maintenance of the GL Subaccount record	NULLABLE	DATE
commentone	This field stores an optional comment about the subaccount	NULLABLE	STRING
commenttwo	This field stores a second optional comment about the subaccount	NULLABLE	STRING
acquisitiondate	This field stores the date the item was acquired	NULLABLE	DATE
maturitydate	This field stores the date when the item is fully amortized or the last date on which income accrues	NULLABLE	DATE
termfrequency	This field stores a code that specifies how the term of the accrual is calculated for this GL subaccount	NULLABLE	INTEGER
termperiod	This field stores the number of days or months over which to accrue the income or expense for this GL subaccount	NULLABLE	INTEGER
rate	This field stores the percentage of the current value to expense monthly or the interest rate at which the system should accrue income for this GL subaccount	NULLABLE	INTEGER
originalvalue	This field stores the purchase price of the asset or investment	NULLABLE	INTEGER
limitvalue	This field stores the salvage value of the asset or the maximum value of the investment	NULLABLE	INTEGER
accrualamount	The system stores the calculated amount of expense or income to be accrued in this field	NULLABLE	INTEGER
currentvalue	The system stores the calculated current value of the asset or investment in this field	NULLABLE	INTEGER
accruedamount	The system stores the total amount in this field accrued for this subaccount since you created the GL Subaccount record	NULLABLE	INTEGER
accruedcount	The system stores the number of months or days over which the income or expense has accrued in this field	NULLABLE	INTEGER
ratebase	This field stores a code that specifies the base method for accrual for this GL subaccount	NULLABLE	INTEGER
disposition	This field stores an optional credit union-defined code to identify how the credit union disposed of an asset	NULLABLE	INTEGER
saledate	This field stores the date on which the credit union sold the asset	NULLABLE	DATE
saleamount	The system stores amount the credit union received when the asset was sold in this field	NULLABLE	INTEGER
recordchangedate	The system stores the system date when you create, change, or save the GL Subaccount record in this field. 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
accrualstartdate	This field stores the date income starts to accrue	NULLABLE	DATE
firstmonthmethod	This field stores a code that specifies whether the first month posts for the entire month or for a part of the month for this GL subaccount	NULLABLE	INTEGER
accrualpostdate	The system stores the date in this field of the most recent accrual posting date	NULLABLE	DATE
accrualeffectdate	The system stores the date in this field of the accrual effective date	NULLABLE	DATE
accrualpostthrudate	This field stores the date through which accruals are posted	NULLABLE	DATE
taxcategory	This field stores the tax category of the accrual item	NULLABLE	STRING
taxdate	This field stores the tax date of the accrual item	NULLABLE	DATE
taxdescription	This field stores the description of the tax category	NULLABLE	STRING
taxlocation	This field stores the location of the item	NULLABLE	STRING
taxamount	The system stores the tax amount of the item	NULLABLE	INTEGER
insurancetype	This field stores the credit union-defined insurance type	NULLABLE	STRING
instypedescription	This field stores the insurance type description	NULLABLE	STRING
insmaturitydate	This field stores the insurance maturity date	NULLABLE	DATE
gloffset	This field stores the offset GL number	NULLABLE	STRING

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