All Layers and Tables (PublicWorks/HeavyEquip_Services

Layers:

Layer: All Active Service Requests (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Default Label:

UniqueValueInfos:

Value: 20748
Label: PW (HE)-Demo
Description: N/A
Symbol:
Value: 20749
Label: PW (HE)-Ditch
Description: N/A
Symbol:
Value: 20750
Label: PW (HE)-Dump
Description: N/A
Symbol:
Value: 20747
Label: PW (HE)-Fire
Description: N/A
Symbol:
Value: 20751
Label: PW (HE)-Heavy Equipment
Description: N/A
Symbol:
Value: 10203
Label: PW (HE)-Street Cleaning
Description: N/A
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
X ( type: esriFieldTypeDouble, alias: X )
Y ( type: esriFieldTypeDouble, alias: Y )
DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 , Coded Values: [PW (HE)-Demo: PW (HE)-Demo] , [PW (HE)-Ditch: PW (HE)-Ditch] , [PW (HE)-Dump: PW (HE)-Dump] , ...3 more... )
REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Open: Open] , [Closed: Closed] , [In Progress: In Progress] , ...3 more... )
REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [IMMEDIATE: IMMEDIATE] , [HIGH: HIGH] , [MODERATE: MODERATE] )
REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 , Coded Values: [HE351: HE351] , [HE352: HE352] , [HE353: HE353] , ...17 more... )
ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating , Coded Values: [1: Poor] , [2: Weak] , [3: Fair] , ...2 more... )
SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 , Coded Values: [OTHER: Please see Resolution Summary] , [TDOT - ROUTE: This street is maintained by the state through TDOT.] )
RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
CITY ( type: esriFieldTypeString, alias: City, length: 100 )
STATE ( type: esriFieldTypeString, alias: State, length: 50 )
POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
cd_name ( type: esriFieldTypeInteger, alias: Council District No )
cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
scd_name ( type: esriFieldTypeInteger, alias: Super District No )
scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
Reported_By ( type: esriFieldTypeString, alias: Reported By, length: 50 , Coded Values: [ADMIN: ADMINISTRATION] , [BUSINESS: BUSINESS] , [CNSTINSP: CONSTRUCTION INSPECTION] , ...22 more... )
Dispatch_Date ( type: esriFieldTypeDate, alias: Dispatch Date, length: 8 )
Action_Taken ( type: esriFieldTypeString, alias: Action Taken, length: 50 )
Barricade ( type: esriFieldTypeString, alias: Barricade, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Repair_Method ( type: esriFieldTypeString, alias: Repair Method, length: 50 )
Repaired_Date ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
Time_Received ( type: esriFieldTypeDate, alias: Time Received, length: 8 )
Length ( type: esriFieldTypeSmallInteger, alias: Length )
Width ( type: esriFieldTypeSmallInteger, alias: Width )
Depth ( type: esriFieldTypeSmallInteger, alias: Depth )
Size ( type: esriFieldTypeString, alias: Size, length: 50 )
No_Barricades ( type: esriFieldTypeSmallInteger, alias: No Barricades )
Barricade_Date ( type: esriFieldTypeDate, alias: Barricade Date, length: 8 )
State_Route ( type: esriFieldTypeString, alias: Barricade By, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Barricade_By_Radio_No ( type: esriFieldTypeSmallInteger, alias: Barricade By Radio No )
ReferredTo ( type: esriFieldTypeString, alias: Referred To, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ReferredFromNotes ( type: esriFieldTypeString, alias: Referred From Notes, length: 1000 )
ReferredContact ( type: esriFieldTypeString, alias: Referred Contact, length: 100 )
LoadsHauled ( type: esriFieldTypeDouble, alias: LoadsHauled )
TotalFeetCleaned ( type: esriFieldTypeDouble, alias: TotalFeetCleaned )
DitchName ( type: esriFieldTypeString, alias: DitchName, length: 50 )
WorkNotes ( type: esriFieldTypeString, alias: WorkNotes, length: 50 )
ReferredFrom ( type: esriFieldTypeString, alias: ReferredFrom, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ExpectedCompletionDate ( type: esriFieldTypeDate, alias: ExpectedCompletionDate, length: 8 )
DumpLocation ( type: esriFieldTypeString, alias: DumpLocation, length: 50 , Coded Values: [RANGE HILLS: RANGE HILLS] , [COLLINS: COLLINS] , [SCOTT: SCOTT] , ...2 more... )
BackHoeHours ( type: esriFieldTypeDouble, alias: BackHoeHours )
FrontEndLoaderHours ( type: esriFieldTypeDouble, alias: FrontEndLoaderHours )
DozerHours ( type: esriFieldTypeDouble, alias: DozerHours )
Start_Mile ( type: esriFieldTypeDouble, alias: Start_Mile )
End_Mile ( type: esriFieldTypeDouble, alias: End_Mile )
Total_Mile ( type: esriFieldTypeDouble, alias: Total_Mile )
SmallDozerHrs ( type: esriFieldTypeDouble, alias: SmallDozerHrs )
GreaseTrkHrs ( type: esriFieldTypeDouble, alias: GreaseTrkHrs )
TandemTrkHrs ( type: esriFieldTypeDouble, alias: TandemTrkHrs )
LowBoyHrs ( type: esriFieldTypeDouble, alias: LowBoyHrs )
MiniExcHrs ( type: esriFieldTypeDouble, alias: MiniExcHrs )
SkidSteerHrs ( type: esriFieldTypeDouble, alias: SkidSteerHrs )
GraderHrs ( type: esriFieldTypeDouble, alias: GraderHrs )
TrailerDumperHrs ( type: esriFieldTypeDouble, alias: TrailerDumperHrs )
WaterTrkHrs ( type: esriFieldTypeDouble, alias: WaterTrkHrs )
WheeledExcHrs ( type: esriFieldTypeDouble, alias: WheeledExcHrs )
TrkSteerHrs ( type: esriFieldTypeDouble, alias: TrkSteerHrs )
GroveCraneHrs ( type: esriFieldTypeDouble, alias: GroveCraneHrs )
BoatHrs ( type: esriFieldTypeDouble, alias: BoatHrs )
HydSeedHrs ( type: esriFieldTypeDouble, alias: HydSeedHrs )
HeavyOpHrs ( type: esriFieldTypeDouble, alias: HeavyOpHrs )
EquipOpHrs ( type: esriFieldTypeDouble, alias: EquipOpHrs )
TempHours ( type: esriFieldTypeDouble, alias: TempHours )
Cat349Hrs ( type: esriFieldTypeDouble, alias: Cat349Hrs )
CatCompactHrs ( type: esriFieldTypeDouble, alias: CatCompactHrs )
a3830TrctrHrs ( type: esriFieldTypeDouble, alias: a3830TrctrHrs )
BoomMowerHrs ( type: esriFieldTypeDouble, alias: BoomMowerHrs )
HEMechHrs ( type: esriFieldTypeDouble, alias: HEMechHrs )
BrbRoadRakeHrs ( type: esriFieldTypeDouble, alias: BrbRoadRakeHrs )
BobcatMiniHrs ( type: esriFieldTypeDouble, alias: BobcatMiniHrs )
GreaserHrs ( type: esriFieldTypeDouble, alias: GreaserHrs )
LeafVacHrs ( type: esriFieldTypeDouble, alias: LeafVacHrs )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 , Coded Values: [311: 311] , [Animal Shelter: Animal Shelter] , [CE Commercial: CE Commercial] , ...22 more... )
Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )

Types:

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

Layer: All Active from SCF (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Default Label:

UniqueValueInfos:

Value: 20748
Label: PW (HE)-Demo
Description: N/A
Symbol:
Value: 20749
Label: PW (HE)-Ditch
Description: N/A
Symbol:
Value: 20750
Label: PW (HE)-Dump
Description: N/A
Symbol:
Value: 20747
Label: PW (HE)-Fire
Description: N/A
Symbol:
Value: 20751
Label: PW (HE)-Heavy Equipment
Description: N/A
Symbol:
Value: 10203
Label: PW (HE)-Street Cleaning
Description: N/A
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
X ( type: esriFieldTypeDouble, alias: X )
Y ( type: esriFieldTypeDouble, alias: Y )
DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 , Coded Values: [PW (HE)-Demo: PW (HE)-Demo] , [PW (HE)-Ditch: PW (HE)-Ditch] , [PW (HE)-Dump: PW (HE)-Dump] , ...3 more... )
REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Open: Open] , [Closed: Closed] , [In Progress: In Progress] , ...3 more... )
REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [IMMEDIATE: IMMEDIATE] , [HIGH: HIGH] , [MODERATE: MODERATE] )
REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 , Coded Values: [HE351: HE351] , [HE352: HE352] , [HE353: HE353] , ...17 more... )
ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating , Coded Values: [1: Poor] , [2: Weak] , [3: Fair] , ...2 more... )
SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 , Coded Values: [OTHER: Please see Resolution Summary] , [TDOT - ROUTE: This street is maintained by the state through TDOT.] )
RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
CITY ( type: esriFieldTypeString, alias: City, length: 100 )
STATE ( type: esriFieldTypeString, alias: State, length: 50 )
POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
cd_name ( type: esriFieldTypeInteger, alias: Council District No )
cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
scd_name ( type: esriFieldTypeInteger, alias: Super District No )
scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
Reported_By ( type: esriFieldTypeString, alias: Reported By, length: 50 , Coded Values: [ADMIN: ADMINISTRATION] , [BUSINESS: BUSINESS] , [CNSTINSP: CONSTRUCTION INSPECTION] , ...22 more... )
Dispatch_Date ( type: esriFieldTypeDate, alias: Dispatch Date, length: 8 )
Action_Taken ( type: esriFieldTypeString, alias: Action Taken, length: 50 )
Barricade ( type: esriFieldTypeString, alias: Barricade, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Repair_Method ( type: esriFieldTypeString, alias: Repair Method, length: 50 )
Repaired_Date ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
Time_Received ( type: esriFieldTypeDate, alias: Time Received, length: 8 )
Length ( type: esriFieldTypeSmallInteger, alias: Length )
Width ( type: esriFieldTypeSmallInteger, alias: Width )
Depth ( type: esriFieldTypeSmallInteger, alias: Depth )
Size ( type: esriFieldTypeString, alias: Size, length: 50 )
No_Barricades ( type: esriFieldTypeSmallInteger, alias: No Barricades )
Barricade_Date ( type: esriFieldTypeDate, alias: Barricade Date, length: 8 )
State_Route ( type: esriFieldTypeString, alias: Barricade By, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Barricade_By_Radio_No ( type: esriFieldTypeSmallInteger, alias: Barricade By Radio No )
ReferredTo ( type: esriFieldTypeString, alias: Referred To, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ReferredFromNotes ( type: esriFieldTypeString, alias: Referred From Notes, length: 1000 )
ReferredContact ( type: esriFieldTypeString, alias: Referred Contact, length: 100 )
LoadsHauled ( type: esriFieldTypeDouble, alias: LoadsHauled )
TotalFeetCleaned ( type: esriFieldTypeDouble, alias: TotalFeetCleaned )
DitchName ( type: esriFieldTypeString, alias: DitchName, length: 50 )
WorkNotes ( type: esriFieldTypeString, alias: WorkNotes, length: 50 )
ReferredFrom ( type: esriFieldTypeString, alias: ReferredFrom, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ExpectedCompletionDate ( type: esriFieldTypeDate, alias: ExpectedCompletionDate, length: 8 )
DumpLocation ( type: esriFieldTypeString, alias: DumpLocation, length: 50 , Coded Values: [RANGE HILLS: RANGE HILLS] , [COLLINS: COLLINS] , [SCOTT: SCOTT] , ...2 more... )
BackHoeHours ( type: esriFieldTypeDouble, alias: BackHoeHours )
FrontEndLoaderHours ( type: esriFieldTypeDouble, alias: FrontEndLoaderHours )
DozerHours ( type: esriFieldTypeDouble, alias: DozerHours )
Start_Mile ( type: esriFieldTypeDouble, alias: Start_Mile )
End_Mile ( type: esriFieldTypeDouble, alias: End_Mile )
Total_Mile ( type: esriFieldTypeDouble, alias: Total_Mile )
SmallDozerHrs ( type: esriFieldTypeDouble, alias: SmallDozerHrs )
GreaseTrkHrs ( type: esriFieldTypeDouble, alias: GreaseTrkHrs )
TandemTrkHrs ( type: esriFieldTypeDouble, alias: TandemTrkHrs )
LowBoyHrs ( type: esriFieldTypeDouble, alias: LowBoyHrs )
MiniExcHrs ( type: esriFieldTypeDouble, alias: MiniExcHrs )
SkidSteerHrs ( type: esriFieldTypeDouble, alias: SkidSteerHrs )
GraderHrs ( type: esriFieldTypeDouble, alias: GraderHrs )
TrailerDumperHrs ( type: esriFieldTypeDouble, alias: TrailerDumperHrs )
WaterTrkHrs ( type: esriFieldTypeDouble, alias: WaterTrkHrs )
WheeledExcHrs ( type: esriFieldTypeDouble, alias: WheeledExcHrs )
TrkSteerHrs ( type: esriFieldTypeDouble, alias: TrkSteerHrs )
GroveCraneHrs ( type: esriFieldTypeDouble, alias: GroveCraneHrs )
BoatHrs ( type: esriFieldTypeDouble, alias: BoatHrs )
HydSeedHrs ( type: esriFieldTypeDouble, alias: HydSeedHrs )
HeavyOpHrs ( type: esriFieldTypeDouble, alias: HeavyOpHrs )
EquipOpHrs ( type: esriFieldTypeDouble, alias: EquipOpHrs )
TempHours ( type: esriFieldTypeDouble, alias: TempHours )
Cat349Hrs ( type: esriFieldTypeDouble, alias: Cat349Hrs )
CatCompactHrs ( type: esriFieldTypeDouble, alias: CatCompactHrs )
a3830TrctrHrs ( type: esriFieldTypeDouble, alias: a3830TrctrHrs )
BoomMowerHrs ( type: esriFieldTypeDouble, alias: BoomMowerHrs )
HEMechHrs ( type: esriFieldTypeDouble, alias: HEMechHrs )
BrbRoadRakeHrs ( type: esriFieldTypeDouble, alias: BrbRoadRakeHrs )
BobcatMiniHrs ( type: esriFieldTypeDouble, alias: BobcatMiniHrs )
GreaserHrs ( type: esriFieldTypeDouble, alias: GreaserHrs )
LeafVacHrs ( type: esriFieldTypeDouble, alias: LeafVacHrs )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 , Coded Values: [311: 311] , [Animal Shelter: Animal Shelter] , [CE Commercial: CE Commercial] , ...22 more... )
Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )

Types:

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

Layer: All Heavy Equipment Service Requests (2)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Default Label:

UniqueValueInfos:

Value: 20748
Label: PW (HE)-Demo
Description: N/A
Symbol:
Value: 20749
Label: PW (HE)-Ditch
Description: N/A
Symbol:
Value: 20750
Label: PW (HE)-Dump
Description: N/A
Symbol:
Value: 20747
Label: PW (HE)-Fire
Description: N/A
Symbol:
Value: 20751
Label: PW (HE)-Heavy Equipment
Description: N/A
Symbol:
Value: 10203
Label: PW (HE)-Street Cleaning
Description: N/A
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
X ( type: esriFieldTypeDouble, alias: X )
Y ( type: esriFieldTypeDouble, alias: Y )
DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 , Coded Values: [PW (HE)-Demo: PW (HE)-Demo] , [PW (HE)-Ditch: PW (HE)-Ditch] , [PW (HE)-Dump: PW (HE)-Dump] , ...3 more... )
REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Open: Open] , [Closed: Closed] , [In Progress: In Progress] , ...3 more... )
REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [IMMEDIATE: IMMEDIATE] , [HIGH: HIGH] , [MODERATE: MODERATE] )
REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 , Coded Values: [HE351: HE351] , [HE352: HE352] , [HE353: HE353] , ...17 more... )
ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating , Coded Values: [1: Poor] , [2: Weak] , [3: Fair] , ...2 more... )
SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 , Coded Values: [OTHER: Please see Resolution Summary] , [TDOT - ROUTE: This street is maintained by the state through TDOT.] )
RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
CITY ( type: esriFieldTypeString, alias: City, length: 100 )
STATE ( type: esriFieldTypeString, alias: State, length: 50 )
POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
cd_name ( type: esriFieldTypeInteger, alias: Council District No )
cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
scd_name ( type: esriFieldTypeInteger, alias: Super District No )
scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
Reported_By ( type: esriFieldTypeString, alias: Reported By, length: 50 , Coded Values: [ADMIN: ADMINISTRATION] , [BUSINESS: BUSINESS] , [CNSTINSP: CONSTRUCTION INSPECTION] , ...22 more... )
Dispatch_Date ( type: esriFieldTypeDate, alias: Dispatch Date, length: 8 )
Action_Taken ( type: esriFieldTypeString, alias: Action Taken, length: 50 )
Barricade ( type: esriFieldTypeString, alias: Barricade, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Repair_Method ( type: esriFieldTypeString, alias: Repair Method, length: 50 )
Repaired_Date ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
Time_Received ( type: esriFieldTypeDate, alias: Time Received, length: 8 )
Length ( type: esriFieldTypeSmallInteger, alias: Length )
Width ( type: esriFieldTypeSmallInteger, alias: Width )
Depth ( type: esriFieldTypeSmallInteger, alias: Depth )
Size ( type: esriFieldTypeString, alias: Size, length: 50 )
No_Barricades ( type: esriFieldTypeSmallInteger, alias: No Barricades )
Barricade_Date ( type: esriFieldTypeDate, alias: Barricade Date, length: 8 )
State_Route ( type: esriFieldTypeString, alias: Barricade By, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Barricade_By_Radio_No ( type: esriFieldTypeSmallInteger, alias: Barricade By Radio No )
ReferredTo ( type: esriFieldTypeString, alias: Referred To, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ReferredFromNotes ( type: esriFieldTypeString, alias: Referred From Notes, length: 1000 )
ReferredContact ( type: esriFieldTypeString, alias: Referred Contact, length: 100 )
LoadsHauled ( type: esriFieldTypeDouble, alias: LoadsHauled )
TotalFeetCleaned ( type: esriFieldTypeDouble, alias: TotalFeetCleaned )
DitchName ( type: esriFieldTypeString, alias: DitchName, length: 50 )
WorkNotes ( type: esriFieldTypeString, alias: WorkNotes, length: 50 )
ReferredFrom ( type: esriFieldTypeString, alias: ReferredFrom, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ExpectedCompletionDate ( type: esriFieldTypeDate, alias: ExpectedCompletionDate, length: 8 )
DumpLocation ( type: esriFieldTypeString, alias: DumpLocation, length: 50 , Coded Values: [RANGE HILLS: RANGE HILLS] , [COLLINS: COLLINS] , [SCOTT: SCOTT] , ...2 more... )
BackHoeHours ( type: esriFieldTypeDouble, alias: BackHoeHours )
FrontEndLoaderHours ( type: esriFieldTypeDouble, alias: FrontEndLoaderHours )
DozerHours ( type: esriFieldTypeDouble, alias: DozerHours )
Start_Mile ( type: esriFieldTypeDouble, alias: Start_Mile )
End_Mile ( type: esriFieldTypeDouble, alias: End_Mile )
Total_Mile ( type: esriFieldTypeDouble, alias: Total_Mile )
SmallDozerHrs ( type: esriFieldTypeDouble, alias: SmallDozerHrs )
GreaseTrkHrs ( type: esriFieldTypeDouble, alias: GreaseTrkHrs )
TandemTrkHrs ( type: esriFieldTypeDouble, alias: TandemTrkHrs )
LowBoyHrs ( type: esriFieldTypeDouble, alias: LowBoyHrs )
MiniExcHrs ( type: esriFieldTypeDouble, alias: MiniExcHrs )
SkidSteerHrs ( type: esriFieldTypeDouble, alias: SkidSteerHrs )
GraderHrs ( type: esriFieldTypeDouble, alias: GraderHrs )
TrailerDumperHrs ( type: esriFieldTypeDouble, alias: TrailerDumperHrs )
WaterTrkHrs ( type: esriFieldTypeDouble, alias: WaterTrkHrs )
WheeledExcHrs ( type: esriFieldTypeDouble, alias: WheeledExcHrs )
TrkSteerHrs ( type: esriFieldTypeDouble, alias: TrkSteerHrs )
GroveCraneHrs ( type: esriFieldTypeDouble, alias: GroveCraneHrs )
BoatHrs ( type: esriFieldTypeDouble, alias: BoatHrs )
HydSeedHrs ( type: esriFieldTypeDouble, alias: HydSeedHrs )
HeavyOpHrs ( type: esriFieldTypeDouble, alias: HeavyOpHrs )
EquipOpHrs ( type: esriFieldTypeDouble, alias: EquipOpHrs )
TempHours ( type: esriFieldTypeDouble, alias: TempHours )
Cat349Hrs ( type: esriFieldTypeDouble, alias: Cat349Hrs )
CatCompactHrs ( type: esriFieldTypeDouble, alias: CatCompactHrs )
a3830TrctrHrs ( type: esriFieldTypeDouble, alias: a3830TrctrHrs )
BoomMowerHrs ( type: esriFieldTypeDouble, alias: BoomMowerHrs )
HEMechHrs ( type: esriFieldTypeDouble, alias: HEMechHrs )
BrbRoadRakeHrs ( type: esriFieldTypeDouble, alias: BrbRoadRakeHrs )
BobcatMiniHrs ( type: esriFieldTypeDouble, alias: BobcatMiniHrs )
GreaserHrs ( type: esriFieldTypeDouble, alias: GreaserHrs )
LeafVacHrs ( type: esriFieldTypeDouble, alias: LeafVacHrs )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 , Coded Values: [311: 311] , [Animal Shelter: Animal Shelter] , [CE Commercial: CE Commercial] , ...22 more... )
Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )

Types:

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

Layer: Heavy Equipment Street Groups (3)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: true

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
ASSETID ( type: esriFieldTypeInteger, alias: AssetID )
ASSET_STATUS ( type: esriFieldTypeString, alias: Asset Status, length: 10 )
SUM_CALC_LANE_MILES ( type: esriFieldTypeDouble, alias: Calculated Lane Miles )
ASSET_NOTES ( type: esriFieldTypeString, alias: Asset Notes, length: 1000 )
SERVICE_BY ( type: esriFieldTypeString, alias: Serviced By, length: 50 )
GRID_NAME ( type: esriFieldTypeString, alias: Grid Name, length: 50 )
ASSETRP_NAME ( type: esriFieldTypeString, alias: Responsible Party Name, length: 50 )
ASSETRP_ADDRESS ( type: esriFieldTypeString, alias: Responsible Party Address, length: 50 )
ASSETRP_CITY ( type: esriFieldTypeString, alias: Responsible Party City, length: 50 )
ASSETRP_PHONE ( type: esriFieldTypeString, alias: Responsible Party Phone, length: 50 )
ASSETRP_STATE ( type: esriFieldTypeString, alias: Responsible Party State, length: 50 )
ASSETRP_ZIP ( type: esriFieldTypeString, alias: Responsible Party Zip, length: 50 )
ASSET_CREATIONDATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
LASTMODIFIEDDATE ( type: esriFieldTypeDate, alias: Last Modified Date, length: 8 )
ZIP_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 60 )
MAP_PAGE ( type: esriFieldTypeString, alias: Map Page, length: 50 )
MAP_BLOCK ( type: esriFieldTypeString, alias: Map Block, length: 50 )
X_LONG ( type: esriFieldTypeDouble, alias: X_LONG )
Y_LAT ( type: esriFieldTypeDouble, alias: Y_LAT )
STATE_ROUTE ( type: esriFieldTypeString, alias: State Route, length: 20 )
TDOT_CLASSIFICATION ( type: esriFieldTypeString, alias: TDOT Classification, length: 50 )
CFCC ( type: esriFieldTypeString, alias: CFCC, length: 3 )
CLASSIFICATION ( type: esriFieldTypeString, alias: Classification, length: 150 )
COUNCIL_DISTRICT ( type: esriFieldTypeSmallInteger, alias: CouncilDist. )
MTFCC ( type: esriFieldTypeString, alias: MTFCC, length: 5 )
SUBNAME ( type: esriFieldTypeString, alias: Neighborhood, length: 50 )
ZONE ( type: esriFieldTypeString, alias: Sweeper Zone, length: 50 )
SM_ZONE ( type: esriFieldTypeString, alias: Street Maint Zone, length: 10 )
SM_GRID ( type: esriFieldTypeSmallInteger, alias: Street Maint Grid )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
ASSET_NAME ( type: esriFieldTypeString, alias: Asset Name, length: 100 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Relationships:

Groups to Maint (0) -- Related To: Heavy Equip Maint Table (5)

Layer: All Active Service Requests for Followup (4)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Default Label:

UniqueValueInfos:

Value: 20748
Label: PW (HE)-Demo
Description: N/A
Symbol:
Value: 20749
Label: PW (HE)-Ditch
Description: N/A
Symbol:
Value: 20750
Label: PW (HE)-Dump
Description: N/A
Symbol:
Value: 20747
Label: PW (HE)-Fire
Description: N/A
Symbol:
Value: 20751
Label: PW (HE)-Heavy Equipment
Description: N/A
Symbol:
Value: 10203
Label: PW (HE)-Street Cleaning
Description: N/A
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
X ( type: esriFieldTypeDouble, alias: X )
Y ( type: esriFieldTypeDouble, alias: Y )
DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 , Coded Values: [PW (HE)-Demo: PW (HE)-Demo] , [PW (HE)-Ditch: PW (HE)-Ditch] , [PW (HE)-Dump: PW (HE)-Dump] , ...3 more... )
REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Open: Open] , [Closed: Closed] , [In Progress: In Progress] , ...3 more... )
REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [IMMEDIATE: IMMEDIATE] , [HIGH: HIGH] , [MODERATE: MODERATE] )
REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 , Coded Values: [HE351: HE351] , [HE352: HE352] , [HE353: HE353] , ...17 more... )
ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 , Coded Values: [BECTON.PAULA: Paula Becton] , [SHIPP.JERRY: Jerry Shipp] , [LANE.ARTHUR: Arthur Lane] , ...10 more... )
NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating , Coded Values: [1: Poor] , [2: Weak] , [3: Fair] , ...2 more... )
SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 , Coded Values: [OTHER: Please see Resolution Summary] , [TDOT - ROUTE: This street is maintained by the state through TDOT.] )
RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
CITY ( type: esriFieldTypeString, alias: City, length: 100 )
STATE ( type: esriFieldTypeString, alias: State, length: 50 )
POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
cd_name ( type: esriFieldTypeInteger, alias: Council District No )
cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
scd_name ( type: esriFieldTypeInteger, alias: Super District No )
scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
Reported_By ( type: esriFieldTypeString, alias: Reported By, length: 50 , Coded Values: [ADMIN: ADMINISTRATION] , [BUSINESS: BUSINESS] , [CNSTINSP: CONSTRUCTION INSPECTION] , ...22 more... )
Dispatch_Date ( type: esriFieldTypeDate, alias: Dispatch Date, length: 8 )
Action_Taken ( type: esriFieldTypeString, alias: Action Taken, length: 50 )
Barricade ( type: esriFieldTypeString, alias: Barricade, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Repair_Method ( type: esriFieldTypeString, alias: Repair Method, length: 50 )
Repaired_Date ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
Time_Received ( type: esriFieldTypeDate, alias: Time Received, length: 8 )
Length ( type: esriFieldTypeSmallInteger, alias: Length )
Width ( type: esriFieldTypeSmallInteger, alias: Width )
Depth ( type: esriFieldTypeSmallInteger, alias: Depth )
Size ( type: esriFieldTypeString, alias: Size, length: 50 )
No_Barricades ( type: esriFieldTypeSmallInteger, alias: No Barricades )
Barricade_Date ( type: esriFieldTypeDate, alias: Barricade Date, length: 8 )
State_Route ( type: esriFieldTypeString, alias: Barricade By, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
Barricade_By_Radio_No ( type: esriFieldTypeSmallInteger, alias: Barricade By Radio No )
ReferredTo ( type: esriFieldTypeString, alias: Referred To, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ReferredFromNotes ( type: esriFieldTypeString, alias: Referred From Notes, length: 1000 )
ReferredContact ( type: esriFieldTypeString, alias: Referred Contact, length: 100 )
LoadsHauled ( type: esriFieldTypeDouble, alias: LoadsHauled )
TotalFeetCleaned ( type: esriFieldTypeDouble, alias: TotalFeetCleaned )
DitchName ( type: esriFieldTypeString, alias: DitchName, length: 50 )
WorkNotes ( type: esriFieldTypeString, alias: WorkNotes, length: 50 )
ReferredFrom ( type: esriFieldTypeString, alias: ReferredFrom, length: 50 , Coded Values: [ANIMALCONTROL: ANIMAL CONTROL] , [CODE: CODE ENFORCEMENT] , [CONST: CONSTRUCTION INSPECTION] , ...21 more... )
ExpectedCompletionDate ( type: esriFieldTypeDate, alias: ExpectedCompletionDate, length: 8 )
DumpLocation ( type: esriFieldTypeString, alias: DumpLocation, length: 50 , Coded Values: [RANGE HILLS: RANGE HILLS] , [COLLINS: COLLINS] , [SCOTT: SCOTT] , ...2 more... )
BackHoeHours ( type: esriFieldTypeDouble, alias: BackHoeHours )
FrontEndLoaderHours ( type: esriFieldTypeDouble, alias: FrontEndLoaderHours )
DozerHours ( type: esriFieldTypeDouble, alias: DozerHours )
Start_Mile ( type: esriFieldTypeDouble, alias: Start_Mile )
End_Mile ( type: esriFieldTypeDouble, alias: End_Mile )
Total_Mile ( type: esriFieldTypeDouble, alias: Total_Mile )
SmallDozerHrs ( type: esriFieldTypeDouble, alias: SmallDozerHrs )
GreaseTrkHrs ( type: esriFieldTypeDouble, alias: GreaseTrkHrs )
TandemTrkHrs ( type: esriFieldTypeDouble, alias: TandemTrkHrs )
LowBoyHrs ( type: esriFieldTypeDouble, alias: LowBoyHrs )
MiniExcHrs ( type: esriFieldTypeDouble, alias: MiniExcHrs )
SkidSteerHrs ( type: esriFieldTypeDouble, alias: SkidSteerHrs )
GraderHrs ( type: esriFieldTypeDouble, alias: GraderHrs )
TrailerDumperHrs ( type: esriFieldTypeDouble, alias: TrailerDumperHrs )
WaterTrkHrs ( type: esriFieldTypeDouble, alias: WaterTrkHrs )
WheeledExcHrs ( type: esriFieldTypeDouble, alias: WheeledExcHrs )
TrkSteerHrs ( type: esriFieldTypeDouble, alias: TrkSteerHrs )
GroveCraneHrs ( type: esriFieldTypeDouble, alias: GroveCraneHrs )
BoatHrs ( type: esriFieldTypeDouble, alias: BoatHrs )
HydSeedHrs ( type: esriFieldTypeDouble, alias: HydSeedHrs )
HeavyOpHrs ( type: esriFieldTypeDouble, alias: HeavyOpHrs )
EquipOpHrs ( type: esriFieldTypeDouble, alias: EquipOpHrs )
TempHours ( type: esriFieldTypeDouble, alias: TempHours )
Cat349Hrs ( type: esriFieldTypeDouble, alias: Cat349Hrs )
CatCompactHrs ( type: esriFieldTypeDouble, alias: CatCompactHrs )
a3830TrctrHrs ( type: esriFieldTypeDouble, alias: a3830TrctrHrs )
BoomMowerHrs ( type: esriFieldTypeDouble, alias: BoomMowerHrs )
HEMechHrs ( type: esriFieldTypeDouble, alias: HEMechHrs )
BrbRoadRakeHrs ( type: esriFieldTypeDouble, alias: BrbRoadRakeHrs )
BobcatMiniHrs ( type: esriFieldTypeDouble, alias: BobcatMiniHrs )
GreaserHrs ( type: esriFieldTypeDouble, alias: GreaserHrs )
LeafVacHrs ( type: esriFieldTypeDouble, alias: LeafVacHrs )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 , Coded Values: [311: 311] , [Animal Shelter: Animal Shelter] , [CE Commercial: CE Commercial] , ...22 more... )
Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )

Types:

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

REC_EDIT_MODE:
Inherited
REQUEST_TYPE:
Inherited
REQUEST_STATUS:
Inherited
REQUEST_PRIORITY:
Inherited
CREATED_BY_USER:
Inherited
UPDATED_BY_USER:
Inherited
ASSIGNED_TO:
Inherited
SUPERVISOR:
Inherited
QAQC_YESNO:
Inherited
QAQC_RATING:
Inherited
SUPERVISOR_APPROVAL:
Inherited
RESOLUTION_CODE:
Inherited
MAP_PG:
Inherited
MAP_BLK:
Inherited
GRID_NO:
Inherited
CODE_DISTRICT:
Inherited
CODE_SUBDISTRICT:
Inherited
TARGET_BLOCK:
Inherited
SWM_AREA:
Inherited
SWM_ZONE:
Inherited
COLLECTION_DAY:
Inherited
MLGW_STATUS:
Inherited
SWF_RATE:
Inherited
SWF_STATUS:
Inherited
Reported_By:
Inherited
Barricade:
Inherited
State_Route:
Inherited
ReferredTo:
Inherited
ReferredFrom:
Inherited
DumpLocation:
Inherited
Transfer:
Inherited
Transfer_Dept:
Inherited

Tables:

Table: Heavy Equip Maint Table (5)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, length: 150 )
INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID )
INCIDENT_NUMBER ( type: esriFieldTypeString, alias: INCIDENT_NUMBER, length: 100 )
INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: INCIDENT_TYPE_ID )
TASK_TYPE_ID ( type: esriFieldTypeInteger, alias: Task Type ID )
TASK_ID ( type: esriFieldTypeInteger, alias: Task ID )
TASK_NUMBER ( type: esriFieldTypeString, alias: Task Number, length: 30 )
CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
CREATED_BY ( type: esriFieldTypeInteger, alias: Created By )
FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: FOLLOWUP_DATE, length: 8 )
TASK_TYPE ( type: esriFieldTypeString, alias: Task Type, length: 100 )
TASK_STATUS ( type: esriFieldTypeString, alias: Task Status, length: 50 , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [On Hold: On Hold] , ...1 more... )
TASK_PRIORITY ( type: esriFieldTypeString, alias: Task Priority, length: 25 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
TASK_OWNER ( type: esriFieldTypeString, alias: Task Owner, length: 255 )
TASK_ASSIGNEE ( type: esriFieldTypeString, alias: Task Assignee, length: 255 )
TASK_ASSIGNMENT_ID ( type: esriFieldTypeString, alias: TASK_ASSIGNMENT_ID, length: 50 )
ASSIGNEE_STATUS ( type: esriFieldTypeString, alias: Assignee Status, length: 50 )
TASK_SUBJECT ( type: esriFieldTypeString, alias: Task Subject, length: 255 )
TASK_NOTES ( type: esriFieldTypeString, alias: Task Notes, length: 255 )
PLANNED_START_DATE ( type: esriFieldTypeDate, alias: Planned Start Date, length: 8 )
PLANNED_END_DATE ( type: esriFieldTypeDate, alias: Planned End Date, length: 8 )
SCHEDULED_START_DATE ( type: esriFieldTypeDate, alias: Scheduled Start Date, length: 8 )
SCHEDULED_END_DATE ( type: esriFieldTypeDate, alias: Scheduled End Date, length: 8 )
ACTUAL_START_DATE ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
ACTUAL_END_DATE ( type: esriFieldTypeDate, alias: Actual End Date, length: 8 )
PLANNED_EFFORT ( type: esriFieldTypeDouble, alias: PLANNED_EFFORT )
PLANNED_EFFORT_UOM ( type: esriFieldTypeString, alias: PLANNED_EFFORT_UOM, length: 10 )
ACTUAL_EFFORT ( type: esriFieldTypeDouble, alias: ACTUAL_EFFORT )
ACTUAL_EFFORT_UOM ( type: esriFieldTypeString, alias: ACTUAL_EFFORT_UOM, length: 10 )
DURATION ( type: esriFieldTypeDouble, alias: Days Old )
DURATION_UOM ( type: esriFieldTypeString, alias: DURATION_UOM, length: 10 )
ADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 100 )
REC_EDIT_MODE ( type: esriFieldTypeString, alias: Send to Oracle: Change to Manual, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 50 )
LOADS_HAULED ( type: esriFieldTypeDouble, alias: Loads Hauled )
TOTAL_FEET ( type: esriFieldTypeDouble, alias: Total Feet )
TOTAL_HOURS ( type: esriFieldTypeDouble, alias: Total Hours )
EQUIPMENT ( type: esriFieldTypeString, alias: Equipment, length: 100 )
START_MILES ( type: esriFieldTypeDouble, alias: Start Miles )
END_MILES ( type: esriFieldTypeDouble, alias: End Miles )
TOTAL_MILES ( type: esriFieldTypeDouble, alias: Total Miles )
ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
ASSET_GUID ( type: esriFieldTypeGUID, alias: ASSET_GUID, length: 38 )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
CREW_NUMBER ( type: esriFieldTypeString, alias: Crew Number, length: 50 )

Relationships:

Maint to Groups (0) -- Related To: Heavy Equipment Street Groups (3)