If Load from Spreadsheet is selected in the Docking field on the TX TEAM Report - Load page, you can load the number of docked and additional days in the Regular Payroll (RP) data from a comma-delimited .csv file.
The following table shows the columns, column names, descriptions, data types, lengths, and valid values for the docking spreadsheet.
|
Column |
Column Name |
Description |
Data type |
Length |
Valid Values |
|---|---|---|---|---|---|
|
A |
Employee Number |
The employee’s identification (ID) number. |
Integer |
6 |
Not applicable |
|
B |
TRS Position Code |
The employee's TRS position code. |
Char |
2 |
Valid values:
If only one character is entered, a leading zero is added. |
|
C |
Start Date |
The starting date of the docking/additional days period. The format is MM/DD/YYYY. |
Date |
4 |
The date must be within the reporting month/year. |
|
D |
End Date |
The ending date of the docking/additional days period. The format is MM/DD/YYYY. |
Date |
4 |
The date must be within the reporting month/year. |
|
E |
Type Flag |
Indicates the type of upload. |
Char |
1 |
Valid values:
|
|
F |
Total Days |
The total number of days worked in the reporting month/year. |
Integer |
3 |
If the Type Flag value is A, the valid value is positive. If the Type Flag value is D, the valid value is negative. |