{ "Data": { "Name": "Employee Details Report Analytics API", "Description": "Displays employee details, such as their manager, hire date, birth date, job, department, status, pay type, pay class, and employee group by an as of date.", "XRefCode": "EmployeeDetailsReportAnalyticsAPI", "ReportId": 4610, "MaxRows": 10000000, "OnlyIncludeUniqueRecords": true, "Columns": [ { "Name": "Location", "Description": "Short name for a location; i.e. ABL, Headquarters", "DataType": "Reference" }, { "Name": "Employee", "Description": "Displays both the employee name and number", "DataType": "String" }, { "Name": "Manager", "Description": "Displays both the manager name and number", "DataType": "String" }, { "Name": "Hire Date", "Description": "Date upon which an employee was hired; may be a rehire date", "DataType": "Date" }, { "Name": "Birth Month Day", "Description": "Displays the month and day the employee was born", "DataType": "String" }, { "Name": "Job", "Description": "Short name for a job; Regional Dir., Asst Manager", "DataType": "Reference" }, { "Name": "Department", "Description": "Short name for the department(s) the employee works in; i.e. S;HW", "DataType": "Reference" }, { "Name": "Status", "Description": "Short name for an employment status group; Active; Termed", "DataType": "Reference" }, { "Name": "Pay Type", "Description": "Short name for a pay type; Hr (Exempt); Sal (Non-exempt)", "DataType": "Reference" }, { "Name": "Pay Class", "Description": "Short name for a pay class; FT; Temp", "DataType": "Reference" }, { "Name": "Employee Group", "Description": "Short name for an employee group; i.e. AHMS/GSO; NNY", "DataType": "Reference" } ], "Filters": [ { "Name": "Employee Display Name", "Description": "Display name for an employee", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 1 }, { "Name": "Primary Work Assignment", "Description": "Designates if work assignment is employee's primary work assignment; true or false", "DataType": "Boolean", "Operator": "=", "IsRequired": true, "Value": "True", "Editable": true, "Sequence": 2 }, { "Name": "Status", "Description": "Short name for an employment status group; Active; Termed", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "1,4", "Editable": true, "Sequence": 3, "AvailableValues": [ { "ListValueId": 1, "Name": "Active" }, { "ListValueId": 2, "Name": "Inactive" }, { "ListValueId": 3, "Name": "Terminated" }, { "ListValueId": 4, "Name": "Pre-Start" } ] }, { "Name": "Birth Month Day", "Description": "Displays the month and day the employee was born", "DataType": "String", "Operator": "=", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 4 }, { "Name": "Hire Date", "Description": "Date upon which an employee was hired; may be a rehire date", "DataType": "Date", "Operator": "<=", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 5 }, { "Name": "Hire Date", "Description": "Date upon which an employee was hired; may be a rehire date", "DataType": "Date", "Operator": ">=", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 6 }, { "Name": "Location", "Description": "Short name for a location; i.e. ABL, Headquarters", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 7, "AvailableValues": [ { "ListValueId": 1000, "Name": "prd-500b-2018--01-29" }, { "ListValueId": 1019, "Name": "Retail Co. USA" }, { "ListValueId": 1020, "Name": "District 1" }, { "ListValueId": 1021, "Name": "District 2" }, { "ListValueId": 1023, "Name": "Store 118" }, { "ListValueId": 1024, "Name": "Store 118 - Accessories" }, { "ListValueId": 1025, "Name": "Store 118 - Mens" }, { "ListValueId": 1026, "Name": "Store 118 - Footwear" }, { "ListValueId": 1027, "Name": "Store 118 - Womens" }, { "ListValueId": 1028, "Name": "Store 118 - Management" }, { "ListValueId": 1029, "Name": "Store 118 - Receiving" }, { "ListValueId": 1030, "Name": "Store 113" }, { "ListValueId": 1031, "Name": "Store 113 - Accessories" }, { "ListValueId": 1032, "Name": "Store 113 - Mens" }, { "ListValueId": 1033, "Name": "Store 113 - Footwear" }, { "ListValueId": 1034, "Name": "Store 113 - Womens" }, { "ListValueId": 1035, "Name": "Store 113 - Management" }, { "ListValueId": 1036, "Name": "Store 113 - Receiving" }, { "ListValueId": 1037, "Name": "Store 110" }, { "ListValueId": 1038, "Name": "Store 110 - Accessories" }, { "ListValueId": 1039, "Name": "Store 110 - Mens" }, { "ListValueId": 1040, "Name": "Store 110 - Logistics" }, { "ListValueId": 1041, "Name": "Store 110 - Footwear" }, { "ListValueId": 1042, "Name": "Store 110 - Womens" }, { "ListValueId": 1043, "Name": "Store 110 - Management" }, { "ListValueId": 1044, "Name": "Store 110 - Receiving" }, { "ListValueId": 1045, "Name": "Store 105" }, { "ListValueId": 1046, "Name": "Store 105 - Accessories" }, { "ListValueId": 1047, "Name": "Store 105 - Mens" }, { "ListValueId": 1048, "Name": "Store 105 - Footwear" }, { "ListValueId": 1049, "Name": "Store 105 - Womens" }, { "ListValueId": 1050, "Name": "Store 105 - Management" }, { "ListValueId": 1051, "Name": "Store 105 - Receiving" }, { "ListValueId": 1052, "Name": "Store 120" }, { "ListValueId": 1053, "Name": "Store 120 - Accessories" }, { "ListValueId": 1054, "Name": "Store 120 - Mens" }, { "ListValueId": 1055, "Name": "Store 120 - Footwear" }, { "ListValueId": 1056, "Name": "Store 120 - Womens" }, { "ListValueId": 1057, "Name": "Store 120 - Management" }, { "ListValueId": 1058, "Name": "Store 120 - Receiving" }, { "ListValueId": 1059, "Name": "Store 125" }, { "ListValueId": 1060, "Name": "Store 125 - Accessories" }, { "ListValueId": 1061, "Name": "Store 125 - Mens" }, { "ListValueId": 1062, "Name": "Store 125 - Footwear" }, { "ListValueId": 1063, "Name": "Store 125 - Womens" }, { "ListValueId": 1064, "Name": "Store 125 - Management" }, { "ListValueId": 1065, "Name": "Store 125 - Receiving" }, { "ListValueId": 1066, "Name": "Store 999" }, { "ListValueId": 1067, "Name": "Store 999 - Accessories" }, { "ListValueId": 1068, "Name": "Store 999 - Mens" }, { "ListValueId": 1069, "Name": "Store 999 - Womens" }, { "ListValueId": 1070, "Name": "Store 999 - Management" }, { "ListValueId": 1071, "Name": "Store 999 - Receiving" }, { "ListValueId": 1072, "Name": "Store 999 - Footwear" }, { "ListValueId": 1073, "Name": "Manufacturing Co. USA" }, { "ListValueId": 1074, "Name": "District 01" }, { "ListValueId": 1076, "Name": "Plant 1" }, { "ListValueId": 1077, "Name": "Plant 1 - Assembly 1" }, { "ListValueId": 1078, "Name": "Plant 1 - Assembly 2" }, { "ListValueId": 1079, "Name": "Plant 1 - Maintenance" }, { "ListValueId": 1080, "Name": "Plant 1 - Management" }, { "ListValueId": 1081, "Name": "Plant 1 - Receiving" }, { "ListValueId": 1082, "Name": "Plant 1 - Packaging" }, { "ListValueId": 1083, "Name": "Financial Co. USA" }, { "ListValueId": 1084, "Name": "Bank 1" }, { "ListValueId": 1085, "Name": "Bank 1 - Admin" }, { "ListValueId": 1086, "Name": "Bank 1 - Commercial Lines" }, { "ListValueId": 1087, "Name": "Bank 1 - Customer Service" }, { "ListValueId": 1088, "Name": "Bank 1 - Employee Benefits" }, { "ListValueId": 1090, "Name": "Bank 1 - Personal Lines" }, { "ListValueId": 1091, "Name": "Healthcare Co. USA" }, { "ListValueId": 1092, "Name": "Sunny Valley" }, { "ListValueId": 1093, "Name": "Sunny Valley - Admin" }, { "ListValueId": 1094, "Name": "Sunny Valley - Community Care" }, { "ListValueId": 1095, "Name": "Sunny Valley - Housekeeping" }, { "ListValueId": 1096, "Name": "Sunny Valley - Nursing" }, { "ListValueId": 1097, "Name": "Sunny Valley - PP&E" }, { "ListValueId": 1098, "Name": "Sunny Valley - Front Desk" }, { "ListValueId": 1099, "Name": "Store 122" }, { "ListValueId": 1100, "Name": "Store 122 - Cust. Svc." }, { "ListValueId": 1101, "Name": "Store 155" }, { "ListValueId": 1102, "Name": "Store 155 - Cust. Svc." }, { "ListValueId": 1105, "Name": "Hospitality Co. USA" }, { "ListValueId": 1106, "Name": "Hotel 1" }, { "ListValueId": 1107, "Name": "Hotel 1 - Concierge" }, { "ListValueId": 1108, "Name": "Hotel 1 - Food & Beverage" }, { "ListValueId": 1109, "Name": "Hotel 1 - Front Desk" }, { "ListValueId": 1110, "Name": "Hotel 1 - Housekeeping" }, { "ListValueId": 1111, "Name": "Hotel 1 - Management" }, { "ListValueId": 1112, "Name": "Hotel 1 - Receiving" }, { "ListValueId": 1113, "Name": "Hotel 1 - PP&E" }, { "ListValueId": 1114, "Name": "Manufacturing Co. Canada" }, { "ListValueId": 1115, "Name": "Plant 2" }, { "ListValueId": 1116, "Name": "Plant 2 - Assembly 1" }, { "ListValueId": 1118, "Name": "Plant 2 - Maintenance" }, { "ListValueId": 1119, "Name": "Plant 2 - Management" }, { "ListValueId": 1120, "Name": "Plant 2 - Packaging" }, { "ListValueId": 1122, "Name": "Plant 3" }, { "ListValueId": 1123, "Name": "Plant 3 - Assembly 1" }, { "ListValueId": 1124, "Name": "Plant 3 - Assembly 2" }, { "ListValueId": 1125, "Name": "Plant 3 - Maintenance" }, { "ListValueId": 1126, "Name": "Plant 3 - Management" }, { "ListValueId": 1127, "Name": "Plant 3 - Packaging" }, { "ListValueId": 1128, "Name": "Plant 3 - Receiving" }, { "ListValueId": 1129, "Name": "Plant 4" }, { "ListValueId": 1130, "Name": "Plant 4 - Assembly 1" }, { "ListValueId": 1131, "Name": "Plant 4 - Assembly 2" }, { "ListValueId": 1132, "Name": "Plant 4 - Maintenance" }, { "ListValueId": 1133, "Name": "Plant 4 - Management" }, { "ListValueId": 1134, "Name": "Plant 4 - Packaging" }, { "ListValueId": 1135, "Name": "Plant 4 - Receiving" }, { "ListValueId": 1136, "Name": "Grocery Co. USA" }, { "ListValueId": 1137, "Name": "District 1" }, { "ListValueId": 1138, "Name": "Store 320" }, { "ListValueId": 1139, "Name": "Store 320 - Customer Service" }, { "ListValueId": 1140, "Name": "Store 320 - Meat" }, { "ListValueId": 1141, "Name": "Store 320 - Produce" }, { "ListValueId": 1142, "Name": "Store 320 - Seafood" }, { "ListValueId": 1143, "Name": "Store 320 - Stocking" }, { "ListValueId": 1144, "Name": "Store 320 - Management" }, { "ListValueId": 1145, "Name": "Contractor Co. USA" }, { "ListValueId": 1146, "Name": "Minneapolis" }, { "ListValueId": 1147, "Name": "Minneapolis - Contractors" }, { "ListValueId": 1148, "Name": "Retail Co. UK" }, { "ListValueId": 1149, "Name": "District 01" }, { "ListValueId": 1150, "Name": "District 02 " }, { "ListValueId": 1151, "Name": "Store 1001" }, { "ListValueId": 1152, "Name": "Store 1001 - Cust. Svc." }, { "ListValueId": 1153, "Name": "Community Center Co. USA" }, { "ListValueId": 1154, "Name": "Pittsburgh" }, { "ListValueId": 1155, "Name": "Cloverleaf" }, { "ListValueId": 1156, "Name": "Cloverleaf - Admin" }, { "ListValueId": 1157, "Name": "Cloverleaf - Child Care" }, { "ListValueId": 1158, "Name": "Cloverleaf - Community Care" }, { "ListValueId": 1159, "Name": "Cloverleaf - Lifeguards" }, { "ListValueId": 1160, "Name": "Cloverleaf - Membership" }, { "ListValueId": 1161, "Name": "Cloverleaf - Personal Training" }, { "ListValueId": 1162, "Name": "Cranberry" }, { "ListValueId": 1163, "Name": "Cranberry - Admin" }, { "ListValueId": 1164, "Name": "Cranberry - Child Care" }, { "ListValueId": 1165, "Name": "Cranberry - Community Care" }, { "ListValueId": 1166, "Name": "Cranberry - Lifeguards" }, { "ListValueId": 1167, "Name": "Cranberry - Membership" }, { "ListValueId": 1168, "Name": "Cranberry - Personal Training" }, { "ListValueId": 1169, "Name": "Store 2001" }, { "ListValueId": 1170, "Name": "Store 2001 Cust. Svc." }, { "ListValueId": 1171, "Name": "Manufacturing Co. Mexico" }, { "ListValueId": 1172, "Name": "District 1" }, { "ListValueId": 1173, "Name": "District 2" }, { "ListValueId": 1174, "Name": "Plant 601" }, { "ListValueId": 1175, "Name": "Plant 601 Assembly 1" }, { "ListValueId": 1176, "Name": "Plant 601 Assembly 2" }, { "ListValueId": 1177, "Name": "Plant 601 Maintenance" }, { "ListValueId": 1178, "Name": "Plant 601 Management" }, { "ListValueId": 1179, "Name": "Plant 601 Packaging" }, { "ListValueId": 1180, "Name": "Plant 601 Receiving" }, { "ListValueId": 1188, "Name": "Plant 501" }, { "ListValueId": 1189, "Name": "Plant 501 Assembly 1" }, { "ListValueId": 1191, "Name": "Plant 501 Maintenance" }, { "ListValueId": 1192, "Name": "Plant 501 Management" }, { "ListValueId": 1193, "Name": "Plant 501 Packaging" }, { "ListValueId": 1195, "Name": "Head Office" }, { "ListValueId": 1196, "Name": "Head Office - HR" }, { "ListValueId": 1197, "Name": "Head Office - Finance" }, { "ListValueId": 1198, "Name": "Head Office - Marketing" }, { "ListValueId": 1199, "Name": "Head Office - Senior Leadership" }, { "ListValueId": 1200, "Name": "Head Office - Operations" }, { "ListValueId": 1201, "Name": "Retail Co. AUS" }, { "ListValueId": 1202, "Name": "District 10" }, { "ListValueId": 1203, "Name": "Store 200" }, { "ListValueId": 1204, "Name": "Store 200 Accessories" }, { "ListValueId": 1205, "Name": "Store 200 Footwear" }, { "ListValueId": 1206, "Name": "Store 200 Management" }, { "ListValueId": 1207, "Name": "Store 200 Mens" }, { "ListValueId": 1208, "Name": "Store 200 Receiving" }, { "ListValueId": 1209, "Name": "Store 200 Womens" }, { "ListValueId": 1210, "Name": "Financial Co. Canada" }, { "ListValueId": 1211, "Name": "Central Bank" }, { "ListValueId": 1212, "Name": "Central Bank Admin" }, { "ListValueId": 1214, "Name": "Central Bank Customer Service" }, { "ListValueId": 1217, "Name": "Central Bank IT" }, { "ListValueId": 1218, "Name": "Eastern Bank" }, { "ListValueId": 1219, "Name": "Eastern Bank Admin" }, { "ListValueId": 1220, "Name": "Eastern Bank Customer Service" }, { "ListValueId": 1221, "Name": "Eastern Bank IT" }, { "ListValueId": 1222, "Name": "Western Bank" }, { "ListValueId": 1223, "Name": "Western Bank Admin" }, { "ListValueId": 1224, "Name": "Western Bank Customer Service" }, { "ListValueId": 1225, "Name": "Western Bank IT" }, { "ListValueId": 1226, "Name": "Clinic" }, { "ListValueId": 1227, "Name": "Clinic - Medical" }, { "ListValueId": 1228, "Name": "Projects" }, { "ListValueId": 1229, "Name": "IT Projects" }, { "ListValueId": 1230, "Name": "ShopDDN" }, { "ListValueId": 1231, "Name": "Project_81601-Integration Added" }, { "ListValueId": 1232, "Name": "Corporate" }, { "ListValueId": 1233, "Name": "Bradley" }, { "ListValueId": 1234, "Name": "Bradleys" }, { "ListValueId": 1235, "Name": "Joe 220526-1" } ] }, { "Name": "Job", "Description": "Short name for a job; Regional Dir., Asst Manager", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 8, "AvailableValues": [ { "ListValueId": 1000, "Name": "Manager" }, { "ListValueId": 1001, "Name": "S&T Manager" }, { "ListValueId": 1002, "Name": "Assistant Mgr" }, { "ListValueId": 1006, "Name": "Dept. Mgr" }, { "ListValueId": 1007, "Name": "Assoc." }, { "ListValueId": 1008, "Name": "Administrator" }, { "ListValueId": 1010, "Name": "Lead Rcv." }, { "ListValueId": 1011, "Name": "Receiver" }, { "ListValueId": 1012, "Name": "Receiving" }, { "ListValueId": 1013, "Name": "Machinist" }, { "ListValueId": 1014, "Name": "Material Handler" }, { "ListValueId": 1015, "Name": "Process Technician" }, { "ListValueId": 1016, "Name": "Packager" }, { "ListValueId": 1017, "Name": "RN" }, { "ListValueId": 1018, "Name": "Lead Nurse" }, { "ListValueId": 1019, "Name": "Orderly" }, { "ListValueId": 1020, "Name": "Counselor" }, { "ListValueId": 1021, "Name": "Receptionist" }, { "ListValueId": 1022, "Name": "Cook" }, { "ListValueId": 1023, "Name": "Waiter" }, { "ListValueId": 1024, "Name": "Room Attendant" }, { "ListValueId": 1025, "Name": "Ground Keeper" }, { "ListValueId": 1026, "Name": "Cashier" }, { "ListValueId": 1027, "Name": "Clerk" }, { "ListValueId": 1028, "Name": "Stocker" }, { "ListValueId": 1029, "Name": "Contractor" }, { "ListValueId": 1030, "Name": "Executive" }, { "ListValueId": 1031, "Name": "Doctor" }, { "ListValueId": 1032, "Name": "Developer" }, { "ListValueId": 1033, "Name": "Chief Executive Officer" } ] }, { "Name": "Department", "Description": "Short name for the department(s) the employee works in; i.e. S;HW", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 9, "AvailableValues": [ { "ListValueId": 1, "Name": "Accessories" }, { "ListValueId": 2, "Name": "Mens" }, { "ListValueId": 3, "Name": "Footwear" }, { "ListValueId": 4, "Name": "Logistics" }, { "ListValueId": 5, "Name": "Womens" }, { "ListValueId": 6, "Name": "Receiving" }, { "ListValueId": 7, "Name": "Management" }, { "ListValueId": 14, "Name": "Assembly 1" }, { "ListValueId": 15, "Name": "Assembly 2" }, { "ListValueId": 16, "Name": "Maintenance" }, { "ListValueId": 17, "Name": "Packaging" }, { "ListValueId": 18, "Name": "Admin" }, { "ListValueId": 19, "Name": "Commercial Lines" }, { "ListValueId": 20, "Name": "Customer Service" }, { "ListValueId": 21, "Name": "Employee Benefits" }, { "ListValueId": 22, "Name": "Personal Lines" }, { "ListValueId": 23, "Name": "Front Desk" }, { "ListValueId": 24, "Name": "Nursing" }, { "ListValueId": 25, "Name": "Community Care" }, { "ListValueId": 26, "Name": "Housekeeping" }, { "ListValueId": 27, "Name": "PP&E" }, { "ListValueId": 28, "Name": "Cust. Svc." }, { "ListValueId": 29, "Name": "Food & Beverage" }, { "ListValueId": 30, "Name": "Concierge" }, { "ListValueId": 31, "Name": "Meat" }, { "ListValueId": 32, "Name": "Produce" }, { "ListValueId": 33, "Name": "Seafood" }, { "ListValueId": 34, "Name": "Stocking" }, { "ListValueId": 35, "Name": "Contractors" }, { "ListValueId": 36, "Name": "Lifeguards" }, { "ListValueId": 37, "Name": "Personal Training" }, { "ListValueId": 38, "Name": "Membership" }, { "ListValueId": 39, "Name": "Child Care" }, { "ListValueId": 40, "Name": "Finance" }, { "ListValueId": 41, "Name": "Operations" }, { "ListValueId": 42, "Name": "HR" }, { "ListValueId": 43, "Name": "Marketing" }, { "ListValueId": 44, "Name": "Senior Leadership" }, { "ListValueId": 45, "Name": "IT" }, { "ListValueId": 46, "Name": "Medical" }, { "ListValueId": 47, "Name": "Accessories" }, { "ListValueId": 48, "Name": "FCB" }, { "ListValueId": 49, "Name": "Dayforce Department API Test" }, { "ListValueId": 50, "Name": "81601-Integration Added" }, { "ListValueId": 51, "Name": "Bradley2" }, { "ListValueId": 52, "Name": "Dept jtg" }, { "ListValueId": 53, "Name": "gg" }, { "ListValueId": 54, "Name": "gg" }, { "ListValueId": 55, "Name": "gg" } ] }, { "Name": "Pay Type", "Description": "Short name for a pay type; Hr (Exempt); Sal (Non-exempt)", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 10, "AvailableValues": [ { "ListValueId": 5, "Name": "Hourly(Exempt)" }, { "ListValueId": 6, "Name": "Hourly(Non-Exempt)" }, { "ListValueId": 7, "Name": "Salaried(Exempt)" }, { "ListValueId": 8, "Name": "Salaried(Non-Exempt)" } ] }, { "Name": "Pay Class", "Description": "Short name for a pay class; FT; Temp", "DataType": "Reference", "Operator": "in", "IsRequired": false, "Value": "", "Editable": true, "Sequence": 11, "AvailableValues": [ { "ListValueId": 3, "Name": "FT" }, { "ListValueId": 4, "Name": "PT" }, { "ListValueId": 5, "Name": "Contractor" }, { "ListValueId": 6, "Name": "UK FT 100%" }, { "ListValueId": 7, "Name": "UK FT 75% " }, { "ListValueId": 8, "Name": "UK FT 50%" }, { "ListValueId": 9, "Name": "UK FT 25%" } ] }, { "Name": "@AsOfDate", "Description": "@AsOfDate", "DataType": "Date", "Operator": "=", "IsRequired": true, "Value": "2022-11-24T00:00:00-05:00", "Editable": true } ] } }