Name: Salesforce_Table

Display Field: SLA_Estate_Name_Detailed

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Salesforce_Unique_ID (type: esriFieldTypeDouble, alias: Salesforce Unique ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_BlockKey (type: esriFieldTypeDouble, alias: BlockKey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Land_Status (type: esriFieldTypeString, alias: Land Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Release_Status (type: esriFieldTypeString, alias: Release Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Land_Sales_Status (type: esriFieldTypeString, alias: Land Sales Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Land_District (type: esriFieldTypeString, alias: Land District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Land_Division (type: esriFieldTypeString, alias: Land Division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Land_Estate (type: esriFieldTypeString, alias: Land Estate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Estate_Name_Detailed (type: esriFieldTypeString, alias: Estate Name Detailed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Stage (type: esriFieldTypeString, alias: Stage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Alpha_Section (type: esriFieldTypeString, alias: Section Alpha, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Alpha_Block (type: esriFieldTypeString, alias: Block Alpha, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Substage (type: esriFieldTypeString, alias: Substage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Land_Size (type: esriFieldTypeDouble, alias: Land Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Block_Size_Type (type: esriFieldTypeString, alias: Block Size Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Zoning (type: esriFieldTypeString, alias: Zoning, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Price_Per_SqM (type: esriFieldTypeDouble, alias: Price Per SqM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Corner_Block (type: esriFieldTypeString, alias: Corner Block, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Easement (type: esriFieldTypeString, alias: Easement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Orientation (type: esriFieldTypeString, alias: Orientation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Current_Price_GST_Inc (type: esriFieldTypeDouble, alias: Current Price GST Inc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Land_Release_Product_Type (type: esriFieldTypeString, alias: Land Release Product Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Land_Release_Sub_Product_Type (type: esriFieldTypeString, alias: Land Release Sub Product Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Release_Type (type: esriFieldTypeString, alias: Release Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Sales_Release (type: esriFieldTypeString, alias: Sales Release, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Number_of_Dwellings (type: esriFieldTypeInteger, alias: Number of Dwellings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Affordable_Housing_Dwelling (type: esriFieldTypeInteger, alias: Affordable Housing Dwellings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Public_Housing_Dwellings (type: esriFieldTypeInteger, alias: Public Housing Dwellings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Community_Housing_Dwellings (type: esriFieldTypeInteger, alias: Community Housing Dwellings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Sales_Status (type: esriFieldTypeString, alias: Sales Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Sale_Method (type: esriFieldTypeString, alias: Sale Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Expected_Release_Date (type: esriFieldTypeDate, alias: Expected Release Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_ILRP_Forecast_Release_Date (type: esriFieldTypeDate, alias: ILRP Forecast Release Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Expected_Exchange_Date (type: esriFieldTypeDate, alias: Expected Exchange Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Expected_Settlement_Date (type: esriFieldTypeDate, alias: Expected Settlement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Actual_Release_Date (type: esriFieldTypeDate, alias: Actual Release Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Actual_Exchange_Date (type: esriFieldTypeDate, alias: Actual Exchange Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Actual_Settlement_Date (type: esriFieldTypeDate, alias: Actual Settlement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Lot_Grouping (type: esriFieldTypeString, alias: Lot Grouping, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Bushfire_Attack_Level (type: esriFieldTypeString, alias: Bushfire Attack Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sales_Agent (type: esriFieldTypeString, alias: Sales Agent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Section (type: esriFieldTypeString, alias: Section, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WebsiteNotes (type: esriFieldTypeString, alias: Website Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Builder (type: esriFieldTypeString, alias: Builder, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PublishWebsite (type: esriFieldTypeString, alias: Publish On Website, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PriceOnWebsite (type: esriFieldTypeString, alias: Display Price On Website, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SLA_Expected_Settlement_Date_Range (type: esriFieldTypeString, alias: Expected Settlement Date Range, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WebsiteDepositAmount (type: esriFieldTypeString, alias: Website Deposit Amount, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SLA_1_Bathroom (type: esriFieldTypeString, alias: 1 Bathroom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_2_Bathroom (type: esriFieldTypeString, alias: 2 Bathroom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Accessability_Class (type: esriFieldTypeString, alias: Accessability Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_AirCycleChanges_Airtight (type: esriFieldTypeInteger, alias: Air Cycle Changes / Air tightness, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Battery (type: esriFieldTypeString, alias: Battery, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Bedrooms (type: esriFieldTypeString, alias: Bedrooms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Built_Form_Price_Per_Sqm (type: esriFieldTypeInteger, alias: Built Form Price Per Sqm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_Built_Form_Product_Type (type: esriFieldTypeString, alias: Built Form Product Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Carbon_Footprint_LCA (type: esriFieldTypeString, alias: Carbon Footprint (LCA), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Carport (type: esriFieldTypeString, alias: Carport, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Carspaces (type: esriFieldTypeString, alias: Carspaces, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Cert_of_Occupancy_Date (type: esriFieldTypeDate, alias: Certificate of Occupancy Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Colour_Scheme (type: esriFieldTypeString, alias: Colour Scheme, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Defect_LiabPeriodEnd_Date (type: esriFieldTypeDate, alias: Defect Liability Period end date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Dev_Liability_End_Date (type: esriFieldTypeDate, alias: Developer Liability end date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Double_Glaze (type: esriFieldTypeString, alias: Double Glaze, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Ensuite (type: esriFieldTypeString, alias: Ensuite, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_EV_Charger (type: esriFieldTypeString, alias: EV Charger, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Floor_Area (type: esriFieldTypeString, alias: Floor Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Floorplan_Type (type: esriFieldTypeString, alias: Floorplan Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Garage (type: esriFieldTypeString, alias: Garage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Green_Roof (type: esriFieldTypeString, alias: Green Roof, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Heat_Pump (type: esriFieldTypeString, alias: Heat Pump, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_House_and_Land_Sale_Price (type: esriFieldTypeDouble, alias: House and Land Sale Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLA_HVAC_Heating_and_Cooling (type: esriFieldTypeString, alias: HVAC (Heating and Cooling), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_LED_Lighting (type: esriFieldTypeString, alias: LED Lighting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Number_of_levels (type: esriFieldTypeString, alias: Number of levels, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Number_of_Trees (type: esriFieldTypeString, alias: Number of Trees, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_OtherBuiltForm_ProductTyp (type: esriFieldTypeString, alias: Other Built Form Product Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Passivhaus (type: esriFieldTypeString, alias: Passivhaus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Permeable_Percentage (type: esriFieldTypeString, alias: Permeable Percentage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Planted_Area_Percentage (type: esriFieldTypeString, alias: Planted Area Percentage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Powder_Room (type: esriFieldTypeString, alias: Powder Room, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Prefabrication (type: esriFieldTypeString, alias: Prefabrication, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Raked_Ceilings (type: esriFieldTypeString, alias: Raked Ceilings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Renewable_Energy_Gen (type: esriFieldTypeString, alias: Renewable Energy Generation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Res_Date_Buyer_DefectList (type: esriFieldTypeDate, alias: Resolution Date for Buyer Defect List, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SLA_Solar_Passive_Design (type: esriFieldTypeString, alias: Solar Passive Design, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Solar_PV (type: esriFieldTypeString, alias: Solar PV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Toilet_WC (type: esriFieldTypeString, alias: Toilet (WC), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Tree_Canopy_Percentage (type: esriFieldTypeString, alias: Tree Canopy Percentage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Triple_Glaze (type: esriFieldTypeString, alias: Triple Glaze, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLA_Dual_Key (type: esriFieldTypeInteger, alias: Dual Key, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• SLA_Room_to_Grow (type: esriFieldTypeInteger, alias: Room to Grow, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• SLA_Living_Area (type: esriFieldTypeString, alias: Living Area, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SLA_Website_Bathrooms (type: esriFieldTypeString, alias: Website Bathrooms, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SLA_Car_Accommodation_Size (type: esriFieldTypeString, alias: Car Accommodation Size, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SLA_Energy_Efficiency_Rating (type: esriFieldTypeDouble, alias: Energy Efficiency Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Salesforce_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/17/2025 3:16:14 AM

Schema Last Edit Date: 6/17/2025 3:16:14 AM

Data Last Edit Date: 6/17/2025 3:16:14 AM

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