Hi Guys,
Is there are way for table 1 below to be populated based on the data in table 2 below?
Basically The activities in the table 1 has the day in which it needs to carried out for a month with the team responsible for the particular activity.
So for Example, "Check month end close & data delivery dates" is to be carried out by team "LSV" on 31st of the month. Additionally if the owner is "site" they will not work on holidays which is the weekend.
In Table 1 when the activity uis carried ou on 31 it should populate as "ALL SITES"
Hope this makes sense.
Table 1 = how its looks once data is populated.
Table 2 = The days of the month when the activity is carried out
Tabel 1
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="7"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>
Table 2
<tbody>
</tbody><colgroup><col><col><col><col span="4"></colgroup>
Is there are way for table 1 below to be populated based on the data in table 2 below?
Basically The activities in the table 1 has the day in which it needs to carried out for a month with the team responsible for the particular activity.
So for Example, "Check month end close & data delivery dates" is to be carried out by team "LSV" on 31st of the month. Additionally if the owner is "site" they will not work on holidays which is the weekend.
In Table 1 when the activity uis carried ou on 31 it should populate as "ALL SITES"
Hope this makes sense.
Table 1 = how its looks once data is populated.
Table 2 = The days of the month when the activity is carried out
Tabel 1
Working Day | H | H | -9 | -8 | -7 | -6 | -5 | H | H | -4 | -3 | -2 | -1 | 1 | H | H | 2 | 3 | 4 | 5 | 6 | H | H | 7 | 8 | 9 | 10 | 11 | H | H | 12 | 13 | 14 | 15 | 16 | H | H | 17 | 18 | 19 | 20 | ||
Dependency | Calendar Date | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | |
Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | |||
Release 9 | MAUIs DA_ LRVR | ||||||||||||||||||||||||||||||||||||||||||
1 | Check month end close & data delivery dates | LSV | All SITES | ||||||||||||||||||||||||||||||||||||||||
2 | Confirm Golden Reference context is setup | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
3 | Non-GBM Data | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
4 | ESR | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
5 | GBM data | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
6 | GBM Error Reports | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
7 | GCDU | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
8 | Share Reference data files for Current Month with CTB | LSV | |||||||||||||||||||||||||||||||||||||||||
9 | Uplift Reference data Files to Moody's format on Sharepoint | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
10 | Technical checks prior to batch trigger | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
11 | Load CSV to table | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
12 | Create consolidation context (Note: Context creation is required to be created on ANY ONE environment ONLY - PSS to share the environment & Context id with LSS) | PSV | |||||||||||||||||||||||||||||||||||||||||
13 | Create Reporting Context | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
14 | Trigger Batch | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
15 | Open Reference Context Batch | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
16 | Reference data to be shared by LSS with PSS | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
17 | Reference Load Batch | PSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
18 | GCDU Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
19 | Update Reporting Date Context | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
20 | Open Reporting Date Context Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
21 | SDI Load Batch execution | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
22 | DMDS Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
23 | SARACEN Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
24 | ESR Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
25 | TL Kick Start Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
26 | Setting up data patch rules | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
27 | TL Load Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
28 | Execute Data Patch rules (SDI) | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
29 | Execute Data Patch rules (FDM) | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
30 | TL Stop Process | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
31 | REPORTING Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
32 | Housekeeping Batch | PSV | ALL Sites | ALL Sites | ALL Sites | ||||||||||||||||||||||||||||||||||||||
33 | Execute Unadjusted Drill Back queries - Moody's DB editor - TOAD | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
34 | Execute Error and Control queries - Moody's DB editor - TOAD | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
35 | Execute TM1_Query_weight_applicable & TM1_Query_weight_execluded extract | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
36 | Provide excel Pivots on EnC for 3 months | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
37 | Generate Unadjusted DA LCR reports from Moodys RA | RTP | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
38 | Transmission of PCM files to RTB team | Site | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
39 | Execute the query to fetch Company Exchange Rate data | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
40 | Fetch the Company Hierarchy data file from Reference Data management team | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
41 | Execute currency coversion query (RTB team requires to start adjustments process) | LSV | ALL Sites | ||||||||||||||||||||||||||||||||||||||||
42 | Moody's Extraction (Erstwhile FinArch)starting on CD2 and ednding on CD4 | LSV | ALL Sites |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="7"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>
Table 2
Release 9 | MAUIs DA_ LRVR | Owners | Calendar Date | Calendar Date | Calendar Date | Calendar Date |
1 | Check month end close & data delivery dates | LSV | 31 | |||
2 | Confirm Golden Reference context is setup | PSV | 1 | |||
3 | Non-GBM Data | PSV | 1 | |||
4 | ESR | PSV | 1 | |||
5 | GBM data | PSV | 1 | |||
6 | GBM Error Reports | PSV | 1 | |||
7 | GCDU | PSV | 1 | |||
8 | Share Reference data files for Current Month with CTB | LSV | ||||
9 | Uplift Reference data Files to Moody's format on Sharepoint | LSV | 31 | |||
10 | Technical checks prior to batch trigger | PSV | 31 | |||
11 | Load CSV to table | PSV | 31 | |||
12 | Create consolidation context (Note: Context creation is required to be created on ANY ONE environment ONLY - PSS to share the environment & Context id with LSS) | PSV | ||||
13 | Create Reporting Context | PSV | 31 | |||
14 | Trigger Batch | PSV | 31 | |||
15 | Open Reference Context Batch | PSV | 31 | |||
16 | Reference data to be shared by LSS with PSS | LSV | 31 | |||
17 | Reference Load Batch | PSV | 31 | |||
18 | GCDU Batch | PSV | 2 | 3 | 4 | 5 |
19 | Update Reporting Date Context | PSV | 2 | 3 | 4 | 5 |
20 | Open Reporting Date Context Batch | PSV | 2 | 3 | 4 | 5 |
21 | SDI Load Batch execution | PSV | 2 | 3 | 4 | 5 |
22 | DMDS Batch | PSV | 2 | 3 | 4 | 5 |
23 | SARACEN Batch | PSV | 2 | 3 | 4 | 5 |
24 | ESR Batch | PSV | 2 | 3 | 4 | 5 |
25 | TL Kick Start Batch | PSV | 2 | 3 | 4 | 5 |
26 | Setting up data patch rules | PSV | 2 | 3 | 4 | 5 |
27 | TL Load Batch | PSV | 2 | 3 | 4 | 5 |
28 | Execute Data Patch rules (SDI) | PSV | 2 | 3 | 4 | 5 |
29 | Execute Data Patch rules (FDM) | PSV | 2 | 3 | 4 | 5 |
30 | TL Stop Process | PSV | 2 | 3 | 4 | 5 |
31 | REPORTING Batch | PSV | 2 | 3 | 4 | 5 |
32 | Housekeeping Batch | PSV | 2 | 3 | 4 | 5 |
33 | Execute Unadjusted Drill Back queries - Moody's DB editor - TOAD | LSV | 4 | |||
34 | Execute Error and Control queries - Moody's DB editor - TOAD | LSV | 4 | |||
35 | Execute TM1_Query_weight_applicable & TM1_Query_weight_execluded extract | LSV | 4 | |||
36 | Provide excel Pivots on EnC for 3 months | LSV | 4 | |||
37 | Generate Unadjusted DA LCR reports from Moodys RA | RTP | 2 | 3 | 4 | 5 |
38 | Transmission of PCM files to RTB team | SITE | 4 | |||
39 | Execute the query to fetch Company Exchange Rate data | LSV | 4 | |||
40 | Fetch the Company Hierarchy data file from Reference Data management team | LSV | 4 | |||
41 | Execute currency coversion query (RTB team requires to start adjustments process) | LSV | 4 | |||
42 | Moody's Extraction (Erstwhile FinArch)starting on CD2 and ednding on CD4 | LSV | 2 | 3 | 4 |
<tbody>
</tbody><colgroup><col><col><col><col span="4"></colgroup>