Dim.ProjectPlanningLevel
This is a single select list of the values available in the Project Planning Level drop-down. This table contains Type 1 data for the Project Planning Level values you have configured in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| ProjectPlanningLevelKey | Data Mart identifier for this data | int |
| ProjectPlanningLevelOid | VersionOne identifier for this data | int |
| ProjectPlanningLevelName | Name | varchar |
| ProjectPlanningLevelOrder | The order this value appears in the VersionOne drop-down list | int |
| ProjectPlanningLevelAssetState | State of this value (Active or Closed) | varchar |
| ProjectPlanningLevelCreateDateUTC | Date and time this value was created | datetime |
| ProjectPlanningLevelLastModifiedDateUTC | Date and time this value was last modified | datetime |
| ProjectPlanningLevelCreatedByKey | Data Mart identifier of the Dim.Member that created this value | int |
| ProjectPlanningLevelLastModifiedByKey | Data Mart identifier of the Dim.Member that last modified this value | int |
| ProjectPlanningLevelCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| ProjectPlanningLevelLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |