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:

  • HR_WRKFC_SNAPSHOT_DAY_CODE to specify the day, for example Tuesday.

  • HR_WRKFC_SNAPSHOT_DAY_OCCURENCE to specify the nth occurrence, for example 3rd Tuesday.

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:

  • HR_WRKFC_SNAPSHOT_DAY_CODE to specify the day, for example Tuesday.

  • HR_WRKFC_SNAPSHOT_DAY_OCCURENCE to specify the nth occurrence, for example 3rd Tuesday.

Day of Week

Snapshots taken once per week on a specific day of week, for example every Monday. Other parameters need to be configured:

  • HR_WRKFC_SNAPSHOT_DAY_CODE to specify the day, for example Monday.

Dependency

No dependencies.