About Workforce Frozen Snapshot Fact
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.