transport report flow

Flussdiagrammknoten

• TRANSPORT REPORT FLOW

• Vendor send excel files called "Process".

• SURA's general process per week

• Pay Pal Spain's general process per week.

• Ocuppancy report SURA

• Ocuppancy report MIGUEL VARGAS

• Join the process in one excel file: General + Pay pal Spain.

• In the Excel file where the process were joined, please filter by:

• Per Site

• 00393 - UP1 -    ULTRA

• 00353 - METRO

• Service type

• cost

• capacity

• trips

• The data "USERS" it must be extracted filter information from:

• Ocuppancy report MIGUEL VARGAS

• Ocuppancy report SURA

• From my WORKDAY Convergys, per site we search the follow information:

• # of employees 

• # of agents

• Last update of week- to 7th day of week. - to 15th day of week. -to 22nd day of week. - to last day of end month.