Name: Closure_M

Display Field: Pharmacy_Legal_Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OID (type: esriFieldTypeDouble, alias: OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SN (type: esriFieldTypeDouble, alias: SN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pharmacy_NCPDP_No (type: esriFieldTypeString, alias: Pharmacy NCPDP No, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Number (type: esriFieldTypeString, alias: Store Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pharmacy_Legal_Name (type: esriFieldTypeString, alias: Pharmacy Legal Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pharmacy_DBA_Name (type: esriFieldTypeString, alias: Pharmacy DBA Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Doctor_Name (type: esriFieldTypeString, alias: Doctor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NPI_Number (type: esriFieldTypeString, alias: NPI Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DEA_Number (type: esriFieldTypeString, alias: DEA Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Federal_License_Exp__Date (type: esriFieldTypeString, alias: Federal License Exp# Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State_License_No (type: esriFieldTypeString, alias: State License No, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State_License__Exp__Date (type: esriFieldTypeString, alias: State License Exp# Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• License_State (type: esriFieldTypeString, alias: License State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Dispenser_Class_Code (type: esriFieldTypeString, alias: Dispenser Class_Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Dispenser_Type_Code (type: esriFieldTypeString, alias: Dispenser Type Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address1___Physical (type: esriFieldTypeString, alias: Address1 - Physical, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address2___Physical_ (type: esriFieldTypeString, alias: Address2 - Physical_, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City_Physical (type: esriFieldTypeString, alias: City Physical, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State_Physical (type: esriFieldTypeString, alias: State Physical, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zip_Code__as_reported (type: esriFieldTypeString, alias: Zip Code _as reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Main_Phone (type: esriFieldTypeString, alias: Main Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Phone_Ext (type: esriFieldTypeString, alias: Phone Ext, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County_Code (type: esriFieldTypeString, alias: County Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MSA_Code (type: esriFieldTypeString, alias: MSA Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PMSA_Code (type: esriFieldTypeString, alias: PMSA Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Congressional_District (type: esriFieldTypeString, alias: Congressional District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pharmacy_Relationship_Id__name_ (type: esriFieldTypeString, alias: Pharmacy Relationship Id (name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Group_Key (type: esriFieldTypeString, alias: Group Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Group__Start_Date (type: esriFieldTypeString, alias: Group Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Group_Deleted_Date (type: esriFieldTypeString, alias: Group Deleted Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Type (type: esriFieldTypeString, alias: Relation Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Type_Code (type: esriFieldTypeString, alias: Relation Type Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Address1 (type: esriFieldTypeString, alias: Relation Address1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Address2 (type: esriFieldTypeString, alias: Relation Address2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_City_ (type: esriFieldTypeString, alias: Relation City_, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_State (type: esriFieldTypeString, alias: Relation State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Zip (type: esriFieldTypeString, alias: Relation Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Phone (type: esriFieldTypeString, alias: Relation Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Phone_Ext (type: esriFieldTypeString, alias: Relation Phone Ext, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relation_Fax (type: esriFieldTypeString, alias: Relation Fax, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relationship_Start_Date (type: esriFieldTypeString, alias: Relationship Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Relationship_End_Date (type: esriFieldTypeString, alias: Relationship End Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Is_Primary__Y_N (type: esriFieldTypeString, alias: Is Primary?=Y/N, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_First_Name (type: esriFieldTypeString, alias: AO First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Middle_Name (type: esriFieldTypeString, alias: AO Middle Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Last_Name (type: esriFieldTypeString, alias: AO Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Contact_Title (type: esriFieldTypeString, alias: AO Contact Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Contact_Email (type: esriFieldTypeString, alias: AO Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Contact_Phone (type: esriFieldTypeString, alias: AO Contact Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Contact_Phone_Ext (type: esriFieldTypeString, alias: AO Contact Phone Ext, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AO_Contact_Fax (type: esriFieldTypeString, alias: AO Contact Fax, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Open_Date (type: esriFieldTypeString, alias: Store Open Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Close_Date (type: esriFieldTypeString, alias: Store Close Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sunday_24_Hours (type: esriFieldTypeString, alias: Sunday 24 Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Monday_24__Hours (type: esriFieldTypeString, alias: Monday 24 _Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tuesday_24__Hours (type: esriFieldTypeString, alias: Tuesday 24 _Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wednesday_24__Hours (type: esriFieldTypeString, alias: Wednesday 24 _Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Thursday_24__Hours (type: esriFieldTypeString, alias: Thursday 24 _Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Friday_24_Hours (type: esriFieldTypeString, alias: Friday 24 Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Saturday_24__Hours (type: esriFieldTypeString, alias: Saturday 24 _Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lon (type: esriFieldTypeDouble, alias: Lon, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Closure_M
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2024 9:35:27 PM

Schema Last Edit Date: 4/30/2024 9:35:27 PM

Data Last Edit Date: 4/16/2024 6:46:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat