Purpose
The purpose of this Report Description is to show Last Employee Action in Effect as of Selected Date. This report shows the most current action (to date) on an employee.
Report Description
This report shows Last Employee Action in Effect as of Selected Date. This report shows the most current action (to date) on an employee.
Report Location
PA: Employee Actions
Report Uses
- This report is used to provide a list of employees and their last action as of a specified date, along with additional details such as action effective date and original hire date. It can be used to answer simple questions such as “Which employees are currently on LOA?” or “Which employees have not had a promotion since being hired?”.
- Use Compa Ratio Rate to evaluate, either at a summary or detail level, how employee salaries compare to others within their specific job market.
How to Generate This Report
This report is generated after selecting values for the mandatory prompts. All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory). Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.
The Mandatory prompts for this report are:
- Organizational Unit
- As of Day
This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as optional in parentheses beside the prompt.
The Optional prompts are:
- Action Type(s)
- Employee(s) PersNo.
- Employment Status(es)
- Job(s)
- Employee Pay Types(s)
- Employee Pay Area(s)
Exclusion prompts exclude specified data by default while allowing customers the flexibility of changing them when necessary. Exclusion prompts are identified by the term Exclude followed by the prompt.
The Exclusion prompts are:
- Exclude Employee Subgroup (Contractors)
Initial Layout
The report lists last employee action in effect based on the prompt selections. Below is a sample of the initial layout rendered.
Continued...
Available Objects
This is a list of the available objects that can be added to the report, from the Document Dictionary once in the Design mode:
Dimensions
- Action Reason
- Action Type
- Age
- Age Range
- Cal Qtr
- Country
- Effective Date
- Emp Pay Area
- Emp Pay Group
- Emp Pay Level
- Emp Pay Type
- Employee
- Employee Group
- Employee Subgroup
- Employee’s Name
- Employment Status
- ESG CAP
- Ethinic Origin
- Fiscal period
- Fiscal year
- Flag
- Gender
- Job
- Job Branch
- Job Family
- Judicial Ann Date
- Length of Serv as of Date of Action
- Next Increase Date
- Organizational Unit
- Original Hire Data
- Personnel Area
- Personnel Subare
- Pos Addr Street
- Pos City
- Pos Country
- Pos County
- Position
- Position Chief
- Prior Position
- Processed Date
- State
- Supplemental Saff 11 Month Limit Required
- Supv Employee
- Supv Position
- Valid To
Measures
- Annual Salary
- Emp Reference Salary
- FTE Annual Salary
- Job Reference Salary
- Prior Salary
Variables
- Prompt Response Action Reason
- Prompt Response Action Type
- Prompt Response As of Day
- Prompt Response Employee Pay Area
- Prompt Response Employee Pay Type
- Prompt Response Employee PersNo
- Prompt Response Employment Status
- Prompt Response Exclude Prompt Response Employee Subgroup
- Prompt Response Job
- Prompt Response Organizational Unit
- Compa Ratio
- Emp/Job Ref Salary
