Projects - Contracts Table Format

Follow DPS specifications for preparing a file containing project-contract associations.

Field Name	Data Type	Length	Notes
ContractNumber	Varchar	30	Contract Number for the record, primary key, required and must exist in Contracts.
WBS1	varchar	30	Project number associated with the Contract, Primary Key, required and must exist in PR.
ApprovedDate	datetime		User-entered approved date.
ContractStatus	nvarchar	10	Contract status for the record.
ContractType	nvarchar	10	Contract type for the record.
FeeIncludeInd	nvarchar	1
Notes	ntext
Period	int		Period for the project's contract.
RequestDate	datetime		User-entered request date.