Project Awards Table Formats (PRAwards)
Follow DPS specifications for preparing a file containing project awards.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| WBS1 | varchar | 30 | The project's project number; primary key; must exist in PR |
| WBS2 | varchar | 7 | Phase's phase number; primary key; must exist in PR |
| WBS3 | varchar | 7 | Task's task number; primary key; must exist in PR |
| Description | varchar | 100 | Award's description; required field |
| Institution | varchar | 100 | Awarding institution |
| AwardDate | datetime | 8 | Award's date |