Name: View_2$

Display Field: FirstName

Type: Table

Description: This table show the various details of the Lecturer/Instructor, name , course taught and location of departments. This is the main Sql query/ view created from all the 3 tables(Instructor, CourseTaught and Department).

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• InstructID (type: esriFieldTypeString, alias: InstructID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Semester (type: esriFieldTypeString, alias: Semester, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Credits (type: esriFieldTypeDouble, alias: Credits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DepartName (type: esriFieldTypeString, alias: DepartName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: View_2$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:15:44 AM

Schema Last Edit Date: 8/2/2022 2:15:44 AM

Data Last Edit Date: 8/2/2022 2:15:44 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat