Name: ClosureM

Display Field: Pharmacy_Legal_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12863342.7268533
YMin: 3542210.61422412
XMax: -7489525.18078812
YMax: 6249118.38046568
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: Close_Date
End Time Field: null
Track ID Field: null
Time Extent
[1/1/2014 12:00:00 AM UTC, 3/1/2024 12:00:00 AM UTC]

Time Reference: UTC
Time Interval: 10
Time Interval Units: esriTimeUnitsUnknown
Has Live Data: false
Export Options:

Use Time: true
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• Close_Date (type: esriFieldTypeDate, alias: Close_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: ClosureM
Description:
Drawing Tool: esriFeatureEditToolPoint
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:45:56 PM

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