ExportOlapUtilizationRecords

Once all of the records have been exported (or if they are not exported within a few hours of their availability), the exported records are deleted from the server.

Request

See Common Export Batch Records Request

Response

Each response includes the information described in Common Elements of Export Batch Records Response. In addition, for each record in the result set the following data is returned:

Name

Data Type

Discussion

RowIndex

long

Projector's internal identifier for the record. This is used only to avoid skipping or duplicating exported records.

ActualProjectedFlag

string

"A" for actual data.
"P" for projected data.

PeriodStartDate

date

First date of time bucket.

ResourceDisplayName

string

 

ResourceEmployeeId

string

This is the resource's reference system ID.

CostCenterName

string

 

LocationName

string

 

DepartmentName

string

 

TitleName

string

 

ResourceBillableFlag

boolean

 

ResourceTemporaryWorkerFlag

boolean

 

ResourcePayCategory

string

"S" = Salaried, "H" = Hourly, "O" = Salaried with overtime

NormalWorkingMinutes

float

 

OvertimeMinutes

float

 

HolidayMinutes

float

 

VacationMinutes

float

 

UtilizationBasisMinutes

float

 

RdcBasisMinutes

float

 

ResourceDirectCost

float

 

BillableMinutes

float

 

ChargeableMinutes

float

These are billable minutes that have billing adjusted revenue greater than zero

SystemRevenue

float

 

BillingAdjustedRevenue

float

 

ContractRevenue

float

 

StandardRevenue

float

 

ReportingCurrencyCode

string

 

BusyMinutes

float

 

NonBillableMinutes

float

 

TrackMissingTimeFlag

boolean

 

LocationNormalWorkingMinutes

int

 

HeadCount

int

 

BillableTypeFtes

float

 

NonbillableTypeFtes

float

 

ChargeableTypeFtes

float

 

NormalWorkingFtes

float

 

HolidayFtes

float

 

TimeoffFtes

float

 

OvertimeFtes

float

 

UtilizationBasisFtes

float

 

UtilizationRdcBasisFtes

float

 

BusyFtes

float

 

ResourceTypeName 

string(50)

Added as response parameter

ResourceTypeCode 

string(20)

Added as response parameter


Changelog

History of changes to this web service

4.4

Parameter

Notes

ResourceTypeName

Added as response parameter

ResourceTypeCode

Added as response parameter



4.3.2

Parameter

Notes

BillingAdjustedRevenue

Added as response parameter

ContractRevenue

Added as response parameter

StandardRevenue

Added as response parameter

LocationNormalWorkingMinutes

Added as response parameter

HeadCount

Added as response parameter

BillableTypeFtes

Added as response parameter

NonbillableTypeFtes

Added as response parameter

ChargeableTypeFtes

Added as response parameter

NormalWorkingFtes

Added as response parameter

HolidayFtes

Added as response parameter

TimeoffFtes

Added as response parameter

OvertimeFtes

Added as response parameter

UtilizationBasisFtes

Added as response parameter

UtilizationRdcBasisFtes

Added as response parameter

BusyFtes

Added as response parameter