Name: Test.dbo.vwPDAssignRoster

Display Field: O1_LNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT )
• OFF1 ( type: esriFieldTypeInteger, alias: OFF1 )
• O1_EMPNO ( type: esriFieldTypeInteger, alias: O1_EMPNO )
• O1_POSITION ( type: esriFieldTypeString, alias: O1_POSITION, length: 50 )
• O1_LNAME ( type: esriFieldTypeString, alias: O1_LNAME, length: 50 )
• O1_FNAME ( type: esriFieldTypeString, alias: O1_FNAME, length: 50 )
• O1_BADGE ( type: esriFieldTypeString, alias: O1_BADGE, length: 50 )
• O1_PHONE ( type: esriFieldTypeString, alias: O1_PHONE, length: 50 )
• O1_EMAIL ( type: esriFieldTypeString, alias: O1_EMAIL, length: 50 )
• OFF2 ( type: esriFieldTypeInteger, alias: OFF2 )
• O2_EMPNO ( type: esriFieldTypeInteger, alias: O2_EMPNO )
• O2_POSITION ( type: esriFieldTypeString, alias: O2_POSITION, length: 50 )
• O2_LNAME ( type: esriFieldTypeString, alias: O2_LNAME, length: 50 )
• O2_FNAME ( type: esriFieldTypeString, alias: O2_FNAME, length: 50 )
• O2_BADGE ( type: esriFieldTypeString, alias: O2_BADGE, length: 50 )
• O2_PHONE ( type: esriFieldTypeString, alias: O2_PHONE, length: 50 )
• O2_EMAIL ( type: esriFieldTypeString, alias: O2_EMAIL, length: 50 )
• BEATSGT ( type: esriFieldTypeInteger, alias: BEATSGT )
• BS_EMPNO ( type: esriFieldTypeInteger, alias: BS_EMPNO )
• BS_POSITION ( type: esriFieldTypeString, alias: BS_POSITION, length: 50 )
• BS_LNAME ( type: esriFieldTypeString, alias: BS_LNAME, length: 50 )
• BS_FNAME ( type: esriFieldTypeString, alias: BS_FNAME, length: 50 )
• BS_BADGE ( type: esriFieldTypeString, alias: BS_BADGE, length: 50 )
• BS_PHONE ( type: esriFieldTypeString, alias: BS_PHONE, length: 50 )
• BS_EMAIL ( type: esriFieldTypeString, alias: BS_EMAIL, length: 50 )
• EWSGT ( type: esriFieldTypeInteger, alias: EWSGT )
• EWS_EMPNO ( type: esriFieldTypeInteger, alias: EWS_EMPNO )
• EWS_POSITION ( type: esriFieldTypeString, alias: EWS_POSITION, length: 50 )
• EWS_LNAME ( type: esriFieldTypeString, alias: EWS_LNAME, length: 50 )
• EWS_FNAME ( type: esriFieldTypeString, alias: EWS_FNAME, length: 50 )
• EWS_BADGE ( type: esriFieldTypeString, alias: EWS_BADGE, length: 50 )
• EWS_PHONE ( type: esriFieldTypeString, alias: EWS_PHONE, length: 50 )
• EWS_EMAIL ( type: esriFieldTypeString, alias: EWS_EMAIL, length: 50 )
• LT ( type: esriFieldTypeInteger, alias: LT )
• LT_EMPNO ( type: esriFieldTypeInteger, alias: LT_EMPNO )
• LT_POSITION ( type: esriFieldTypeString, alias: LT_POSITION, length: 50 )
• LT_LNAME ( type: esriFieldTypeString, alias: LT_LNAME, length: 50 )
• LT_FNAME ( type: esriFieldTypeString, alias: LT_FNAME, length: 50 )
• LT_BADGE ( type: esriFieldTypeString, alias: LT_BADGE, length: 50 )
• LT_PHONE ( type: esriFieldTypeString, alias: LT_PHONE, length: 50 )
• LT_EMAIL ( type: esriFieldTypeString, alias: LT_EMAIL, length: 50 )
• CHIEF ( type: esriFieldTypeInteger, alias: CHIEF )
• CH_EMPNO ( type: esriFieldTypeInteger, alias: CH_EMPNO )
• CH_POSITION ( type: esriFieldTypeString, alias: CH_POSITION, length: 50 )
• CH_LNAME ( type: esriFieldTypeString, alias: CH_LNAME, length: 50 )
• CH_FNAME ( type: esriFieldTypeString, alias: CH_FNAME, length: 50 )
• CH_BADGE ( type: esriFieldTypeString, alias: CH_BADGE, length: 50 )
• CH_PHONE ( type: esriFieldTypeString, alias: CH_PHONE, length: 50 )
• CH_EMAIL ( type: esriFieldTypeString, alias: CH_EMAIL, length: 50 )
• TRAFFIC ( type: esriFieldTypeInteger, alias: TRAFFIC )
• TR_EMPNO ( type: esriFieldTypeInteger, alias: TR_EMPNO )
• TR_POSITION ( type: esriFieldTypeString, alias: TR_POSITION, length: 50 )
• TR_LNAME ( type: esriFieldTypeString, alias: TR_LNAME, length: 50 )
• TR_FNAME ( type: esriFieldTypeString, alias: TR_FNAME, length: 50 )
• TR_BADGE ( type: esriFieldTypeString, alias: TR_BADGE, length: 50 )
• TR_PHONE ( type: esriFieldTypeString, alias: TR_PHONE, length: 50 )
• TR_EMAIL ( type: esriFieldTypeString, alias: TR_EMAIL, length: 50 )
• DEPCHIEF ( type: esriFieldTypeInteger, alias: DEPCHIEF )
• DC_EMPNO ( type: esriFieldTypeInteger, alias: DC_EMPNO )
• DC_POSITION ( type: esriFieldTypeString, alias: DC_POSITION, length: 50 )
• DC_LNAME ( type: esriFieldTypeString, alias: DC_LNAME, length: 50 )
• DC_FNAME ( type: esriFieldTypeString, alias: DC_FNAME, length: 50 )
• DC_BADGE ( type: esriFieldTypeString, alias: DC_BADGE, length: 50 )
• DC_PHONE ( type: esriFieldTypeString, alias: DC_PHONE, length: 50 )
• DC_EMAIL ( type: esriFieldTypeString, alias: DC_EMAIL, length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata