Use this screen to import timesheet data from Deltek Time & Expense.
Do not select one of the Auto Adjust check boxes until you are ready to perform the final upload for a timesheet period. Timesheets must remain unposted until all timesheets are complete. Until you perform the final upload, each upload from Time & Expense adds new lines to the existing, unposted timesheets. This provides a better audit trail.
When you perform the final upload with an Auto Adjust check box selected, the application includes all existing timesheet lines from the timesheets that have previously been uploaded, in addition to any new lines.
You can also use the Auto-Adjust Timesheets screen to auto-adjust the uploaded timesheets.
Use this program whenever you need to import timesheet data from Deltek Time & Expense. Before you run this application, you must select a Deltek Time & Expense Version on the Corporate Labor Settings subtask of the Configure Labor Settings screen.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
This field always displays One.
Enter, or click to select, the name of the file to be processed.
File Location
This field always displays One.
Enter, or click to select, the location of the file to be processed.
Enter the range of dates to be included from the input file. When the Roll Up Timesheet Dates check box in the Options group box is not selected, any record in the input file that is outside this range is not imported and is not written to the error file. However, records that were not imported are included on the Error Report with a warning message and a record number of "0."
This field always displays Range.
Enter, or click to select, the starting timesheet date.
Enter, or click to select, the ending timesheet date. If you select the Roll Up Timesheet Dates check box, enter the timesheet date that will be used for all the imported timesheets.
This field always displays One.
Enter, or click to select, the fiscal year, period, and subperiod to be used as defaults. These do not override values in the input file but are used if the fiscal year, period, and/or subperiod in the input file are blank.
Select this check box to auto adjust timesheets for salaried employees. This check box is available only if the Enable for Salaried Employees check box is selected in the Selective Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen.
Select this check box to auto adjust timesheets for hourly employees. This check box is available only if the Enable for Hourly Employees check box is selected in the Selective Auto-Adjust group box on the Overtime Settings subtask of the Configure Labor Settings screen.
Enter the auto adjust percentage to be applied. If you do not specify an Override Auto Adjust %, Costpoint uses the Default Auto-Adjust % on the Manage Timesheet Periods screen for the employee's timesheet cycle.
Rules for Auto-Adjustment of D and N Type Timesheets
If the Use Ref Date in Correcting and Labor Only TS check box is selected on the Configure Labor Settings screen, Costpoint uses the D or N timesheet's Reference Date to determine the employee's Salary Amount and Rate Type status for use in auto-adjusting.
If the Use Ref Date in Correcting and Labor Only TS check box is NOT selected on the Configure Labor Settings screen, Costpoint uses the D or N Timesheet Date to determine the employee's Salary Amount and Rate Type status for use in auto-adjusting.
If the employee is Salaried and the Auto-Adjust Salaried Employees check box is selected, Costpoint auto-adjusts any D and N type timesheets for that employee. If you specified an Override Auto Adjust % in this screen, that value is used; otherwise, the Default Auto-Adjust % for the employee's Timesheet Cycle is used (this is current auto-adjust logic).
If the employee is Hourly and the Auto-Adjust Hourly Employees check box is selected, Costpoint auto-adjusts any D and N type timesheets for that employee. If you specified an Override Auto Adjust % in this screen, that value is used; otherwise, the Default Auto-Adjust % for the employee's Timesheet Cycle is used (this is current auto-adjust logic).
After inserting D and N timesheets into Costpoint tables, the application sets the timesheet type (TS_HDR. S_TS_TYPE_CD) to C. The Sequence Number (TS_HDR.TS_HDR_SEQ_NO) is incremented to a maximum value of 99 to avoid duplicate key issues. A sequence number is assigned to the N type timesheet, then the D type timesheet.
Assumptions for D and N Type Timesheets
Time & Expense exports timesheet types R (Regular), C (Correcting), N (Reversing), and D (Replacement).
Do not change the original timesheet in Costpoint. (This could cause an imbalance between the original timesheet and the reversal (N type) timesheet from Time & Expense.)
If timesheets are auto-adjusted for salaried employees in Costpoint, the Signature Process must be set to Auto-Adjust for all salaried Employee Classes in Time & Expense.
If timesheets are auto-adjusted for hourly employees in Costpoint, the Signature Process must be set to Auto-Adjust for all salaried Employee Classes in Time & Expense.
Select this check box to prorate labor costs for salaried employees in the final upload of the timesheet cycle. If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is None, this check box is cleared and disabled.
From the drop-down list, select the timesheet type to be used as a default if there is no timesheet type in the input file. This does not override values entered in the input file. Valid options are:
Bonus
Correcting
Labor Only
Regular
Enter, or click to select, a date to override the effective bill date Default Method from the Configure Labor Settings screen.
Select this check box to have Costpoint calculate applicable union cash fringes when you import a timesheet for a union employee. This check box is enabled only if the Enable Union Functionality check box is selected on the Configure Labor Settings screen. Union cash fringe timesheet lines are built according to settings on the Manage Union Profile Setup screen.
Select this check box to ignore dates in the input file and put all records on one timesheet.
If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is Days per Cycle, this check box is cleared and disabled.
Select this check box to add together lines in the input file when they belong to the same account, project, organization, and so forth. If the Withholding State differs, the lines are not rolled up.
If the Calculation Method in the Prorate Options group box in the Configure Labor Settings screen is Days per Cycle, this check box is cleared and disabled.
Select this check box to format segmented IDs. Segmented ID fields are Costpoint fields (such as account, organization, project, reference number 1, reference number 2, project report, and organization) that require segment separators (periods or dashes). If you select this check box, the upload takes longer.
Click and select Edit Report to print the Import Timesheets from Time Collection Edit Report. This button is enabled after the input file is preprocessed (see "Print"). The Import Timesheets from Time Collection Edit Report lists any timesheet records that are ready for import.
Click to preprocess the specified input file and preview the error report. Any errors and/or warnings found during the preprocessing are displayed in the error report. Timesheets that do not have errors are available for import.
Click to preprocess the specified input file and print the error report. Any errors and/or warnings found during the preprocessing are listed in the error report. Timesheets that do not have errors are available for import.
Click to read the input file, create the temporary table, validate the records, print the error report, and import valid timesheets into the timesheet tables. Details of the import appear later in this document.
Click to import the rows from the temporary table (created by the process) into the Timesheet Header and Timesheet Line tables. Details of the import appear later in this document.