payee_raw

Pipelined Data Sets > Symitar > payee_raw

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
eventtime	Internal use only	NULLABLE	INTEGER
sourcetype	Internal use only; SSDB field	NULLABLE	STRING
operation	Internal use only; SSDB field	NULLABLE	STRING
extractdate	Internal use only	NULLABLE	DATE
processdatetime	Internal use only; SSDB field	NULLABLE	TIMESTAMP
payeeuuid	This field stores a JH Platform unique identifier for a payee	NULLABLE	STRING
payeekey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	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	NUMERIC
paymentslastyear	The system stores the total amount in this field of payments to this payee for the previous year	NULLABLE	NUMERIC
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