ExportOlapGinsuRecords
- Thomas Sherman (Deactivated)
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. |
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 |