/
ExportOlapUtilizationRecords

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.


Rate Limiting

In order to protect our servers from inadvertent service overuse or intentional attack, and to fairly distribute services to all our customers, we have implemented a rate limiting algorithm.  When fully deployed, this new algorithm will cause services to either succeed with new warnings or fail with new errors when services are consumed at too high a rate.  Programs that consume Projector services should be enhanced to handle rate limiting errors so that they can continue functioning properly.  For more information please visit: Projector Rate Limiting Behavior.


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

Related content

ExportOlapGinsuRecords
ExportOlapGinsuRecords
More like this
ExportOlapEprRecords
ExportOlapEprRecords
More like this
SubmitOlapUtilizationExport
SubmitOlapUtilizationExport
More like this
ExportResources
ExportResources
More like this
SubmitOlapGinsuExport
SubmitOlapGinsuExport
More like this
SubmitOlapEprExport
SubmitOlapEprExport
More like this