Skip to content

Instantly share code, notes, and snippets.

@ianrussel

ianrussel/gist:048d99f4ab2d06d68a699cb8b2a1be91

Created August 17, 2024 09:07
Show Gist options
  • Save ianrussel/048d99f4ab2d06d68a699cb8b2a1be91 to your computer and use it in GitHub Desktop.
Save ianrussel/048d99f4ab2d06d68a699cb8b2a1be91 to your computer and use it in GitHub Desktop.
Download ZIP
reports
Raw
gistfile1.txt
{
"errors": [],
"processing": {
"writetostorage": "false",
"queued": "false",
"reportuuid": ""
},
"report": {
"TOTALREPORTVARIABLEPAY": "14632.58",
"IncludedAccountCodes": [
"Manufacturing",
"Operations",
"Sales Dept",
"Shipping",
"Uncategorized"
],
"ReportFormat": "Summary",
"IncludedAccountCodeIDs": [
"25641",
"25642",
"25643",
"25644",
"25645"
],
"PayrollPeriodsSpanned": "1",
"TotalActualReportHours": "839.29",
"TotalStandardReportHours": "486.31",
"TOTALREPORTFIXEDPAY": "5777.12",
"TotalOvertime15ReportHours": "0.85",
"TotalPayableReportHours": "839.29",
"TotalAddedReportHours": "0",
"EmployeesProcessed": "0",
"TotalPTOReportHours": "0",
"TotalSalaryReportHours": "352.13",
"ReportName": "ProcessedHourlyPayrollReport",
"TotalOther1ReportHours": "0",
"TotalAccruedSickHours": "N/A",
"TotalDeductedReportHours": "0",
"IncludedUsers": [
"Carol Canipe",
"Michelle Conley",
"Robert Green",
"Gordon Hallemeyer",
"William Hooper",
"Carey Huffman",
"Vincent Jennings",
"Joseph Kawley",
"Danyelle Russell",
"Nancy Shanley",
"Francisco Tannmer",
"Idella Thorton"
],
"IncludeWorkDescription": "true",
"AggregationBy": "",
"StartDate": "June, 16 2024 00:00:00",
"ReportGenerationDate": "August 17 2024 02:07 PDT",
"TotalOvertime20ReportHours": "0",
"TOTALREPORTPAYROLL": "20409.7",
"TotalAccruedPTOHours": "N/A",
"TotalSickReportHours": "0",
"ReportRange": "Jun 16, 2024 - Jun 29, 2024",
"ReportData": [
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Carol",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10008",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Canipe",
"UserID": "50142",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Carol Canipe",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "72.64",
"Other2Hours": "0.00",
"FixedPay": "0",
"SalaryHours": "72.64",
"StandardHours": "0.00",
"PayType": "SALARY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "72.64",
"VariablePay": "0",
"VacationHours": "0.00",
"JobTitle": "Consumer Product Manager"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Michelle",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10011",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Conley",
"UserID": "50146",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Michelle Conley",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "68.00",
"Other2Hours": "0.00",
"FixedPay": "928.21",
"SalaryHours": "0.00",
"StandardHours": "68.00",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "68.00",
"VariablePay": "2040.20",
"VacationHours": "0.00",
"JobTitle": "Assistant Project Coordinator"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.85",
"WorkersCompJobCode": "",
"FirstName": "Robert",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10004",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Green",
"UserID": "50136",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Robert Green",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "74.93",
"Other2Hours": "0.00",
"FixedPay": "715.91",
"SalaryHours": "0.00",
"StandardHours": "74.08",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "74.93",
"VariablePay": "2306.93",
"VacationHours": "0.00",
"JobTitle": "Technical Support"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Gordon",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10005",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Hallemeyer",
"UserID": "50137",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Gordon Hallemeyer",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "67.01",
"Other2Hours": "0.00",
"FixedPay": "519.35",
"SalaryHours": "0.00",
"StandardHours": "67.01",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "67.01",
"VariablePay": "1995.85",
"VacationHours": "0.00",
"JobTitle": "Sales Support"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "William",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10001",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Hooper",
"UserID": "50133",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "William Hooper",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "66.07",
"Other2Hours": "0.00",
"FixedPay": "0",
"SalaryHours": "66.07",
"StandardHours": "0.00",
"PayType": "SALARY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "66.07",
"VariablePay": "0",
"VacationHours": "0.00",
"JobTitle": "Account Administrator"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Carey",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10012",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Huffman",
"UserID": "50144",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Carey Huffman",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "72.17",
"Other2Hours": "0.00",
"FixedPay": "1212.44",
"SalaryHours": "0.00",
"StandardHours": "72.17",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "72.17",
"VariablePay": "2033.35",
"VacationHours": "0.00",
"JobTitle": "Associate Project Manager"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Vincent",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10010",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Jennings",
"UserID": "50143",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Vincent Jennings",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "68.13",
"Other2Hours": "0.00",
"FixedPay": "0",
"SalaryHours": "68.13",
"StandardHours": "0.00",
"PayType": "SALARY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "68.13",
"VariablePay": "0",
"VacationHours": "0.00",
"JobTitle": "Associate Project Manager"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Joseph",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10009",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Kawley",
"UserID": "50141",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Joseph Kawley",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "72.99",
"Other2Hours": "0.00",
"FixedPay": "0",
"SalaryHours": "72.99",
"StandardHours": "0.00",
"PayType": "SALARY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "72.99",
"VariablePay": "0",
"VacationHours": "0.00",
"JobTitle": "Direct Marketing Manager"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Danyelle",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10002",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Russell",
"UserID": "50134",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Danyelle Russell",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "66.95",
"Other2Hours": "0.00",
"FixedPay": "719.74",
"SalaryHours": "0.00",
"StandardHours": "66.95",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "66.95",
"VariablePay": "2073.35",
"VacationHours": "0.00",
"JobTitle": "Personal Assistant"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Nancy",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10007",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Shanley",
"UserID": "50140",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Nancy Shanley",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "72.30",
"Other2Hours": "0.00",
"FixedPay": "0",
"SalaryHours": "72.30",
"StandardHours": "0.00",
"PayType": "SALARY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "72.30",
"VariablePay": "0",
"VacationHours": "0.00",
"JobTitle": "Director of Marketing"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Francisco",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10013",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Tannmer",
"UserID": "50145",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Francisco Tannmer",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "69.16",
"Other2Hours": "0.00",
"FixedPay": "871.41",
"SalaryHours": "0.00",
"StandardHours": "69.16",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "69.16",
"VariablePay": "2120.30",
"VacationHours": "0.00",
"JobTitle": "Associate Project Manager"
},
{
"Location": "",
"EmployeeType": "1",
"Overtime15Hours": "0.00",
"WorkersCompJobCode": "",
"FirstName": "Idella",
"Division": "",
"ExemptFromWorkersComp": "0",
"EmployeeNumber": "10003",
"SickHours": "0.00",
"PTOHours": "0.00",
"LastName": "Thorton",
"UserID": "50135",
"AddedHours": "0.00",
"Other1Hours": "0.00",
"FullName": "Idella Thorton",
"DeductedHours": "0.00",
"Overtime20Hours": "0.00",
"ActualHours": "68.94",
"Other2Hours": "0.00",
"FixedPay": "810.06",
"SalaryHours": "0.00",
"StandardHours": "68.94",
"PayType": "HOURLY",
"Department": "",
"HolidayHours": "0.00",
"PayableHours": "68.94",
"VariablePay": "2062.60",
"VacationHours": "0.00",
"JobTitle": "Account Executive"
}
],
"GeneratedDateGMT": "August, 17 2024 09:07:11",
"PayrollRunDate": "",
"IncludedUserIDs": [
"50142",
"50146",
"50136",
"50137",
"50133",
"50144",
"50143",
"50141",
"50134",
"50140",
"50145",
"50135"
],
"AvailableFileFormats": [
{
"Available": "2",
"Requirements": {
"ReportFormat": [
"Detailed",
"Summary"
]
},
"Value": "TextCSV",
"Name": "TextCSV"
}
],
"CompanyID": "2606",
"TotalOther2ReportHours": "0",
"GroupType": "User",
"TotalVacationReportHours": "0",
"PayrollID": "",
"PayrollDescription": "",
"TotalHolidayReportHours": "0",
"EndDate": "June, 29 2024 23:59:59",
"TimeClassLabels": {
"VacationAbbrevLabel": "VAC",
"StandardAbbrevLabel": "STD",
"PTOAbbrevLabel": "PTO",
"Other2Enabled": "false",
"PTOEnabled": "true",
"DoubletimeEnabled": "true",
"StandardEnabled": "true",
"StandardLabel": "Standard",
"HolidayLabel": "Holiday",
"SalariedAbbrevLabel": "UnP/Sal",
"VacationEnabled": "true",
"DoubletimeLabel": "Double Time",
"HolidayAbbrevLabel": "HOL",
"HolidayEnabled": "true",
"Other2AbbrevLabel": "OR2",
"SickLabel": "Sick",
"Other2Label": "Other2",
"TimeClassID": {
"1": {
"Color": "none",
"Label": "Standard",
"Abbrev": "STD"
},
"2": {
"Color": "red",
"Label": "Sick",
"Abbrev": "SIC"
},
"3": {
"Color": "green",
"Label": "Vacation",
"Abbrev": "VAC"
},
"4": {
"Color": "purple-dark",
"Label": "PTO",
"Abbrev": "PTO"
},
"5": {
"Color": "blue",
"Label": "Holiday",
"Abbrev": "HOL"
},
"6": {
"Color": "blue-bright",
"Label": "Other1",
"Abbrev": "OR1"
},
"7": {
"Color": "yellow",
"Label": "Unpayable/Salaried",
"Abbrev": "UnP/Sal"
},
"8": {
"Color": "charcoal",
"Label": "Other2",
"Abbrev": "OR2"
}
},
"VacationLabel": "Vacation",
"SalariedEnabled": "true",
"OvertimeEnabled": "true",
"PTOLabel": "PTO",
"SickAbbrevLabel": "SIC",
"OvertimeLabel": "Overtime",
"OvertimeAbbrevLabel": "OT",
"SickEnabled": "true",
"Other1AbbrevLabel": "OR1",
"Other1Label": "Other1",
"Other1Enabled": "false",
"SalariedLabel": "Unpayable/Salaried",
"DoubletimeAbbrevLabel": "DT"
},
"ReportClass": "PayrollReport",
"PayrollDatesAreGMT": "",
"IncludePayTotals": "true",
"Locale": "en_US",
"TotalAccruedVacationHours": "N/A",
"ReportUUID": "BBEC9D57-E356-5807-3C466473ECB5BA82",
"CompanyName": "Judy's API Test Acct",
"RunByUserID": "50133",
"TotalRecords": "240"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment