ssdb_work_list_edit_cdc

Pipelined Data Sets > Symitar > ssdb_work_list_edit_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
worklisteditkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
targetrectype		NULLABLE	INTEGER
globalsequence	This field contains a unique number that the system assigns when you enter a work list edit	NULLABLE	INTEGER
globalsequencedate	This field contains the date when you enter this work list edit	NULLABLE	DATE
edittype	This field indicates the type of edit this record represents	NULLABLE	INTEGER
recordfmtype	This field indicates the type of file maintenance this record represents	NULLABLE	INTEGER
status	This field contains the status of the edit request	NULLABLE	INTEGER
fmfilenumber	This field stores an integer constant specifying which database the edit request change affects	NULLABLE	INTEGER
lvlcount	This field indicates how many levels deep into the Symitar record structure the record is that this edit request change affects	NULLABLE	INTEGER
rectype_0		NULLABLE	INTEGER
rectype_1	This field stores the record type of the first level of the system records (below Account records) to which the record affected by edit request change belongs	NULLABLE	INTEGER
rectype_2	This field stores the record type of the second level of the system records (below Account records) to which the record affected by edit request change belongs	NULLABLE	INTEGER
rectype_3	This field stores the record type of the first level of the system records (below Account records) to which the record affected by edit request change belongs	NULLABLE	INTEGER
id_0		NULLABLE	STRING
id_1	This field stores the ID of the Share or Loan record affected by this edit request	NULLABLE	STRING
id_2	This field stores the ID of a child record of the Share or Loan record affected by this edit request	NULLABLE	STRING
id_3	This field stores the ID of the grandchild record of the Share or Loan record affected by this edit request	NULLABLE	STRING
ordinal_0		NULLABLE	INTEGER
ordinal_1	This field stores an ordinal for level 1 of this record; some specfiles use an ordinal record number as the record designator	NULLABLE	INTEGER
ordinal_2	This field stores an ordinal for level 2 of this record; some specfiles use an ordinal record number as the record designator	NULLABLE	INTEGER
ordinal_3	This field stores an ordinal for level 3 of this record; some specfiles use an ordinal record number as the record designator	NULLABLE	INTEGER
locator_0		NULLABLE	INTEGER
locator_1	When creating a new Share Hold record, this field stores a locator field value that can be use as a unique identification for level 1 of this specific record	NULLABLE	INTEGER
locator_2	When creating a new Share Hold record, this field stores a locator field value that can be use as a unique identification for level 2 of this specific record	NULLABLE	INTEGER
locator_3	When creating a new Share Hold record, this field stores a locator field value that can be use as a unique identification for level 3 of this specific record	NULLABLE	INTEGER
requesteddate	This field stores the date of the edit request	NULLABLE	DATE
requestedtime	This field stores the time of the edit request	NULLABLE	INTEGER
requestedmemberuser	This field stores the user number of the member user who made the edit request	NULLABLE	INTEGER
requestedcorporateuser	This field stores the user number of the corporate user who made the edit request	NULLABLE	INTEGER
decisiondate	This field stores the date of approval or denial for this edit request	NULLABLE	DATE
decisiontime	This field stores the time of approval or denial for this edit request	NULLABLE	INTEGER
decisionuser	This field stores the user number of the user who approved or denied this edit request	NULLABLE	INTEGER
decisionreason	If the Status field for this edit request is set to (2) Denied, this field stores the reason the work list edit file was rejected	NULLABLE	STRING
accountnumber	This field stores the account number of the account affected by the edit request	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