All Layers and Tables (Hosted/survey123_f8fc2f060ae14aecae298b03988e5c9f

Layers:

Layer: BASCIC_FACILITY_INFO (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
property_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Facility Number, type: esriFieldTypeString , Coded Values: [SHRA00001: SHRA00001] , [SHRA00002: SHRA00002] , [SHRA00003: SHRA00003] )
facility_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Facility Type, type: esriFieldTypeString , Coded Values: [Residential Apartments: Residential Apartments] , [Other: Other] , [other: Other] )
facility_type_other ( nullable: true, editable: true, defaultValue: , length: 255, alias: Other - Facility Type, type: esriFieldTypeString )
name_of_development ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name of Development:, type: esriFieldTypeString )
property_owner_manager ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Owner / Manager:, type: esriFieldTypeString )
property_manager_details ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Manager Details, type: esriFieldTypeString )
name_of_assessor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name of Assessor, type: esriFieldTypeString )
field_290 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Development Phase (If Applicable), type: esriFieldTypeString , Coded Values: [Phase 1: Phase 1] , [Phase 2: Phase 2] , [Phase 3: Phase 3] )
erf_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Erf Number, type: esriFieldTypeString )
building_address ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Facility Address, type: esriFieldTypeString )
facility_extent ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Facility Extent, type: esriFieldTypeString )
building_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Building Type, type: esriFieldTypeString )
block_no_unitschedule ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Block_No., type: esriFieldTypeString )
unit_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit Type, type: esriFieldTypeString , Coded Values: [1_Bed_Unit: 1_Bed_Unit] , [2_Bed_Unit: 2_Bed_Unit] , [3_Bed_Unit: 3_Bed_Unit] , ...2 more... )
no_of_units ( nullable: true, editable: true, defaultValue: null, alias: No. of Units, type: esriFieldTypeDouble )
typical_layouts ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Typical Layouts, type: esriFieldTypeString )
number_of_stories ( nullable: true, editable: true, defaultValue: null, alias: Number of Stories, type: esriFieldTypeDouble )
building_area_sqm ( nullable: true, editable: true, defaultValue: null, alias: Building Area_SQm, type: esriFieldTypeDouble )
date_of_construction ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date of Construction (Year Built), type: esriFieldTypeDate )
current_age_of_the_building ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Current Age of the Building, type: esriFieldTypeString )
aduti_details ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Audit Details, type: esriFieldTypeDate )
company_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Name, type: esriFieldTypeString )
number_of_inspections_of_indivi ( nullable: true, editable: true, defaultValue: null, alias: Number of Inspections of individual Units, type: esriFieldTypeDouble )
percentage_of_individual_units ( nullable: true, editable: true, defaultValue: null, alias: Percentage of individual units audited (%), type: esriFieldTypeDouble )
number_of_blocks_audited ( nullable: true, editable: true, defaultValue: null, alias: Number of blocks Audited, type: esriFieldTypeDouble )
percentage_blocks_audited ( nullable: true, editable: true, defaultValue: null, alias: Percentage Blocks Audited (%), type: esriFieldTypeDouble )
prev_audit_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Date of previous Audit, type: esriFieldTypeString )
previous_audit_details ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Previous Audit Details, type: esriFieldTypeString )
previous_maintenance_info ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Previous Maintenance Info, type: esriFieldTypeString )
component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Name, type: esriFieldTypeString , Coded Values: [A1_Boundary wall/ fence: A1_Boundary wall/ fence] , [A2_Entrance/exit gate(s): A2_Entrance/exit gate(s)] , [A3_Security offices/ gate-house: A3_Security offices/ gate-house] , ...26 more... )
component_type_site ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Type, type: esriFieldTypeString , Coded Values: [Fence_Domestic: Fence_Domestic] , [Fence_Palisade_Steel: Fence_Palisade_Steel] , [Fence_Palisade_Concrete: Fence_Palisade_Concrete] , ...21 more... )
component_condition_rating_comp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Condition Rating, type: esriFieldTypeString , Coded Values: [C1: C1] , [C2: C2] , [C3: C3] , ...2 more... )
comment ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Comment, type: esriFieldTypeString )
repairs_or_action_required ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Repairs Or Action Required, type: esriFieldTypeString )
req_maintenance_actions ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
ratings_priority ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
unit_of_measure ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Unit of Measure, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...2 more... )
extent ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
defect_extent ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
building_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_No, type: esriFieldTypeString )
type_building ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Type, type: esriFieldTypeString )
bca_component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Component Name, type: esriFieldTypeString , Coded Values: [A1_Footings: A1_Footings] , [A2_Surface bed: A2_Surface bed] , [A3_Building apron: A3_Building apron] , ...35 more... )
bca_component_name_other ( nullable: true, editable: true, defaultValue: , length: 255, alias: Other - BCA_Component Name, type: esriFieldTypeString )
component_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Type, type: esriFieldTypeString , Coded Values: [Walls_Raw_Brick: Walls_Raw_Brick] , [Walls_Plastered: Walls_Plastered] , [Walls_Prefabricated_Panel: Walls_Prefabricated_Panel] , ...9 more... )
component_type_other ( nullable: true, editable: true, defaultValue: , length: 255, alias: Other - Component Type, type: esriFieldTypeString )
bca_component_cond_rating_compo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Condition Rating, type: esriFieldTypeString , Coded Values: [C1: C1] , [C2: C2] , [C3: C3] , ...2 more... )
bca_comment ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Comment, type: esriFieldTypeString )
bca_required_maintenance_action ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
bca_priority_rating ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
bca_repairs_or_action_required ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Repairs Or Action Required, type: esriFieldTypeString )
unit_of_measure_external_defect ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Unit of Measure_Ext, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...3 more... )
ext_bca ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
def_ext_bca ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
block_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Block_No., type: esriFieldTypeString )
floor_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Floor Number, type: esriFieldTypeString , Coded Values: [F_01: F_01] , [F000: F000] , [F001: F001] , ...15 more... )
unit_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit_No, type: esriFieldTypeString )
internal_component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Component Name, type: esriFieldTypeString , Coded Values: [A1_Distribution board: A1_Distribution board] , [A2_Pre-paid electrical meter: A2_Pre-paid electrical meter] , [A3_Light switches: A3_Light switches] , ...36 more... )
type_component_internal ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Type, type: esriFieldTypeString , Coded Values: [Walls_Facebrick: Walls_Facebrick] , [Walls_Plastered: Walls_Plastered] , [Walls_Dry Wall_Prefab: Walls_Dry Wall_Prefab] , ...14 more... )
interior_cr_component_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Condition Rating, type: esriFieldTypeString , Coded Values: [C1: C1] , [C2: C2] , [C3: C3] , ...2 more... )
internal_comment ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Comment, type: esriFieldTypeString )
internal_required_maintenance_a ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
internal_priority_rating ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
internal_repairs_or_action_requ ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Repairs Or Action Required, type: esriFieldTypeString )
unit_of_measure_int_def ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Unit of Measure_Int, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...3 more... )
ext ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
def_ext ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
equipment_or_service ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment OR Service, type: esriFieldTypeString , Coded Values: [Lifts: Lifts] , [Access control system: Access control system] , [Surveillance system: Surveillance system] , ...15 more... )
applicable_yes_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicable, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
condition_service ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Acceptable Condition, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
service_reg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Register and Details Available, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
date_prev_service ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date of Last Service, type: esriFieldTypeDate )
required_service_frequency ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Required Service Frequency, type: esriFieldTypeString , Coded Values: [Monthly: Monthly] , [Quarterly: Quarterly] , [Bi-Annually: Bi-Annually] , ...6 more... )
timeously_serviced ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Timeously Serviced, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
general_remarks ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Remarks, type: esriFieldTypeString )
req_ohs ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requirements, type: esriFieldTypeString , Coded Values: [1_Building plans approved by lo: 1_Building plans approved by local authority] , [1_Approved plans are current an: 1_Approved plans are current and reflect as-built condition] , [1_Fire protection plan displaye: 1_Fire protection plan displayed on building] , ...60 more... )
legislation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Legislation, type: esriFieldTypeString , Coded Values: [NBRR & BSA (Act 103 of 1977) (1: NBRR & BSA (Act 103 of 1977) (1_BUILDING REG.)] , [SANS 10400-A (1_FIRE_PROT_PLAN): SANS 10400-A (1_FIRE_PROT_PLAN)] , [SANS 10400-T (2_FIRE): SANS 10400-T (2_FIRE)] , ...10 more... )
status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
comment_ ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Name: New Feature
Description:
Prototype:
Drawing Tool: N/A

Relationships:

BASCIC_FACILITY_INFO_site_grounds_condition_assess (0) -- Related To: site_grounds_condition_assess (1)
BASCIC_FACILITY_INFO_bca_external (1) -- Related To: bca_external (2)
BASCIC_FACILITY_INFO_bca_internal_unit_interiors (2) -- Related To: bca_internal_unit_interiors (3)
BASCIC_FACILITY_INFO_equipment_checklist (3) -- Related To: equipment_checklist (4)
BASCIC_FACILITY_INFO_ohs_checklist (4) -- Related To: ohs_checklist (5)

Tables:

Table: site_grounds_condition_assess (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Name, type: esriFieldTypeString , Coded Values: [A1_Boundary wall/ fence: A1_Boundary wall/ fence] , [A2_Entrance/exit gate(s): A2_Entrance/exit gate(s)] , [A3_Security offices/ gate-house: A3_Security offices/ gate-house] , ...26 more... )
component_type_site ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Type, type: esriFieldTypeString , Coded Values: [Fence_Domestic: Fence_Domestic] , [Fence_Palisade_Steel: Fence_Palisade_Steel] , [Fence_Palisade_Concrete: Fence_Palisade_Concrete] , ...21 more... )
component_condition_rating_comp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: component_condition_rating_comp, type: esriFieldTypeString )
comment ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Comment, type: esriFieldTypeString )
repairs_or_action_required ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Repairs Or Action Required, type: esriFieldTypeString )
req_maintenance_actions ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
ratings_priority ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
unit_of_measure ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Unit of Measure_Site, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...2 more... )
extent ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
defect_extent ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
parentglobalid ( nullable: true, defaultValue: null, editable: true, length: 38, alias: ParentGlobalID, type: esriFieldTypeGUID )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
field_320 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FacilityNr, type: esriFieldTypeString , Coded Values: [Choice 1: Choice 1] , [Choice 2: Choice 2] , [Choice 3: Choice 3] )

Relationships:

BASCIC_FACILITY_INFO_site_grounds_condition_assess (0) -- Related To: BASCIC_FACILITY_INFO (0)

Table: bca_external (2)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
building_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Block No., type: esriFieldTypeString )
type_building ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Type, type: esriFieldTypeString )
bca_component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Component Name, type: esriFieldTypeString , Coded Values: [A1_Footings: A1_Footings] , [A2_Surface bed: A2_Surface bed] , [A3_Building apron: A3_Building apron] , ...35 more... )
bca_component_name_other ( nullable: true, editable: true, defaultValue: , length: 255, alias: Other, type: esriFieldTypeString )
component_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: component_type, type: esriFieldTypeString )
component_type_other ( nullable: true, editable: true, defaultValue: , length: 255, alias: Other, type: esriFieldTypeString )
bca_component_cond_rating_compo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: bca_component_cond_rating_compo, type: esriFieldTypeString )
bca_comment ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Comment, type: esriFieldTypeString )
bca_required_maintenance_action ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
bca_priority_rating ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
bca_repairs_or_action_required ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BCA_Repairs Or Action Required, type: esriFieldTypeString )
unit_of_measure_external_defect ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit of Measure_Ext, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...3 more... )
ext_bca ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
def_ext_bca ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
parentglobalid ( nullable: true, defaultValue: null, editable: true, length: 38, alias: ParentGlobalID, type: esriFieldTypeGUID )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
field_307 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FacilityNr, type: esriFieldTypeString , Coded Values: [SHRA00001: SHRA00001] , [SHRA00002: SHRA00002] , [SHRA00003: SHRA00003] , ...1 more... )
field_321 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BuildingNr, type: esriFieldTypeString )
field_322 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FloorNr, type: esriFieldTypeString )
field_323 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit_Type, type: esriFieldTypeString )

Relationships:

BASCIC_FACILITY_INFO_bca_external (1) -- Related To: BASCIC_FACILITY_INFO (0)

Table: bca_internal_unit_interiors (3)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
block_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Block_No., type: esriFieldTypeString )
floor_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FloorNr, type: esriFieldTypeString , Coded Values: [F_01: F_01] , [F000: F000] , [F001: F001] , ...15 more... )
unit_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit_No, type: esriFieldTypeString )
internal_component_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Component Name, type: esriFieldTypeString , Coded Values: [A1_Distribution board: A1_Distribution board] , [A2_Pre-paid electrical meter: A2_Pre-paid electrical meter] , [A3_Light switches: A3_Light switches] , ...36 more... )
type_component_internal ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component Type, type: esriFieldTypeString , Coded Values: [Walls_Facebrick: Walls_Facebrick] , [Walls_Plastered: Walls_Plastered] , [Walls_Dry Wall_Prefab: Walls_Dry Wall_Prefab] , ...14 more... )
interior_cr_component_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: interior_cr_component_condition, type: esriFieldTypeString )
internal_comment ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Comment, type: esriFieldTypeString )
internal_required_maintenance_a ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Required Maintenance Actions, type: esriFieldTypeString , Coded Values: [H&S_Health & Safety: H&S_Health & Safety] , [RM_Reactive / Responsive Mainte: RM_Reactive / Responsive Maintenance] , [VC_Vacancy / complaints-based m: VC_Vacancy / complaints-based maintenance] , ...3 more... )
internal_priority_rating ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Priority Rating, type: esriFieldTypeString , Coded Values: [P1_Immediate: P1_Immediate] , [P2_Short term - up to 1 year: P2_Short term - up to 1 year] , [P3_Medium term - 1 to 2 years: P3_Medium term - 1 to 2 years] , ...2 more... )
internal_repairs_or_action_requ ( nullable: true, editable: true, defaultValue: null, length: 255, alias: INTERNAL_Repairs Or Action Required, type: esriFieldTypeString )
unit_of_measure_int_def ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Unit of Measure_Int, type: esriFieldTypeString , Coded Values: [Count: Count] , [Meter: Meter] , [Square Meter: Square Meter] , ...3 more... )
ext ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extent, type: esriFieldTypeString )
def_ext ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Defect_Extent, type: esriFieldTypeString )
parentglobalid ( nullable: true, defaultValue: null, editable: true, length: 38, alias: ParentGlobalID, type: esriFieldTypeGUID )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
facilitynr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FacilityNr, type: esriFieldTypeString , Coded Values: [SHRA00001: SHRA00001] , [SHRA00002: SHRA00002] , [SHRA00003: SHRA00003] , ...1 more... )
buildingnr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: BuildingNr, type: esriFieldTypeString , Coded Values: [B001: B001] , [B002: B002] , [B003: B003] , ...2 more... )

Relationships:

BASCIC_FACILITY_INFO_bca_internal_unit_interiors (2) -- Related To: BASCIC_FACILITY_INFO (0)

Table: equipment_checklist (4)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
equipment_or_service ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Equipment OR Service, type: esriFieldTypeString , Coded Values: [Lifts: Lifts] , [Access control system: Access control system] , [Surveillance system: Surveillance system] , ...15 more... )
applicable_yes_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicable, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
condition_service ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Acceptable Condition, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
service_reg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Register and Details Available, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
date_prev_service ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date of Last Service, type: esriFieldTypeDate )
required_service_frequency ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Required Service Frequency, type: esriFieldTypeString , Coded Values: [Monthly: Monthly] , [Quarterly: Quarterly] , [Bi-Annually: Bi-Annually] , ...6 more... )
timeously_serviced ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Timeously Serviced, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
general_remarks ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Remarks, type: esriFieldTypeString )
parentglobalid ( nullable: true, defaultValue: null, editable: true, length: 38, alias: ParentGlobalID, type: esriFieldTypeGUID )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
field_324 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: FacilityNr, type: esriFieldTypeString )
buildingblocknr ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Building/BlockNr, type: esriFieldTypeString )
floornr ( nullable: true, editable: true, defaultValue: null, length: 256, alias: FloorNr, type: esriFieldTypeString )
e_facilitynr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: FacilityNr, type: esriFieldTypeString )

Relationships:

BASCIC_FACILITY_INFO_equipment_checklist (3) -- Related To: BASCIC_FACILITY_INFO (0)

Table: ohs_checklist (5)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
req_ohs ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requirements, type: esriFieldTypeString , Coded Values: [1_Building plans approved by lo: 1_Building plans approved by local authority] , [1_Approved plans are current an: 1_Approved plans are current and reflect as-built condition] , [1_Fire protection plan displaye: 1_Fire protection plan displayed on building] , ...60 more... )
legislation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Legislation, type: esriFieldTypeString , Coded Values: [NBRR & BSA (Act 103 of 1977) (1: NBRR & BSA (Act 103 of 1977) (1_BUILDING REG.)] , [SANS 10400-A (1_FIRE_PROT_PLAN): SANS 10400-A (1_FIRE_PROT_PLAN)] , [SANS 10400-T (2_FIRE): SANS 10400-T (2_FIRE)] , ...10 more... )
status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Compliance Status, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
comment_ ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comment, type: esriFieldTypeString )
parentglobalid ( nullable: true, defaultValue: null, editable: true, length: 38, alias: ParentGlobalID, type: esriFieldTypeGUID )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
field_310 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: FacilityNr, type: esriFieldTypeString )
field_312 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: BuildingNr, type: esriFieldTypeString )
field_311 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: FloorNr, type: esriFieldTypeString )

Relationships:

BASCIC_FACILITY_INFO_ohs_checklist (4) -- Related To: BASCIC_FACILITY_INFO (0)