All Layers and Tables (finalproject)

Layers:

Layer: xyutmcampuslocation (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CampusName","uniqueValueInfos":[{"value":"Fennell Campus","label":"Fennell Campus","symbol":{"color":[237,81,81,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Institute for Applied Health Sciences at McMaster","label":"Institute for Applied Health Sciences at McMaster","symbol":{"color":[20,158,206,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Six Nations Polytechnic - Brantford","label":"Six Nations Polytechnic - Brantford","symbol":{"color":[167,198,54,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Stoney Creek Campus for Skilled Trades","label":"Stoney Creek Campus for Skilled Trades","symbol":{"color":[158,85,156,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Wentworth Heights - Schlegel","label":"Wentworth Heights - Schlegel","symbol":{"color":[252,146,31,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}}]},"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)
x_utm (type: esriFieldTypeInteger, alias: x_utm, SQL Type: sqlTypeOther, nullable: true, editable: true)
y_utm (type: esriFieldTypeInteger, alias: y_utm, SQL Type: sqlTypeOther, nullable: true, editable: true)
LocationID (type: esriFieldTypeInteger, alias: LocationID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CampusName (type: esriFieldTypeString, alias: CampusName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Province (type: esriFieldTypeString, alias: Province, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Types:

CampusName: Fennell Campus

CampusName: Institute for Applied Health Sciences at McMaster

CampusName: Six Nations Polytechnic - Brantford

CampusName: Stoney Creek Campus for Skilled Trades

CampusName: Wentworth Heights - Schlegel

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

tblDepartment (1)

Name:

Display Field:

Type:

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:

DepartmentID (type: esriFieldTypeOID, alias: DepartmentID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
DepartmentName (type: esriFieldTypeString, alias: DepartmentName, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

tblEmployee (2)

Name:

Display Field:

Type:

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:

EmployeeID (type: esriFieldTypeOID, alias: EmployeeID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
DepartmentID (type: esriFieldTypeSmallInteger, alias: DepartmentID, SQL Type: sqlTypeOther, nullable: false, editable: true)
Position (type: esriFieldTypeString, alias: Position, SQL Type: sqlTypeOther, length: 80, nullable: false, editable: true)
Salary (type: esriFieldTypeDouble, alias: Salary, SQL Type: sqlTypeOther, nullable: false, editable: true)
LocationID (type: esriFieldTypeInteger, alias: LocationID, SQL Type: sqlTypeOther, nullable: false, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

tblLocation (3)

Name:

Display Field:

Type:

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:

LocationID (type: esriFieldTypeOID, alias: LocationID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CampusName (type: esriFieldTypeString, alias: CampusName, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 80, nullable: false, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
Province (type: esriFieldTypeString, alias: Province, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: