Docking Spreadsheet - File Layout

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: 00 = Missing Position 01 = Professional/Administrative 02 = Teacher or Full-time Librarian 03 = Support Staff 04 = Bus Driver 05 = Full-time Nurse/Counselor 06 = Peace Officer 07 = Support Staff-Food Service Worker 09 = Summer School Pay 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: A = Additional days (days to be added) D = Docked days (days to be subtracted)
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.