Rapid Time Excel/CI Spreadsheet Update

posted Feb 10, 2017, 12:00 PM by Barbara Thiss
The Rapid Time Excel/CI Spreadsheet (SDCOE_CI_TL_RAPID_TIME_EMPPOS_TEMPLATE_P.xls) has been updated to expand the Empl Record column’s VLOOKUP formula to search for a maximum of 20,000 rows on the EMPPOS tab of the spreadsheet. This change was made to accommodate the higher number of employees found on the District Retro Position List (M_RETRO_POSTN_LIST) query used by larger organizations to populate the EMPPOS tab.

Download the revised SDCOE_CI_TL_RAPID_TIME_EMPPOS_TEMPLATE_P.xls spreadsheet using Internet Explorer from the CRC website located in the Resources > PeopleSoft Resources > Guides and Job Aids section of the CRC website under HCM – Excel/CI. Use this version as your new “master” Rapid Time Excel/CI spreadsheet.

Please Note:
  • The Rapid Time Excel/CI spreadsheet (SDCOE_CI_TL_RAPID_TIME_EMPPOS_TEMPLATE_P.xls) has been moved from the Time & Labor – RT Rapid Time section to the HCM – Excel/CI section under Resources > PeopleSoft Resources > Guides and Job Aids on the CRC website. 
  • We still recommend not exceed 500 rows per staging/submission as issues tend to arise when too much data is loaded at once. 
If you have any questions about Rapid Time Excel/CI spreadsheet update please contact the Customer Service Center (CRC) by submitting a HEAT Self Service Ticket or calling 1-800-289-1500.