ssdb_user_cdc

Pipelined Data Sets > Symitar > ssdb_user_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
userkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
lastconsole		NULLABLE	INTEGER
number		NULLABLE	INTEGER
name		NULLABLE	STRING
directory		NULLABLE	STRING
passwordchgdate		NULLABLE	DATE
accountverification		NULLABLE	INTEGER
restrictedaccounts_1		NULLABLE	STRING
restrictedaccounts_2		NULLABLE	STRING
restrictedaccounts_3		NULLABLE	STRING
restrictedaccounts_4		NULLABLE	STRING
restrictedaccounts_5		NULLABLE	STRING
restrictedaccounts_6		NULLABLE	STRING
restrictedaccounts_7		NULLABLE	STRING
restrictedaccounts_8		NULLABLE	STRING
restrictedaccounts_9		NULLABLE	STRING
restrictedaccounts_10		NULLABLE	STRING
restrictedaccounts_11		NULLABLE	STRING
restrictedaccounts_12		NULLABLE	STRING
restrictedaccounts_13		NULLABLE	STRING
restrictedaccounts_14		NULLABLE	STRING
restrictedaccounts_15		NULLABLE	STRING
restrictedaccounts_16		NULLABLE	STRING
restrictedaccounts_17		NULLABLE	STRING
restrictedaccounts_18		NULLABLE	STRING
restrictedaccounts_19		NULLABLE	STRING
restrictedaccounts_20		NULLABLE	STRING
tapetotal_1		NULLABLE	INTEGER
tapetotal_2		NULLABLE	INTEGER
tapetotal_3		NULLABLE	INTEGER
tapetotal_4		NULLABLE	INTEGER
tapetotal_5		NULLABLE	INTEGER
tapetotal_6		NULLABLE	INTEGER
tapetotal_7		NULLABLE	INTEGER
tapetotal_8		NULLABLE	INTEGER
tapetotal_9		NULLABLE	INTEGER
tapetotal_10		NULLABLE	INTEGER
tapetotal_11		NULLABLE	INTEGER
tapetotal_12		NULLABLE	INTEGER
tapetotal_13		NULLABLE	INTEGER
tapetotal_14		NULLABLE	INTEGER
tapetotal_15		NULLABLE	INTEGER
tapetotal_16		NULLABLE	INTEGER
tapetotal_17		NULLABLE	INTEGER
tapetotal_18		NULLABLE	INTEGER
tapetotal_19		NULLABLE	INTEGER
tapetotal_20		NULLABLE	INTEGER
tapetotal_21		NULLABLE	INTEGER
tapetotal_22		NULLABLE	INTEGER
tapetotal_23		NULLABLE	INTEGER
tapetotal_24		NULLABLE	INTEGER
tapetotal_25		NULLABLE	INTEGER
tapetotal_26		NULLABLE	INTEGER
tapetotal_27		NULLABLE	INTEGER
tapetotal_28		NULLABLE	INTEGER
tapetotal_29		NULLABLE	INTEGER
tapetotal_30		NULLABLE	INTEGER
tapetotal_31		NULLABLE	INTEGER
tapetotal_32		NULLABLE	INTEGER
tapetotal_33		NULLABLE	INTEGER
tapetotal_34		NULLABLE	INTEGER
tapetotal_35		NULLABLE	INTEGER
tapetotal_36		NULLABLE	INTEGER
tapetotal_37		NULLABLE	INTEGER
tapetotal_38		NULLABLE	INTEGER
tapetotal_39		NULLABLE	INTEGER
securitycode		NULLABLE	BYTES
securityamount_1		NULLABLE	INTEGER
securityamount_2		NULLABLE	INTEGER
securityamount_3		NULLABLE	INTEGER
securityamount_4		NULLABLE	INTEGER
securityamount_5		NULLABLE	INTEGER
securityamount_6		NULLABLE	INTEGER
securityamount_7		NULLABLE	INTEGER
securityamount_8		NULLABLE	INTEGER
securityamount_9		NULLABLE	INTEGER
securityamount_10		NULLABLE	INTEGER
securityamount_11		NULLABLE	INTEGER
securityamount_12		NULLABLE	INTEGER
securityamount_13		NULLABLE	INTEGER
securityamount_14		NULLABLE	INTEGER
securityamount_15		NULLABLE	INTEGER
securityamount_16		NULLABLE	INTEGER
securityamount_17		NULLABLE	INTEGER
securityamount_18		NULLABLE	INTEGER
securityamount_19		NULLABLE	INTEGER
securityamount_20		NULLABLE	INTEGER
checktapecols		NULLABLE	INTEGER
prtcheckindex		NULLABLE	INTEGER
activpurgedate		NULLABLE	DATE
jobtitle		NULLABLE	STRING
phone		NULLABLE	STRING
type		NULLABLE	INTEGER
onlineaccess		NULLABLE	INTEGER
pin		NULLABLE	STRING
temporarypassword		NULLABLE	INTEGER
temporarypin		NULLABLE	INTEGER
email		NULLABLE	STRING
note2_1		NULLABLE	STRING
note2_2		NULLABLE	STRING
secondaryid		NULLABLE	STRING
lastlogondate		NULLABLE	DATE
lastlogontime		NULLABLE	INTEGER
lastinvalidpassworddate		NULLABLE	DATE
lastinvalidpasswordtime		NULLABLE	INTEGER
invalidpasswordattemptcount		NULLABLE	INTEGER
lastinvalidpindate		NULLABLE	DATE
lastinvalidpintime		NULLABLE	INTEGER
invalidpinattemptcount		NULLABLE	INTEGER
activemode		NULLABLE	INTEGER
pinactivemode		NULLABLE	INTEGER
pinchangedate		NULLABLE	DATE
privilegegroup		NULLABLE	BYTES
displayitem		NULLABLE	BYTES
worklist		NULLABLE	BYTES
functions		NULLABLE	BYTES
archivedate		NULLABLE	DATE
lastcheckseq		NULLABLE	INTEGER
jobfunction		NULLABLE	STRING
assignedbranch		NULLABLE	INTEGER
location		NULLABLE	STRING
extension		NULLABLE	STRING
managersname		NULLABLE	STRING
deptname		NULLABLE	STRING
castrackingcode		NULLABLE	INTEGER
priordaytapetotal_1		NULLABLE	INTEGER
priordaytapetotal_2		NULLABLE	INTEGER
priordaytapetotal_3		NULLABLE	INTEGER
priordaytapetotal_4		NULLABLE	INTEGER
priordaytapetotal_5		NULLABLE	INTEGER
priordaytapetotal_6		NULLABLE	INTEGER
priordaytapetotal_7		NULLABLE	INTEGER
priordaytapetotal_8		NULLABLE	INTEGER
priordaytapetotal_9		NULLABLE	INTEGER
priordaytapetotal_10		NULLABLE	INTEGER
priordaytapetotal_11		NULLABLE	INTEGER
priordaytapetotal_12		NULLABLE	INTEGER
priordaytapetotal_13		NULLABLE	INTEGER
priordaytapetotal_14		NULLABLE	INTEGER
priordaytapetotal_15		NULLABLE	INTEGER
priordaytapetotal_16		NULLABLE	INTEGER
priordaytapetotal_17		NULLABLE	INTEGER
priordaytapetotal_18		NULLABLE	INTEGER
priordaytapetotal_19		NULLABLE	INTEGER
priordaytapetotal_20		NULLABLE	INTEGER
priordaytapetotal_21		NULLABLE	INTEGER
priordaytapetotal_22		NULLABLE	INTEGER
priordaytapetotal_23		NULLABLE	INTEGER
priordaytapetotal_24		NULLABLE	INTEGER
priordaytapetotal_25		NULLABLE	INTEGER
priordaytapetotal_26		NULLABLE	INTEGER
priordaytapetotal_27		NULLABLE	INTEGER
priordaytapetotal_28		NULLABLE	INTEGER
priordaytapetotal_29		NULLABLE	INTEGER
priordaytapetotal_30		NULLABLE	INTEGER
priordaytapetotal_31		NULLABLE	INTEGER
priordaytapetotal_32		NULLABLE	INTEGER
priordaytapetotal_33		NULLABLE	INTEGER
priordaytapetotal_34		NULLABLE	INTEGER
priordaytapetotal_35		NULLABLE	INTEGER
priordaytapetotal_36		NULLABLE	INTEGER
priordaytapetotal_37		NULLABLE	INTEGER
priordaytapetotal_38		NULLABLE	INTEGER
priordaytapetotal_39		NULLABLE	INTEGER
recordchangedate		NULLABLE	DATE
passwordmode		NULLABLE	INTEGER
passwordhash1		NULLABLE	STRING
passwordhash2		NULLABLE	STRING
passwordhash3		NULLABLE	STRING
passwordhash4		NULLABLE	STRING
previouspasswordmode_1		NULLABLE	INTEGER
previouspasswordmode_2		NULLABLE	INTEGER
previouspasswordmode_3		NULLABLE	INTEGER
previouspasswordmode_4		NULLABLE	INTEGER
previouspasswordmode_5		NULLABLE	INTEGER
previouspasswordmode_6		NULLABLE	INTEGER
previouspasswordmode_7		NULLABLE	INTEGER
previouspasswordmode_8		NULLABLE	INTEGER
previouspasswordmode_9		NULLABLE	INTEGER
previouspasswordmode_10		NULLABLE	INTEGER
previouspasswordmode_11		NULLABLE	INTEGER
previouspasswordmode_12		NULLABLE	INTEGER
previouspasswordhash1_1		NULLABLE	STRING
previouspasswordhash1_2		NULLABLE	STRING
previouspasswordhash1_3		NULLABLE	STRING
previouspasswordhash1_4		NULLABLE	STRING
previouspasswordhash1_5		NULLABLE	STRING
previouspasswordhash1_6		NULLABLE	STRING
previouspasswordhash1_7		NULLABLE	STRING
previouspasswordhash1_8		NULLABLE	STRING
previouspasswordhash1_9		NULLABLE	STRING
previouspasswordhash1_10		NULLABLE	STRING
previouspasswordhash1_11		NULLABLE	STRING
previouspasswordhash1_12		NULLABLE	STRING
previouspasswordhash2_1		NULLABLE	STRING
previouspasswordhash2_2		NULLABLE	STRING
previouspasswordhash2_3		NULLABLE	STRING
previouspasswordhash2_4		NULLABLE	STRING
previouspasswordhash2_5		NULLABLE	STRING
previouspasswordhash2_6		NULLABLE	STRING
previouspasswordhash2_7		NULLABLE	STRING
previouspasswordhash2_8		NULLABLE	STRING
previouspasswordhash2_9		NULLABLE	STRING
previouspasswordhash2_10		NULLABLE	STRING
previouspasswordhash2_11		NULLABLE	STRING
previouspasswordhash2_12		NULLABLE	STRING
previouspasswordhash3_1		NULLABLE	STRING
previouspasswordhash3_2		NULLABLE	STRING
previouspasswordhash3_3		NULLABLE	STRING
previouspasswordhash3_4		NULLABLE	STRING
previouspasswordhash3_5		NULLABLE	STRING
previouspasswordhash3_6		NULLABLE	STRING
previouspasswordhash3_7		NULLABLE	STRING
previouspasswordhash3_8		NULLABLE	STRING
previouspasswordhash3_9		NULLABLE	STRING
previouspasswordhash3_10		NULLABLE	STRING
previouspasswordhash3_11		NULLABLE	STRING
previouspasswordhash3_12		NULLABLE	STRING
previouspasswordhash4_1		NULLABLE	STRING
previouspasswordhash4_2		NULLABLE	STRING
previouspasswordhash4_3		NULLABLE	STRING
previouspasswordhash4_4		NULLABLE	STRING
previouspasswordhash4_5		NULLABLE	STRING
previouspasswordhash4_6		NULLABLE	STRING
previouspasswordhash4_7		NULLABLE	STRING
previouspasswordhash4_8		NULLABLE	STRING
previouspasswordhash4_9		NULLABLE	STRING
previouspasswordhash4_10		NULLABLE	STRING
previouspasswordhash4_11		NULLABLE	STRING
previouspasswordhash4_12		NULLABLE	STRING
previouslogondate		NULLABLE	DATE
previouslogontime		NULLABLE	INTEGER
ssodomainusersub1		NULLABLE	STRING
ssodomainusersub2		NULLABLE	STRING
ssodomainusersub3		NULLABLE	STRING
ssodomainusersub4		NULLABLE	STRING
configurationgroup		NULLABLE	INTEGER
temppasswordexpirationdate		NULLABLE	DATE
temppasswordexpirationtime		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