GET v1/Reports/GetAllPaidHoursForDateRangeByEmployeeNumber?startDate={startDate}&endDate={endDate}&employeeNumber={employeeNumber}

Returns All Paid Hours for a Specified Date Range and Employee

Request Information

URI Parameters

NameDescriptionTypeAdditional information
startDate

The Range Start Date. e.g 2014-01-01

date

Required

endDate

The Range End Date. e.g 2014-01-01

date

Required

employeeNumber

The Employee to get the data for

string

Required

Body Parameters

None.

Response Information

Resource Description

Collection of vwReportsTimeClockPaidHour
NameDescriptionTypeAdditional information
DivsionName

string

None.

CompanyCode

string

None.

DivisionCode

string

None.

EmployeeID

integer

None.

EmployeePersonalID

integer

None.

DivisionID

integer

None.

EmployeeNumber

string

None.

DivisionEmployeeStatus

string

None.

PayGroup

string

None.

Location

string

None.

Job

string

None.

Position

string

None.

JobTitle

string

None.

ClockNumber

string

None.

IsExemptFromOT

boolean

None.

FullOrPartTime

string

None.

HireDate

date

None.

PayType

string

None.

AutoPay

boolean

None.

SSN

string

None.

FirstName

string

None.

MiddleInitial

character

None.

LastName

string

None.

CostCenter1

string

None.

CostCenter2

string

None.

CostCenter3

string

None.

CostCenter4

string

None.

CostCenter5

string

None.

FirstLast

string

None.

LastFirst

string

None.

DateWorked

date

None.

EarningCode

string

None.

ShortDescription

string

None.

Description

string

None.

Week

integer

None.

Month

integer

None.

Hours

decimal number

None.

Amount

decimal number

None.

RecordType

string

None.

TimeIn

date

None.

TimeOut

date

None.

cc1Code

string

None.

cc2Code

string

None.

cc3Code

string

None.

cc4Code

string

None.

cc5Code

string

None.

cc1Description

string

None.

cc2Description

string

None.

cc3Description

string

None.

cc4Description

string

None.

cc5Description

string

None.

JobPunch

string

None.

TaskPunch

string

None.

Notes

string

None.

DisplaySequence

integer

None.

Minutes

integer

None.

ActualTimeIn

date

None.

ActualTimeOut

date

None.

Rate

decimal number

None.

EarningType

integer

None.

DoNotTransferHoursToPayroll

boolean

None.

JobDescriptionPunch

string

None.

TaskDescriptionPunch

string

None.

RoundedTimeClockIn

date

None.

RoundedTimeClockOut

date

None.

Task

string

None.

JobMapCodePunch

string

None.

TempRateCode

string

None.

Response Formats

application/json, text/json

Sample:
[
  {
    "DivsionName": "sample string 1",
    "CompanyCode": "sample string 2",
    "DivisionCode": "sample string 3",
    "EmployeeID": 4,
    "EmployeePersonalID": 5,
    "DivisionID": 6,
    "EmployeeNumber": "sample string 7",
    "DivisionEmployeeStatus": "sample string 8",
    "PayGroup": "sample string 9",
    "Location": "sample string 10",
    "Job": "sample string 11",
    "Position": "sample string 12",
    "JobTitle": "sample string 13",
    "ClockNumber": "sample string 14",
    "IsExemptFromOT": true,
    "FullOrPartTime": "sample string 16",
    "HireDate": "2017-06-27T07:48:07.2083628-04:00",
    "PayType": "sample string 17",
    "AutoPay": true,
    "SSN": "sample string 19",
    "FirstName": "sample string 20",
    "MiddleInitial": "A",
    "LastName": "sample string 22",
    "CostCenter1": "sample string 23",
    "CostCenter2": "sample string 24",
    "CostCenter3": "sample string 25",
    "CostCenter4": "sample string 26",
    "CostCenter5": "sample string 27",
    "FirstLast": "sample string 28",
    "LastFirst": "sample string 29",
    "DateWorked": "2017-06-27T07:48:07.2083628-04:00",
    "EarningCode": "sample string 31",
    "ShortDescription": "sample string 32",
    "Description": "sample string 33",
    "Week": 34,
    "Month": 35,
    "Hours": 36.0,
    "Amount": 37.0,
    "RecordType": "sample string 38",
    "TimeIn": "2017-06-27T07:48:07.2083628-04:00",
    "TimeOut": "2017-06-27T07:48:07.2083628-04:00",
    "cc1Code": "sample string 41",
    "cc2Code": "sample string 42",
    "cc3Code": "sample string 43",
    "cc4Code": "sample string 44",
    "cc5Code": "sample string 45",
    "cc1Description": "sample string 46",
    "cc2Description": "sample string 47",
    "cc3Description": "sample string 48",
    "cc4Description": "sample string 49",
    "cc5Description": "sample string 50",
    "JobPunch": "sample string 51",
    "TaskPunch": "sample string 52",
    "Notes": "sample string 53",
    "DisplaySequence": 54,
    "Minutes": 55,
    "ActualTimeIn": "2017-06-27T07:48:07.2083628-04:00",
    "ActualTimeOut": "2017-06-27T07:48:07.2083628-04:00",
    "Rate": 1.0,
    "EarningType": 56,
    "DoNotTransferHoursToPayroll": true,
    "JobDescriptionPunch": "sample string 58",
    "TaskDescriptionPunch": "sample string 59",
    "RoundedTimeClockIn": "2017-06-27T07:48:07.2083628-04:00",
    "RoundedTimeClockOut": "2017-06-27T07:48:07.2083628-04:00",
    "Task": "sample string 60",
    "JobMapCodePunch": "sample string 61",
    "TempRateCode": "sample string 62"
  },
  {
    "DivsionName": "sample string 1",
    "CompanyCode": "sample string 2",
    "DivisionCode": "sample string 3",
    "EmployeeID": 4,
    "EmployeePersonalID": 5,
    "DivisionID": 6,
    "EmployeeNumber": "sample string 7",
    "DivisionEmployeeStatus": "sample string 8",
    "PayGroup": "sample string 9",
    "Location": "sample string 10",
    "Job": "sample string 11",
    "Position": "sample string 12",
    "JobTitle": "sample string 13",
    "ClockNumber": "sample string 14",
    "IsExemptFromOT": true,
    "FullOrPartTime": "sample string 16",
    "HireDate": "2017-06-27T07:48:07.2083628-04:00",
    "PayType": "sample string 17",
    "AutoPay": true,
    "SSN": "sample string 19",
    "FirstName": "sample string 20",
    "MiddleInitial": "A",
    "LastName": "sample string 22",
    "CostCenter1": "sample string 23",
    "CostCenter2": "sample string 24",
    "CostCenter3": "sample string 25",
    "CostCenter4": "sample string 26",
    "CostCenter5": "sample string 27",
    "FirstLast": "sample string 28",
    "LastFirst": "sample string 29",
    "DateWorked": "2017-06-27T07:48:07.2083628-04:00",
    "EarningCode": "sample string 31",
    "ShortDescription": "sample string 32",
    "Description": "sample string 33",
    "Week": 34,
    "Month": 35,
    "Hours": 36.0,
    "Amount": 37.0,
    "RecordType": "sample string 38",
    "TimeIn": "2017-06-27T07:48:07.2083628-04:00",
    "TimeOut": "2017-06-27T07:48:07.2083628-04:00",
    "cc1Code": "sample string 41",
    "cc2Code": "sample string 42",
    "cc3Code": "sample string 43",
    "cc4Code": "sample string 44",
    "cc5Code": "sample string 45",
    "cc1Description": "sample string 46",
    "cc2Description": "sample string 47",
    "cc3Description": "sample string 48",
    "cc4Description": "sample string 49",
    "cc5Description": "sample string 50",
    "JobPunch": "sample string 51",
    "TaskPunch": "sample string 52",
    "Notes": "sample string 53",
    "DisplaySequence": 54,
    "Minutes": 55,
    "ActualTimeIn": "2017-06-27T07:48:07.2083628-04:00",
    "ActualTimeOut": "2017-06-27T07:48:07.2083628-04:00",
    "Rate": 1.0,
    "EarningType": 56,
    "DoNotTransferHoursToPayroll": true,
    "JobDescriptionPunch": "sample string 58",
    "TaskDescriptionPunch": "sample string 59",
    "RoundedTimeClockIn": "2017-06-27T07:48:07.2083628-04:00",
    "RoundedTimeClockOut": "2017-06-27T07:48:07.2083628-04:00",
    "Task": "sample string 60",
    "JobMapCodePunch": "sample string 61",
    "TempRateCode": "sample string 62"
  }
]

application/xml, text/xml

Sample:
<ArrayOfvwReportsTimeClockPaidHour xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/BDBPayroll.TimeAttendance.Entities">
  <vwReportsTimeClockPaidHour>
    <DivsionName>sample string 1</DivsionName>
    <CompanyCode>sample string 2</CompanyCode>
    <DivisionCode>sample string 3</DivisionCode>
    <EmployeeID>4</EmployeeID>
    <EmployeePersonalID>5</EmployeePersonalID>
    <DivisionID>6</DivisionID>
    <EmployeeNumber>sample string 7</EmployeeNumber>
    <DivisionEmployeeStatus>sample string 8</DivisionEmployeeStatus>
    <PayGroup>sample string 9</PayGroup>
    <Location>sample string 10</Location>
    <Job>sample string 11</Job>
    <Position>sample string 12</Position>
    <JobTitle>sample string 13</JobTitle>
    <ClockNumber>sample string 14</ClockNumber>
    <IsExemptFromOT>true</IsExemptFromOT>
    <FullOrPartTime>sample string 16</FullOrPartTime>
    <HireDate>2017-06-27T07:48:07.2083628-04:00</HireDate>
    <PayType>sample string 17</PayType>
    <AutoPay>true</AutoPay>
    <SSN>sample string 19</SSN>
    <FirstName>sample string 20</FirstName>
    <MiddleInitial>65</MiddleInitial>
    <LastName>sample string 22</LastName>
    <CostCenter1>sample string 23</CostCenter1>
    <CostCenter2>sample string 24</CostCenter2>
    <CostCenter3>sample string 25</CostCenter3>
    <CostCenter4>sample string 26</CostCenter4>
    <CostCenter5>sample string 27</CostCenter5>
    <FirstLast>sample string 28</FirstLast>
    <LastFirst>sample string 29</LastFirst>
    <DateWorked>2017-06-27T07:48:07.2083628-04:00</DateWorked>
    <EarningCode>sample string 31</EarningCode>
    <ShortDescription>sample string 32</ShortDescription>
    <Description>sample string 33</Description>
    <Week>34</Week>
    <Month>35</Month>
    <Hours>36</Hours>
    <Amount>37</Amount>
    <RecordType>sample string 38</RecordType>
    <TimeIn>2017-06-27T07:48:07.2083628-04:00</TimeIn>
    <TimeOut>2017-06-27T07:48:07.2083628-04:00</TimeOut>
    <cc1Code>sample string 41</cc1Code>
    <cc2Code>sample string 42</cc2Code>
    <cc3Code>sample string 43</cc3Code>
    <cc4Code>sample string 44</cc4Code>
    <cc5Code>sample string 45</cc5Code>
    <cc1Description>sample string 46</cc1Description>
    <cc2Description>sample string 47</cc2Description>
    <cc3Description>sample string 48</cc3Description>
    <cc4Description>sample string 49</cc4Description>
    <cc5Description>sample string 50</cc5Description>
    <JobPunch>sample string 51</JobPunch>
    <TaskPunch>sample string 52</TaskPunch>
    <Notes>sample string 53</Notes>
    <DisplaySequence>54</DisplaySequence>
    <Minutes>55</Minutes>
    <ActualTimeIn>2017-06-27T07:48:07.2083628-04:00</ActualTimeIn>
    <ActualTimeOut>2017-06-27T07:48:07.2083628-04:00</ActualTimeOut>
    <Rate>1</Rate>
    <EarningType>56</EarningType>
    <DoNotTransferHoursToPayroll>true</DoNotTransferHoursToPayroll>
    <JobDescriptionPunch>sample string 58</JobDescriptionPunch>
    <TaskDescriptionPunch>sample string 59</TaskDescriptionPunch>
    <RoundedTimeClockIn>2017-06-27T07:48:07.2083628-04:00</RoundedTimeClockIn>
    <RoundedTimeClockOut>2017-06-27T07:48:07.2083628-04:00</RoundedTimeClockOut>
    <Task>sample string 60</Task>
    <JobMapCodePunch>sample string 61</JobMapCodePunch>
    <TempRateCode>sample string 62</TempRateCode>
  </vwReportsTimeClockPaidHour>
  <vwReportsTimeClockPaidHour>
    <DivsionName>sample string 1</DivsionName>
    <CompanyCode>sample string 2</CompanyCode>
    <DivisionCode>sample string 3</DivisionCode>
    <EmployeeID>4</EmployeeID>
    <EmployeePersonalID>5</EmployeePersonalID>
    <DivisionID>6</DivisionID>
    <EmployeeNumber>sample string 7</EmployeeNumber>
    <DivisionEmployeeStatus>sample string 8</DivisionEmployeeStatus>
    <PayGroup>sample string 9</PayGroup>
    <Location>sample string 10</Location>
    <Job>sample string 11</Job>
    <Position>sample string 12</Position>
    <JobTitle>sample string 13</JobTitle>
    <ClockNumber>sample string 14</ClockNumber>
    <IsExemptFromOT>true</IsExemptFromOT>
    <FullOrPartTime>sample string 16</FullOrPartTime>
    <HireDate>2017-06-27T07:48:07.2083628-04:00</HireDate>
    <PayType>sample string 17</PayType>
    <AutoPay>true</AutoPay>
    <SSN>sample string 19</SSN>
    <FirstName>sample string 20</FirstName>
    <MiddleInitial>65</MiddleInitial>
    <LastName>sample string 22</LastName>
    <CostCenter1>sample string 23</CostCenter1>
    <CostCenter2>sample string 24</CostCenter2>
    <CostCenter3>sample string 25</CostCenter3>
    <CostCenter4>sample string 26</CostCenter4>
    <CostCenter5>sample string 27</CostCenter5>
    <FirstLast>sample string 28</FirstLast>
    <LastFirst>sample string 29</LastFirst>
    <DateWorked>2017-06-27T07:48:07.2083628-04:00</DateWorked>
    <EarningCode>sample string 31</EarningCode>
    <ShortDescription>sample string 32</ShortDescription>
    <Description>sample string 33</Description>
    <Week>34</Week>
    <Month>35</Month>
    <Hours>36</Hours>
    <Amount>37</Amount>
    <RecordType>sample string 38</RecordType>
    <TimeIn>2017-06-27T07:48:07.2083628-04:00</TimeIn>
    <TimeOut>2017-06-27T07:48:07.2083628-04:00</TimeOut>
    <cc1Code>sample string 41</cc1Code>
    <cc2Code>sample string 42</cc2Code>
    <cc3Code>sample string 43</cc3Code>
    <cc4Code>sample string 44</cc4Code>
    <cc5Code>sample string 45</cc5Code>
    <cc1Description>sample string 46</cc1Description>
    <cc2Description>sample string 47</cc2Description>
    <cc3Description>sample string 48</cc3Description>
    <cc4Description>sample string 49</cc4Description>
    <cc5Description>sample string 50</cc5Description>
    <JobPunch>sample string 51</JobPunch>
    <TaskPunch>sample string 52</TaskPunch>
    <Notes>sample string 53</Notes>
    <DisplaySequence>54</DisplaySequence>
    <Minutes>55</Minutes>
    <ActualTimeIn>2017-06-27T07:48:07.2083628-04:00</ActualTimeIn>
    <ActualTimeOut>2017-06-27T07:48:07.2083628-04:00</ActualTimeOut>
    <Rate>1</Rate>
    <EarningType>56</EarningType>
    <DoNotTransferHoursToPayroll>true</DoNotTransferHoursToPayroll>
    <JobDescriptionPunch>sample string 58</JobDescriptionPunch>
    <TaskDescriptionPunch>sample string 59</TaskDescriptionPunch>
    <RoundedTimeClockIn>2017-06-27T07:48:07.2083628-04:00</RoundedTimeClockIn>
    <RoundedTimeClockOut>2017-06-27T07:48:07.2083628-04:00</RoundedTimeClockOut>
    <Task>sample string 60</Task>
    <JobMapCodePunch>sample string 61</JobMapCodePunch>
    <TempRateCode>sample string 62</TempRateCode>
  </vwReportsTimeClockPaidHour>
</ArrayOfvwReportsTimeClockPaidHour>