table

Batch_Control ETL_NO BATCH_Type BATCH_Date batch_Start_Time batch_End_Time IS_Daily IS_Reload is_part_load 1 Hermes Daily Load 05/02/2019 05/02/2019 5:05 05/02/2019 15:00 N N N 2 Hermes Daily Load 06/02/2019 06/02/2019 5:05 06/02/2019 15:00 Y N N Job_Master job_id Group_Id Site/Country COUNTRY Site_Description Plug_Type Plug_Name Source Mandatory_flag is_active Dependency_order File_Name CRT_datetime UPD_DATETIME 1 1 LATAM AR Latin America Referential Account ATLAS Y Y 1 AR_Account 05/02/2019 5:05 05/02/2019 5:05 2 1 LATAM AR Latin America Referential Client ATLAS Y Y 1 AR_Client 05/02/2019 5:05 05/02/2019 5:05 3 1 LATAM AR Latin America Referential National Client ATLAS Y Y 1 AR_National Client 05/02/2019 5:05 05/02/2019 5:05 4 1 LATAM AR Latin America Referential Account External ATLAS Y Y 1 AR_Account External 05/02/2019 5:05 05/02/2019 5:05 5 1 LATAM AR Latin America operational 09391ST SCT4CIB Y Y 2 BFI_OPE_09391ST 05/02/2019 5:05 05/02/2019 5:05 6 1 LATAM AR Latin America operational 09108SP ORION y Y 2 BFI_OPE_09108SP 05/02/2019 5:05 05/02/2019 5:05 7 1 LATAM AR Latin America operational 09888IP IP4CIB y Y 2 BFI_OPE_09888IP 05/02/2019 5:05 05/02/2019 5:05 8 1 LATAM BR Latin America Referential Account ATLAS Y Y 1 AR_Account 05/02/2019 5:05 05/02/2019 5:05 9 1 LATAM BR Latin America Referential Client ATLAS Y Y 1 AR_Client 05/02/2019 5:05 05/02/2019 5:05 10 1 LATAM BR Latin America Referential National Client ATLAS Y Y 1 AR_National Client 05/02/2019 5:05 05/02/2019 5:05 11 1 LATAM BR Latin America Referential Account External ATLAS Y Y 1 AR_Account External 05/02/2019 5:05 05/02/2019 5:05 12 1 LATAM BR Latin America operational 09391ST SCT4CIB Y Y 2 BFI_OPE_09391ST 05/02/2019 5:05 05/02/2019 5:05 13 1 LATAM BR Latin America operational 09108SP ORION y Y 2 BFI_OPE_09108SP 05/02/2019 5:05 05/02/2019 5:05 14 1 LATAM BR Latin America operational 09888IP IP4CIB y Y 2 BFI_OPE_09888IP 05/02/2019 5:05 05/02/2019 5:05 15 1 LATAM CO Latin America Referential Account ATLAS Y Y 1 AR_Account 05/02/2019 5:05 05/02/2019 5:05 16 1 LATAM CO Latin America Referential Client ATLAS Y Y 1 AR_Client 05/02/2019 5:05 05/02/2019 5:05 17 1 LATAM CO Latin America Referential National Client ATLAS Y Y 1 AR_National Client 05/02/2019 5:05 05/02/2019 5:05 18 1 LATAM CO Latin America Referential Account External ATLAS Y Y 1 AR_Account External 05/02/2019 5:05 05/02/2019 5:05 19 1 LATAM CO Latin America operational 09391ST SCT4CIB Y Y 2 BFI_OPE_09391ST 05/02/2019 5:05 05/02/2019 5:05 20 1 LATAM CO Latin America operational 09108SP ORION y Y 2 BFI_OPE_09108SP 05/02/2019 5:05 05/02/2019 5:05 21 1 LATAM CO Latin America operational 09888IP IP4CIB y Y 2 BFI_OPE_09888IP 05/02/2019 5:05 05/02/2019 5:05 22 2 CEM DE Central Europe Referential Account ATLAS y Y 1 AU_Account 05/02/2019 5:05 05/02/2019 5:05 23 2 CEM DE Central Europe Referential Client ATLAS y N 1 AU_Client 05/02/2019 5:05 06/02/2019 5:05 24 2 CEM DE Central Europe operational 06545SP ORION y Y 2 BFI_OPE_06545SP 05/02/2019 5:05 05/02/2019 5:05 25 2 CEM DE Central Europe operational 08541IP IP4CIB y Y 2 BFI_OPE_08541IP 05/02/2019 5:05 05/02/2019 5:05 Batch_Daily BATCH_ID ETL_NO RUN_DATE JOB_ID GROUP_ID Plug_Name Source Site_Description Is_active is_completed ETL_START_TIME ETL_END_TIME ETL_UPD_DATE USER 1 2 06/02/2019 1 1 Account ATLAS Latin America Y N scsvcauxhmsd 2 2 06/02/2019 2 1 Client ATLAS Latin America Y N scsvcauxhmsd 3 2 06/02/2019 3 1 National Client ATLAS Latin America Y N scsvcauxhmsd 4 2 06/02/2019 4 1 Account External ATLAS Latin America Y N scsvcauxhmsd 5 2 06/02/2019 5 1 09391ST SCT4CIB Latin America Y N scsvcauxhmsd 6 2 06/02/2019 6 1 09108SP ORION Latin America Y N scsvcauxhmsd 7 2 06/02/2019 7 1 09888IP IP4CIB Latin America Y N scsvcauxhmsd 8 2 06/02/2019 8 2 Referential ATLAS Central Europe Y N scsvcauxhmsd 9 2 06/02/2019 10 2 operational ORION Central Europe Y N scsvcauxhmsd 10 2 06/02/2019 11 2 operational IP4CIB Central Europe Y N scsvcauxhmsd Job_Flow flow_id work_flow job_name site country is_active Crt_dt upd_Dt 1 Referential Load REF_ACCOUNT latam AR y 06/02/2019 06/02/2019 2 Referential Load REF_CLIENT latam AR y 06/02/2019 06/02/2019 3 Referential Load REF_RFRMPM latam AR y 06/02/2019 06/02/2019 4 Referential Load REF_ACT_TYP latam AR y 06/02/2019 06/02/2019 5 Referential Load REF_ATL_BRC latam AR y 06/02/2019 06/02/2019 6 operatial Load CM_VOL_LOAD latam AR y 06/02/2019 06/02/2019

7 File_watcher fw latam AR y