Loading Time Record Group using HCM Data Loader for Multiple Assignments

Summary

Loading Time Record Group using HCM Data Loader for Multiple Assignments

Content

I have been asked to investigate the possibility of uploading time data to the Time and Labor module for multiple assignments. I have reviewed the Loading Time Record Group using HCM Data Loader White Paper and have noticed that this may not necessarily cater for multiple assignments. The customer has a combined time card layout which includes 'Position' not 'Assignment Number' but i cannot see Position in the list of Attribution on the Time Card using the following SQL:-

SELECT ATRB.NAME, ATRB.DISPLAY_NAME, ATRB.CLASS, ATRB.ATTRIBUTE_TYPE FROM HWM_TM_ATRB_FLDS_VL ATRB WHERE ATRB.ATTRIBUTE_CATEGORY NOT IN ('TIME_BUILDING_BLOCK', 'TIME_RECORD', 'TIME_RECORD_GROUP')