10/28/10
SHARP Corrections affect the data in the Data Warehouse.
Data is loaded into the HR Data Warehouse incrementally, which means that it extracts, transforms, then loads each day's data. History data is not changed or refreshed until a full refresh or "destructive load" is completed (which will happen occassionally). If a correction is made to any previous date, this will not be reflected in the data warehouse until a refresh is done. Please keep this in mind when you are entering data into SHARP and also when you pull requests from the Data Warehouse.
9/13/10
Make sure to Cancel a request if you are moving to another tab.
9/1/10
Want a column's data to repeat and not group rows? Here is how....
8/27/10
Employee Job Subject Area:
Employee Job Dimension: Fields that are in the Data Warehouse but not in SHARP.
- Current Indicator: Yes or No. This will pull the last effective dated row for an employee as of the day before. (A future dated row is the last effective dated row)
- Active Indicator: 1=Yes or 0=No. This will tell you if the employee is Active.
- If you combine this with the Current Indicator, you will current, active employees as of the last effective dated row in Job.
- If you combine this with the Current Indicator and an employee has a future dated termination/retirement, they will not be in your results.
- HR Status Code: A=Active or I=Inactive. This will tell you if the person is Active, Suspended, Leave w/Pay or Leave w/o Pay.
- If you combine this with the Current Indicator, you will current, active employees as of the last effective dated row in Job.
- If you combine this with the Current Indicator and an employee has a future dated termination/retirement, they will not be in your results.
- Effective Date Month: Pulls the Month and Year (ie. Jan - 2002)
- This is used in charting and reporting.
- Effective Date Month Num: Pulls the Month and Year number (ie. 1-2002).
- This is used in charting and reporting.
