ExportOlapGinsuRecords
- Thomas Sherman (Deactivated)
- Bettina Borces
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. |
EngagementCode | string | |
ProjectCode | string | |
Role | string | |
VendorNumber | string(50) | |
ActualProjectedFlag | string | "A" for actual data. |
PeriodStartDate | date | First date of time bucket. Will be null if the BucketWidth is null. |
ResourceDisplayName | string | |
ResourceEmployeeId | string | This is the resource's reference system ID. |
CostCenterName | string | |
LocationName | string | |
DepartmentName | string | |
TitleName | string | |
BillingDepartmentName | string(50) | |
BillingTitleName | string(50) | |
ResourceBillableFlag | boolean | |
ResourceTemporaryWorkerFlag | boolean | |
ResourcePayCategory | string | "S" = Salaried, "H" = Hourly, "O" = Salaried with overtime |
ResourceTypeName | string(50) | |
ResourceTypeCode | string(20) | |
ProjectTaskName | string | |
ProjectTaskTypeName | string(50) | |
ProjectRateTypeName | string(50) | |
CostCodeName | string | |
ExpenseLocationName | string(50) | |
CostCardChargeableFlag | boolean | |
TimeLocationName | string(50) | |
TimeCardChargeableFlag | boolean | |
HoursType | string | "P" = Project, "H" = Holiday, "T" = Timeoff |
HoursStatus | string | "A"=Approved, "U"=Unapproved, "B"=Booked, "R"=RequestedChange, "X"=UnscheduledRevenue |
BillingStatus | string | "I"=Issued, "D"=Draft, "U"=Unbilled, "P"=Projected, "T"=Timeoff, "H"=Holiday, "N"=Nonbillable, "X"=UnscheduledRevenue |
InvoiceNumber | string | |
InvoiceDate | date | |
PurchaseOrderNumber | string(50) | |
TimeoffReasonName | string | |
HolidayName | string | |
HoldbackRevenueFlag | boolean | |
ProjectPctLikelihood | int | |
CostCenterMappingRevenue | string(159) | |
CostCenterMappingExpense | string(159) | |
PersonMinutes | float | |
SystemRevenue | float | |
RecognizedRevenue | float | |
BillingAdjustedRevenue | float | |
ContractRevenue | float | |
StandardRevenue | float | |
ResourceDirectCost | float | |
OtherDirectCosts | float | |
OtherDirectCostsClient | float | |
OtherDirectCostsRevenue | float | |
Units | float | |
UnitDrivenFlag | boolean | |
UnitPluralName | string(50) | |
ExpenseDocumentNumber | string(20) | |
UtilizationBasisMinutes | float | |
UtilizedMinutes | float | |
NormalWorkingMinutes | float | |
WorkingMinutes | float | |
ForReportingOnlyFlag | boolean | |
TimeCardMarkedNonBillableFlag | boolean | Deprecated. Always returns false. |
ReportingCurrencyCode | string | |
StandardTaskTypeName | string(50) | |
StandardTaskTypeCode | string(50) | |
StandardRateTypeName | string(50) | |
StandardRateTypeCode | string(20) |
Changelog
History of changes to this web service
4.4
Parameter | Notes |
|---|---|
ResourceTypeName | Added as response parameter |
ResourceTypeCode | Added as response parameter |
ProjectTaskTypeName | Added as response parameter |
StandardTaskTypeName | Added as response parameter |
StandardTaskTypeCode | Added as response parameter |
ProjectRateTypeName | Added as response parameter |
StandardRateTypeName | Added as response parameter |
StandardRateTypeCode | Added as response parameter |
TimeCardMarkedNonBillableFlag | Deprecated |
4.3.2
Parameter | Notes |
|---|---|
VendorNumber | Added as response parameter |
BillingDepartmentName | Added as response parameter |
BillingTitleName | Added as response parameter |
ExpenseLocationName | Added as response parameter |
CostCardChargeableFlag | Added as response parameter |
TimeLocationName | Added as response parameter |
TimeCardChargeableFlag | Added as response parameter |
InvoiceDate | Added as response parameter |
PuchaseOrderNumber | Added as response parameter |
HoldbackRevenueFlag | Added as response parameter |
ProjectPctLikelihood | Added as response parameter |
CostCenterMappingRevenue | Added as response parameter |
CostCenterMappingExpense | Added as response parameter |
RecognizedRevenue | Added as response parameter |
Units | Added as response parameter |
UnitDrivenFlag | Added as response parameter |
UnitPluralName | Added as response parameter |
ExpenseDocumentNumber | Added as response parameter |
UtilizationBasisMinutes | Added as response parameter |
UtilizedMinutes | Added as response parameter |
NormalWorkingMinutes | Added as response parameter |
WorkingMinutes | Added as response parameter |
ForReportingOnlyFlag | Added as response parameter |
TimeCardMarkedNonBillableFlag | Added as response parameter |