|
SHARP Hours:
Mon-Fri: 7AM-6PM
Sat: 1PM-9PM
Sun: 1PM-6PM
SHARP Help Desk:
785-368-8000
Option 1 (SHARP)
*Listen for options.
|
Time and Labor: Reported Time Extract - KTL108
DESCRIPTION:
This report is an extract of data from the Reported Time Table for the pay period specified. The data on this extract represents data from teh on-line Tiem and Labor timesheet. NOTE: There is no .pdf for this report. Instead a .dat Flat File (Results in a fixed width file that can be imported into a spreadsheet or database) is created.
When importing the .dat flat file into Excel, choose the following:
- Delimited
- Semicolon
- Text (for lengthy fields, such as Combo Code)
PARAMETERS TO SET:
For one employee:
-
Pay Period End Date
-
Empl ID
-
Empl Rcd Nbr
For one department or department group:
- Pay Period End Date
- Department
- Department Group ID
FIELDS:
(Note: All fields from the Reported Time Table [timesheet] and a few from Job Data display on the report; just a few are listed below)
- Department ID
- Employee Name
- Employee ID
- Employee Record Number
- Date Under Report (DUR)
- Time Reporting Code (TRC)/TRC Description
- TL Quantity (Hours/ Amount per DUR)
- Reported Status/ Reported Status Description
- Taskgroup/ Taskgroup Description
- Task Profile
- Account Code (Combo Code)
- All Project Costing and General Ledger Chartfields when applicable (Interface agencies only – Associated with data interfaced for employees with the SOKDETAIL Time Reporting Template)
- Job Data Fields: FLSA Status, Empl Type, Empl Class, Reg/Temp, Full/Part-time, FTE, Holiday Schedule
SORT SEQUENCE:
WHERE FOUND:
Time and Labor> Reports>Reported Time Extract
ADDITIONAL INFORMATION:
Job Data Field Values
| FIELD |
VALUES |
VALUE DESCRIPTION |
| FLSA_STATUS |
E |
Exempt |
| FLSA_STATUStatus |
N |
Non-exempt |
| FLSA_STATUS |
X |
Non-covered |
| EMPL_TYPE |
H |
Hourly |
| EMPL_TYPE |
S |
Salaried |
| EMPL_CLASS |
O |
All Other |
| EMPL_CLASS |
D |
Daily Paid |
| EMPL_CLASS |
F |
Unclass Temp Not Ben Eligibl |
| EMPL_CLASS |
H |
Resident Worker |
| EMPL_CLASS |
L |
Unclassified Temp Ben Eligibl |
| EMPL_CLASS |
M |
Elected Officals not lv elig |
| EMPL_CLASS |
P |
Special Project |
| EMPL_CLASS |
S |
Student |
| EMPL_CLASS |
T |
Trainee |
| EMPL_CLASS |
V |
Governors Trainee |
| CLASS_INDC |
C |
Classified |
| CLASS_INDC |
U |
Unclassified |
| REG_TEMP |
R |
Regular |
| REG_TEMP |
T |
Temporary |
| FULL_PART_TIME |
F |
Full-time |
| FULL_PART_TIME |
P |
Part-Time |
| FTE (Full-Time Equivalent) |
-Numeric value- |
Varies |
| HOLIDAY_SCHEDULE |
JUDC |
Judicial 8 Hours |
| HOLIDAY_SCHEDULE |
JUDP |
Judicial 4 Hours |
| HOLIDAY_SCHEDULE |
MO04 |
MOA FLSA Holiday 4 Hrs |
| HOLIDAY_SCHEDULE |
MO06 |
MOA FLSA Holiday 6 Hrs |
| HOLIDAY_SCHEDULE |
MO08 |
MOA FLSA Holiday 8 Hrs |
| HOLIDAY_SCHEDULE |
MO10 |
MOA FLSA Holiday 10 Hrs |
| HOLIDAY_SCHEDULE |
MO12 |
MOA FLSA Holiday 12 Hrs |
| HOLIDAY_SCHEDULE |
PRNT |
Printer 7.5 Hours |
| HOLIDAY_SCHEDULE |
PSTV |
State of Kansas Holiday 0 Hrs |
| HOLIDAY_SCHEDULE |
SO03 |
State of Kansas Holiday 3 Hrs |
| HOLIDAY_SCHEDULE |
SO05 |
State of Kansas Holiday 5 Hrs |
| HOLIDAY_SCHEDULE |
SO06 |
State of Kansas Holiday 6 Hrs |
| HOLIDAY_SCHEDULE |
SO10 |
State of Kansas Holiday 10 Hrs |
| HOLIDAY_SCHEDULE |
SO12 |
State of Kansas Holiday 12 Hrs |
| HOLIDAY_SCHEDULE |
SOKP |
State of Kansas Holiday 4 Hrs |
| HOLIDAY_SCHEDULE |
SOKS |
State of Kansas Holiday 8 Hrs |
|
