For Peoplesoft implementations the file domainValues_Wrkfc_EventType_psft.csv file is used to populate persisted staging table, W_PSFT_DMN_WEVT_TYP_PS, which is then used to load data into the dimension table, W_WRKFC_EVENT_TYPE_D.
The default domainValues_Wrkfc_EventType_psft.csv file contains event groups, sub groups, and events, which are supported by the workforce event dimension. Using the columns EVENT_TYPE, EVENT_REASON, ORG_CHANGE_FLG, JOB_CHANGE_FLG, POS_CHANGE_FLG, GRD_CHANGE_FLG, LOC_CHANGE_FLG, and SUP_CHANGE_FLG, map a combination of source system attribute changes to a conformed warehouse event.
The default domain values for the event types include;
By default, the following events are defined in the domainValues_Wrkfc_EventType_psft.csv file under the column heading, EVENT_NAME:
- International Transfer End
- Additional Assignment End
- Assignment Change
- Renew Contract
- Assignment Start
- International Transfer
- New Hire
- Involuntary Termination
SELECT ACTION, ACTION_REASON, DESCR
ORDER BY 1;
Then edit the file $PMServer\LkpFiles\domainValues_Wrkfc_EventType_psft.csv file and map each of the combinations above to one of the combinations of:
Note: In the CSV file there is a column called EXCLUDE_FLG. Setting this value to Y for a PeopleSoft Action/Action Reason will prevent it from being picked up as events in the Workforce Event Fact are loaded. Excluding some events that are not required for analysis helps limit the size of the Workforce Event Fact table.