• Author / Uploaded
• Yonny Isidro Rendon

Citation preview

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes Oracle Fusion Time and Labor ORACLE WHITE PAPER

|

MARCH 2018

Table of Contents Introducing Fast Formula Use in the Oracle Cloud Time and Labor

4

Rule Templates, Rules, and Rule Sets

1

Workforce Management Formulas

1

Rule Template

1

Rules

3

Rule Sets

3

Formula Types Formula Type: WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES

2

Description

2

First Available Release

2

Rule Template Header Indicators

2

Formula Type: WORKFORCE_MANAGEMENT_TIME_DEVICE_RULES

3

Description

3

First Available Release

3

Rule Template Header Indicators

3

Formula Type: WORKFORCE_MANAGEMENT_TIME_ENTRY_RULES

4

Description

4

First Available Release

4

Rule Template Header Indicators

4

Formula Type: WORKFORCE_MANAGEMENT_TIME_SUBMISSION_RULES Description

1 |

1

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

6 6

First Available Release

6

Rule Template Header Indicators

6

Formula Type: WORKFORCE_MANAGEMENT_SUBROUTINE Description

8

First Available Release

8

Formula Type: WORKFORCE_MANAGEMENT_ UTILITY

8

Description

8

First Available Release

8

Contexts

9

Workforce Management Functions Working Storage Area Functions

11 Error! Bookmark not defined.

Rule Parameter and Header Values Functions

12

Miscellaneous Functions

13

Data Access View Entry (DAVE) Functions

16

Database Items (DBIs)

2 |

8

17

Base Route Name: HWM_EMP_HOLIDAY_SCHEDULE_RN

17

Base Route Name: HWM_EMP_SCHD_DEVIATION_RN

18

Base Route Name: HWM_EMP_SCHD_EMPLOYMENT_SCHEDULE_RN

19

Base Route Name: HWM_PAY_OVERTIME_ASSIGNED_PAYROLL_LVL_RN

20

Base Route Name: HWM_PAY_OVERTIME_ASSIGNMENT_LVL_RN

20

Base Route Name: HWM_PAY_OVERTIME_RELATIONSHIP_LVL_RN

20

Base Route Name: HWM_PAY_PAYROLL_ASSIGNED_PAYROLLS_RN

21

Base Route Name: HWM_PAY_PAYROLL_RELATIONSHIPS_DETAIL_RN

21

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

Base Route Name: HWM_PAY_REL_GROUP_RN

21

Base Route Name: HWM_PAY_TC_REQUIRED_ASSIGNED_PAYROLLS_LVL_RN 22 Base Route Name: HWM_PAY_TC_REQUIRED_ASSIGNMENT_LEVEL_RN

22

Base Route Name: HWM_PER_ASG_ASSIGNMENT_DETAILS_RN

22

Base Route Name: HWM_PER_ASG_WORK_MEASURES_RN

34

Base Route Name: HWM_PER_DERIVED_DETAILS_RN

34

Base Route Name: HWM_PUB_SCHD_PUBLISHED_SCHEDULE_RN

34

Base Route Name: HWM_TIME_ALLOCATIONS_RN

35

Input Attributes

3 |

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

38

Introducing Fast Formula Use in the Oracle Cloud Time and Labor Oracle Cloud Fast Formula is an easy way to configure the existing functionality in Oracle Cloud Time and Labor. Formulas are pieces of code that can receive information from calling program (packages), access database information, and return values to the calling program. The calling program can use this information to modify the process functionality. The fast formula language hides the complexity of accessing the tables and column.

A formula can return more than one value to the calling program. Different programs that call the formula expect outputs to return differently. Based on the formula type, the number and data type of values to return are already defined. » Some programs expect the defined names for outputs: the location of an output in the return statement does not matter. If defined names are expected and the formula does not use the expected names, the process errors out at run time. » Some programs expect the output to return by location; in this case the name of outputs does not matter.

4 |

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

Rule Templates, Rules, and Rule Sets Time and Labor uses a rule template to associate input values, parameters, and outputs with a fast formula while processing time rules. The formula and template enable the return of as many data types as required. Each data type is associated with time attributes in the template. As shown in this figure, formulas are associated with rule templates, which are used to create rules. A group of rules form a rule set. Rule sets are attached to worker time processing setup profiles.

Workforce Management Formulas Workforce Management encompasses the architecture, core components, and applications to manage time-related information for workers. It also encompasses both the Oracle Fusion Time and Labor and Oracle Fusion Absence Management applications and other shared components. Formulas for Time and Labor rules are delivered with the WFM designation in the name, representing Workforce Management. These formulas contain: » Logic for processing or calculating time » Parameters that enable rules to pass values to the formula for use in calculations » Outputs that the formula uses to return calculation results to the rules You can use a single formula in multiple rule templates.

Rule Template A rule template is an interface that exposes inputs, parameters, and outputs from the associated fast formula. The purpose of rule templates is to simplify rule configuration. Administrators determine exactly what parameters the formula requires and the outputs that the formula returns. They document this information in the template. When administrators create a rule, they pick the template to use rather than the formula. The template automatically populates the description of all outputs and provides a mechanism that helps administrators enter the parameters.

1 |

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

As shown in this figure, you can create a time entry validation rule template with Defined_Limit (the maximum number of work hours) as a parameter.

The rule template ensures that the parameters are of the correct data type. The same logic applies to template outputs. The rule template can ensure that the outputs uses only specific time attributes, and the correct number of outputs is associated with the formula results. Note: Multiple rules can share the same template with different parameter values. For example, two rules created using the preceding example rule template could have the defined limit values of 36 and 40 hours, respectively.

2 |

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

Rules Time and Labor administrators use the delivered rule template types to create different types of rules: Rule Type

Description

Example Rule Usages

Time calculation

Creates or updates time card entries and uses the data to create calculated results based on formula logic.

Handle overtime or premium pay by updating reported time or creating additional calculated time.

Time device

Evaluates time events imported from time collection devices and creates time entry exceptions.

Create time entry exceptions for entries affected by reported time outside the specified grace period.

Time entry

Validates time card entries and generates a message with a defined severity.

When reported time exceeds a specified weekly maximum, display the specified message.

Time submission

Determines when to automatically save and submit time card entries created with time events imported from time collection devices.

Automatically save a time card after each Out application event.

Identifies upcoming compliance exceptions by reviewing time card data and unprocessed time events so that the exceptions can be prevented or resolved quickly.

Notify managers when young workers are approaching mandated worked time limits.

Workforce compliance

Automatically submit a time card after receiving the Out application event for the last scheduled shift of the week.

Notify managers when workers start new shifts before the minimum rest period is over.

Rule Sets Rule sets are a date-effective collection of rules or rule sets of the same type. Effective dates enable you to add, delete, and edit rules and embedded rule sets within the rule set. Assign rule sets to groups of workers with similar validations or premium pay requirements using a time processing profile.

3 |

Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes

Formula Types The workforce management (WFM) formula types available for time rule templates are: » WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES » WORKFORCE_MANAGEMENT_TIME_DEVICE_RULES » WORKFORCE_MANAGEMENT_TIME_ENTRY_RULES » WORKFORCE_MANAGEMENT_TIME_SUBMISSION_RULES » WORKFORCE_MANAGEMENT_WORKFORCE_COMPLIANCE_RULES Additional WFM formula types available for WFM formulas but not for rule templates are: » WORKFORCE_MANAGEMENT_SUBROUTINE » WORKFORCE_MANAGEMENT_ UTILITY

1 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES Description You can select only formulas with this formula type when creating time calculation rule templates.

Figure 1: TCR template type with WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES formulas.

First Available Release This formula type is available as of release 11.1.8. Rule Template Header Indicators Header Indicator

Description

Rule Classification

Choice list with the values applicable to time calculation rules

Rule Execution Type

Specify whether rules must create additional hours or update existing hours. This indicator displays only for time calculation rule templates when the associated formula includes this indicator. Examples:

» Create: Rule processing creates total calculated time of 12 hours, which is 2 hours more than the reported time. » Keeps the 10 hours of Regular time at the regular hourly rate » Creates 2 hours of Premium time at .5 times the regular hourly rate » Calculation example: (10 hours * 10 USD) + (2 hours * 5 USD) = 110 USD

» Update: Rule processing creates total calculated time of 10 hours, which matches the reported time. Processing adjusts the pay rate for 2 of the 10 reported hours. » 8 hours of Regular time at the regular hourly rate » 2 hours of Overtime at 1.5 times the regular hourly rate » Calculation example: (8 hours * 10 USD) + (2 hours * 15 USD) = 110 USD Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. » Details: Process the rule against all time entries that match the time category condition. » Day: Process the rule against hours entered for the entire day that match the time category conditions. » Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

2 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_TIME_DEVICE_RULES Description You can select only formulas with this formula type when creating time device rule templates.

Figure 2: TDR template type with WORKFORCE_MANAGEMENT_TIME_DEVICE_RULES formulas.

First Available Release This formula type is available as of release 11.1.11. Rule Template Header Indicators Header Indicator

Description

Rule Classification

Choice list with the values applicable to time calculation rules

Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. » Details: Process the rule against all time entries that match the time category condition. » Day: Process the rule against hours entered for the entire day that match the time category conditions. » Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

Reporting Level

Specify at what level to display the rule message results. This indicator displays only when the associated formula includes this indicator. » Details: Display rule results for all time entries that match the time category condition. » Day: Display rule results for the hours reported for the entire day that match the time category conditions. » Time Card: Display rule results for the hours reported for the entire period that match the time category conditions.

Suppress Duplicate Messages Display

Specify how to handle the generation of repeated messages by selecting one of these two values: » Yes: Display the message just once. » No: Display the message every time that the message generation event occurs.

3 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_TIME_ENTRY_RULES Description Administrators can select only formulas with this formula type when creating time entry rule templates.

Figure 3: TER template type with WORKFORCE_MANAGEMENT_TIME_ ENTRY _RULES formulas.

First Available Release This formula type is available as of release 11.1.8. Rule Template Header Indicators Header Indicator

Description

Rule Classification

Choice list with the values applicable to time calculation rules

Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. » Details: Process the rule against all time entries that match the time category condition. » Day: Process the rule against hours entered for the entire day that match the time category conditions. » Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

Reporting Level

Specify at what level to display the rule message results. This indicator displays only when the associated formula includes this indicator. » Details: Display rule results for all time entries that match the time category condition. » Day: Display rule results for the hours reported for the entire day that match the time category conditions. » Time Card: Display rule results for the hours reported for the entire period that match the time category conditions.

Suppress Duplicate Messages Display

Specify how to handle the generation of repeated messages by select one of these two values: » Yes: Display the message just once. » No: Display the message every time that the message generation event occurs.

4 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Header Indicator

Description

Process Empty Time Card

Specify whether to process time card days with no time entry values. If you select Yes, then the rule processes all entries, not just those with hours. Example: A worker reports these time entries: » » » » » » »

Day 1: 8 hours Day 2: 8 hours Day 3: No reported hours Day 4: 4 hours Day 5: 8 hours Day 6: No reported hours Day 7: No reported hours

If you select Yes, the rule with this formula type generates error messages for days 3, 4, 6, and 7. If you select No, the rule generates a message for day 4 only.

5 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_TIME_SUBMISSION_RULES Description You can select only formulas with this formula type when creating time submission rule templates.

Figure 4: TSR template type with WORKFORCE_MANAGEMENT_TIME_SUBMISSION_RULES formulas.

First Available Release This formula type is available as of release 11.1.11. Rule Template Header Indicators Header Indicator

Description

Rule Classification

Choice list with the values applicable to time calculation rules

Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. » Details: Process the rule against all time entries that match the time category condition. » Day: Process the rule against hours entered for the entire day that match the time category conditions. » Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

6 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_WORKFORCE_COMPLIANCE_RULES Description You can select only formulas with this formula type when creating workforce compliance rule templates. You must create your compliance formulas and then the rule templates, rules, and rule sets that use those formulas. First Available Release This formula type is available as of release 13.17.11 Rule Template Header Indicators Header Indicator

Description

Rule Classification

Choice list with the values applicable to time calculation rules

Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. » Details: Process the rule against all time entries that match the time category condition. » Day: Process the rule against hours entered for the entire day that match the time category conditions. » Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

Reporting Level

Specify at what level to display the rule message results. This indicator displays only when the associated formula includes this indicator. » Details: Display rule results for all time entries that match the time category condition. » Day: Display rule results for the hours reported for the entire day that match the time category conditions. Time Card: Display rule results for the hours reported for the entire period that match the time category conditions.

Suppress Duplicate Messages Display

Specify how to handle the generation of repeated messages by selecting one of these two values: » Yes: Display the message just once. » No: Display the message every time that the message generation event occurs.

7 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Formula Type: WORKFORCE_MANAGEMENT_SUBROUTINE Description Fast formulas have many limitations, one of which is that functions or procedures cannot be created inside the formula. This formula type is a workaround for that limitation. Administrators use this formula type with formulas that provide specific functionality for parent formulas. Since this formula type is not associated with any rule template type, it cannot be selected when creating rule templates. This formula can be called by the other formula types. First Available Release This formula type is available as of release 11.1.8.

Formula Type: WORKFORCE_MANAGEMENT_ UTILITY Description Very similar functionality to the WORKFORCE_MANAGEMENT_SUBROUTINE formula type. You can use the WORKFORCE_MANAGEMENT_SUBROUTINE and WORKFORCE_MANAGEMENT_ UTILITY formula types interchangeably. Using a correct type makes it much easier to determine which formulas are function-specific and which ones are general utility for all formulas First Available Release This formula type is available as of release 11.1.8.

8 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Contexts Formula contexts of different types define the formula's application-specific execution context that you control by setting context values for the formula. Formula context values affect database item and formula function values. Usually, you set context values immediately before calling a formula. You can now include context values in formula expressions, so you no longer have to set context values on entering a formula. You can test whether a context value is set and modify the execution context of a formula in the formula. This table describes the different contexts available for workforce management formulas. All of these contexts are available for all formula types. First Available

Context Name

Description

HWM_FFS_ID

Most workforce management functions use the unique fast formula session ID and rule ID as a key identifier for logs and work area related record processing.

Release 11.1.8

For more details, see the next section, Workforce Management Functions HWM_SUMMATION_LEVEL

HWM_RECORD_POSITION

Gets the summation level from the rule template page. This value indicates how to summarize time cards. This table describes the valid values.

Valid Value

Description

DETAIL

Process each record individually. Usually no summation is required.

DAY

Use to sum and calculate values on a daily basis.

TIMECARD

Use to sum and calculate values for the entire time card period.

The record position value indicates the type of record being processed. This table describes the valid values.

Valid Value

Description

DETAIL

Detail record

END_DAY

End of day record; enables day summation calculation.

END_PERIOD

End period record; the last record for the time card

11.1.8

11.1.8

The time card records are passed to the fast formula in this sequence:

1. Repeat these steps for each day of the time card period: a.

Detail records for the time card day, sorted in a predefined order.

b.

End of day record for the day.

End period record for the time card, it is the final record passed from the time card.

Important: Applies to nonAP fprmulas only. For AP formulas, use HWM_CTXARY_RECORD_POSITIONS in 'Inputs Are ..' parameter instead of HWM_RECORD_POSITION context.

HWM_RULE_ID

The rule ID is the key for the rule currently being processed. This key is used to get parameter values set in the rule and, in combination with HWM_FFS_ID, to store and retrieve work area values.

9 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

11.1.8

First Available

Context Name

Description

HWM_PROJECT_ID

The project ID associated with the time card record currently being processed.

11.1.8

HWM_RESOURCE_ID

The resource ID or person ID associated with the time card record currently being processed.

11.1.8

HWM_CTX_SEARCH_END_DATE

The end date used to search for the relevant records to process.

11.1.8

HWM_CTX_SEARCH_START_DATE The start date used to search for the relevant records to process.

11.1.8

HWM_MEASURE_DAY

The total measure for the time card day to use when processing records.

11.1.8

HWM_MEASURE_PERIOD

The total measure for the time card period to use when processing records.

11.1.8

HWM_SUBRESOURCE_ID

The subresource ID or assignment ID associated with the time card record currently being processed.

11.1.8

HWM_CTX_PERIOD_END_DATE

Date identifying the end of the time card period being used to process records.

11.1.8

HWM_CTX_PERIOD_START_DATE

Date identifying the start of the time card period being used to process records.

11.1.8

HWM_ALLOCATION_DATA_LEVEL

Gets the summation level from the allocation page. This value indicates how to summarize time entries for the allocation. This table describes the valid values.

13.17.05

Release

Valid Value

Description

DAY

Use to sum and calculate values on a daily basis.

TIMECARD

Use to sum and calculate values for the entire time card period.

HWM_ALLOCATION_ID

The allocation ID is the key for the allocation currently being processed.

13.17.05

HWM_ALLOCATION_RULE_ID

The key for the time calculation rule currently being processed. This key is used to get parameter values set in the rule and allocation and, in combination with HWM_FFS_ID, to store and retrieve work area values.

13.17.05

This ID is different from the normal rule ID because it refers to different conditions in the allocation definition. Each source that composes an allocation has a different rule and rule ID. HWM_ALLOCATION_START_DATE

The date when the allocation becomes effective and can be used by the time calculation rule.

13.17.05

GRP_TYPE_ID

The ID for the group type associated with the worker time processing setup profile containing the rule that is currently processing time card records.

13.17.08

HWM_REPEATING_TM_PERIOD_ID The ID for the repeating period associated with the worker time processing setup profile containing the rule that is currently processing time card records.

10 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

13.17.08

Workforce Management Functions Important: Do NOT use fast formula working storage area methods, such as WSA_GET and WSA_SET. Fast formula methods work only between fast formula calls. Since workforce management passes records from Java programs and these values must be stored during the call, you must use these workforce management functions to store and retrieve values in between calls. Function

Description

SET_WRK_NUM( P_FFS_ID

,

Set the numeric value for the item called P_PARM_NAME. Any existing item with the same name is overwritten.

P_PARM_NAME ,

Parameters:

P_PARM_SEQ

P_PARM_VALUE )

» » » »

SET_WRK_DATE(

Same as SET_WRK_NUM, except it is used to store date values.

P_FFS_ID

Parameters:

,

,

P_PARM_NAME , P_PARM_SEQ

,

P_PARM_VALUE )

» » » »

Same as SET_WRK_NUM, except it is used to store string values. Parameters:

P_PARM_SEQ

,

P_PARM_VALUE ) GET_WRK_TEXT( P_FFS_ID

,

P_PARM_NAME , P_PARM_SEQ

,

DEFVAL

) RETURN VARCHAR2

GET_WRK_NUM( P_FFS_ID

» » » »

P_PARM_NAME , P_PARM_SEQ

,

DEFVAL

) RETURN NUMBER

Get the stored value for the item called P_PARM_NAME. If there is no item called P_PARM_NAME, then return the default-value. The data type of the default value is the expected data type for the item.

11.1.8

11.1.8

Parameters: » » » » »

P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. DEFVAL: Default value VARCHAR2 RETURN VARCHAR2: Return a varchar value 11.1.8

Parameters: » » » » »

P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. DEFVAL: Default value NUMBER RETURN VARCHAR2: Return a NUMBER value

GET_WRK_DATE(

Same as GET_WRK_TEXT, except it is used to return date values.

P_FFS_ID

Parameters:

,

11.1.8

P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. P_PARM_VALUE: String value.

Same as GET_WRK_TEXT, except it is used to return numeric values. ,

11.1.8

P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. P_PARM_VALUE: Date value.

P_FFS_ID

P_PARM_NAME ,

Release

P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. P_PARM_VALUE: Numeric value.

SET_WRK_TEXT( ,

First Available

» P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts).

11 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

11.1.8

Function

First Available

Description

P_PARM_NAME , P_PARM_SEQ

,

DEFVAL

) RETURN DATE

» » » »

Release

P_PARM_NAME: Any alphanumeric name. P_PARM_SEQ: Set to 0 unless storing multiple values with the same PARM_NAME. DEFVAL: Default value DATE RETURN VARCHAR2: Return a DATE value

Rule Parameter and Header Values Functions Use these workforce management functions to get rule header and parameter values. Any names used in a rule parameter function appear as input parameter values on the rule template Parameters page. Function

First Available

Description

GET_HDR_TEXT( P_RULE_ID

,

Release

Use this function to get values, set in the basic information section of the rule template definition page, for these text fields.

P_COLUMN_NAME ,

Parameters:

DEFVAL

» P_RULE_ID: Use HWM_RULE_ID context (see Appendix 3: Contexts) » P_COLUMN_NAME: Use one of these valid column names.

)

RETURN VARCHAR2

Column Name

Description

Possible Return Values

RUN_TBB_LEVEL

Reporting level

DAY, DETAIL, TIMECARD

RULE_EXEC_TYPE

Rule execution type

CREATE, UPDATE

SUPPRESS_DUP_MSGS

Suppress duplicate messages display

Y, N

INCLUDE_EMPTY_TC

Process empty time card

Y, N

11.1.8

» DEFVAL: Default value » RETURN VARCHAR2: Return varchar value FUNCTION get_hdr_num( P_rule_Id In Number, p_column_name IN VARCHAR2, defval

IN Number )

RETURN Number;

Use this function to get values set in the basic information section of the rule or rule template definition page, for this numeric field.

11.1.8

Parameters: » P_RULE_ID: Use HWM_RULE_ID context (see Appendix 3: Contexts) » P_COLUMN_NAME: Use one of these valid column names.

Column Name

Description

Possible Return Values

DFLT_ALLOCATION_ID

Default Allocation ID

Number, null

» DEFVAL: Default value » RETURN Number: Return numeric value

GET_RVALUE_NUMBER(

Use this function to get numeric values; set in the Rule Parameters section of the rule.

P_RULE_ID

Note: A rule template uses the name from P_VALUE_NAME to populate the Parameters section of the rule template.

,

12 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

11.1.8

Function

Description

P_VALUE_NAME ,

Parameters:

DEFVAL

» P_RULE_ID: Use the HWM_RULE_ID context (see Appendix 2: Contexts). » P_VALUE_NAME: Use upper case alpha characters and underscores only. The rule template uses this name to populate the Formula Parameter Name section of the Parameter page. » DEFVAL: Default value » RETURN NUMBER: Return numeric value

)

RETURN NUMBER

GET_RVALUE_TEXT(

Same as GET_RVALUE_NUMBER, except it returns string values.

P_RULE_ID

Parameters:

,

P_VALUE_NAME , RETURN VARCHAR2

» P_RULE_ID: Use the HWM_RULE_ID context (see Appendix 2: Contexts). » P_VALUE_NAME: Use upper case alpha characters and underscores only. The rule template uses this name to populate the Formula Parameter Name section of the Parameter page. » DEFVAL: Default value » RETURN NUMBER: Return varchar value

GET_RVALUE_DATE(

Same as GET_RVALUE_NUMBER, except it returns date values.

P_RULE_ID

Parameters:

DEFVAL

)

,

P_VALUE_NAME , DEFVAL

First Available Release

11.1.8

11.1.8

» P_RULE_ID: Use the HWM_RULE_ID context (see Appendix 2: Contexts). » P_VALUE_NAME: Use upper case alpha characters and underscores only. The rule template uses this name to populate the Formula Parameter Name section of the Parameter page. » DEFVAL: Default value » RETURN NUMBER: Return date value

)

RETURN DATE

Miscellaneous Functions Function

Description

ADD_RLOG( P_FFS_ID

,

P_RULE_ID

,

Create a log for tracing and debug. All logs with this function appear on the Analyze Rule Processing Details page of the Time Management work area, in the Rule Processing Log column of the Processing Results section.

First Available Release 11.1.8

Parameters:

P_LOG_TEXT )

» P_FFS_ID: Use the HWM_FFS_ID context (see Appendix 2: Contexts). » P_RULE_ID: Use the HWM_RULE_ID context (see Appendix 2: Contexts). » P_LOG_TEXT: Any string for log/debug purposes. GET_OUTPUT_MSG1(P_APP_SHORT_NAME,

For TER formulas, use this function to format data repository message for output.

P_MESSAGE_NAME

Note: Any message that is passed as output for the data repository MUST use the appropriate GET_OUTPUT_MSG function for proper formatting.

,

TOKEN1_NAME TOKEN1_VALUE RETURN VARCHAR2

, )

Use this function for the message code with a single token. It creates a single message string with one token for the output, formatted for workforce management consumption. Parameters: » » » » »

P_APP_SHORT_NAME: 3-character application short name, in most cases FND P_MESSAGE_NAME: The message code as defined in the FND_MESSAGES table TOKEN1_NAME: The token name as defined in in the FND_MESSAGES table TOKEN1_VALUE: The token Value RETURN VARCHAR2: Formatted message ready for output

Example: message_name:

13 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

11.1.8

Function

First Available

Description

Release

'HWM_FF_TER_PERIOD_GT_MAX_WRN' message_text : The hours entered for the period exceed the maximum limit {DEF_LIMIT} defined for the time card. from fnd_messages P_MESSAGE_NAME: HWM_FF_TER_PERIOD_GT_MAX_WRN TOKEN1_NAME: TOKEN1_VALUE:

'DEF_LIMIT' 8

OUT_MSG = get_output_msg1 ( 'HWM' , P_MESSAGE_NAME, TOKEN1_NAME , TOKEN1_VALUE)

GET_OUTPUT_MSG2(P_APP_SHORT_NAME,

For TER formulas, use this function to format the data repository message for output.

P_MESSAGE_NAME

Same as GET_OUTPUT_MSG1, except for messages use two tokens.

,

TOKEN1_NAME

11.1.8

,

TOKEN1_VALUE

,

TOKEN2_NAME

,

TOKEN2_VALUE

)

RETURN VARCHAR2 GET_OUTPUT_MSG( P_APP_SHORT_NAME ,

For TER formulas, use this function to format the data repository message for output.

P_MESSAGE_NAME

Same as GET_OUTPUT_MSG1, except for messages with no tokens.

)

11.1.8

RETURN VARCHAR2 get_msg_tags

Used only with workforce compliance rules. Add comma-separated tags to message.

p_msg_tags

IN VARCHAR2 )

RETURN VARCHAR2

pTagVals = ' tag1, tag2, Compliance ' tm = get_msg_tags(pTagVals) ,pMsgCd ,tkn , val )

FUNCTION time_hhmm_to_dec(

13.17.11

Sample: ||

get_output_msg1 ( 'FND'

This function converts time to decimal, for example, 2.59 hhmm to 2.983 dec.

13.17.08

Stop processing and raise a fatal error.

13.17.08

Calculate duration (measure) using the start and stop date_time stamps.

13.17.08

Return the short (3 Characters) , upper case day of week from the date, such as MON and TUE.

13.17.08

time_dec IN NUMBER ) RETURN NUMBER; FUNCTION raise_error( p_ffs_id

IN NUMBER ,

p_rule_id

IN NUMBER ,

p_message_text IN varchar2 ) return number ; FUNCTION get_measure_from_time( start_time IN date, stop_time IN date ) RETURN NUMBER; FUNCTION get_date_day_of_Week( p_in_date

IN date )

14 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Function

First Available

Description

Release

RETURN VARCHAR2; FUNCTION get_is_date_same_as_dow(

Compare the date with the string day of week and return YES or No.

13.17.08

FUNCTION is_date_between(

Verify if compare_date is between the start_time and stop_time.

13.17.08

compare_date

» If the date time is between the start and stop dates, the function returns 1. » If the date time is NOT between the start and stop dates, the function returns 0.

p_in_date

IN date ,

p_in_day_of_week

IN VARCHAR2

) RETURN VARCHAR2;

IN date,

start_time

IN date,

stop_time

IN date

)

RETURN number;

FUNCTION get_current_date

Return the current server date and time. The date time is not based on user Time zone.

13.17.08

--

Get the current time stamp for the given resource, time zone type, and so on.

13.17.08

FUNCTION get_current_time (

Input:

RETURN date;

o_staus_log

varchar2,

o_current_time

date,

resource_id

If Resource ID is not provided or to get current time for specific time zone:

NUMBER,

zone_type

IN varchar2,

zone_code

IN varchar2,

gmt_offset

resource_id: if resource Id provided function will return current time based on resource (person) time zone.

IN

zone_type - valid Values ' ZONE' , ' OFFSET' zone_code

number,

gmt_offset

) RETURN

O_STATUS

VARCHAR2;

Zone code, if Zone type set to 'Zone' gmt Offset, if zone type is set to ' OFFSET'

Outputs o_current_time : current time for specified user/time zone, If Status is ''SUCCESS' Return

O_STATUS

(

'SUCCESS',

'FAILED') - Status

o_staus_log: If Status is Failed, information for failure FUNCTION get_duration_start_to_now ( o_staus_log

varchar2,

o_calculated_Hours resource_id start_Time

Calculate the duration from start_time to current time based on the user's time zone or the supplied zone and offset. Input:

number,

IN NUMBER,

resource_id: if resource Id provided function will return current time based on resource (person) time zone.

IN date,

start_Time: Start Date time, of duration to current time

start_zone_type start_zone_code

IN IN

If Resource ID is not provided or to get current time for specific time zone:

varchar2, varchar2,

start_gmt_offset

IN

number

RETURN O_STATUS

VARCHAR2;

)

zone_type - valid Values ' ZONE' , ' OFFSET' zone_code gmt_offset

Zone code, if Zone type set to 'Zone' gmt Offset, if zone type is set to ' OFFSET'

Outputs o_calculated_Hours: Calculated duration(hours) time for specified user/time zone, If Status is ''SUCCESS'

15 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

13.17.08

Function

First Available

Description

Return

Release

O_STATUS

(

'SUCCESS',

'FAILED') - Status

o_staus_log: If Status is Failed, information for failure get_unprocessed_event_set ( staus_log out varchar2, row_count

out number,

Select unprocessed events for a given resource and date range, similar to (executeQuery). The function caches the identified data. Use the get_unprocessed_event_rec function to loop through and retrieve each row.

event_rs_key out varchar2, resource_id

IN NUMBER,

start_date

IN date,

end_date

IN date )

RETURN STATUS

VARCHAR2;

STATUS

TEXT

Output. Request status, possible values are:

» 'NO_REC_FOUND' » 'SUCCESS' » 'FAILED' status_log TEXT The output log file containing detailed information related to the 'FAILED' status and corresponding process data. row_count

NUMBER

Number of rows selected

event_rs_key Text - Output row set key required for get_unprocessed_event_rec function resource_id start_date end_date

get_unprocessed_event_rec (staus_log

NUMBER date date

varchar2,

Event_Type out

varchar2,

STATUS

Event_Time out

date,

» 'NO_REC_FOUND' » 'SUCCESS' » 'FAILED'

out

event_rs_key row_index

varchar2,

IN VARCHAR2 ,

IN NUMBER

RETURN STATUS

End date for row selection

Get individual rows selected by the get_unprocessed_event_set function.

out

Event_InOut

Input Resource Id used to select records

Start Date for row selection

TEXT

Output. Request status, possible values are:

)

VARCHAR2;

staus_log TEXT The output log file containing detailed information related to the 'FAILED' status and corresponding process data. Event output information: Event_Type, Event_Time, Event_InOut event_rs_key Text - Input row set key from get_unprocessed_event_set function row_index use index from 0 to row_count from get_unprocessed_event_set function to loop through and select rows

Data Access View Entry (DAVE) Functions These functions enable you to filter and summarize time repository data that aren't available in the current time card period. The details for each DAVE function are included in the white paper for the release when they first became available. The first DAVE functions were delivered in release 13.

16 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Database Items (DBIs) All DBIs except for the HWM_TIME_ALLOCATIONS_RN DBIs are available starting with release 11.1.12. The HWM_TIME_ALLOCTIONS_RN DBIs are available starting with release 13.17.05. DBIs with a 2-character data type (DN, NN, or TN) are multirow. DBIs with a single-character data type (D, N, or T) are single row. All DBIs allow Null.

Base Route Name: HWM_EMP_HOLIDAY_SCHEDULE_RN Available as of release 11.1.12 Data

Base User Name (DBI Name)

DBI Description

HWM_PUB_HOLIDAY_AVAILABILITY_CODE

Public Holiday Scheduled - Availability Code

TN

, ,

HWM_PUB_HOLIDAY_DATE_SOURCE

Public Holiday Scheduled - Data Source

TN

, ,

HWM_PUB_HOLIDAY_END_TIME

Public Holiday Scheduled - End Date

DN

, ,

HWM_PUB_HOLIDAY_OBJECT_CATEGORY

Public Holiday Scheduled - Object Category

TN

, ,

HWM_PUB_HOLIDAY_OBJECT_NAME

Public Holiday Scheduled - Object Name

TN

, ,

HWM_PUB_HOLIDAY_OBJECT_TYPE

Public Holiday Scheduled - Object Type

TN

, ,

HWM_PUB_HOLIDAY_START_TIME

Public Holiday Scheduled - Start Date

DN

, ,

HWM_PUB_HOLIDAY_SUBRESOURCE_ID

Public Holiday Scheduled -Assignment Resource ID

NN

, ,

Type

17 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Route Context Usages

Base Route Name: HWM_EMP_SCHD_DEVIATION_RN Available as of release 11.1.11 Data

Base User Name (DBI Name)

DBI Description

HWM_EMP_SCHD_END_EARLY_ERR_TYPE

Employment Schedule - End Early Error Type

TN

, ,

HWM_EMP_SCHD_END_EARLY_GRACE_PERIOD

Employment Schedule - End Early Grace Period in Minutes

NN

, ,

HWM_EMP_SCHD_END_GRACE_BEGIN

Employment Schedule - Begin Stop DN Time with Grace Period

, ,

HWM_EMP_SCHD_END_GRACE_END

Employment Schedule - End Stop Time with Grace Period

DN

, ,

HWM_EMP_SCHD_END_LATE_ERR_TYPE

Employment Schedule - End Late Error Type

TN

, ,

HWM_EMP_SCHD_END_LATE_GRACE_PERIOD

Employment Schedule - End Late Grace Period in Minutes

NN

, ,

HWM_EMP_SCHD_END_TIME

Employment Schedule - End Time

DN

, ,

HWM_EMP_SCHD_END_TOLERANCE_BEGIN

Employment Schedule - Begin Stop DN Time with Tolerance

, ,

HWM_EMP_SCHD_END_TOLERANCE_END

Employment Schedule - End Stop Time with Tolerance

DN

, ,

HWM_EMP_SCHD_IS_ELAPSED_SHIFT

Employment Schedule - Elapsed Shift Indicator

TN

, ,

HWM_EMP_SCHD_LONG_DURATION

Employment Schedule - Scheduled Long Duration in minutes

NN

, ,

HWM_EMP_SCHD_SHORT_DURATION

Employment Schedule - Scheduled Short Duration in minutes

NN

, ,

HWM_EMP_SCHD_START_EARLY_ERR_TYPE

Employment Schedule - Start Early Error Type

TN

, ,

HWM_EMP_SCHD_START_EARLY_GRACE_PERIOD

Employment Schedule - Start Early Grace Period in Minutes

NN

, ,

Type

18 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_EMP_SCHD_START_GRACE_BEGIN

Employment Schedule - Begin Start DN Time with Grace Period

, ,

HWM_EMP_SCHD_START_GRACE_END

Employment Schedule - End Start Time with Grace Period

DN

, ,

HWM_EMP_SCHD_START_LATE_ERR_TYPE

Employment Schedule - Start Late Error Type

TN

, ,

HWM_EMP_SCHD_START_LATE_GRACE_PERIOD

Employment Schedule - Start Late Grace Period in Minutes

NN

, ,

HWM_EMP_SCHD_START_TIME

Employment Schedule - Start Time

DN

, ,

HWM_EMP_SCHD_START_TOLERANCE_BEGIN

Employment Schedule - Begin Start DN Time with Tolerance

, ,

HWM_EMP_SCHD_START_TOLERANCE_END

Employment Schedule - End Start Time with Tolerance

DN

, ,

HWM_EMP_SCHD_TOLERANCE

Employment Schedule - Tolerance in Minutes

NN

, ,

Type

Route Context Usages

Base Route Name: HWM_EMP_SCHD_EMPLOYMENT_SCHEDULE_RN Available as of release 11.1.10. Data

Base User Name (DBI Name)

DBI Description

HWM_EMP_SCHD_AVAILABILITY_CODE

Employment Schedule - Availability Code

TN

, ,

HWM_EMP_SCHD_END_DATE_TIME

Employment Schedule - End Date

DN

, ,

HWM_EMP_SCHD_MEASURE

Employment Schedule - Duration in Hours

NN

, ,

HWM_EMP_SCHD_OBJECT_CATEGORY

Employment Schedule - Object Category

TN

, ,

HWM_EMP_SCHD_OBJECT_ID

Employment Schedule - Object ID

NN

, ,

Type

Route Context Usages

19 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

HWM_EMP_SCHD_OBJECT_NAME

Employment Schedule - Object Name

TN

, ,

HWM_EMP_SCHD_OBJECT_TYPE

Employment Schedule - Object Type

TN

, ,

HWM_EMP_SCHD_PERSON_ID

Employment Schedule - Person ID

NN

, ,

HWM_EMP_SCHD_START_DATE_TIME

Employment Schedule - Start Date

DN

, ,

HWM_EMP_SCHD_SUBRESOURCE_ID

Employment Schedule - Assignment Resource ID

NN

, ,

Base Route Name: HWM_PAY_OVERTIME_ASSIGNED_PAYROLL_LVL_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_OVERTIME_PERIOD_ASSIGNED_PAYROLL_LVL Assignment Overtime Period - Assigned Payroll Level

Data Type N

Route Context Usages ,

Base Route Name: HWM_PAY_OVERTIME_ASSIGNMENT_LVL_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_OVERTIME_PERIOD_ASSIGNMENT_LEVEL

Assignment Overtime Period - Assignment level

Data Type N

Route Context Usages ,

Base Route Name: HWM_PAY_OVERTIME_RELATIONSHIP_LVL_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_OVERTIME_PERIOD_RELATIONSHIP_LVL

Assignment Overtime Period - Payroll Relationship Level

Data Type N

20 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Route Context Usages ,

Base Route Name: HWM_PAY_PAYROLL_ASSIGNED_PAYROLLS_RN Available as of release 11.1.10 Data

Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_PAYROLL_ASG_END_DATE

Assignment Payroll Relationship Payroll End Date

D

,

HWM_PAY_REL_PAYROLL_ASG_PAYROLL_ID

Assignment Payroll Relationship Payroll Number

N

,

HWM_PAY_REL_PAYROLL_ASG_START_DATE

Assignment Payroll Relationship Payroll Start Date

D

,

Type

Route Context Usages

Base Route Name: HWM_PAY_PAYROLL_RELATIONSHIPS_DETAIL_RN Available as of release 11.1.10 Data

Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_DTL_PAYROLL_END_DATE

Payroll Relationship - Payroll End Date

D

HWM_PAY_REL_DTL_PAYROLL_RELATIONSHIP_ID

Payroll Relationship - Payroll Relationship ID

N

HWM_PAY_REL_DTL_PAYROLL_RELATIONSHIP_NUMBER

Payroll Relationship - Payroll Relationship Number

N

HWM_PAY_REL_DTL_PAYROLL_RELATIONSHIP_TYPE_ID

Payroll Relationship - Payroll Relationship Type

N

HWM_PAY_REL_DTL_PAYROLL_START_DATE

Payroll Relationship - Payroll Start Date

D

HWM_PAY_REL_DTL_PAYROLL_STAT_UNIT_ID

Payroll Relationship - Payroll Statutory Unit

N

Type

Route Context Usages

Base Route Name: HWM_PAY_REL_GROUP_RN Available as of release 11.1.10 Data

Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_ASSIGNMENT_NUMBER

Assignment Payroll Relationship Assignment Number

T

HWM_PAY_REL_ASSIGNMENT_NUMBER_PAYROLL

Assignment Payroll Relationship Assignment Number - Payroll

N

21 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Base Route Name: HWM_PAY_TC_REQUIRED_ASSIGNED_PAYROLLS_LVL_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_TIME_CARD_REQD_ASG_PAY_LVL

Assignment Payroll Relationship Time Card Required - Assigned Payroll Level

Data Type T

Route Context Usages ,

Base Route Name: HWM_PAY_TC_REQUIRED_ASSIGNMENT_LEVEL_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PAY_REL_TIME_CARD_REQD_ASSIGNMENT_LVL

Assignment Payroll Relationship Time Card Required - Assignment Level

Data Type T

Route Context Usages ,

Base Route Name: HWM_PER_ASG_ASSIGNMENT_DETAILS_RN Available as of release 11.1.10 Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_ACTION_CODE

Assignment - Action Code T

,

HWM_PER_ASG_ACTION_REASON_CODE

Assignment - Action Reason Code

T

,

HWM_PER_ASG_ALLOW_ASG_OVERRIDE_FLAG

Assignment - Allow Assignment Override Indicator

T

,

HWM_PER_ASG_APPLICANT_RANK

Assignment - Applicant Rank

N

,

HWM_PER_ASG_ASSIGNMENT_ID

Assignment - Identifier

N

,

HWM_PER_ASG_ASSIGNMENT_NAME

Assignment - Name

T

,

HWM_PER_ASG_ASSIGNMENT_NUMBER

Assignment - Number

T

,

HWM_PER_ASG_ASSIGNMENT_SEQUENCE

Assignment - Sequence

N

,

HWM_PER_ASG_ASSIGNMENT_STATUS_TYPE

Assignment - Status Type

T

,

HWM_PER_ASG_ASSIGNMENT_STATUS_TYPE_ID

Assignment - Status Type ID

N

,

22 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_ASSIGNMENT_STATUS_TYPE_MEANING

Assignment - Status Type Meaning

T

,

HWM_PER_ASG_ASSIGNMENT_TYPE

Assignment - Type

T

,

HWM_PER_ASG_ASSIGNMENT_TYPE_MEANING

Assignment - Type Meaning

T

,

HWM_PER_ASG_AUTO_END_FLAG

Assignment - Auto End Indicator

T

,

HWM_PER_ASG_AVAILABILITY_WORKDAY_PATTERN

Assignment - Availability Workday Pattern

T

,

HWM_PER_ASG_BARGAINING_UNIT_CODE

Assignment - Bargaining Unit Code

T

,

HWM_PER_ASG_BARGAINING_UNIT_CODE_NAME

Assignment - Bargaining Unit Code Name

T

,

HWM_PER_ASG_BILLING_TITLE

Assignment - Billing Title

T

,

HWM_PER_ASG_BUSINESS_GROUP_ID

Assignment - Business Group ID

N

,

HWM_PER_ASG_BUSINESS_UNIT_ID

Assignment - Business Unit Id

T

,

HWM_PER_ASG_COLLECTIVE_AGREEMENT_ID

Assignment - Collective Agreement ID

N

,

HWM_PER_ASG_CONTRACT_DESCRIPTION

Assignment - Contract Description

T

,

HWM_PER_ASG_CONTRACT_DOC_STATUS

Assignment - Contract Document Status

T

,

HWM_PER_ASG_CONTRACT_DOC_STATUS_CHANGE_DATE

Assignment - Contract Document Status Change Date

D

,

HWM_PER_ASG_CONTRACT_DURATION

Assignment - Contract Duration

N

,

HWM_PER_ASG_CONTRACT_DURATION_UNITS

Assignment - Contract Duration Units

T

,

HWM_PER_ASG_CONTRACT_EFFECTIVE_END_DATE

Assignment - Contract Effective End Date

D

,

HWM_PER_ASG_CONTRACT_EFFECTIVE_START_DATE

Assignment - Contract Effective Start Date

D

,

HWM_PER_ASG_CONTRACT_ID

Assignment - Contract ID

N

,

HWM_PER_ASG_CONTRACT_JOB_TITLE

Assignment - Contract Job Title

T

,

HWM_PER_ASG_CONTRACT_NUM_OF_EXTENSIONS

Assignment - Contract Number of Extensions

N

,

23 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_CONTRACT_PARTIES

Assignment - Contract Parties

T

,

HWM_PER_ASG_CONTRACT_STATUS

Assignment - Contract Status

T

,

HWM_PER_ASG_CONTRACT_STATUS_MEANING

Assignment - Contract Status Meaning

T

,

HWM_PER_ASG_CONTRACT_STATUS_REASON

Assignment - Contract Status Reason

T

,

HWM_PER_ASG_CONTRACT_TYPE

Assignment - Contract Type

T

,

HWM_PER_ASG_CONTRACT_TYPE_MEANING

Assignment - Contract Type Meaning

T

,

HWM_PER_ASG_CONTRACT_WORK_TERMS_TYPE

Assignment - Contract Work Terms Type

T

,

HWM_PER_ASG_CREATION_DATE

Assignment - Creation Date

D

,

HWM_PER_ASG_DATE_PROBATION_END

Assignment - Date Probation End

D

,

HWM_PER_ASG_DEPARTMENT_ID

Assignment - Department ID

N

,

HWM_PER_ASG_DUTIES_TYPE

Assignment - Duties Type

T

,

HWM_PER_ASG_EFFECTIVE_END_DATE

Assignment - Effective Start Date

D

,

HWM_PER_ASG_EFFECTIVE_START_DATE

Assignment - Effective End Date

D

,

HWM_PER_ASG_EMPLOYEE_CATEGORY

Assignment - Employee Category

T

,

HWM_PER_ASG_EMPLOYEE_CATEGORY_MEANING

Assignment - Employee Category Meaning

T

,

HWM_PER_ASG_EMPLOYMENT_CATEGORY

Assignment - Employment T Category

,

HWM_PER_ASG_EMPLOYMENT_CATEGORY_MEANING

Assignment - Employment T Category Meaning

,

HWM_PER_ASG_ESTABLISHMENT_ID

Assignment Establishment ID

N

,

HWM_PER_ASG_FREEZE_START_DATE

Assignment - Freeze Start T Date

,

HWM_PER_ASG_FREEZE_UNTIL_DATE

Assignment - Freeze Until Date

T

,

HWM_PER_ASG_FREQUENCY

Assignment - Frequency

T

,

24 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_FREQUENCY_MEANING

Assignment - Frequency Meaning

T

,

HWM_PER_ASG_FTE

Assignment - Position FTE

N

,

HWM_PER_ASG_FULL_PART_TIME

Assignment - Full time or Part time

T

,

HWM_PER_ASG_GRADE_ACTIVE_STATUS

Assignment - Grade Active Status

T

,

HWM_PER_ASG_GRADE_CODE

Assignment - Grade Code T

,

HWM_PER_ASG_GRADE_EFFECTIVE_END_DATE

Assignment - Grade Effective End Date

D

,

HWM_PER_ASG_GRADE_EFFECTIVE_START_DATE

Assignment - Grade Effective Start Date

D

,

HWM_PER_ASG_GRADE_ID

Assignment - Grade ID

N

,

HWM_PER_ASG_GRADE_NAME

Assignment - Grade Name

T

,

HWM_PER_ASG_GRADE_TYPE

Assignment - Grade Type

T

,

HWM_PER_ASG_HOURLY_SALARIED_CODE

Assignment - Hourly Salary Code

T

,

HWM_PER_ASG_HOURLY_SALARIED_CODE_MEANING

Assignment - Hourly Salary Code Meaning

T

,

HWM_PER_ASG_INTERNAL_EXTERNAL_FLAG

Assignment Organization Internal External Indicator

T

,

HWM_PER_ASG_JOB_ACTIVE_STATUS

Assignment - Job Active Status

T

,

HWM_PER_ASG_JOB_APPROVAL_AUTHORITY

Assignment - Job Approval Authority

N

,

HWM_PER_ASG_JOB_BENCHMARK_JOB_FLAG

Assignment - Job Benchmark Job Indicator

T

,

HWM_PER_ASG_JOB_CODE

Assignment - Job Code

T

,

HWM_PER_ASG_JOB_EFFECTIVE_END_DATE

Assignment - Job Effective End Date

D

,

HWM_PER_ASG_JOB_EFFECTIVE_START_DATE

Assignment - Job Effective Start Date

D

,

HWM_PER_ASG_JOB_FULL_PART_TIME

Assignment - Job Full time or Part time

T

,

HWM_PER_ASG_JOB_FUNCTION_CODE

Assignment - Job Function Code

T

,

25 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_JOB_ID

Assignment - Job ID

N

,

HWM_PER_ASG_JOB_MANAGER_LEVEL

Assignment - Job Manager Level

T

,

HWM_PER_ASG_JOB_MANAGER_LEVEL_NAME

Assignment - Job Manager Level Name

T

,

HWM_PER_ASG_JOB_MED_CHECKUP_REQ

Assignment - Job Medical Checkup Required

T

,

HWM_PER_ASG_JOB_NAME

Assignment - Job Name

T

,

HWM_PER_ASG_JOB_POST_SOURCE_NAME

Assignment - Job Post Source Name

T

,

HWM_PER_ASG_JOB_REGULAR_TEMPORARY

Assignment - Job Regular or Temporary

T

,

HWM_PER_ASG_LABOUR_UNION_MEMBER_FLAG

Assignment - Labor Union T Member Indicator

,

HWM_PER_ASG_LABOUR_UNION_MEMBER_FLAG_MEANING

Assignment - Labor Union T Member Indicator Meaning

,

HWM_PER_ASG_LAST_UPDATE_DATE

Assignment - Last Update Date

D

,

HWM_PER_ASG_LEGAL_ENTITY_ID

Assignment - Legal Employer ID

N

,

HWM_PER_ASG_LEGISLATION_CODE

Assignment - Legislation Code

T

,

HWM_PER_ASG_LEGISLATION_NAME

Assignment - Legislation Name

T

,

HWM_PER_ASG_LEGISLATIVE_DATA_GROUP_NAME

Assignment - Legislative Data Group Name

T

,

HWM_PER_ASG_LOCATION_CODE

Assignment - Location Code

T

,

HWM_PER_ASG_LOCATION_ID

Assignment - Location ID

N

,

HWM_PER_ASG_LOCATION_NAME

Assignment - Location Name

T

,

HWM_PER_ASG_LOC_ACTIVE_STATUS

Assignment - Location Active Status

T

,

HWM_PER_ASG_LOC_ATTRIBUTE_CATEGORY

Assignment - Location Attribute Category

T

,

HWM_PER_ASG_LOC_BILL_TO_SITE_FLAG

Assignment - Location Bill to Site Indicator

T

,

HWM_PER_ASG_LOC_COUNTRY

Assignment - Location Country

T

,

26 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_LOC_COUNTRY_NAME

Assignment - Location Country Name

T

,

HWM_PER_ASG_LOC_DERIVED_LOCALE

Assignment - Location Derived Locale

T

,

HWM_PER_ASG_LOC_EFFECTIVE_END_DATE

Assignment - Location Effective End Date

D

,

HWM_PER_ASG_LOC_EFFECTIVE_START_DATE

Assignment - Location Effective Start Date

D

,

HWM_PER_ASG_LOC_INTERNAL_LOC_CODE

Assignment - Location Internal Code

T

,

HWM_PER_ASG_LOC_LONG_POSTAL_CODE

Assignment - Location Long Postal Code

T

,

HWM_PER_ASG_LOC_OFFICE_SITE_FLAG

Assignment - Location Office Site Indicator

T

,

HWM_PER_ASG_LOC_OFFICIAL_LANG_CODE

Assignment - Location Official Language Code

T

,

HWM_PER_ASG_LOC_POSTAL_CODE

Assignment - Location Postal Code

T

,

HWM_PER_ASG_LOC_REGION1

Assignment - Location Region1

T

,

HWM_PER_ASG_LOC_REGION2

Assignment - Location Region2

T

,

HWM_PER_ASG_LOC_REGION3

Assignment - Location Region3

T

,

HWM_PER_ASG_LOC_SHIP_TO_SITE_FLAG

Assignment - Location Ship to Site Indicator

T

,

HWM_PER_ASG_LOC_TIMEZONE_CODE

Assignment - Location Time Zone Code

T

,

HWM_PER_ASG_LOC_TIMEZONE_OFFSET

Assignment - Location Time Zone Offset

T

,

HWM_PER_ASG_LOC_TOWN_OR_CITY

Assignment - Location Town or City

T

,

HWM_PER_ASG_MANAGER_FLAG

Assignment - Manager Indicator

T

,

HWM_PER_ASG_MANAGER_FLAG_MEANING

Assignment - Manager Indicator Meaning

T

,

HWM_PER_ASG_MAX_REHIRE_DATE

Assignment - Maximum Rehire Date

D

,

HWM_PER_ASG_MIN_REHIRE_DATE

Assignment - Minimum Rehire Date

D

,

HWM_PER_ASG_NEXT_EFFECTIVE_SEQUENCE

Assignment - Next Effective Sequence

N

,

27 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_NORMAL_HOURS

Assignment - Normal Hours

N

,

HWM_PER_ASG_NOTICE_PERIOD

Assignment - Notice Period

N

,

HWM_PER_ASG_NOTICE_PERIOD_UOM

Assignment - Notice Period UOM

T

,

HWM_PER_ASG_NOTICE_PERIOD_UOM_MEANING

Assignment - Notice Period UOM Meaning

T

,

HWM_PER_ASG_OBJECT_GUID

Assignment - Object GUID

T

,

HWM_PER_ASG_ORG_CODE

Assignment Organization Code

T

,

HWM_PER_ASG_ORG_EED

Assignment Organization Effective End Date

D

,

HWM_PER_ASG_ORG_ESD

Assignment Organization Effective Start Date

D

,

HWM_PER_ASG_ORG_INTERNAL_ADDR_LINE

Assignment Organization Internal Address Line

T

,

HWM_PER_ASG_ORG_NAME

Assignment Organization Name

T

,

HWM_PER_ASG_ORG_TYPE

Assignment Organization Type

T

,

HWM_PER_ASG_ORG_TYPE_MEANING

Assignment Organization Type Meaning

T

,

HWM_PER_ASG_PARENT_ASSIGNMENT_ID

Assignment - Parent Assignment ID

N

,

HWM_PER_ASG_PEOPLE_GROUP_ID

Assignment - People Group ID

N

,

HWM_PER_ASG_PERSON_ID

Assignment - Person ID

N

,

HWM_PER_ASG_PERSON_REFERRED_BY_ID

Assignment - Person Referred By ID

N

,

HWM_PER_ASG_PERSON_TYPE_ID

Assignment - Person Type ID

N

,

HWM_PER_ASG_POSITION_ID

Assignment - Position ID

N

,

HWM_PER_ASG_POSITION_NAME

Assignment - Position Name

T

,

HWM_PER_ASG_POSITION_OVERRIDE_FLAG

Assignment - Position Override Indicator

T

,

28 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_POS_ACTIVE_STATUS

Assignment - Position Active Status

T

,

HWM_PER_ASG_POS_ACTIVE_STATUS_MEANING

Assignment - Position Active Status Meaning

T

,

HWM_PER_ASG_POS_BARGAINING_UNIT_CD

Assignment - Position Bargaining Unit Code

T

,

HWM_PER_ASG_POS_BARGAINING_UNIT_CD_NAME

Assignment - Position Bargaining Unit Code Name

T

,

HWM_PER_ASG_POS_EFFECTIVE_END_DATE

Assignment - Position Effective End Date

D

,

HWM_PER_ASG_POS_EFFECTIVE_START_DATE

Assignment - Position Effective Start Date

D

,

HWM_PER_ASG_POS_FREQUENCY

Assignment - Position Frequency

T

,

HWM_PER_ASG_POS_FREQUENCY_MEANING

Assignment - Position Frequency Meaning

T

,

HWM_PER_ASG_POS_FULL_PART_TIME

Assignment - Position Full Time Or Part Time

T

,

HWM_PER_ASG_POS_HIRING_STATUS

Assignment - Position Hiring Status

T

,

HWM_PER_ASG_POS_MAX_PERSONS

Assignment - Position Maximum Persons

N

,

HWM_PER_ASG_POS_OVERLAP_ALLOWED

Assignment - Position Overlap Allowed

T

,

HWM_PER_ASG_POS_PERM_TEMP_FLAG

Assignment - Position Permanent Temporary Indicator

T

,

HWM_PER_ASG_POS_POS_CODE

Assignment - Position Code

T

,

HWM_PER_ASG_POS_POS_TYPE

Assignment - Position Type

T

,

HWM_PER_ASG_POS_PROB_PERIOD

Assignment - Position Probation Period

N

,

HWM_PER_ASG_POS_PROB_PERIOD_UNIT_CD

Assignment - Position Probation Unit Code

T

,

HWM_PER_ASG_POS_PROB_PERIOD_UNIT_CD_MEANING

Assignment - Position Probation Unit Code Meaning

T

,

HWM_PER_ASG_POS_SEASONAL_END_DATE

Assignment - Position Seasonal End Date

D

,

HWM_PER_ASG_POS_SEASONAL_FLAG

Assignment - Position Seasonal Indicator

T

,

29 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_POS_SEASONAL_START_DATE

Assignment - Position Seasonal Start Date

D

,

HWM_PER_ASG_POS_SECURITY_CLEARANCE

Assignment - Position Security Clearance

T

,

HWM_PER_ASG_POS_SYNC_FLAG

Assignment - Position Synchronization Indicator

T

,

HWM_PER_ASG_POS_TIME_NORMAL_FINISH

Assignment - Position Time Normal Finish

T

,

HWM_PER_ASG_POS_TIME_NORMAL_START

Assignment - Position Time Normal Start

T

,

HWM_PER_ASG_PRIMARY_ASSIGNMENT_FLAG

Assignment - Primary Assignment Indicator

T

,

HWM_PER_ASG_PRIMARY_ASSIGNMENT_FLAG_MEANING

Assignment - Primary Assignment Indicator Meaning

T

,

HWM_PER_ASG_PRIMARY_FLAG

Assignment - Primary Indicator

T

,

HWM_PER_ASG_PRIMARY_WORK_RELATION_FLAG

Assignment - Primary Work Relationship Indicator

T

,

HWM_PER_ASG_PRIMARY_WORK_TERMS_FLAG

Assignment - Primary Work Terms Indicator

T

,

HWM_PER_ASG_PROBATION_PERIOD

Assignment - Probation Period

N

,

HWM_PER_ASG_PROBATION_UNIT

Assignment - Probation Unit

T

,

HWM_PER_ASG_PROBATION_UNIT_MEANING

Assignment - Probation Unit Meaning

T

,

HWM_PER_ASG_PROJECTED_ASSIGNMENT_END_DATE

Assignment - Projected End Date

D

,

HWM_PER_ASG_PROJECTED_START_DATE

Assignment - Projected Start Date

D

,

HWM_PER_ASG_PROJECT_TITLE

Assignment - Project Title

T

,

HWM_PER_ASG_PROPOSED_WORKER_TYPE

Assignment - Proposed Worker Type

T

,

HWM_PER_ASG_REASON_CODE

Assignment - Reason Code

T

,

HWM_PER_ASG_RECORD_CREATOR

Assignment - Record Creator

T

,

HWM_PER_ASG_REL_ACCEPTED_TERMINATION_DATE

Assignment - Relationship D Accepted Termination Date

,

30 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_REL_ACTUAL_TERMINATION_DATE

Assignment - Relationship D Actual Termination Date

,

HWM_PER_ASG_REL_ADJUSTED_SVC_DATE

Assignment - Relationship D Adjusted Service Date

,

HWM_PER_ASG_REL_DATE_START

Assignment - Relationship D Start Date

,

HWM_PER_ASG_REL_LAST_WORKING_DATE

Assignment - Relationship D Last Working Date

,

HWM_PER_ASG_REL_LEGAL_ENTITY_ID

Assignment - Relationship N Legal Entity ID

,

HWM_PER_ASG_REL_LEGISLATION_CODE

Assignment - Relationship T Legislation Code

,

HWM_PER_ASG_REL_LEGISLATION_NAME

Assignment - Relationship T Legislation Name

,

HWM_PER_ASG_REL_LENGTH_OF_SERVICE

Assignment - Relationship N Length Of Service

,

HWM_PER_ASG_REL_NOTIFIED_TERMINATION_DATE

Assignment - Relationship D Notified Termination Date

,

HWM_PER_ASG_REL_ON_MILITARY_SERVICE

Assignment - Relationship T On Military Service

,

HWM_PER_ASG_REL_ORIGINAL_DATE_OF_HIRE

Assignment - Relationship D Original Date of Hire

,

HWM_PER_ASG_REL_PERIOD_OF_SERVICE_ID

Assignment - Relationship N Period of Service ID

,

HWM_PER_ASG_REL_PERIOD_TYPE

Assignment - Relationship T Period Type

,

HWM_PER_ASG_REL_PERIOD_TYPE_MEANING

Assignment - Relationship Period Type Meaning

T

,

HWM_PER_ASG_REL_PRIMARY_FLAG

Assignment - Relationship T Primary Indicator

,

HWM_PER_ASG_REL_PROJECTED_TERMINATION_DATE

Assignment - Relationship D Projected Termination Date

,

HWM_PER_ASG_REL_REHIRE_AUTHORIZER

Assignment - Relationship T Rehire Approver

,

HWM_PER_ASG_REL_REHIRE_REASON

Assignment - Relationship T Rehire Reason

,

HWM_PER_ASG_REL_REHIRE_REASON_MEANING

Assignment - Relationship T Rehire Reason Meaning

,

HWM_PER_ASG_REL_REHIRE_RECOMMENDATION

Assignment - Relationship T Rehire Recommendation

,

HWM_PER_ASG_REL_REVOKE_USER_ACCESS

Assignment - Relationship T Revoke User Access

,

31 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_REL_WORKER_NUMBER

Assignment - Relationship T Worker Number

,

HWM_PER_ASG_RETIREMENT_AGE

Assignment - Retirement Age

N

,

HWM_PER_ASG_RETIREMENT_DATE

Assignment - Retirement Date

D

,

HWM_PER_ASG_SAL_REVIEW_PERIOD

Assignment - Salary Review Period

N

,

HWM_PER_ASG_SAL_REVIEW_PERIOD_FREQUENCY

Assignment - Salary Review Period Frequency

T

,

HWM_PER_ASG_SAL_REVIEW_PERIOD_FREQUENCY_MEANING

Assignment - Salary Review Period Frequency Meaning

T

,

HWM_PER_ASG_SET_OF_BOOKS_ID

Assignment - Set Of Books ID

N

,

HWM_PER_ASG_SPECIAL_CEILING_STEP_ID

Assignment - Special Ceiling Step Id

N

,

HWM_PER_ASG_SPECIAL_CEILING_STEP_NAME

Assignment - Special Ceiling Step Name

T

,

HWM_PER_ASG_STANDARD_WORKING_HOURS

Assignment - Standard Working Hours

N

,

HWM_PER_ASG_STEP_ENTRY_DATE

Assignment - Step Entry Date

D

,

HWM_PER_ASG_SUPPLIER_ASSIGNMENT_NUMBER

Assignment - Supplier Assignment Number

N

,

HWM_PER_ASG_SUPPLIER_EMPLOYEE_NUMBER

Assignment - Supplier Employee Number

N

,

HWM_PER_ASG_SYSTEM_PERSON_TYPE

Assignment - System Person Type

T

,

HWM_PER_ASG_TAX_ADDRESS_ID

Assignment - Tax Address ID

N

,

HWM_PER_ASG_TIME_NORMAL_FINISH

Assignment - Time Normal Finish

T

,

HWM_PER_ASG_TIME_NORMAL_START

Assignment - Time Normal Start

T

,

HWM_PER_ASG_USER_PERSON_TYPE

Assignment - User Person T Type

,

HWM_PER_ASG_WORKING_HOURS

Assignment - Position Working Hours

N

,

HWM_PER_ASG_WORK_AT_HOME

Assignment - Work at home

T

,

HWM_PER_ASG_WORK_AT_HOME_MEANING

Assignment - Work at home Meaning

T

,

32 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_WORK_SCH_WORKDAY_PATTERN

Assignment - Work Schedule Workday Pattern

T

,

HWM_PER_ASG_WORK_TERMS_ASSIGNMENT_ID

Assignment - Work Terms N Assignment ID

,

33 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Type

Route Context Usages

Base Route Name: HWM_PER_ASG_WORK_MEASURES_RN Available as of release 11.1.10 Data

Base User Name (DBI Name)

DBI Description

HWM_PER_ASG_WORK_MEASURES_UNIT

Assignment Work - Measure Unit

T

,

HWM_PER_ASG_WORK_MEASURES_VALUE

Assignment Work - Measure Value

N

,

Type

Route Context Usages

Base Route Name: HWM_PER_DERIVED_DETAILS_RN Available as of release 11.1.10 Base User Name (DBI Name)

DBI Description

HWM_PER_PERSON_ENTERPRISE_HIRE_DATE

Person - Enterprise Hire Date

Data Type D

Route Context Usages

Base Route Name: HWM_PUB_SCHD_PUBLISHED_SCHEDULE_RN Available as of release 11.1.11 Data

Base User Name (DBI Name)

DBI Description

HWM_PUB_SCHD_ACTIVITY_TYPE

Published Schedule - Activity Type

TN

, ,

HWM_PUB_SCHD_DATE_FROM

Published Schedule - From Date

DN

, ,

HWM_PUB_SCHD_DATE_TO

Published Schedule - To Date

DN

, ,

HWM_PUB_SCHD_MEASURE

Published Schedule - Measure

NN

, ,

HWM_PUB_SCHD_ORDER_ENTERED

Published Schedule - Order Entered

NN

, ,

HWM_PUB_SCHD_REC_SOURCE

Published Schedule - Record Source

TN

, ,

HWM_PUB_SCHD_START_TIME

Published Schedule - Start Time

DN

, ,

HWM_PUB_SCHD_STOP_TIME

Published Schedule - Stop Time

DN

, ,

Type

Route Context Usages

34 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

HWM_PUB_SCHD_SUBRESOURCE_ID

Published Schedule Assignment Resource ID

NN

, ,

HWM_PUB_SCHD_TCSMR_CONFIG_SET_ID

Published Schedule Consumer Configure Set ID

NN

, ,

HWM_PUB_SCHD_TCSMR_SET_ID

Published Schedule Consumer Set ID

NN

, ,

HWM_PUB_SCHD_TM_REC_ID

Published Schedule - Record ID NN

, ,

HWM_PUB_SCHD_TM_REC_TYPE

Published Schedule - Record Type

TN

, ,

HWM_PUB_SCHD_TM_REC_VERSION

Published Schedule - Record Version ID

NN

, ,

HWM_PUB_SCHD_UNIT_OF_MEASURE

Published Schedule - Unit of Measure

TN

, ,

Base Route Name: HWM_TIME_ALLOCATIONS_RN Available as of release 13.17.05 Data

Base User Name (DBI Name)

DBI Description

HWM_ALOC_ALLOCATION_ID

Time Allocations - Allocation ID

NN

, , ,

HWM_ALOC_ALLOCATION_LINE_ID

Time Allocations - Allocation Line ID

NN

, , ,

HWM_ALOC_ALLOCATION_LINE_PRIORITY

Time Allocations - Allocation Line Priority

NN

, , ,

HWM_ALOC_ALLOCATION_LN_ATRB_ID

Time Allocations - Allocations Line Attribute ID

NN

, , ,

HWM_ALOC_ALLOCATION_NAME

Time Allocations - Allocation Name

TN

, , ,

HWM_ALOC_ALLOCATION_RULE_ID

Time Allocations - Allocation Rule ID

NN

, , ,

Type

Route Context Usages

35 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Data

Base User Name (DBI Name)

DBI Description

HWM_ALOC_ALLOCATION_RULE_PRIORITY

Time Allocations - Allocation Rule Priority

NN

, , ,

HWM_ALOC_ALLOCATION_TYPE

Time Allocations - Allocation Type

TN

, , ,

HWM_ALOC_ALLOCATION_VALUE

Time Allocations - Allocation Value

NN

, , ,

HWM_ALOC_ATRB_DATA_TYPE

Time Allocations - Attribute Data Type

TN

, , ,

HWM_ALOC_ATRB_FLD_NAME

Time Allocations - Attribute Field Name

TN

, , ,

HWM_ALOC_ATRB_VALUE_DATE

Time Allocations - Attribute Value Date

DN

, , ,

HWM_ALOC_ATRB_VALUE_NUMBER

Time Allocations - Attribute Value Number

NN

, , ,

HWM_ALOC_ATRB_VALUE_TEXT

Time Allocations - Attribute Value Text

TN

, , ,

HWM_ALOC_DATA_LEVEL

Time Allocations - Data Level

NN

, , ,

HWM_ALOC_EFFECTIVE_END_DATE

Time Allocations - Effective End DN Date

, , ,

HWM_ALOC_EFFECTIVE_START_DATE

Time Allocations - Effective Start Date

DN

, , ,

HWM_ALOC_RUN_SUMMATION_LEVEL

Time Allocations - Summation Level

TN

, , ,

Type

Route Context Usages

36 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Data

Base User Name (DBI Name)

DBI Description

HWM_ALOC_TCAT_ID

Time Allocations - Time Category ID

NN

, , ,

HWM_ALOC_TM_ATRB_FLD_ID

Time Allocations - Attribute Field ID

NN

, , ,

Type

Route Context Usages

37 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Input Attributes You can use any attribute listed in the HWM_TM_ATRB_FLDS_VL table as an input for fast formula. To get a complete list from your time repository data dictionary, use this SQL: (SELECT NAME,DISPLAY_NAME, ATTRIBUTE_TYPE FROM HWM_TM_ATRB_FLDS_VL) Input (Attribute Name)

Description

Data Type

Measure

Hours

Time duration in Hours

StartTime

Start Time

Time that the entry started

StopTime

Stop Time

Time that the entry ended

UnitOfMeasure

Unit Of Measure

Unit of measure for the time entry, either Hours or Units

StartGmtOffset

Start GMT Offset

Number of hours to add to GMT to match the zone of the start time for the entry

StartTimeZoneCode

Start TimeZone Code

Zone code for the time that the entry started

StopGmtOffset

Stop GMT Offset

Number of hours to add to GMT to match the zone of the end time for the entry

StopTimeZoneCode

Stop TimeZone Code

Zone code for the time that the entry ended

ZoneType

Zone Type

Time Zone Type ( Time zone code or Offset)

TimeRecordType

Record Type

Type of Record 'RANGE' (Start/stop time was used to calculate time duration) or 'MEASURE' (Time duration was entered without start/stop time

CostSegment

Cost Segment

Payroll cost segment associated with the time entry

LDG_ID

Legislative Data Group

Identifier for partitioned payroll and related data

PJC_PROJECT_ID

Project

Project time attribute associated with the time entry

PJC_TASK_ID

Task

Task time attribute associated with the time entry

PayrollTimeType

Payroll Time Type

Payroll time type attribute associated with the time entry

Location

State

Top level of the geographical hierarchy of state, county, and city in the United States

38 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES

Oracle Corporation, World Headquarters

Worldwide Inquiries

500 Oracle Parkway

Phone: +1.650.506.7000

Redwood Shores, CA 94065, USA

Fax: +1.650.506.7200

CONNECT W ITH US

blogs.oracle.com/oracle facebook.com/oracle twitter.com/oracle oracle.com

Copyright © 2018, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0318 Workforce Management Fast Formula Types, Contexts, Functions, DBIs, and Input Attributes March 2018 Authors: David Cohanoff, John Finnegan, and Lynn Raiser Contributing Authors: [OPTIONAL]

1 | WORKFORCE MANAGEMENT FAST FORMULA TYPES, CONTEXTS, FUNCTIONS, DBIS, AND INPUT ATTRIBUTES