ssdb_payee_cdc

Pipelined Data Sets > Symitar > ssdb_payee_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
payeekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
number	This field stores this number that uniquely identifies the Payee record when the record is created	NULLABLE	STRING
name	This field stores the name of the payee	NULLABLE	STRING
extraaddress	This field stores any extra address information for the payee	NULLABLE	STRING
street	This field stores the payee's street address	NULLABLE	STRING
city	This field stores the payee's city	NULLABLE	STRING
state	This field stores the payee's state	NULLABLE	STRING
zipcode	This field stores the payee's ZIP Code	NULLABLE	STRING
paymentsytd	The system stores the total amount in this field of payments to this payee for the year to date	NULLABLE	INTEGER
paymentslastyear	The system stores the total amount in this field of payments to this payee for the previous year	NULLABLE	INTEGER
lastpaymentdate	The system stores the date of the last payment to this payee	NULLABLE	DATE
checkcode	This field stores a code that specifies whether to create checks for this payee or not	NULLABLE	INTEGER
billpaymenttypecode	This field stores a code that determines the source code used for posting bill payment corporate drafts	NULLABLE	INTEGER
lastfmdate	The system stores the date in this field of the last file maintenance to the Payee record	NULLABLE	DATE
creationdate	The system stores the system date in this field when you create the Payee record	NULLABLE	DATE
contactphone	This field stores the phone number of the payee contact	NULLABLE	STRING
contactname	This field stores the name of the payee contact	NULLABLE	STRING
contactemail	This field stores the email address of the payee contact	NULLABLE	STRING
rdfiname	This optional field stores the name of the Receiving Depository Financial Institution (RDFI)	NULLABLE	STRING
rdfirt	This field stores the unique routing and transit (R&T) number (nine characters, including a check digit) of the Receiving Depository Financial Institution (RDFI)	NULLABLE	STRING
companyname	This field stores any company information your credit union wants to appear in the ACH warehouse entry and on the member's statements	NULLABLE	STRING
companydisc	This field stores optional discretionary data	NULLABLE	STRING
companyentrydesc	This field stores required description of the purpose of the entry	NULLABLE	STRING
receivingcomp	This field stores the receiving company name or ID number for an ENR (Automated Enrollment Entry) entry class code	NULLABLE	STRING
dfiaccount	This field stores the member's account number at the receiving institution, not their credit union account number for ACH origination	NULLABLE	STRING
recordchangedate	This field stores the system date when you create, change, or save the Payee record. 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

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