Bring data from Prevision to your Lakehouse.
Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
Projects
Field | Type | Description |
---|---|---|
id | String | The unique identifier for the project. |
name | String | The name of the project. |
area | String | The area of the project. |
phase | String | The phase of the project. |
Activities
Field | Type | Description |
---|---|---|
id | String | The unique identifier for the activity. |
part | String | The part of the activity. |
wbsCode | String | The WBS code of the activity. |
percentageCompleted | Number | The percentage completed of the activity. |
expectedPercentageCompleted | Number | The expected percentage completed of the activity. |
startAt | DateTime | The start date of the activity. |
endAt | DateTime | The end date of the activity. |
duration | Number | The duration of the activity in days. |
service | Object | The service associated with the activity, containing a name (String). |
floor | Object | The floor associated with the activity, containing a name (String). |
jobs | Array of Objects | A list of jobs associated with the activity, each containing id , name , wbsCode , percentageCompleted , expectedPercentageCompleted , startAt , endAt , and duration . |
Budget Reports Page
Field | Type | Description |
---|---|---|
id | String | The unique identifier for the budget report. |
name | String | The name of the budget report. |
Last Measurement Data
Field | Type | Description |
---|---|---|
workType | String | The type of work (e.g., ActivityDeadlineMeasurement ). |
percentageCompleted | Number | The percentage completed for this work. |
basePercentageCompleted | Number | The base percentage completed for this work. |
expectedPercentageCompleted | Number | The expected percentage completed for this work. |
work | Object | Contains detailed information about the work item. |
work.id | String | The unique identifier for the work item. |
work.workDuration | Number | The duration of the work. |
work.duration | Number | The duration. |
work.measurementUnit | Object | The measurement unit, containing type and symbol . |
work.service | Object | The service associated with the work, containing id and name . |
work.jobMeasuresPage | Object | A paginated list of job measures. |
work.jobMeasuresPage.nodes | Array | A list of job measure nodes, each containing measuredIn , basePercentageCompleted , percentageCompleted , and expectedPercentageCompleted . |
Last Measurement Task Data
Field | Type | Description |
---|---|---|
workType | String | The type of work (e.g., ActivityDeadlineMeasurement ). |
percentageCompleted | Number | The percentage completed for this work. |
basePercentageCompleted | Number | The base percentage completed for this work. |
expectedPercentageCompleted | Number | The expected percentage completed for this work. |
work | Object | Contains detailed information about the work item. |
work.id | String | The unique identifier for the work item. |
work.name | String | The name of the work. |
work.part | String | The part of the work. |
work.service | Object | The service associated with the work, containing id and name . |
work.floor | Object | The floor associated with the work, containing id and name . |
Physical Schedule Table Query
Field | Type | Description |
---|---|---|
code | String | Activity code. |
description | String | Activity description. |
level | Integer | Activity level in hierarchy. |
duration | Integer | Activity duration in days. |
start_at | String | Activity start date. |
end_at | String | Activity end date. |
baseline_start_at | String | Baseline start date. |
baseline_end_at | String | Baseline end date. |
base_points | String | Base points for each date (JSON string). |
expected_points | String | Expected points for each date (JSON string). |
realized_points | String | Realized points for each date (JSON string). |
Schedule Activities
Field | Type | Description |
---|---|---|
id | String | The unique identifier for the activity. |
endAt | DateTime | The end date of the activity. |
deletedAt | DateTime | The deletion date of the activity. |
startAt | DateTime | The start date of the activity. |
wbsCode | String | The WBS code of the activity. |
workDuration | Number | The work duration of the activity. |
part | String | The part of the activity. |
service | Object | The service associated with the activity, containing id , name , position , startAt , endAt , and createdAt . |
floor | Object | The floor associated with the activity, containing id , name , and replicationGroup . |
jobs | Array of Objects | A list of jobs associated with the activity, each with its own detailed properties. |
workPackageResponsiblesPage | Object | A paginated list of responsible contractors for the activity. |
measurementUnit | Object | The measurement unit for the activity, containing detailed properties like id , name , type , symbol , quantity , and checklist . |