Name: ReProp_Campus

Display Field: Main_Facility_Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• Main_Facility_Name (type: esriFieldTypeString, alias: Main Facility Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FCID (type: esriFieldTypeString, alias: FCID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Branch_FCID (type: esriFieldTypeString, alias: Branch FCID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Main_SCID (type: esriFieldTypeString, alias: Main SCID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Co_Locating_SCID (type: esriFieldTypeString, alias: Co Locating SCID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Main_Oracle_ID (type: esriFieldTypeString, alias: Main Oracle ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Co_Locating_Oracle_ID (type: esriFieldTypeString, alias: Co Locating Oracle ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Quality_Region (type: esriFieldTypeString, alias: Quality Region, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CPS_Maintenance_Program (type: esriFieldTypeString, alias: CPS Maintenance Program, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Co_Locating (type: esriFieldTypeString, alias: Co Locating, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Property_Use (type: esriFieldTypeString, alias: Property Use, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Main_Facility_Name_1 (type: esriFieldTypeString, alias: Main Facility Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Main_School_Short_Name (type: esriFieldTypeString, alias: Main School Short Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Co_locating_School_Short_Name (type: esriFieldTypeString, alias: Co Locating School Short Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• School_Long_Name (type: esriFieldTypeString, alias: School Long Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Main_Address (type: esriFieldTypeString, alias: Main Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Facility_Type (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Branch_Address (type: esriFieldTypeString, alias: Branch Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Number_of_Buildings (type: esriFieldTypeInteger, alias: Number of Buildings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_Branch_Size_SQFT (type: esriFieldTypeInteger, alias: NonBranch Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Branch_Size_SQFT (type: esriFieldTypeInteger, alias: Branch Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Campus_Size_SQFT (type: esriFieldTypeInteger, alias: Total Campus Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IFM_Zone (type: esriFieldTypeString, alias: IFM Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Principal_1_Name (type: esriFieldTypeString, alias: Principal 1 Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Principal_1_Email (type: esriFieldTypeString, alias: Principal 1 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Principal_2_Name (type: esriFieldTypeString, alias: Principal 2 Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Principal_2_Email (type: esriFieldTypeString, alias: Principal 2 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Assitant_Principal_1_Name (type: esriFieldTypeString, alias: Assitant Principal 1 Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Assistant_Principal_1_Email (type: esriFieldTypeString, alias: Assistant Principal 1 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Network (type: esriFieldTypeString, alias: Network, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Network_Chief (type: esriFieldTypeString, alias: Network Chief, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NC_Phone (type: esriFieldTypeString, alias: NC Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NC_Email (type: esriFieldTypeString, alias: NC Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Aldermanic_Ward (type: esriFieldTypeSmallInteger, alias: Aldermanic Ward, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Alderman (type: esriFieldTypeString, alias: Alderman, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALD_Phone (type: esriFieldTypeString, alias: ALD Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALD_Email (type: esriFieldTypeString, alias: ALD Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Building_Manager_Name (type: esriFieldTypeString, alias: Building Manager Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BM_Email (type: esriFieldTypeString, alias: BM_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BM_Phone (type: esriFieldTypeString, alias: BM_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Custodial_Manager (type: esriFieldTypeString, alias: Custodial Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CM_Email (type: esriFieldTypeString, alias: CM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CM_Phone (type: esriFieldTypeString, alias: CM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Senior_Custodial_Manager (type: esriFieldTypeString, alias: Senior Custodial Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SCM_Email (type: esriFieldTypeString, alias: SCM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SCM_Phone (type: esriFieldTypeString, alias: SCM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Custodial_District_Manager (type: esriFieldTypeString, alias: Custodial District Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CDM_Email (type: esriFieldTypeString, alias: CDM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CDM_Phone (type: esriFieldTypeString, alias: CDM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Building_Manager__BM_ (type: esriFieldTypeString, alias: Building Manager (BM), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BM_Email_1 (type: esriFieldTypeString, alias: BM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BM_Phone_1 (type: esriFieldTypeString, alias: BM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Facility_Manager (type: esriFieldTypeString, alias: Facility Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FM_Email (type: esriFieldTypeString, alias: FM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FM_Phone (type: esriFieldTypeString, alias: FM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Senior_Program_Manager_Name (type: esriFieldTypeString, alias: Senior Program Manager Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPM_Email (type: esriFieldTypeString, alias: SPM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPM_Phone (type: esriFieldTypeString, alias: SPM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Facility_Management_Lead_Name (type: esriFieldTypeString, alias: Facility Management Lead Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FML_Email (type: esriFieldTypeString, alias: FML Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FML_Phone (type: esriFieldTypeString, alias: FML Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Operations_Manager__JLL_ (type: esriFieldTypeString, alias: Operations Manager (JLL), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OM_Email (type: esriFieldTypeString, alias: OM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OM_Phone (type: esriFieldTypeString, alias: OM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Senior_Program_Manager (type: esriFieldTypeString, alias: Senior Program Manager, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPM_Email_1 (type: esriFieldTypeString, alias: SPM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPM_Phone_1 (type: esriFieldTypeString, alias: SPM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Regional_Manager_Name (type: esriFieldTypeString, alias: Regional Manager Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RM_Email (type: esriFieldTypeString, alias: RM Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RM_Phone (type: esriFieldTypeString, alias: RM Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zone_Chief_Engineer (type: esriFieldTypeString, alias: Zone Chief Engineer, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zone_Chief_Email (type: esriFieldTypeString, alias: Zone Chief Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zone_Chief_Phone (type: esriFieldTypeString, alias: Zone Chief Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Engineer_1__ENG1_ (type: esriFieldTypeString, alias: Engineer 1 (ENG1), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG1_Email (type: esriFieldTypeString, alias: ENG1 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG1_Phone (type: esriFieldTypeString, alias: ENG1 Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG1_Schedule (type: esriFieldTypeString, alias: ENG1 Schedule, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Engineer_2__ENG2_ (type: esriFieldTypeString, alias: Engineer 2 (ENG2), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG2_Email (type: esriFieldTypeString, alias: ENG2 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG2_Phone (type: esriFieldTypeString, alias: ENG2 Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG2_Schedule (type: esriFieldTypeString, alias: ENG2 Schedule, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Engineer_3__ENG3_ (type: esriFieldTypeString, alias: Engineer 3 (ENG3), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG3_Email (type: esriFieldTypeString, alias: ENG3 Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG3_Phone (type: esriFieldTypeString, alias: ENG3 Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENG3_Schedule (type: esriFieldTypeString, alias: ENG3 Schedule, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Number_of_Engineers (type: esriFieldTypeSmallInteger, alias: Number of Engineers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_Private_Custodians (type: esriFieldTypeSmallInteger, alias: Number of Private Custodians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_Board_Custodians (type: esriFieldTypeSmallInteger, alias: Number of Board Custodians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Number_of_Custodians (type: esriFieldTypeSmallInteger, alias: Total Number of Custodians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BM_School (type: esriFieldTypeString, alias: BM School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SBM_School (type: esriFieldTypeString, alias: SBM School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DM_ED_School (type: esriFieldTypeString, alias: DM ED School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MEC (type: esriFieldTypeString, alias: MEC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Pest_Control_Vendor (type: esriFieldTypeString, alias: Pest Control Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Landscaping_Vendor (type: esriFieldTypeString, alias: Landscaping Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Green_Infrastructure_Bioswales_ (type: esriFieldTypeString, alias: Green Infrastructure Bioswales Space to Grow Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Green_Infrastructure_Artifical_ (type: esriFieldTypeString, alias: Green Infrastructure Artifical Turfs Baseball Diamonds Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Snow_Removal_Parking_Lots_Vendo (type: esriFieldTypeString, alias: Snow Removal Parking Lots Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Salt_Supply_Vendor (type: esriFieldTypeString, alias: SaltSupply Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Sidewalk_Snow_Removal_Vendor (type: esriFieldTypeString, alias: Sidewalk Snow Removal Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Sidewalk_Salt_Only_No_Snow_Vend (type: esriFieldTypeString, alias: Sidewalk Salt Only No Snow Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Fire_Suppression_Ansel_Vendor (type: esriFieldTypeString, alias: Fire Suppression Ansel Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Fire_Supression_Vendor (type: esriFieldTypeString, alias: Fire Supression Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Fire_Alarm_Vendor (type: esriFieldTypeString, alias: Fire Alarm Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Fire_Extinguisher_Vendor (type: esriFieldTypeString, alias: Fire Extinguisher Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Pool_Chemicals_Vendor (type: esriFieldTypeString, alias: Pool Chemicals Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Emergency_Generator_Vendor (type: esriFieldTypeString, alias: Emergency Generator Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Conveyance_Maintenance_Vendor (type: esriFieldTypeString, alias: Conveyance Maintenance Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Conveyance_Inspector_Vendor (type: esriFieldTypeString, alias: Conveyance Inspector Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Boiler_Chemicals_Vendor (type: esriFieldTypeString, alias: Boiler Chemicals Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Backflow_Vendor (type: esriFieldTypeString, alias: Backflow Vendor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PK_for_Smartsheet_Reference_She (type: esriFieldTypeString, alias: PK for Smartsheet Reference Sheet, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PK_for_Capital_Asset (type: esriFieldTypeString, alias: PK for Capital Asset, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: ReProp_Campus
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• ReProp_Bldg (8) -- Related To: Real Property-Building (5)
• ReProp_Bldg (7) -- Related To: Real Property-Building (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/22/2023 5:31:11 PM

Schema Last Edit Date: 2/22/2023 5:31:11 PM

Data Last Edit Date: 2/22/2023 5:31:11 PM

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