objid | site | objid | Site internal record number | 3 (UNIQUE) |
address_objid | address | objid | Address internal record number | |
country_objid | country | objid | Country internal record number | |
state_prov_objid | state_prov | objid | State internal record number | |
bus_org_objid | bus_org | objid | Bus Org internal record number | |
ext_ref_objid | bus_org_extern | objid | Bus Org extern internal record number | |
ext_ref | bus_org_extern | ext_ref | Bus Org extern reference id | |
status | site | status | Status of site; i.e., active, inactive, obsolete | |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_name | site | name | Name of the site | |
address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
address_2 | address | address_2 | Line 2 of address which typically includes office, building, or suite number, etc | |
city | address | city | The city for the specified address | |
statename | state_prov | name | State or province name | |
state_fullname | state_prov | full_name | State or province full name | |
zipcode | address | zipcode | The zip or other postal code for the specified address | |