{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "TimeKeeper", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "RequestMaintenance", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 1, "name": "RequestMaintenance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 2, "name": "RequestMaintenance", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 3, "name": "RequestMaintenance", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 4, "name": "RequestMaintenance", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" }, { "id": 5, "name": "RequestMaintenance", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WO_Guid", "composite": false, "catalogID": "{E24E13CB-31C6-4980-BE7C-0407C53094E8}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "AssignedTo", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "Assigned To", "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" }, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "EMP_ID" }, { "name": "REGULAR_HRS", "type": "esriFieldTypeDouble", "alias": "Regular Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REGULAR_HRS" }, { "name": "OVERTIME_HRS", "type": "esriFieldTypeDouble", "alias": "Overtime Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERTIME_HRS" }, { "name": "WORKORDERID", "type": "esriFieldTypeInteger", "alias": "Work Order ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "CHECKIN_DATE", "type": "esriFieldTypeDate", "alias": "Work Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CHECKIN_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "WO_Guid", "type": "esriFieldTypeGUID", "alias": "WO_Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "WO_Guid" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "TimeKeeper", "description": "", "prototype": { "attributes": { "WO_Guid": null, "CHECKIN_DATE": null, "AssignedTo": null, "REGULAR_HRS": null, "OVERTIME_HRS": null, "WORKORDERID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ea3a4c83428e488390521c23ea5cd96d" }