Dim.Project
projects are a collection workitems and the constructs used to organize this work (releases, sprints and themes). This table contains Type 1 data for Project information.
Table Description
| Column Name | Description | Datatype |
|---|---|---|
| ProgramKey | Datamart unique identifier for this Program | int |
| ProgramOid | Identifier for the Program | int |
| ProgramName | Program Name | nvarchar |
| ProgramCreateDateUTC | UTC Date Program was created | datetime |
| ProgramLastModifiedDateUTC | UTC Date Program was last modified | datetime |
| ProgramCreatedByKey | Foreign Key to the Member who created this Program | int |
| ProgramLastModifiedByKey | Foreign Key to the Member who last modified this Program | int |
| ProgramCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| ProgramLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |