View – WQX.ORGANIZATION

View Name: WQX.ORGANIZATION

View Type: WQX

Description: WQX.ORGANIZATION returns details about the WQX organization.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

ORGFORMALNAME = DT_FACILITY.FACILITY_NAME

ORGDESC = DT_FACILITY.REMARK

TRIBALCODE = DT_FACILITY.TRIBE_CODE

ELECTRONICADDRESS = DT_FACILITY.EMAIL_ADDRESS

ELECTRONICADDRESSTYPE = 'INTERNET' if DT_FACILITY.EMAIL_ADDRESS is not NULL

TELEPHONENUMBER = DT_FACILITY.PHONE_NUMBER

TELEPHONENUMBERTYPE = 'OFFICE' if DT_FACILITY.PHONE_NUMBER is not NULL

ADDRESSTYPE = 'LOCATION' if DT_FACILITY.ADDRESS_1 is not NULL

ADDRESS = DT_FACILITY.ADDRESS_1

SUPPLEMENTALADDRESS = DT_FACILITY.ADDRESS_2

LOCALITY = DT_FACILITY.CITY

STATECODE = DT_FACILITY.STATE

POSTALCODE = DT_FACILITY.POSTAL_CODE

COUNTRYCODE = DT_FACILITY.COUNTRY

COUNTYCODE = DT_FACILITY.COUNTY

Tables: DT_FACILITY

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the DT_FACILITY table to be generated in WQX.ORGANIZATION.

Output Type: Grid