All Layers and Tables (Waste_Management_Audit_Survey_-_TT

Layers:

Layer: Waste_Management_Audit_Survey_XWMNZX (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":"Waste Management Audit Survey - BETA","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])
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:

Waste_Management_Audit_Survey_XWMNZX_AuditParticipants (1) -- Related To: AuditParticipants (1)
Waste_Management_Audit_Survey_XWMNZX_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:

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

Waste_Management_Audit_Survey_XWMNZX_AuditParticipants (1) -- Related To: Waste_Management_Audit_Survey_XWMNZX (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:

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

Waste_Management_Audit_Survey_XWMNZX_WasteAudit_ZoneTable (2) -- Related To: Waste_Management_Audit_Survey_XWMNZX (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:

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

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

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)
MainWasteCategory (type: esriFieldTypeString, alias: Primary Waste Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SecondaryWasteCategory (type: esriFieldTypeString, alias: Secondary Waste Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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)
RecoverCurrent (type: esriFieldTypeString, alias: Can this material be recovered immediately using a currently available WM service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
RecoverPotential (type: esriFieldTypeString, alias: Could this material potentially be recovered within the next 24 months via a new upcoming service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Noteworthy (type: esriFieldTypeString, alias: Would this material as a noteworthy mention within the Audit Report?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
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: Accepted - Uncontaminated], [Accepted - Contaminated: Accepted - Contaminated], [Not Accepted: Not Accepted])

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: