{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "TimeKeeper", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssignedTo", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "Assigned To", "length": 150, "domain": { "type": "codedValue", "name": "PMS_AssignedTo", "description": "PMS Assigned To", "codedValues": [ { "name": "Allison, Cary (Heavy Equipment)", "code": "Allison, Cary (Heavy Equipment)" }, { "name": "Antwine, Eyitayo (Building Maint. Mech)", "code": "Antwine, Eyitayo (Building Maint. Mech)" }, { "name": "Avery, Jamie (Part Time)", "code": "Avery, Jamie (Part Time)" }, { "name": "Barrett, Justin (Part Time)", "code": "Barrett, Justin (Part Time)" }, { "name": "Beaty, Phillip (Electrician)", "code": "Beaty, Phillip (Electrician)" }, { "name": "Belk, Charles (Cement)", "code": "Belk, Charles (Cement)" }, { "name": "Bess, Bright (Craft Assistants)", "code": "Bess, Bright (Craft Assistants)" }, { "name": "Blaine, Cameron (Techs)", "code": "Blaine, Cameron (Techs)" }, { "name": "Blalock, James (Roofing)", "code": "Blalock, James (Roofing)" }, { "name": "Blalock, Madison (Carpenters)", "code": "Blalock, Madison (Carpenters)" }, { "name": "Bowden, Gregory (Truck Drivers)", "code": "Bowden, Gregory (Truck Drivers)" }, { "name": "Bowen, Bobby (Painters)", "code": "Bowen, Bobby (Painters)" }, { "name": "Broome, Timain (Painters)", "code": "Broome, Timain (Painters)" }, { "name": "Brown, Jerry (Carpenters)", "code": "Brown, Jerry (Carpenters)" }, { "name": "Bruce, Eshondra (Part Time)", "code": "Bruce, Eshondra (Part Time)" }, { "name": "Bryant, Marshall (Part Time)", "code": "Bryant, Marshall (Part Time)" }, { "name": "Buford, Shanika (Part Time)", "code": "Buford, Shanika (Part Time)" }, { "name": "Butler, Bobby (Carpenters)", "code": "Butler, Bobby (Carpenters)" }, { "name": "Carson, John (Electrician)", "code": "Carson, John (Electrician)" }, { "name": "Carter, Derrick (Painters)", "code": "Carter, Derrick (Painters)" }, { "name": "Clevers, Joe (Plumbers)", "code": "Clevers, Joe (Plumbers)" }, { "name": "Clevers, Joseph (Carpenters)", "code": "Clevers, Joseph (Carpenters)" }, { "name": "Combs, Masharne (Techs)", "code": "Combs, Masharne (Techs)" }, { "name": "Cox, Loretta (GSPM Foremen)", "code": "Cox, Loretta (GSPM Foremen)" }, { "name": "Cox,Loretta - Foreman (Grounds)", "code": "Cox,Loretta - Foreman (Grounds)" }, { "name": "Crawford, Steve (Plumbers)", "code": "Crawford, Steve (Plumbers)" }, { "name": "Daniels, Dwight (Plumbers)", "code": "Daniels, Dwight (Plumbers)" }, { "name": "Darius Graves (Part Time)", "code": "Darius Graves (Part Time)" }, { "name": "Derrick, Lindsey (Crew Chiefs)", "code": "Derrick, Lindsey (Crew Chiefs)" }, { "name": "Dilworth, Sharieff \u2013 Supervisor (Paint Shop)", "code": "Dilworth, Sharieff \u2013 Supervisor (Paint Shop)" }, { "name": "Divilbiss, Ronald (Heavy Equipment)", "code": "Divilbiss, Ronald (Heavy Equipment)" }, { "name": "Dolley, Trinity (Craft Assistants)", "code": "Dolley, Trinity (Craft Assistants)" }, { "name": "Doyle, Charles (GSPM Foremen)", "code": "Doyle, Charles (GSPM Foremen)" }, { "name": "Eric, Holloway (Part Time)", "code": "Eric, Holloway (Part Time)" }, { "name": "Eulls, Hugh (Building Maint. Mech)", "code": "Eulls, Hugh (Building Maint. Mech)" }, { "name": "Fields, Victor (Crew Chiefs)", "code": "Fields, Victor (Crew Chiefs)" }, { "name": "Fleming, Torianna (Crew Chiefs)", "code": "Fleming, Torianna (Crew Chiefs)" }, { "name": "Franklin, John (Crew Chiefs)", "code": "Franklin, John (Crew Chiefs)" }, { "name": "Freeman, Eddie (Painters)", "code": "Freeman, Eddie (Painters)" }, { "name": "Frierser, John (Truck Drivers)", "code": "Frierser, John (Truck Drivers)" }, { "name": "Garrett, Julius (Crew Chiefs)", "code": "Garrett, Julius (Crew Chiefs)" }, { "name": "Gray, Fredrick (Part Time)", "code": "Gray, Fredrick (Part Time)" }, { "name": "Gregory, Charles (Electrician)", "code": "Gregory, Charles (Electrician)" }, { "name": "Guffins, Arrious (Part Time)", "code": "Guffins, Arrious (Part Time)" }, { "name": "Hanks, Billy (Carpenters)", "code": "Hanks, Billy (Carpenters)" }, { "name": "Harper, Mario (Part Time)", "code": "Harper, Mario (Part Time)" }, { "name": "Harrold, James (Techs)", "code": "Harrold, James (Techs)" }, { "name": "Hathaway, Cleven (Craft Assistants)", "code": "Hathaway, Cleven (Craft Assistants)" }, { "name": "Hearn, Steven (Carpenters)", "code": "Hearn, Steven (Carpenters)" }, { "name": "Hill, Glenn (Building Maint. Mech)", "code": "Hill, Glenn (Building Maint. Mech)" }, { "name": "Holley, Paul (Carpenters)", "code": "Holley, Paul (Carpenters)" }, { "name": "Hull, Keith (Heavy Equipment)", "code": "Hull, Keith (Heavy Equipment)" }, { "name": "Hurd, Bernard (Truck Drivers)", "code": "Hurd, Bernard (Truck Drivers)" }, { "name": "Jackson, Fred (Masonry)", "code": "Jackson, Fred (Masonry)" }, { "name": "Johnson, Adrian (Cement)", "code": "Johnson, Adrian (Cement)" }, { "name": "Johnson, Andre (Part Time)", "code": "Johnson, Andre (Part Time)" }, { "name": "Johnson, Devon (Electrician)", "code": "Johnson, Devon (Electrician)" }, { "name": "Jones, Darrell (Carpenters)", "code": "Jones, Darrell (Carpenters)" }, { "name": "Jyule, Criss (Part Time)", "code": "Jyule, Criss (Part Time)" }, { "name": "Keaton, Metron - Craft Supervisor (Plumbing Shop)", "code": "Keaton, Metron - Craft Supervisor (Plumbing Shop)" }, { "name": "King, Joseph (Part Time)", "code": "King, Joseph (Part Time)" }, { "name": "Kohn, David (Painters)", "code": "Kohn, David (Painters)" }, { "name": "Lagrone, Howard (Plumbers)", "code": "Lagrone, Howard (Plumbers)" }, { "name": "Little, Jon (Carpenters)", "code": "Little, Jon (Carpenters)" }, { "name": "Logsdon, Stephen (Building Maint. Mech)", "code": "Logsdon, Stephen (Building Maint. Mech)" }, { "name": "Lurry, Barry (Part Time)", "code": "Lurry, Barry (Part Time)" }, { "name": "Manley, Michael (Roofing)", "code": "Manley, Michael (Roofing)" }, { "name": "Martin, Richard (Electrician)", "code": "Martin, Richard (Electrician)" }, { "name": "Matthews, Derico (Painters)", "code": "Matthews, Derico (Painters)" }, { "name": "McIntyre, Jaylun (Painters)", "code": "McIntyre, Jaylun (Painters)" }, { "name": "McKay, Kyree (Craft Assistants)", "code": "McKay, Kyree (Craft Assistants)" }, { "name": "Moore, Shawn (Plumbers)", "code": "Moore, Shawn (Plumbers)" }, { "name": "Munday, Earl - Craft Supervisor (Carpentry Shop)", "code": "Munday, Earl - Craft Supervisor (Carpentry Shop)" }, { "name": "Murray, Kenneth (Part Time)", "code": "Murray, Kenneth (Part Time)" }, { "name": "Nhem, Sim (Building Maint. Mech)", "code": "Nhem, Sim (Building Maint. Mech)" }, { "name": "Nuccio, Scott (Plumbers)", "code": "Nuccio, Scott (Plumbers)" }, { "name": "Nygaard, Tommy (Techs)", "code": "Nygaard, Tommy (Techs)" }, { "name": "Owens, Michael (Plumbers)", "code": "Owens, Michael (Plumbers)" }, { "name": "Parson, Cleo - Supervisor (Grounds)", "code": "Parson, Cleo - Supervisor (Grounds)" }, { "name": "Poole, Kevin (Crew Chiefs)", "code": "Poole, Kevin (Crew Chiefs)" }, { "name": "Porter, Michael (GSPM Foremen)", "code": "Porter, Michael (GSPM Foremen)" }, { "name": "Qualls, Micheal (Part Time)", "code": "Qualls, Micheal (Part Time)" }, { "name": "Riley, Brandon (Plumbers)", "code": "Riley, Brandon (Plumbers)" }, { "name": "Rodgers, Isaac (Truck Drivers)", "code": "Rodgers, Isaac (Truck Drivers)" }, { "name": "Rodgers, Michale (Keven) (Plumbers)", "code": "Rodgers, Michale (Keven) (Plumbers)" }, { "name": "Rooker, Thomas (Andy) (Plumbers)", "code": "Rooker, Thomas (Andy) (Plumbers)" }, { "name": "Rumsey, Chad (Techs)", "code": "Rumsey, Chad (Techs)" }, { "name": "Ryan, Julius (Plumbers)", "code": "Ryan, Julius (Plumbers)" }, { "name": "Sanders, Carl (Vince) (Techs)", "code": "Sanders, Carl (Vince) (Techs)" }, { "name": "Sao, Sima (Building Maint. Mech)", "code": "Sao, Sima (Building Maint. Mech)" }, { "name": "Scott, Devin (Part Time)", "code": "Scott, Devin (Part Time)" }, { "name": "Scott, William (Billy) (Techs)", "code": "Scott, William (Billy) (Techs)" }, { "name": "Sims, Desmond (Painters)", "code": "Sims, Desmond (Painters)" }, { "name": "Sledge, Allen (Part Time)", "code": "Sledge, Allen (Part Time)" }, { "name": "Slocum, Tyrese (Part Time)", "code": "Slocum, Tyrese (Part Time)" }, { "name": "Smith, Douglass (Carpenters)", "code": "Smith, Douglass (Carpenters)" }, { "name": "Smith, Victor (Carpenters)", "code": "Smith, Victor (Carpenters)" }, { "name": "Stagner, Jerry (Roofing)", "code": "Stagner, Jerry (Roofing)" }, { "name": "Stutes, Marshall (Carpenters)", "code": "Stutes, Marshall (Carpenters)" }, { "name": "Swift, Billy (Plumbers)", "code": "Swift, Billy (Plumbers)" }, { "name": "Tabb, Remarius (Part Time)", "code": "Tabb, Remarius (Part Time)" }, { "name": "Thornton, Phillip (Techs)", "code": "Thornton, Phillip (Techs)" }, { "name": "Todd, Louis - Supervisor (Grounds)", "code": "Todd, Louis - Supervisor (Grounds)" }, { "name": "Toliver, Ronnie (Painters)", "code": "Toliver, Ronnie (Painters)" }, { "name": "Townsend, Brian (Masonry)", "code": "Townsend, Brian (Masonry)" }, { "name": "Turner,Tim (Techs)", "code": "Turner,Tim (Techs)" }, { "name": "Underhill, Tony (Techs)", "code": "Underhill, Tony (Techs)" }, { "name": "Vanzant, David - Craft Supervisor (Electrical Shop)", "code": "Vanzant, David - Craft Supervisor (Electrical Shop)" }, { "name": "Viraxay, Xiong (Sai) (Techs)", "code": "Viraxay, Xiong (Sai) (Techs)" }, { "name": "Wansley, Stuart (Building Maint. Mech)", "code": "Wansley, Stuart (Building Maint. Mech)" }, { "name": "Warner, Wesley (GSPM Foremen)", "code": "Warner, Wesley (GSPM Foremen)" }, { "name": "Webster, John (Truck Drivers)", "code": "Webster, John (Truck Drivers)" }, { "name": "Wilhite, Devin (Plumbers)", "code": "Wilhite, Devin (Plumbers)" }, { "name": "Williams, Brandi (Truck Drivers)", "code": "Williams, Brandi (Truck Drivers)" }, { "name": "Williams, Marcus (Truck Drivers)", "code": "Williams, Marcus (Truck Drivers)" }, { "name": "Yale, Thomas (Plumbers)", "code": "Yale, Thomas (Plumbers)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REGULAR_HRS", "type": "esriFieldTypeDouble", "alias": "Regular Hours", "domain": null }, { "name": "OVERTIME_HRS", "type": "esriFieldTypeDouble", "alias": "Overtime Hours", "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeInteger", "alias": "Work Order ID", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CHECKIN_DATE", "type": "esriFieldTypeDate", "alias": "Work Date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "WO_Guid", "type": "esriFieldTypeGUID", "alias": "WO_Guid", "length": 38, "domain": null } ], "indexes": [ { "name": "R161_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_161", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G748WO_Guid", "fields": "WO_Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "RequestMaintenance", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WO_Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 1, "name": "RequestMaintenance", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "WO_Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 2, "name": "RequestMaintenance", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "WO_Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "b6a6229f24e0465ab9c100aea4c05738" }