The Workforce Frozen Snapshot fact will periodically capture a snapshot of the workforce data and keep it unchanged to allow reporting back on the data at a particular point in time. The snapshot frequency can be configured in various different modes. Snapshots can be purged when they reach a given age.
Optional or Mandatory
This task is optional; however, the default option will not collect any frozen snapshots.
Applies to
All sources (E-Business Suite, PeopleSoft and Fusion).
Task description in detail
To enable the feature, configure the following parameters:
Snapshot Mode (HR_WRKFC_SNAPSHOT_HIST_MODE_CODE)
Note: The options are described in more detail in the table below.
None (default value)
Start of Month
End of Month
Relative to Start
Relative to End
Day of Week
Snapshot Extract From Date (HR_WRKFC_SNAPSHOT_HIST_EXTRACT_DATE)
Set this to the earliest date from which to generate frozen snapshots.
Keep Period Type (KEEP_PERIOD)
Calendar Day
Calendar Week
Calendar Month
Calendar Quarter
Calendar Year
Number of Periods (NUM_OF_PERIOD)
Default 0 (keeps all snapshots)
Set to a positive number N to automatically purge snapshots older than N periods (as specified by Keep Period Type)
Value | Description |
---|---|
None (default) |
The feature is disabled. The other options are described in more detail in the following sections. The frozen snapshots are stored in the table W_WRKFC_SNP_F. |
Start of Month |
Snapshots taken once per month on the first day of each month. No other parameters need to be configured. |
End of Month |
Snapshots taken once per month on the last day of each month. No other parameters need to be configured. |
Relative to Start |
Snapshots taken once per month on the nth occurrence of a given day of each month, for example 3rd Tuesday of each month. Other parameters need to be configured:
|
Relative to End |
Snapshots taken once per month on the nth occurrence of a given day from the end each month, for example 3rd Tuesday from the end each month. Other parameters need to be configured:
|
Day of Week |
Snapshots taken once per week on a specific day of week, for example every Monday. Other parameters need to be configured:
|
Dependency
No dependencies.