Defining Data Retrieval Elements

This chapter provides an overview of data retrieval elements, and discusses how to:

• Work with system elements.

• Work with arrays.

• Work with writable arrays.

• Define brackets.

• Define rate codes.

• Define historical rules.

Understanding Data Retrieval Elements

In Absence Management, you use data retrieval elements to retrieve data from the system.

There are five data retrieval elements included in the system:

• System elements

• Arrays

• Brackets

• Rate codes

• Historical rules

PeopleSoft defines and delivers system elements; you name and define the basic parameters of other elements, such as arrays and brackets.

Batch Processing

During processing, the system truncates data that is retrieved by system elements and arrays when the data exceeds these lengths:

Character fields: 30

Numeric fields: 12.6

See Also

Defining Element Names

Working with System Elements

This section provides overviews of system elements and batch processing of system elements, and discusses how to:

• Name and define system elements.

• View system element details.

• View system element comments.

Understanding System Elements

System elements are delivered and maintained by PeopleSoft and usually contain payee-related data for use in calculations. Although you cannot add system elements, you have the ability to define and alter various parameters that control their use.

There are two types of system elements:

• Database system elements, which come from a predefined list of database records and fields.

• System-computed elements, which come from internally stored data.

  System-computed elements are resolved at different times, for example, at the beginning of calculations, daily, or when a rate code element is encountered, depending on the element's purpose.

Note. To store the value of a database system element for reporting purposes, include the element in your process.

Understanding Batch Processing of System Elements

All system elements, whether they are database or system-computed elements, have several important considerations. A system element that is frequency controlled is annualized by the Frequency field and then deannualized, based on the calendar frequency. Thus, any absence element that uses the Frequency field should be defined as having a frequency equal to the use calendar period frequency. This approach ensures correct results, avoiding additional annualization or deannualization.

Database System Elements

For database elements from effective-dated records, the row selected is based on context. Typically the value is as of the segment end date. If referenced during resolution of a sliced element, the value is as of the slice end date. When retrieving values from job records, for example, the system matches on employee ID, employee record, and the segment and slice end date.

System element definitions for the country being processed and those used by all countries are loaded at the beginning of an absence run. System elements are resolved when used in the absence process.

Note. Only database system elements that are used and have been defined as Store = Yes are stored in the result tables.

PeopleSoft HR Database System Element Records

The following table lists the database tables that populate database system elements:

Note. These HR tables are discussed in detail in the HR documentation.

See Increasing the Workforce.

System-Computed Elements

System-computed elements appear on the output results table only if they are used, provided that the appropriate output options on the Source And Use page are selected.

During batch processing, all database system elements are retrieved and stored in arrays, whereas system-computed element values are retrieved and set by the appropriate processing module. For example, when you process absences, the system populates only those system elements that are specific to absences.

With system-element processing:

• The system populates the first active segment, based on all the active segments that are created for a specific process stat record.

• The system also populates the last active segment, based on all the active segments that are created for a specific process stat record.

Pages Used to Modify and View System Elements

Naming System Elements

Access the System Element Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, System Elements, System Element Name).

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element that you name and define. All of the fields on this page are documented in another chapter in this PeopleBook.

For each system-computed system element that is delivered by PeopleSoft, you can view detailed comments including a general description, when the system element is available, and where the element is used by clicking the Comments link. This is useful information when you want to learn more about how the system uses a specific system element.

See Also

Defining Element Names

Viewing System Element Details

Access the Source And Use page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, System Elements, Source and Use).

Record	Displays the record that the system element populates.
Field Name	Displays the field from which the system element obtains its information.
SetID Controlled	Selected if the field is controlled by SetID. Elements that are controlled by SetID have field name and prompt view values.
Use As Chart Field	This check box is not applicable to Absence Management.
Prompt View	Elements that are controlled by SetID have a prompt view specified. If a SetID-controlled system element is used as a supporting element override for positive input, it also requires a prompt view.
SetID Element	Displays the SetID field name for the system element.

See Also

Business Units, Tablesets and SetIDs

Viewing System Element Comments

Access the Comments for Element <name> page (click the Comments link on the System Element Name page).

For each system-computed system element that is delivered by the PeopleSoft system, you can view detailed comments including a general description, when the system element is available, and where it is used by clicking the Comments link on the System Element Name page. This is useful information when you want to learn about what a specific system element does.

Defining Array Elements

This section provides an overview of arrays and batch processing of arrays, and discusses how to:

• Name an array.

• Select and define information about the SQL statement.

• Define fields retrieved by an array.

• Define formula processing for an array.

Understanding Array Elements

Arrays enable you to retrieve data from external sources such as HR tables—data that you need to use, evaluate, or process in your absence rules.

To build an array, you assemble a Structured Query Language (SQL) statement out of FROM, SELECT, and WHERE clauses using the Array Definition component.

• To define the FROM clause, you identify the table containing the required data in the Record (Table) Name field on the Field Map and Keys page.

• To build the SELECT clause, you identify the table columns (fields) containing the data in the Fields Retrieved group box on the Field Map and Keys page.

• To build the WHERE clause, you define the array keys and the conditions under which rows of data are to be pulled from the database table based on the values of the array keys.

  To do this, you use the fields in the Retrieval Criteria group box on the Field Map and Keys page.

• After defining the SQL statement, you must map the database column values in the array to Absence Management variables.

  These variables hold the column values and make them available for use in Absence Management rules.

  To do this, use the Variable Element Name field on the Field Map and Keys page.

Note. After you construct your SQL statement, you can also define any formulas; you need to evaluate the data retrieved by the array.

Do this on the Array Processing Formulas page.

Note. Arrays are not effective-dated. Any changes are likely to affect retroactive processing.

Understanding Batch Processing of Arrays

Arrays can be used to access data in database tables or views that are not delivered by system elements. They do not resolve to a value but instead invoke processing.

You can create either payee-based arrays or non-payee-based arrays on the Field Map and Keys page. Payee-based arrays are resolved as of the slice or segment that is currently being resolved.

Arrays must be resolved for every segment and slice. If any element set by an array is used by another element that's being sliced, the array itself should be added to the event list to ensure that the array and all return column elements are also sliced. You must enter the array into the event list.

Payee-Based Array Processing

The system performs these steps when processing payee-based arrays:

1. Arrays call the database the first time that they are encountered in a calendar run.

   All of the rows of data that fit the WHERE criteria (based on keys entered) are pulled into memory. The cursors are sorted by employee ID in ascending order, by employee record number in ascending order, and by effective date in descending order.

2. For each payee, a cursor is set to access the appropriate rows of data (the Payee and Effective Date fields based on field use on the Field Map and Keys page).

   Payee-based arrays are aligned per absence based on the period end date. If segmentation occurs and the array is on the event list or is being used in an absence element that is being sliced or segmented, the array must be aligned by slice or segment end date.

3. The array process formulas are applied against the data that is stored in memory (for the payee cursor set above), based on the process code.

4. The database field is resolved to the last row of data against which the process formulas were applied.

Whenever the array is accessed, steps 2 through 4 are performed again. Step 1 is performed only if the payee has changed or if a new slice or segment is being resolved.

Non-Payee-Based Array Processing

When processing non-payee-based arrays, the system performs the following steps:

1. Arrays call the database the first time they are encountered in a calendar run.

   All rows of data that fit the WHERE criteria (based on keys entered) are pulled into memory, so most effective-dated logic should be within the process formula logic.

2. If the table is effective-dated, the lookup formula references the system element that refers to the correct date (segment, slice, period).

   If segmentation occurs and the array is on the event list or is being used in an absence element that's being sliced or segmented, the array must be aligned by slice or segment end date. Arrays can return multiple rows from the database. The process formulas are applied against the rows.

3. The array process formula is run.

4. The database field is resolved to the last row of data against which the process formula was applied.

Whenever the array is accessed, steps 2 through 4 are performed again. Step 1 is performed only if the Reload for Each Resolution or Reload for Each Segment value is selected on the Field Map and Keys page.

See Also

Arrays Used in Batch Processing (Technical)

Pages Used to Define Array Elements

Naming an Array Element

Access the Array Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Arrays, Array Name).

Because arrays are temporary tables that store results only during processing, storing the results after processing isn't necessary. The system clears the Store and Store if Zero check boxes and makes them unavailable for entry.

In addition, arrays are not effective-dated, so this page has no definition as of date. To change an array definition, create a new array and new effective-dated elements that reference it. If a database table or view is renamed, create a new array.

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element you are naming and defining. All of the fields on this page are documented in another chapter in this PeopleBook.

See Also

Defining Element Names

Arrays Used in Batch Processing (Technical)

Selecting and Defining Information for the SQL Statement

Access the Field Map and Keys page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Arrays, Field Map and Keys).

Record (Table) Name

Select the table for the SQL statement to use from the list of PeopleSoft defined tables. In the FROM clause of the SQL statement, the system appends the prefix PS_ to the selected table name. You can also select views. The prompt list displays all SQL tables and views in the database.

Loading Option

Select a value to control how often the array data are refreshed from the database. Values are: Employee-based look-up: Select to create a payee-based array. Data is retrieved once for each payee. When that person is processed, the array storage becomes available for the next payee. Load once (small table):Select to create a non payee-based array. Data is retrieved only once the very first time the array is referenced within the process. Compared to the two "Reload" alternatives, this option can significantly improve performance because the process only accesses the database once to load data. As indicated, this should be used only with smaller tables. The buffer for all arrays with this option combined can only hold 5000 rows. If the data in the table is changed by the process itself (and it is desirable to reflect these updates in the process, Load once is not a good option. Reload for each resolution: Select to create a non payee-based array. Data is retrieved from the database every time the array is resolved. Reload for each segment: Select to create a non payee-based array. Data is retrieved from the database once per segment being processed, regardless of the number of times the array may be resolved within each segment. Note. The loading option that you select controls the key types that you can enter in the Key Type field.

See PeopleTools 8.52: Data Management PeopleBook.

Map Retrieved Fields to Variable Elements

Specify the columns to be retrieved from selected rows in the Array - Fields Retrieved group box (this is the SELECT part of the SQL statement). Also specify the variable elements to populate with the selected columns' values. The system orders the Keyed by Employee arrays by employee ID (and employee record number and effective date, if specified), with employee ID and employee record number in ascending order and effective date in descending order.

Keys and Retrieval Criteria

Review Generated SQL Statement

Using System Elements as Key Values

Depending on your loading option, you can use EmplID, EmplRcd#, and Effdt as key fields.

If you select EmplID or EmplRcd as array keys, the system hides the Operator and Element Name fields and assumes an operator of equal to (=) current EmplID and EmplRcd#. For Effdt, the system assumes an operator of less than or equal to (<=) the date specified in the Compare Effdt (effective date) against field.

For example, if you select Employee-based look-up and enter a key type of EmplID (using field name EmplID), and a key type of EmplRcd# (using field name, EmplRcd#), the system builds a SQL statement that retrieves data for the current payee only.

Using Other as a Key Type in Payee-Based and Non-Payee-Based Arrays

If you are not using one or more of the three provided array key elements—or you want entries beyond those—specify a key field name, an operator, an entry type, and the correct element name.

1. Select the correct operator for the key field (record column) in the WHERE clause.

2. Select an entry type.

3. Enter an element name corresponding to the entry type—this must be a defined element of the type that you selected.

This is the data that the system uses to build the WHERE clause of the SQL statement that it needs for retrieving data for the array. You can enter multiple key fields for your definition.

Note. If you enter multiple rows on the page, the multiple conditions are processed as AND conditions.

Example: User-Defined Key Structure

Say that you're searching the database for a row of data with a matching department ID.

You enter Other DEPTID = System Element DEPTID. The system looks for a row in the Department table (DEPT_TBL) with a DEPTID (department ID) that equals the value in the system element DEPTID for the payee currently being processed when it encounters this array.

Defining Formula Processing for an Array Element

Access the Processing Formulas page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Arrays, Processing Formulas).

Processing Option	Select one of these values to determine when and how the system applies a formula. Values are: By Formula, Apply all Rows: The system selects all the rows required for the array, applies the first formula to all rows, applies the second formula to all rows, and continues for all formulas. By Row, Apply all Formulas: The system selects a row of data from the database and applies each formula on this page to that row. It then selects the next row and applies each formula to that row, continuing for all rows. Look-up: The system selects a row of data from the database, applies each formula on this page to that row, selects the next row, and applies each formula to that row. The first formula that resolves to a value of 1 stops the loop. So if you are searching data for a particular value, the system stops looking when it finds that value. Note. With regards to arrays with look-up processing, if you select a value of Look-up, but do not specify a formula value in the Formula Name field, the system uses the first row of data returned by the array.
Error Formula	Select an Error Formula Name for the system to use during error processing, if no rows are found.
Formula Name	Select the formula that the system applies to each row of data to resolve the array. If you selected Look-up as the array processing option, select a Boolean formula here. Note. Instead of using a formula, consider defining the array so that the desired row of data is always ordered first. Also, if the array will never return more than one row of data, and this row will always contain the desired data, no Formula Name field value is necessary with the processing option of Look-up.

Note. The system automatically assigns a sequence number to each formula. The sequence is unchangeable. If you make a mistake, delete all the items back to the mistake and add the formulas again in the correct order.

See Also

Defining Formula Elements

Defining Writable Array Elements

This section provides overviews of writable arrays, storage considerations for writable arrays, and batch processing of writable arrays, and discusses how to:

• Name a writable array.

• Define writable array records and fields.

Understanding Writable Array Elements

Writable arrays are elements that you can use to populate user-defined result tables. You use PeopleSoft Application Designer to create the result table, then you use the writable array pages that are described in this section to define the element that populates the table during batch processing. Writable arrays are in many ways the opposite of standard arrays. Instead of reading values from a row in a table to user-defined variables, a writable array writes the values of user-defined elements into a row in a table.

Writable arrays make it easy for you to design reports that exactly meet your needs—each row in your table can produce a corresponding line of information in your report. You can also combine multiple tables to create a report, for example, use one table for a report header, one for the body of the report, and another for the footer.

Finally, writable arrays can also conserve valuable storage space by consolidating many vertical rows of information into a single horizontal row.

To define a writable array:

1. Use PeopleSoft Application Designer to create the table that the writable array element populates.

   The first seven fields in the table must be the same as the keys in the basic result tables. You can also use some of the optional result table keys, such as INSTANCE or SLICE_BGN_DT, and include keys that are not used in the basic result tables, such as DEPTID.

   The seven fields are:

   • EMPLID

   • CAL_RUN_ID

   • EMPL_RCD

   • GP_PAYGROUP

   • CAL_ID

   • ORIG_CAL_RUN_ID

   • RSLT_SEG_NUM

2. On the Writable Array Name page, define the naming information for the writable array.

3. On the Definition and Fields page, identify the table that the writable array is to populate, and map the elements that are to populate the table to the corresponding fields (columns) within the table.

Note. When you create a result table using a writable array, the table must include the basic segment status keys shared by all the standard result tables. You can include additional keys as well.

Understanding Storage Considerations for Writable Array Elements

While custom result tables can conserve storage space, they can also increase the need for space if they duplicate data from the standard result tables. Consider using writable arrays to consolidate or temporarily store the following types of results:

• Miscellaneous personal data required for audit purposes.

  You might want to store these values in a single row instead of in the standard result tables and keep the records as long as you need them for auditing purposes.

• Period summary data.

  If you need to summarize data by period on year-to-date reports, you can save summary data for each period for as far back as needed.

• Temporary data used in reports.

  For reporting purposes, you may want to duplicate data found in the standard result tables but present it in a different form. You can then delete the data once you complete the reporting period.

Because you may want to delete temporary data at different times, we leave the management of the data in your result tables up to you.

Understanding Batch Processing of Writable Array Elements

Typically, each call to a writable array element creates one row of data. To produce multiple rows of output, you can use loops within a subprocess section and arrays to call the writable array multiple times. Using pointers and variables, you can populate the same field in a writable array with values from different elements, as long as you do not map character and numeric elements to the same field.

Pages Used to Define Writable Array Elements

Naming a Writable Array Element

Access the Writable Array Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Writable Array Name).

When a writable array resolves successfully, the element itself is set to one. Most likely, you will not want to store this value, so the Store and Store if Zero options on the Element Name page are not selected, by default. You can select them if you choose.

In addition, writable arrays are not effective-dated, so there is no definition as of date on the Writable Array Name page. If you need to change the element's definition, create a new writable array instead, and then create new effective-dated elements that reference the new writable array. If you rename a database table or view, create a new writable array.

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element that you are naming and defining. All of the fields on this page are documented in another chapter in this PeopleBook.

See Also

Defining Element Names

Defining Writable Array Records and Fields

Access the Definition and Fields page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Definition and Fields).

Note. The writable array must have a record name and at least one field name in order to save.

Defining Bracket Elements

This section provides overviews of brackets, interpolation methods, and batch processing of brackets, and discusses how to:

• Define the lookup rules for a bracket.

• Identify the search keys and return columns.

• Enter lookup values.

See Also

Defining Element Names

Understanding Bracket Elements

Brackets enable you to create simple lookup tables. Based on a table that you define in a bracket, a bracket is used to look up data and assign certain values based on the lookup data. Brackets are also called bands and lookup tables.

Brackets can use one or more lookup values (search columns). Using a lookup value, bracket processing returns one or more columns that are available for use in other elements such as formulas.

Before defining a bracket, create any elements that you need to use in the bracket definition. For example, before building a bracket that lets you look up, for example, additional absence entitlements based on years of service, create the duration element that returns the years of service.

To define a bracket:

1. Define the naming information for a bracket on the Bracket Name page.

2. Define the lookup rules for the bracket on the Lookup Rules page.

3. Select the search key values and the return column values that you'll use in the lookup table on the Search Keys/Return Columns page.

4. Enter the lookup values on the Brackets - Data page.

Understanding Interpolation Methods

When a search key doesn't exactly match the lookup values defined for the bracket (on the Bracket Data page), the interpolation method defines how the system calculates the values that the bracket returns.

You can select one of the following three interpolation methods on the Lookup Rules page:

• Linear:

  Uses a mathematical formula to create a prorated value based on the next-higher and next-lower keys (works only with brackets that have one or two numeric keys and with numeric result columns). With the linear interpolation method, you can use a rounding rule to specify the type of rounding for the returned value.

• Use Nearest:

  Uses the value from the row that has the nearest key (works only with brackets that have numeric or date keys).

• Use Next Higher:

  Uses the value from the row that has the next-higher key (works with any bracket).

• Use Next Lower:

  Uses the value from the row that has the next-lower key (works with any bracket).

Use Lowest and Highest Option

For the linear interpolation method, the system looks for the next-lower and next-higher rows to calculate the return value. When there isn't a lower or higher row, you can use the Use Lowest/Highest Option check box on the Lookup Rules page to indicate whether the system should take the lowest or highest matching option.

Understanding Batch Processing of Bracket Elements

In bracket processing, the system looks up a row based on the key values and returns a bracket value.

Brackets always resolve to the value of the first column returned. They are resolved as they're encountered in the process. If an element in the return column of a bracket is encountered during processing, it doesn't automatically invoke resolution of the bracket, because the system doesn't know whether the element is associated with this bracket.

Brackets and all return columns are populated as of applicable slice and segment end dates that are used when encountered during processing, with these criteria:

• If a bracket is used by another element that's being sliced, the bracket and all return column elements are also sliced.

• If the bracket is encountered on the process list, it is resolved for the segment that's currently being processed.

• If a bracket return column needs to be re-resolved during segmentation, the bracket should be used in the calculation or the bracket should be on the event list.

How Brackets Use Interpolation Methods

Three factors need to be considered:

• Interpolation Method (corresponding Use Lowest/Highest Option check box if Use Next Higher, Use Next Lower, or Linear is selected).

• Outside Table Limits (only if there's no match on the first key).

• Error Processing Options (when there's no match using appropriate interpolation methods and selections).

  Two options are available. If Generate Error is selected, the system does not resolve the bracket (or any of the return columns) and puts the calculation in error. If Continue Process is selected, the system resolves the bracket and all the other return columns to be either 0 or blank (depending on the field format).

This table clarifies how batch processing treats each interpolation method:

Additional Notes About Batch Processing for Bracket Elements

Search keys are considered in the order in which they are entered on the bracket definition. Values are in ascending order (based on key order).

For all interpolation methods, if all keys match, use that row. For all interpolation methods, try to match on keys sequentially (first key, second key, and so on).

What to Do When Keys Are Mismatched

If there's a mismatch on the first key:

• Determine whether the mismatch is specified in Outside of the Table Limits.

  If the first key value is under the key 1 value defined on the first row:

  • If Use First Row if Under is selected, use the first row.

  • If Use First Row if Under isn't selected, go to Error Processing Options.

• If the first key value is over the key 1 value defined on the first row:

  • If Use Last Row if Over is selected, use the last row.

  • If Use Last Row if Over isn't selected, go to Error Processing Options.

• If the mismatch isn't specified in Outside of the Table Limits and no interpolation method is selected, go to Error Processing Options.

• If an interpolation method is selected and the field format of the first key is nonnumeric, go to Error Processing Options.

• If an interpolation method is selected and the field format is numeric, go to the appropriate logic, based on the interpolation method process. See details of each interpolation method in the preceding table.

• If there's a mismatch on a subsequent key and no interpolation method is selected, go to Error Processing Options.

• If there's a mismatch on a subsequent key and an interpolation method is selected, consider only the rows where all keys have been matched.

  Go to the appropriate logic based on the interpolation method process. Refer to the details of each interpolation method in the preceding table.

Pages Used to Define Bracket Elements

Naming Bracket Elements

Access the Bracket Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Brackets, Bracket Name).

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element that you are naming and defining. All of the fields on this page are documented in another chapter in this PeopleBook.

See Also

Defining Element Names

Defining Lookup Rules for a Bracket Element

Access the Lookup Rules page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Brackets, Lookup Rules).

Error Processing Options	Select from the following values: Generate Error: Stops processing and generates an error. Continue Process: Continues processing without returning any value.
Outside Table Limits	Defines what happens if the key values are over or under those that are defined in the table: Use First Limit if Under: Select if key values are under those that are defined in the table. Use Last Limit if Over: Select if key values are over those that are defined in the table.
Interpolation Method	Select an interpolation method that defines the values to return if the system doesn't find an exact match; for example, if the key values are between two rows on the table. All interpolation methods use only one search key, the first mismatched one. Select from the following values: Linear: Uses a mathematical formula to create a prorated value based on the next-higher and next-lower keys (works only with brackets that have one or two numeric keys and with numeric result columns). Use Nearest: Uses the value from the row that has the nearest key (works only with brackets that have numeric or date keys). Use Next Higher: Uses the value from the row that has the next-higher key (works with any bracket). Use Next Lower: Uses the value from the row that has the next-lower key (works with any bracket). See Understanding Interpolation Methods.
Use Lowest/Highest Option	When using linear interpolation, the system matches on all search columns that have already been matched. Then it looks for the next-lower and next-higher rows where the search columns match. When there isn't a lower or higher row where search columns match, you can use the Use Lowest/Highest Option check box to indicate whether the system should take the lowest or highest matching option. See Understanding Interpolation Methods.
Rounding Rule Element	With linear interpolation, you can use a rounding rule to specify the type of rounding for the returned value. The system applies this rounding rule to all return columns whose field format is numeric (decimal or monetary), because linear interpolation takes the ratio of the next-lower return column value and the next-higher value and returns the prorated value based on the ratio that is above the next-lower value. The result might be an excess of decimal places. See Understanding Interpolation Methods.

Identifying Bracket Search Keys and Return Columns

Access the Search Keys/Return Columns page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Brackets, Search Keys/Return Columns).

Search Columns

In the Search Columns group box, select the keys that the system uses to search the bracket data. For each key, select the Search Key Type (element type) that you're entering. Then select the corresponding Element Name. You can enter up to five search keys.

Return Columns

In the Return Columns group box, select the columns that tell the system where to store the values returned by the lookup. For each column, select the Return Entry Type(element type) that you're entering. Then select the corresponding Element Name. The bracket itself is the first returned column. You can enter up to eight return columns.

Entering Bracket Lookup Values

Access the Brackets - Data page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Brackets, Data).

Bracket Search Keys and Return Column Values - Search Keys Tab

Enter the values of the search keys.

Bracket Search Keys and Return Column Values - Return Columns Tab

Enter the values to be returned for each search key value, based on your entries on the Search Keys/Return Columns page. You can enter multiple return values.

Defining Rate Code Elements

This section provides overviews of rate code mapping, the use of rate codes and batch processing of rate codes, and discusses how to:

• Name rate code elements.

• Create a rate code element.

Understanding Rate Code Mapping

You can use rate code elements to retrieve multiple components of pay that have been defined in HR—including base pay and non base-pay components.

To have the system retrieve the rate codes set up in HR, matching rate code elements must be defined in Absence Management and mapped to the corresponding HR rate codes. A HR rate code can be associated with only one Absence Management rate code element.

Rate code elements can be defined and mapped to HR rate codes in two ways:

1. If you install Absence Management after creating rate codes in HR, use the Rate Codes - Definition page to create rate code elements and map them to the corresponding rate codes in HR.

   Mapping an element to a HR rate code makes the element take on the values of the HR rate code.

2. If Absence Management is installed when you create rate codes in HR, the creation of the rate code element is dependant on if a row exists on the User Rules Profile page for the rate code creators user ID.

   1. If there is an entry on the User Rules Profile page for the User ID of the person who is creating the Rate Code in HR a matching rate code element is created automatically in Absence Management. This rate code will have the same Used By and Country values on the Rate Code Name page that are defined for the User ID of the person creating the rate code. If a different one is desired, a user will a user ID of All Countries will have to modify the rate code with the applicable change to the Used By and Country fields.

   2. If there is no entry on the User Rules Profile page for the User ID of the person creating the Rate Code in HR, the system does not create a rate code in Global Payroll. It handles it just as in the same manner as described in #1 above. A user with the appropriate User ID set up on the User Rules Profile page will have to go into the Rate Code element in Global Payroll to create the rate code element.

See Restricting User Access.

You can display the rate code elements via the Rate Codes - Definition page in Absence Management. You can also use the page to map the element to a different rate code.

This table lists the values that appear on the Rate Codes - Definition page:

Understanding the Use of Rate Code Elements

Rate code elements return the values of rate codes defined in HR. To use a rate code to calculate a payee's absence information, use the rate code in the absence element definition—either directly, as part of the absence calculation rule, or within a formula or other element used by the absence calculation rule.

See Also

Ordering Elements and Sections in a Process List

Understanding Batch Processing of Rate Code Elements

When the system encounters a rate code element during the absence process, it calls the Rate Code PIN Resolution program, which first determines whether the element, effective on the calendar period end date, represents a base pay rate code or a non base-pay rate code. It then follows the hierarchy for base pay or non base-pay rate code elements, as appropriate, to resolve the rate code.

Criteria for Selecting the Job Row

Absence Management uses the RATE AS OF DATE system element to determine to which maximum effective-dated job row it refers for the rate code.

• If RATE AS OF DATE is unpopulated, the system uses the end date of the current slice or segment to select the job row.

• If RATE AS OF DATE is greater than the calendar period end date, the system uses the calendar period end date to select the job row.

• If RATE AS OF DATE is before the first effective date on job, the rate code resolves to 0 and the payment is put in error.

• In all other cases, RATE AS OF DATE is used.

The FTE factor that applies to some rate codes is retrieved from the maximum effective-dated job row that is less than or equal to the RATE AS OF DATE or slice end date where the payment keys match.

Currency Conversion

When the currency code for a flat amount, hourly, or hourly plus flat amount rate code, as defined in HR, doesn't match the processing currency, Absence Management performs its standard currency conversion during processing. That is, it uses the payee's effective-dated exchange rate type to perform the conversion.

Note. Currency conversion is not required on percent or point rate codes, because returned values are non monetary.

Frequency Conversion

Absence Management also performs frequency conversion on any flat amount or hourly plus flat amount rate code, where the corresponding frequency code in HR doesn't match the calendar period frequency. The system annualizes the rate code using the corresponding frequency factor from HR. It then deannualizes for the calendar period frequency (using the applicable frequency factor). Define all earning elements that use rate codes as Use Calendar Period Frequency.

Note. Frequency conversion is not required on percent or point rate codes, because returned values are non monetary.

Resolving Multiple Instances of the Same Rate Code Element

If the PS_COMPENSATION record contains multiple instances for the same rate code (base pay or non base-pay), the system evaluates each instance separately, sums the instances, and returns one value to the rate code element. Absence Management references two system elements, RATE CODE GROUP and FTE INDICATOR, and applies the following rules:

• If the Rate Code Group differs between the instances, the system element RATE CODE GROUP is resolved according to the last instance and an error message is generated.

• If the FTE indicator differs between instances, the system resolves the system element named FTE INDICATOR according to the last instance and issues a warning message. The payee is not put into an error status. (Absence Management uses the FTE INDICATOR only for rate codes types of flat amount and hourly plus flat amount.)

For example, if a flat amount rate code has one instance in which FTE applies, Absence Management uses the FTE_COMPRATE for this instance. If a second instance indicates that FTE doesn't apply, the system uses the COMPRATE field value for the second instance and sums the two instances.

Hierarchy for Resolving Base Pay Rate Code Elements

When the system encounters a rate code element that's mapped to a HR base pay rate code, it finds the appropriate rows on the PS_COMPENSATION record, where the element matches the rate code. It then identifies the value to be returned, based on the rate code type, as shown in this table:

Hierarchy for Resolving Non Base-Pay Rate Code Elements

When the system encounters a rate code element that's mapped to a HR non base-pay rate code, it derives the rate from the following hierarchy, stopping when it finds the rate:

• Compensation table (PS_COMPENSATION).

• Job Code table (PS_JOBCD_COMP_RATE).

  The system looks for the row where the SetID and Job code fields match the SETID_JOBCODE and JOBCODE system elements.

• HR Comp Rate table (PS_COMP_RATECD_TBL).

The system identifies the value to be returned, based on the rate code type and FTE_INDICATOR, as shown in this table:

Common Elements Used in This Section

Pages Used to Create Rate Code Elements

Naming Rate Code Elements

Access the Rate Code Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Rate Codes, Rate Code Name).

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element that you are naming and defining. All of the fields on this page are documented in another chapter in this PeopleBook.

See Also

Defining Element Names

Creating a Rate Code Element

Access the Rate Code - Definition page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Rate Codes, Definition).

Compensation Rate Code	Enter the HR rate code to which you want to map this element. When you select the rate code, the lower half of the page displays information that is defined for the rate code in HR. You cannot change this information in Absence Management.
Frequency Conversion	This check box is selected by default to indicate that the system is to perform frequency conversion (annualization and deannualization) on the value returned by the rate code. Clear this check box if you want the system to return the value from the rate code definition without performing frequency conversion.
Generate Warning	This check box applies only to rate codes that represent a base pay component. It is selected automatically to indicate that the system generates a warning message during batch processing if it does not find the rate code on the payee's compensation record. Clear the check box if you do not want the system to generate a warning message in these situations.

See Also

Understanding Data Retrieval from HR

Defining Historical Rule Elements

To define historical rule elements, use the Historical Rules (GP_HIST_RULE) component.

This section provides overviews of historical rules and batch processing of historical rules, and discusses how to:

• Define the rule type and periods to be processed.

• Define the formula for a historical rule.

Understanding Historical Rule Elements

You can use historical rule elements to set up rules that retrieve data from prior periods. Historical rules can be used in formulas.

A historical rule can be associated with any element that's stored in the Earnings/Deductions results table, Accumulators results table, or Other Elements results table.

To define a historical rule:

1. Define the naming information for the historical rule on the Historical Rules Name page.

2. Define the rule type and the periods to be processed on the Processing Period page.

3. Define the formula for a historical rule on the Parameters and Mapping page.

Understanding Batch Processing of Historical Rule Elements

You can attach a historical rule to an earning or deduction element on the Formula Definition page or to any element that's stored in the Earnings/Deductions results table (GP_RSLT_ERN_DED), Accumulators results table (GP_RSLT_ACUM), or Other Elements results table (GP_RSLT_PIN).

A historical rule resolves to one if it's successful and to zero if it's not successful. This works the same way as an array element. A historical rule can then be used in a formula such as:

IF HIST_RULE_TEST =1, THEN

Use variable elements populated by historical rule

ELSE

Generate an error

END-IF

A historical rule is set to one when either the end-of-process formula resolves without errors, or if that formula is not used in the processes, the stop-process-if-true variable is set to TRUE.

In all other situations, a historical rule is set to zero and SQL returns no data.

How the System Processes Historical Rule Elements

Here's how the system processes historical rules:

1. The system dynamically creates SQL to load elements requested from the Absence Management result tables.

   It can get data from multiple result tables at one time by using a SQL UNION, meaning direct access to the database each time the historical rule is called. A SELECT and a series of FETCHES are performed each time. The use of this element type affects performance.

2. The system maps columns to variables.

   The variables are available for use in a formula.

3. The first fetch establishes the keys for the first retrieved segment.

   The program continues fetching records until there is a break in the segment keys. It then populates the input and output interface copybook (PINL) with the values for the retrieved elements or with the null values for the elements in the element mapping that were not found. Then the program requests the resolution of Formula to Execute By Segment.

4. The system performs formula resolution per segment.

5. The system resolves an end of process formula for additional calculations such as averaging.

This table lists how calendars and segments are processed in the reverse order in which they were initially run:

Pages Used to Define Historical Rule Elements

Naming Historical Rule Elements

Access the Historical Calculation Name page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Historical Rules, Historical Calculation Name).

Note. You name every element and define its basic parameters on an element name page with the object name of GP_PIN. The page title and general appearance of this page change based on the type of Absence Management element that you are naming and defining. All of the fields on this page are documented in another chapter in this PeopleBook.

See Also

Defining Element Names

Defining the Rule Type and Periods to Be Processed

Access the Processing Period page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Historical Rules, Processing Period).

Note. On the Processing Period page, you create the periods from the date from to the date to date. You then map the selected result data to the processing periods. If no data exists for an element in a period, it is set to spaces for character and date elements and to zeros for numeric and monetary elements.

Example

You want to determine three months of salary (element SALARY) for the period between March 28 and June 27. This table lists the GP_RSLT table values:

If you select Period Begin Date, the historical rule processes only June, May, and April. It does not process July, because July 1, 2003 (the period begin date) is later than the date from date of the historical period (June 27, 2003). It also does not process March, because March 1, 2003 (the period begin date) is before the date to date of the historical period (March 28, 2003).

Note. Historical rules start from the date from date and look at periods and segments in the reverse order in which they were originally processed and go back to the date to date.

If you select Period End Date, the rule processes May, April, and March. It does not process June, because June 30, 2003 (the period end date) is later than the date from date of the historical period (June 27, 2003). It also does not process February, because February 28, 2003 (the period end date) is before the date to date of the historical period (March 28, 2003).

If you select Payment Date, the rule processes May, April, and March. It does not process June, because July 2, 2003 (the payment date) is later than the date from date of the historical period (June 27, 2003). It also does not process February, because March 2, 2003 (the payment date) is before the date to date of the historical period (March 28, 2003).

See Also

Defining Segmentation

PeopleTools 8.52: Data Management PeopleBook

Defining the Formula for a Historical Rule Element

Access the Parameters and Mapping page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Historical Rules, Parameters and Mapping).

When you run an absence run, the system resolves the Formula to Execute by Segment field per historical period until the Stop Process If True variable is not equal to zero or the last historical period is processed. The system then resolves the formula specified in the Formula To Execute at End field.

Element Mapping

The grid in the Element Mapping group box lists the elements for retrieval from the Absence Management result tables for a historical rule.