All Layers and Tables (service_ca218c40ca374ae4a1177132dab53c45)

Layers:

Layer: TT_Waste_Management_Audit_Survey (0)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

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":"T+T Waste Management Audit Survey","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)
CustomerName (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WM_Number (type: esriFieldTypeString, alias: WM Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SiteName (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SiteAddress (type: esriFieldTypeString, alias: Site Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CommercialOutlet (type: esriFieldTypeString, alias: Commercial Outlet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Auckland Commercial: Auckland Commercial], [Auckland Hazardous: Auckland Hazardous], [Auckland Hazardous Processing: Auckland Hazardous Processing], ... 65 more ...)
AuditType (type: esriFieldTypeString, alias: Select an Audit Template, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Food Manufacturing: FMCG / Food Manufacturing], [Health / Aged Care: Health / Aged Care], [Office / Admin / Logistics: Office & Administration / Big Box Retail / Manufacturing / Warehousing / Distribution / Logistics], ... 1 more ...)
AuditDateTime (type: esriFieldTypeDate, alias: Audit Date & Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCName (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCCompany (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCDesignation (type: esriFieldTypeString, alias: Designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustCInduction (type: esriFieldTypeString, alias: HSEQ Induction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
CustCInnoculation (type: esriFieldTypeString, alias: Inoculations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
AuditLeadName (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditLeadCompany (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditLeadDesignation (type: esriFieldTypeString, alias: Designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditLeadEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditLeadPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditLeadInduction (type: esriFieldTypeString, alias: HSEQ Induction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
AuditLeadInnoculation (type: esriFieldTypeString, alias: Inoculations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
DataEntryName (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DataEntryCompany (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DataEntryDesignation (type: esriFieldTypeString, alias: Designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DataEntryEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DataEntryPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DataEntryInduction (type: esriFieldTypeString, alias: HSEQ Induction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
DataEntryInnoculation (type: esriFieldTypeString, alias: Inoculations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
SafetyConversation (type: esriFieldTypeString, alias: Following the HSEQ Induction, describe any site specific safety concerns or considerations that have been addressed., SQL Type: sqlTypeOther, length: 3000, 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)

Templates:

Relationships:

TT_Waste_Management_Audit_Survey_AuditParticipants (1) -- Related To: AuditParticipants (1)
TT_Waste_Management_Audit_Survey_WasteAudit_ZoneTable (2) -- Related To: WasteAudit_ZoneTable (2)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

AuditParticipants (1)

Name:

Display Field:

Type:

Has Views:

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)
AuditParticipName (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditParticipCompany (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditParticipDesignation (type: esriFieldTypeString, alias: Designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditParticipEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditParticipPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AuditParticipInduction (type: esriFieldTypeString, alias: HSEQ Induction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
AuditParticipInnoculation (type: esriFieldTypeString, alias: Inoculations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
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:

TT_Waste_Management_Audit_Survey_AuditParticipants (1) -- Related To: TT_Waste_Management_Audit_Survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

WasteAudit_ZoneTable (2)

Name:

Display Field:

Type:

Has Views:

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)
ZoneName (type: esriFieldTypeString, alias: Name the Zone:, SQL Type: sqlTypeOther, length: 255, 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:

TT_Waste_Management_Audit_Survey_WasteAudit_ZoneTable (2) -- Related To: TT_Waste_Management_Audit_Survey (0)
WasteAudit_ZoneTable_WasteAudit_WasteTypeTable (3) -- Related To: WasteAudit_WasteTypeTable (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

WasteAudit_WasteTypeTable (3)

Name:

Display Field:

Type:

Has Views:

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)
WasteType (type: esriFieldTypeString, alias: WasteType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [General Waste: General Waste], [Recycling: Recycling])
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:

WasteAudit_ZoneTable_WasteAudit_WasteTypeTable (3) -- Related To: WasteAudit_ZoneTable (2)
WasteAudit_WasteTypeTable_WasteAudit_BinTable (4) -- Related To: WasteAudit_BinTable (4)
WasteAudit_WasteTypeTable_WasteAudit_WCategories (5) -- Related To: WasteAudit_WCategories (5)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

WasteAudit_BinTable (4)

Name:

Display Field:

Type:

Has Views:

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)
BinType (type: esriFieldTypeString, alias: Bin Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cage: Cage], [Compactor: Compactor], [Crate: Crate], ... 10 more ...)
BinSize (type: esriFieldTypeString, alias: Bin Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HowFullisBin (type: esriFieldTypeString, alias: How full is this bin? (%), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10: 10%], [20: 20%], [30: 30%], ... 7 more ...)
DaysOfWaste (type: esriFieldTypeInteger, alias: Days of waste in this bin, 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:

WasteAudit_WasteTypeTable_WasteAudit_BinTable (4) -- Related To: WasteAudit_WasteTypeTable (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

WasteAudit_WCategories (5)

Name:

Display Field:

Type:

Has Views:

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)
MainWasteCategory (type: esriFieldTypeString, alias: Primary Waste Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fibre: 01 Fibre], [Plastic: 02 Plastic], [Organics: 03 Organics], ... 11 more ...)
SecondaryWasteCategory (type: esriFieldTypeString, alias: Secondary Waste Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GeneralWasteRecover (type: esriFieldTypeString, alias: Can this material be recovered in the following ways?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Recoverable Immediately: Recoverable Immediately], [Potentially Recoverable within 24 months: Potentially Recoverable within 24 months], [Not Recoverable, but Noteworthy: Not Recoverable, but Noteworthy])
AcceptanceCriteria (type: esriFieldTypeString, alias: Does this material fall within the Recycling Acceptance Criteria?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Accepted - Uncontaminated: Acceptable Material and Uncontaminated], [Accepted - Contaminated: Acceptable Material but Contaminated], [Not Accepted: Not Acceptable Material])
Weight_kg (type: esriFieldTypeDouble, alias: Add Weight (kg), SQL Type: sqlTypeOther, nullable: true, editable: true)
Notes (type: esriFieldTypeString, alias: Add Notes, SQL Type: sqlTypeOther, length: 2000, 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:

WasteAudit_WasteTypeTable_WasteAudit_WCategories (5) -- Related To: WasteAudit_WasteTypeTable (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: