The data file to import Contract links to Skill Rates must consist of five (5) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
|
1 |
Contract ID |
Required |
This is the ID of the contract, and must already exist in the Contract Module. If the contract does not exist, the link will NOT be added. |
|
2 |
Contract Skill Code |
Required |
This is the name of the skill code. The skill code must already exist in the Skills Table, and must already be linked to the Contract ID in the Contract Skills Table. |
|
3 |
Rate Type |
Required |
This is the rate type, and it must already exist in the Rate Types table. |
|
4 |
Date From Which To Apply |
Optional |
This will default to the date of the import if no value is supplied. |
|
5 |
Skill Rate |
Required |
|