This page (revision-15) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 26-Nov-2021 10:22 1 KB jmyers to previous
14 26-Nov-2021 10:22 1 KB jmyers to previous | to last
13 26-Nov-2021 10:22 625 bytes jmyers to previous | to last
12 26-Nov-2021 10:22 619 bytes jmyers to previous | to last
11 26-Nov-2021 10:22 611 bytes jmyers to previous | to last
10 26-Nov-2021 10:22 603 bytes jmyers to previous | to last
9 26-Nov-2021 10:22 589 bytes jmyers to previous | to last
8 26-Nov-2021 10:22 576 bytes jmyers to previous | to last
7 26-Nov-2021 10:22 570 bytes jmyers to previous | to last
6 26-Nov-2021 10:22 559 bytes jmyers to previous | to last
5 26-Nov-2021 10:22 546 bytes jmyers to previous | to last
4 26-Nov-2021 10:22 533 bytes jmyers to previous | to last
3 26-Nov-2021 10:22 553 bytes jmyers to previous | to last
2 26-Nov-2021 10:22 2 KB jmyers to previous | to last
1 26-Nov-2021 10:22 6 bytes jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
!!!ENTER ADDITIONAL HOURS WORKED DIALOG
!!!WHERE CLAUSE CREATOR DIALOG
At line 3 changed one line
The Enter Additional Hours Worked Dialog [MPAH] screen allows you to enter time for additional hours worked. The data in the dialog is stored on the [P2K_PR_TIME_SHEET_ENTRIES] table.
The Where Clause Creator Dialog [MPAH] screen allows you to create a Where Clause. The data in the dialog is stored on the [P2K_AM_WHERE_CLAUSES] and [P2K_AM_CONDITIONS] tables.
At line 5 changed 10 lines
;[Date|ENTRY_DATE]:The entry date is defined in this field.
;[Extra Time|TIME_OR_AMOUNT]:The additional hours are recorded in this field.
;[Reason for Time|REASON_FOR_TIME]:The reason for the additional time is provided in this field.
;[Assignment|ASSIGNMENT_CODE]:The assignment associated with the additional time is defined in this field.
;[Position|POSITION_CODE]:The assignment associated with the additional time is defined in this field.
;[Job|JOB_CODE]:The job associated with the additional time is defined in this field.
;[Department|DEPARTMENT_CODE]:The department associated with the additional time is defined in this field.
;[Cost Center|COST_CENTER_CODE]:The cost center associated with the additional time is defined in this field.
;[Work Order|WORK_ORDER]:The work order associated with the additional time is defined in this field.
;[Comments|REFERENCE_INFO]:Any additional information about the extra time is entered in this field.
;[Where Clause|WHERE_CLAUSE_CODE]:This field identifies the Where Clause.
;[Data Source Name|DATA_SOURCE_NAME]:The data source is the table location in which the information being filtered into the where statement is derived from.
;[Where Clause Usage|WHERE_CLAUSE_USAGE]:This field will indicate if the Where Clause is Pre-loaded (system provided), User Defined or Obsolete. All Where Clauses created by clients should have a usage of ‘User Defined’.
;[Description|DESCRIPTION]:This field provides a brief description outlining the intention of the ‘Where Clause’. Although it is not a mandatory field, it is recommended to always provide a brief description for the purpose of clarity
;[Type|CONDITION_TYPE]:This field indicates whether the criteria have been written in the Java or if the criteria are defined on an ‘as required’ basis. There are two options available, Java Defined and Ad Hoc. Users should use the type Ad Hoc.
;[Predefined|PREDEFINED_CONDITION_CODE]:Some 'pre-loaded' where clauses contain java logic, this predefined logic is specified in this field. This field is not used with user-defined where clauses or conditions.
;[Column|COLUMN_NAME]:This field allows you to define the filters to be used with the Where Clause. You may use more than one filter on a where clause. If you do use multiple filter statements, they are joined by ‘and’ in the statement.
;:e.g. You can use multiple columns to return a Positions LOV that will be filtered first by department, next by active status, and finally by date.
;[Operator|COMPARISON_OPERATOR]:This field allows you to provide an SQL statement to further filter the information.
;:e.g. Equals, Formatted Equals, Greater Than, In, Is Not Null, Is Null, Less Than,…\\By selecting [Formatted Equals|FORMATTED EQUALS WC OPERATOR] in the Operator, the user is able to specify a date format in the Format Symbols field.
;[Value|VALUE]:This field indicates what data the column name is to be compared with. For example this could be the as of date, lexicon values, numbers or specific data within the database such as a department code.
;[Test Where Clause|ACT_WHERE_CLAUSE_CHECK_RESULTS]:This button allows you to test the Where Clause to see if it returns the correct information in a timely manner.