All Layers and Tables (SVT_PRO_SWE_SocialValueActivity_Form_v3

Layers:

Layer: Social Value Activity (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":"SVT - Social Value Activity Form v3","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: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
AuthorisationCode (type: esriFieldTypeString, alias: Authorisation Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
CheckAuthorisationCode (type: esriFieldTypeString, alias: Check Authorisation Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SwecoEmailAccount (type: esriFieldTypeString, alias: Sweco Email Account, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SwecoHomeOffice (type: esriFieldTypeString, alias: Sweco Home Office, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Birmingham: Birmingham], [Brighton: Brighton], [Bristol: Bristol], ... 16 more ...)
ActivityOrigin (type: esriFieldTypeString, alias: Activity Origin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Office-based: A representative of your office-based initiative], [Nationwide: A representative of Sweco UK & Ireland for a nationwide initative (not on a project)], [Project: Part of a project commitment], ... 1 more ...)
SelfOrganisedActivity (type: esriFieldTypeString, alias: Self Organised Activity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ActivityOrganiser (type: esriFieldTypeString, alias: Activity Organiser, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SwecoOffice (type: esriFieldTypeString, alias: Sweco Office, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Birmingham: Birmingham], [Brighton: Brighton], [Bristol: Bristol], ... 16 more ...)
SwecoProjectActivity (type: esriFieldTypeString, alias: Sweco Project Activity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
MaconomyProjectNumber (type: esriFieldTypeString, alias: Maconomy Project Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MaconomyProjectName (type: esriFieldTypeString, alias: Maconomy Project Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ClientName (type: esriFieldTypeString, alias: Client Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ActivityPreviousRelationship (type: esriFieldTypeString, alias: Activity Previous Relationship, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/K: Unsure / Not to my knowledge])
ActivityCategory (type: esriFieldTypeString, alias: Activity Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ActivityType (type: esriFieldTypeString, alias: Activity Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [STEM: STEM (technical talks/activities within a school etc.)], [Career talks: Career talks (including CV advice, mock interviews etc.)], [Environmental: Environmental (e.g., litter picking, conservation etc.)], ... 4 more ...)
NumOfSwecoEmployeesInvolved (type: esriFieldTypeInteger, alias: No. Sweco Employees Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
NumOfPeopleReached (type: esriFieldTypeInteger, alias: No. People Reached, SQL Type: sqlTypeOther, nullable: true, editable: true)
ActivityDelivery (type: esriFieldTypeString, alias: Activity Delivery, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In person: In person], [Remotely: Remotely])
ActivityTimeUsed (type: esriFieldTypeString, alias: Activity Time Used, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Own time, unrelated to work: Own time and unrelated to work], [Own time, related to work: Own time but related to work], [Sweco time: Sweco time (booked on your timesheet)])
ActivityFrequency (type: esriFieldTypeString, alias: Activity Frequency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [One-off activity: One-off activity], [Regular commitment: Regular commitment])
NumOfHoursSpent (type: esriFieldTypeInteger, alias: No. Hours Spent on the Activity, SQL Type: sqlTypeOther, nullable: true, editable: true)
ActivityDate (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ActivityStartDate (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ActivityEndDate (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ActivityRegularity (type: esriFieldTypeString, alias: Activity Regularity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [More than once a week: More than once a week], [Once a week: Once a week], [Twice a month: Twice a month], ... 4 more ...)
OrganisationName_Advice (type: esriFieldTypeString, alias: Organisation Name (Advice), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
OrganisationName_Donation (type: esriFieldTypeString, alias: Organisation Name (Donation), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ActivityMoneyCollected (type: esriFieldTypeDouble, alias: Money Donated or Raised, SQL Type: sqlTypeOther, nullable: true, editable: true)
ActivityDonationType (type: esriFieldTypeString, alias: Activity Donation Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Personal: Personal / personally raised (through activity unrelated to the office)], [Company: Company donation (e.g., spending on a project)], [Office: Raised within the office])
ActivityDescription (type: esriFieldTypeString, alias: Activity Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
ProvisionOfPermissionForPhotos (type: esriFieldTypeString, alias: Provision of Permission for Photos, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: Not applicable])
SMEMoneySpent (type: esriFieldTypeDouble, alias: Money spent with SMEs, SQL Type: sqlTypeOther, nullable: true, editable: true)
WorkExperienceStudentAgeRange (type: esriFieldTypeInteger, alias: Student's Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
MeasurementFramework (type: esriFieldTypeString, alias: Measurement Framework, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [TOMs Framework: TOMs Framework], [Capitals Framework: Capitals Framework (e.g., National Highways, Water companies etc.)], [Four Capitals: Four Capitals (e.g., National Highways)], ... 3 more ...)
ActivityTheme (type: esriFieldTypeString, alias: Activity Theme, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Jobs: Jobs (promote local skills & employment)], [Growth: Growth (supporting growth of responsible business)], [Social: Social (healthier, safer, and more resilient communities)], ... 2 more ...)
CreationDate (type: esriFieldTypeDate, alias: Creation Date, 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: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
SwecoDivisionSptService (type: esriFieldTypeString, alias: Sweco Division or Support Service, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Admin&FacEWE: Administration and Facilities], [BSvc: Building Services], [BStd: Building Standards], ... 11 more ...)
NumOfHoursPrep (type: esriFieldTypeInteger, alias: No. Hours Spent on Preparing the Activity, SQL Type: sqlTypeOther, nullable: true, editable: true)
ActivityTimeSpent (type: esriFieldTypeInteger, alias: Time Spent on the Activity in total, SQL Type: sqlTypeOther, nullable: true, editable: true)
ActivityCategoryGroup (type: esriFieldTypeString, alias: Activity Category Group, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

Relationships:

SVT___Social_Value_Activity_Form_v3_SVT_SWE_ActivityOutcome_Repeat (1) -- Related To: SVT_SWE_ActivityOutcome_Repeat (1)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

SVT_SWE_ActivityOutcome_Repeat (1)