Projects - Contract Credit Table Formats

Follow DPS specifications for preparing a file containing project-contract credit 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	20	Project number associated with the Contract, Primary Key, required and must exist in PR.
Employee	varchar	20	Employee’s employee number, primary key, required and must exist in EM.
PercentCredit	decimal(19,4)	19,4	Employee’s percentage of Contract Amount. Not required.