ssdb_loan_app_tracking_cdc

Pipelined Data Sets > Symitar > ssdb_loan_app_tracking_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
loanapptrackingkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
loanappkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
type	This field stores a code that indicates how you use the Application Tracking record	NULLABLE	INTEGER
id	This field stores the ID of this record's parent Application record	NULLABLE	STRING
idtype	This field stores a number that identifies the type of parent record for this Tracking record	NULLABLE	INTEGER
userid	This field stores the user number of the user who created the Application Tracking record	NULLABLE	INTEGER
fmlastdate	This field stores the date file maintenance was last performed on the Tracking record	NULLABLE	DATE
creationdate	This field stores the current system date when the Tracking record was created	NULLABLE	DATE
creationtime	This field stores the current system time (HHMM) when the Tracking record was created	NULLABLE	INTEGER
expiredate	This field stores an expiration date for the Tracking record	NULLABLE	DATE
trackingcode	This field stores a credit union-defined code to further identify the purpose of the Tracking record	NULLABLE	INTEGER
usernumber1	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber2	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber3	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber4	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber5	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber6	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber7	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber8	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber9	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber10	These fields stores any credit union-defined number	NULLABLE	INTEGER
userchar1	These fields store any credit union-defined character data	NULLABLE	STRING
userchar2	These fields store any credit union-defined character data	NULLABLE	STRING
userchar3	These fields store any credit union-defined character data	NULLABLE	STRING
userchar4	These fields store any credit union-defined character data	NULLABLE	STRING
userchar5	These fields store any credit union-defined character data	NULLABLE	STRING
userchar6	These fields store any credit union-defined character data	NULLABLE	STRING
userchar7	These fields store any credit union-defined character data	NULLABLE	STRING
userchar8	These fields store any credit union-defined character data	NULLABLE	STRING
userchar9	These fields store any credit union-defined character data	NULLABLE	STRING
userchar10	These fields store any credit union-defined character data	NULLABLE	STRING
useramount1	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount2	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount3	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount4	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount5	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount6	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount7	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount8	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount9	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount10	These fields store any credit union-defined amount	NULLABLE	INTEGER
usercode1	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode2	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode3	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode4	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode5	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode6	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode7	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode8	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode9	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode10	These fields store any credit union-defined code	NULLABLE	INTEGER
userdate1	These fields store any credit union-defined date	NULLABLE	DATE
userdate2	These fields store any credit union-defined date	NULLABLE	DATE
userdate3	These fields store any credit union-defined date	NULLABLE	DATE
userdate4	These fields store any credit union-defined date	NULLABLE	DATE
userdate5	These fields store any credit union-defined date	NULLABLE	DATE
userdate6	These fields store any credit union-defined date	NULLABLE	DATE
userdate7	These fields store any credit union-defined date	NULLABLE	DATE
userdate8	These fields store any credit union-defined date	NULLABLE	DATE
userdate9	These fields store any credit union-defined date	NULLABLE	DATE
userdate10	These fields store any credit union-defined date	NULLABLE	DATE
userrate1	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate2	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate3	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate4	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate5	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate6	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate7	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate8	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate9	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate10	These fields store any credit union-defined rate	NULLABLE	INTEGER
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
usernumber11	For tracking types 30-99, this field stores any credit union-defined number	NULLABLE	INTEGER
usernumber12	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber13	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber14	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber15	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber16	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber17	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber18	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber19	These fields stores any credit union-defined number	NULLABLE	INTEGER
usernumber20	For tracking types 30-99, this field stores any credit union-defined number	NULLABLE	INTEGER
userchar11	For tracking types 30-99, these fields store any credit union-defined character data	NULLABLE	STRING
userchar12	These fields store any credit union-defined character data	NULLABLE	STRING
userchar13	These fields store any credit union-defined character data	NULLABLE	STRING
userchar14	These fields store any credit union-defined character data	NULLABLE	STRING
userchar15	These fields store any credit union-defined character data	NULLABLE	STRING
userchar16	These fields store any credit union-defined character data	NULLABLE	STRING
userchar17	These fields store any credit union-defined character data	NULLABLE	STRING
userchar18	These fields store any credit union-defined character data	NULLABLE	STRING
userchar19	These fields store any credit union-defined character data	NULLABLE	STRING
userchar20	For tracking types 30-99, these fields store any credit union-defined character data	NULLABLE	STRING
useramount11	For tracking types 30-99, these fields store any credit union-defined amount	NULLABLE	INTEGER
useramount12	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount13	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount14	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount15	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount16	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount17	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount18	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount19	These fields store any credit union-defined amount	NULLABLE	INTEGER
useramount20	For tracking types 30-99, these fields store any credit union-defined amount	NULLABLE	INTEGER
usercode11	For tracking types 30-99, you can use this field to store any credit union-defined code	NULLABLE	INTEGER
usercode12	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode13	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode14	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode15	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode16	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode17	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode18	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode19	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode20	For tracking types 30-99, you can use this field to store any credit union-defined code	NULLABLE	INTEGER
userdate11	For tracking types 30-99, you can use this field to store any credit union-defined date	NULLABLE	DATE
userdate12	These fields store any credit union-defined date	NULLABLE	DATE
userdate13	These fields store any credit union-defined date	NULLABLE	DATE
userdate14	These fields store any credit union-defined date	NULLABLE	DATE
userdate15	These fields store any credit union-defined date	NULLABLE	DATE
userdate16	These fields store any credit union-defined date	NULLABLE	DATE
userdate17	These fields store any credit union-defined date	NULLABLE	DATE
userdate18	These fields store any credit union-defined date	NULLABLE	DATE
userdate19	These fields store any credit union-defined date	NULLABLE	DATE
userdate20	For tracking types 30-99, you can use this field to store any credit union-defined date	NULLABLE	DATE
userrate11	For tracking types 30-99, these fields store any credit union-defined rate	NULLABLE	INTEGER
userrate12	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate13	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate14	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate15	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate16	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate17	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate18	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate19	These fields store any credit union-defined rate	NULLABLE	INTEGER
userrate20	For tracking types 30-99, these fields store any credit union-defined rate	NULLABLE	INTEGER
recordchangedate	This field stores the system date in the Record Change Date field when you create, change, or save the Application Tracking 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