All Layers and Tables (RAAC_Survey_v1_Dashboard

Layers:

Layer: RAAC_Survey (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"RAAC Survey v1","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
bldg_name (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aldershot Justice Centre: Aldershot Justice Centre], [Amersham Law Courts: Amersham Law Courts], [Barkingside Magistrates Court: Barkingside Magistrates Court], ... 111 more ...)
cal_bldg_ref (type: esriFieldTypeString, alias: cal_bldg_ref, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_add1 (type: esriFieldTypeString, alias: cal_bldg_add1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_add1 (type: esriFieldTypeString, alias: bldg_add1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_add2 (type: esriFieldTypeString, alias: cal_bldg_add2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_add2 (type: esriFieldTypeString, alias: bldg_add2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_add3 (type: esriFieldTypeString, alias: cal_bldg_add3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_add3 (type: esriFieldTypeString, alias: bldg_add3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_postcode (type: esriFieldTypeString, alias: cal_bldg_postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_contact (type: esriFieldTypeString, alias: cal_bldg_contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_tele (type: esriFieldTypeString, alias: cal_bldg_tele, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_bldg_email (type: esriFieldTypeString, alias: cal_bldg_email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
bldg_add_cmb (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Relationships:

RAAC_Survey_rpt_roof_survey (1) -- Related To: rpt_roof_survey (1)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

rpt_roof_survey (1)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
parent_bldg_ref1 (type: esriFieldTypeString, alias: parent_bldg_ref1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
roof_name (type: esriFieldTypeString, alias: Roof Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_const_element (type: esriFieldTypeString, alias: Construction Element (Roof Slab), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
bldg_roof_area (type: esriFieldTypeInteger, alias: Roof Area (m2), SQL Type: sqlTypeOther, nullable: true, editable: true)
survey_weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cal_const_date (type: esriFieldTypeString, alias: cal_const_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_roof_span (type: esriFieldTypeDouble, alias: Span (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
survey_date (type: esriFieldTypeDate, alias: Date of Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_records (type: esriFieldTypeString, alias: Record Drawings Available, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
bldg_roof_depth (type: esriFieldTypeInteger, alias: Depth (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
cal_depth_ratio (type: esriFieldTypeString, alias: cal_depth_ratio, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_constrcut_note (type: esriFieldTypeString, alias: Building Construction, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
bldg_schmidt_read1 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_schmidt_read2 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_schmidt_read3 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_schmidt_read4 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_schmidt_read5 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 5, SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_schmidt_read6 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 6, SQL Type: sqlTypeOther, nullable: true, editable: true)
cal_schmidt_hammer (type: esriFieldTypeString, alias: cal_schmidt_hammer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bldg_ext_fin (type: esriFieldTypeString, alias: External Surface Finishes (Type), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Felt: Felt], [Single Ply Membrane: Single Ply Membrane], [Asphalt: Asphalt], ... 5 more ...)
bldg_int_fin (type: esriFieldTypeString, alias: Internal Ceiling Finishes (Type), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Plaster: Plaster], [Cement Render: Cement Render], [Unfinished/Exposed: Unfinished/Exposed], ... 3 more ...)
bldg_surface_drainage (type: esriFieldTypeString, alias: Surface Water Drainage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [External: External], [Internal: Internal], [Combination: Combination], ... 2 more ...)
bldg_deflection (type: esriFieldTypeString, alias: Structural Deflection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
bldg_ponding (type: esriFieldTypeString, alias: Ponding Water, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
bldg_cracking (type: esriFieldTypeString, alias: Cracking to Slab Soffit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
bldg_water_penetrate (type: esriFieldTypeString, alias: Evidence of Water Penetration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
bldg_reinforce_stain (type: esriFieldTypeString, alias: Reinforcement Staining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
bldg_crack_config (type: esriFieldTypeString, alias: Cracking Configuration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Longitudinal: Longitudinal], [Transverse: Transverse], [Combination: Combination], ... 2 more ...)
bldg_crack_location (type: esriFieldTypeString, alias: Location of Cracking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Bearing: Bearing], [Mid: Mid], [Both: Both], ... 2 more ...)
bldg_ext_fin_colour (type: esriFieldTypeString, alias: External Type Finshes (Colour), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Black: Black], [Dark: Dark], [Light: Light], ... 1 more ...)
bldg_bearing_width (type: esriFieldTypeInteger, alias: Bearing Widths (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
bldg_reinforce_cor (type: esriFieldTypeString, alias: Reinforecment Corrosion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
bldg_last_inspect (type: esriFieldTypeString, alias: Date of Last Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
invest_required (type: esriFieldTypeString, alias: Further Investigation Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
schmidt_hammer (type: esriFieldTypeString, alias: Are you able to carry out Schmidt Hammer Test, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
schmidt_hammer_reason (type: esriFieldTypeString, alias: Why not, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Relationships:

RAAC_Survey_rpt_roof_survey (1) -- Related To: RAAC_Survey (0)
rpt_roof_survey_rpt_invest (2) -- Related To: rpt_invest (2)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

rpt_invest (2)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
parent_bldg_ref2 (type: esriFieldTypeString, alias: parent_bldg_ref2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parent_roof_name (type: esriFieldTypeString, alias: parent_roof_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
invest_desc (type: esriFieldTypeString, alias: Description of Work Costed, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true, Coded Values: [Internal propping to be installed below heavily deflecting roof/deck planks.: Internal propping to be installed below heavily deflecting roof/deck planks.], [Carry out a topographic level survey on roof/deck to assess/confirm fluctuations / deflection in construction and keep records of deflections of RAAC planks.: Carry out a topographic level survey on roof/deck to assess/confirm fluctuations / deflection in construction and keep records of deflections of RAAC planks.], [Inspect the construction on an annual basis as a minimum checking for visual signs of cracks; deflection to soffits; and water penetration and ponding to roofs.: Inspect the construction on an annual basis as a minimum checking for visual signs of cracks; deflection to soffits; and water penetration and ponding to roofs.], ... 8 more ...)
invest_desc_other (type: esriFieldTypeString, alias: Description of Work Costed, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
invest_desc_answer (type: esriFieldTypeString, alias: invest_desc_answer, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
invest_priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 1 more ...)
invest_cost (type: esriFieldTypeDouble, alias: Est. Cost £, SQL Type: sqlTypeOther, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

rpt_roof_survey_rpt_invest (2) -- Related To: rpt_roof_survey (1)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: