a Peoplesoft source, one of the most important steps is the creation configuration file
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_
with entries for all desired values. Each ACTION/REASON can be mapped to a specific
set of standard domain values for spreadsheet columns:
Use the delivered CSV file for examples of the expected values for these columns.