site_raw

Pipelined Data Sets > Symitar > site_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
siteuuid	This field stores a JH Platform unique identifier for a site	NULLABLE	STRING
accountuuid	This field stores a JH Platform unique identifier for an account	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
sitekey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	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
sitenumber	This field stores a credit union-defined code identifying a site to which a vendor delivers cash orders	NULLABLE	INTEGER
sitename	This field stores a descriptive name for the site	NULLABLE	STRING
extraaddress	This field stores an extra address line for the site's deliveries	NULLABLE	STRING
street	This field stores the street address for the site's deliveries	NULLABLE	STRING
city	This field stores the city for the site's delivery address	NULLABLE	STRING
state	This field stores the state for the site's delivery address	NULLABLE	STRING
zipcode	This field stores the ZIP Code for the site's delivery address	NULLABLE	STRING
closedate	This field stores the date the site was closed	NULLABLE	DATE
faxphone	This field stores the phone number for the site's fax machine	NULLABLE	STRING
sitecontactname	This field stores the name of the contact person for this site	NULLABLE	STRING
contactphone	This field stores the phone number of the site's contact person	NULLABLE	STRING
siteid	This field stores the identifier the BillMe system uses to uniquely identify a site	NULLABLE	STRING
sitesettleshareid	This field stores the ID of the share that the corporate interface debits for the total amount of the cash order	NULLABLE	STRING
locator	This field stores a unique number within each Preference record set that can be used as a unique identification of this record	NULLABLE	INTEGER
recordchangedate	This field stores the system date in this field when you create, change, or save the Site 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