Configuring Human Resurce Analytics Workforce Events WIth Peoplesoft

 When configuring Oracle's Business Intelligence Applications Human Resource Analytics using
a Peoplesoft source, one of the most important steps is the creation configuration file
domainValues_Wrkfc_EventType_psft.csv.

This files controls how rows from the PS_JOB table loaded into the data warehouse are mapped
to standard events like Hires, Terminations, Transfers, etc.

The first step in configuring the CSV is to query the Peoplesoft source to get all of the
potential Action / Reason Code combinations that may appear in the PS_JOB table.

 SELECT ACTION, ACTION_REASON, DESCR FROM PS_ACTN_REASON_TBL ORDER BY 1

Once that list has been genereated, edit the domainValues_Wrkfc_EventType_psft.csv file
with entries for all desired values. Each ACTION/REASON can be mapped to a specific
set of standard domain values for spreadsheet columns:

EVENT_TYPE
EVENT_REASON
W_EVENT_GRP_CODE
W_EVENT_GRP_NAME
W_EVENT_SUBG_CODE
W_EVENT_SUBG_NAME
EVENT_CODE
EVENT_NAME

Use the delivered CSV file for examples of the expected values for these columns.