Time inquiry
Use this function to display labor time recorded for one, or between a range of dates.
You can inquire by company and site, employee, category of time, and status of the time entry record for one, a range of projects, or for all time entry records.
You can access this function directly from a project.
Prerequisites
Refer to documentation Implementation
Screen management
This function is customized to the needs of your organization and your processes. The Inquiry screens function for code PTE determines the way in which you enter information, and how information is displayed and printed.
The Time inquiry function contains a section for you to enter your selection criteria, and a table in which the results of the search are displayed.
Header
Selection
Use this section to filter or select employee time records:
- Start date. The default Start date is the first date of the month two months before the current month, but can be amended.
- End date. The default End date is the last date of the current month, but can be amended.
The search, therefore, covers a 3 month period, by default.
Category, Status
You can filter the results by the category of time, and the status of the time entry record using the Category and Status sections.
You can use the Criteria action to enhance the selection criteria applied.
Block number 3
Selection
Company (field CPY) |
The legal company for which the employee time records are to be selected. |
Operating site (field OPEDEFFCY) |
Use this field to filter for employee time records for a budget site, which will be a financial site, or for a task site, which will be an operational site. Type in or select a specific site code or to include all sites, leave blank. |
Financial site (field FCY) |
Employee (field PAUS) |
The user for which employee time records are to be selected. This user must be enabled for recording time against projects. That is, the Time entry checkbox on their user record is selected. |
Time unit (field UOM) |
This field displays the code that represents the unit of time in which labor is measured for this project, or activity. |
Start date (field PTEDATDEB) |
Filter for results for a specific period of time. For a single day, enter the same date in the Start date and End date fields. The Start date and End date fields are both mandatory. |
Time category (field PTETYP) |
The time category (for example, overtime, double time, travel time) for which the employee time records are to be selected. Leave blank to include all time categories. |
From project (field PJTDEB) |
Filter for results within a range of project codes. For a single project, enter the same project code in the From project and To project fields. The content can be one of the following:
If the value of this field includes a character such as an exclamation mark "!" this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3". To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (the link is to the project cost structure). This field is populated by default with the project code if you accessed this function directly from the project. If you accessed this function from the project structure the project code and project budget/task code is displayed accordingly. |
Whole project (field PJTDSPALL) |
Select this checkbox to view all records linked to the selected projects. To only view records linked to the selected structure of the projects, leave this checkbox clear. If the value of the From / To project field includes a character such as an exclamation mark "!" the search includes the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3". |
Status
Pending validation (field PTESTA1) |
Select this checkbox to filter the employee time records to be selected by the current status (work in progress) of the time entry. The following stages are associated with the processing cycle of a time entry record:
All time entry records must first be validated then controlled (mandatory if the PJMTIMENT-Time entry control phase parameter (TC chapter, PJM group) is set) before they can be approved then posted. Authorization for each stage of the processing cycle of a time entry record is controlled by the user record, as follows:
|
Validated (field PTESTA2) |
Controlled (field PTESTA3) |
Approved (field PTESTA4) |
Posted (field PTESTA5) |
Rejected (field PTESTA6) |
Billable only (field BILLABLE) |
Tab Search results
This section displays all time entry lines that meet the defined selection criteria. Details for each line can include the employee, time spent, date, activity, project, task code, budget code, operation and cost type information.
The columns displayed in the table, and the order in which they are displayed is determined by the Inquiry screens function for code PTE.
Grid
Employee (field PAUS) |
The user code against which employee time records have been entered. This user is enabled for recording time against projects. That is, the Time entry checkbox on their user record is selected. |
Name (field PTENAM) |
This field displays the name defined on this employee's user record. |
Time spent (field PTEQTY) |
This field displays the amount of time this employee entered against a specific activity on a specific date. Time can be entered against a project, a task, a task operation, and against a specific budget code, and for non-project activities such as training or annual leave. |
Time unit (field PTEUOM) |
This field displays the code that applies to the unit of time in which this labor time was recorded. |
Date (field PTEDAT) |
This field displays the specific date this labor time was carried out by this employee. Time can be entered against a project, a task, an operation, for a specific budget code, and for non-project activities such as training, or annual leave. |
Project (field OPPNUM) |
This field displays the code of a particular project or job your company is working on. |
Project description (field OPPDES) |
This field displays the description of the particular project or job. |
Budget code (field PBUCOD) |
This field displays the specific budget code for the displayed project against which this labor time was recorded. Each budget code represents a financial phase of a project. |
Budget description (field PBUDES) |
This field displays the description of the budget code. |
Task (field TASCOD) |
This field displays the specific task code for the displayed project against which this labor time was recorded. Each task code corresponds with an operational phase of a project. |
Task description (field TASDES) |
This field displays the description of the task operation. |
Operation (field OPENUM) |
This field displays the specific task operation sequence number against which this employee's labor time was recorded. |
Operation description (field OPEDES) |
This field displays the description of the task operation sequence number. |
Time (field INQQTY) |
This field displays labor time spent on a specific date against a project in the unit of time defined in the search criteria (Home section). |
Unit (field INQUOM) |
This field displays the code of the unit of time defined in the search criteria. |
Billable time (field BILLABLE) |
Billed on (field BILFRO) |
Billing plan number (field PRGBILNUM) |
Planned load (field EXTQTY) |
This field displays the total time planned or estimated for this task operation for this project. The quantity is expressed in the time unit. |
Consumed load (field CSMQTY) |
This field displays the total time consumed by all employees (the aggregated time) against this task or task operation. The quantity is expressed in the time unit. |
Remaining load (field RMNQTY) |
This field displays the total remaining time (planned time - consumed time) to be consumed against this task or task operation. The quantity is expressed in the time unit. |
Assigned planned (field ASNPLN) |
This field displays the total time planned (estimated) for this particular employee for this task operation in this project. The quantity is expressed in the time unit. |
Assigned consumed (field ASNCSM) |
This field displays the total time consumed by this particular employee against this task operation in this project. The quantity is expressed in the time unit. |
Assigned remaining (field ASNREM) |
This field displays the total remaining time (planned time - consumed time) to be consumed by this employee against this task operation in this project. The quantity is expressed in the time unit. |
Project cost type (field PJMPCC) |
This field displays the project cost type against which this employee's labor time was recorded. Project cost types define types of cost that can affect a project such as raw materials, labor costs and indirect costs. The following rules are applied to time entry records to assign the project cost type:
The Project overview function (PJMOVE) uses this cost type to calculate actuals. |
Employee cost type (field CLBPCC) |
This field displays the cost type against which this employee's labor time was recorded. Project cost types define types of cost that can affect a project such as labor costs. This employee cost type is defined on this employee's user record. If the user cost type is blank, the cost type is defined on the project, or if the user cost type is blank and the project cost type is blank, the cost type is defined in the PCCCOD-Default labor cost type parameter (TC chapter, PJM group). |
Time category (field PTETYP) |
This field displays the specific time category (for example, overtime, double time, travel time) against which this employee's labor time was recorded. |
Status (field PTESTA) |
This field displays the current work in progress status of this time record. The following stages are associated with the processing cycle of a time entry record:
All time entry records must first be validated then controlled (mandatory if the PJMTIMENT-Time entry control phase parameter (TC chapter, PJM group) is set) before they can be approved then posted. Authorization for each stage of the processing cycle of a time entry record is controlled by the user record, as follows:
|
Financial site (field FCY) |
This field displays the site from which this project is managed. |
Entry number (field JOUNUM) |
This field is only populated if this time entry line is at Posted status. It displays the journal number generated when this time entry line was posted as a cost against a project. |
Journal |
Select Journal from the Actions icon to view the journal details for the journal generated when this time entry line was posted. The transaction you select determines the way in which you enter information, and how information is displayed and printed. If only 1 transaction has been set up you are not offered a choice, the default entry screen is displayed. This action is only available for a posted time entry line. |
Specific actions
Select the Search action to load the list of time entry lines that meet the entered selection criteria. The maximum number of lines displayed is defined in the Inquiry screens function for code PTE. |
Select the Criteria action to access additional selection and display criteria. You can filter the time entry lines to be processed by project cost type, routing operation number and employee cost type.
Selection
Company (field CPY) |
The legal company for which the employee time records are to be selected. |
Operating site (field OPEDEFFCY) |
Use this field to filter for employee time records for a budget site, which will be a financial site, or for a task site, which will be an operational site. Type in or select a specific site code or to include all sites, leave blank. |
Financial site (field FCY) |
Employee (field PAUS) |
The user for which employee time records are to be selected. This user must be enabled for recording time against projects. That is, the Time entry checkbox on their user record is selected. |
Time unit (field PTEUOM) |
This field displays the time unit as specified on the task operation on the project, but can be amended. |
From project (field PJTDEBC) |
Filter for results within a range of project codes. For a single project, enter the same project code in the From project and To project fields. The content can be one of the following:
If the value of this field includes a character such as an exclamation mark "!" this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3". To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (the link is to the project cost structure). This field is populated by default with the project code if you accessed this function directly from the project. If you accessed this function from the project structure the project code and project budget/task code is displayed accordingly. |
Whole project (field PJTDSPALL) |
Select this checkbox to view all records linked to the selected projects. To only view records linked to the selected structure of the projects, leave this checkbox clear. If the value of the From / To project field includes a character such as an exclamation mark "!" the search includes the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational structure. For example, if a material task code is "USA-P3" and a project code is "USA12345678", this field displays a link to the project operational structure as "USA12345678!USA-P3". |
Start date (field PTEDATDEB) |
Filter for results for a specific period of time. For a single day, enter the same date in the Start date and End date fields. The Start date and End date fields are both mandatory. |
End date (field PTEDATFIN) |
Operation (field OPENUM) |
Filter the results for a specific task operation sequence number in the selected project(s). Leave blank to include all operation sequence numbers for the selected project(s). |
Status
Pending validation (field PTESTA1) |
Select this checkbox to filter the employee time records to be selected by the current status (work in progress) of the time entry. The following stages are associated with the processing cycle of a time entry record:
All time entry records must first be validated then controlled (mandatory if the PJMTIMENT-Time entry control phase parameter (TC chapter, PJM group) is set) before they can be approved then posted. Authorization for each stage of the processing cycle of a time entry record is controlled by the user record, as follows:
|
Validated (field PTESTA2) |
Controlled (field PTESTA3) |
Approved (field PTESTA4) |
Posted (field PTESTA5) |
Rejected (field PTESTA6) |
Billable time (field BILLABLE) |
Category
Time category (field PTETYP) |
The time category (for example, overtime, double time, travel time) for which the employee time records are to be selected. Leave blank to include all time categories. |
Cost type
Project cost type (field PJMPCC) |
Filter the results for a specific project cost type. Leave blank to include all project cost types. Project cost types define types of cost that can affect a project such as raw materials, labor costs and indirect costs. The following rules are applied to time entry records to assign the project cost type:
|
Employee cost type (field CLBPCC) |
Filter the results for a specific employee cost type. Leave blank to include all cost types. Project cost types define types of cost that can affect a project such as labor costs. The cost type is defined on the employee's user record. If the user cost type is blank, the cost type is defined on the project, or if the user cost type is blank and the project cost type is blank, the cost type is defined in the PCCCOD-Default labor cost type parameter (TC chapter, PJM group). |
Employee
Employee company (field CPYAUS) |
Employee site (field FCYAUS) |
Role (field ROLAUS) |
Display
Screen code (field ECRAN) |
Memo code (field MEMO) |
Error messages
The only error messages are the generic ones.
Tables used
Refer to documentation Implementation