Spreadsheet: 748687d1632294887-check-the-value-based-on-two-different-fields-in-a-set-checkrisk
Sheet: Sheet1

GROUP_ID | ENTITY_NUMBER | ENTITY | Type | RELATED_ENTITY_VALUE | Risk | Review | Date | Same/Different | Expected Values | Explanation
8446722 | SG12312388-01 |  | Main | SGP3317783 | HIGH | 2021-01-12 00:00:00 | 2020-01-12 00:00:00 |  | False | Because Same Entity ID has HIGH and MEDIUM
8446722 | SG12312388-02 |  | Associated | SGP3317783 | MEDIUM | 2020-01-12 00:00:00 | 2020-01-12 00:00:00 |  | False | Because Same Entity ID has HIGH and MEDIUM
8446725 | SG06983668-01 |  | Main | SGP1033223 | MEDIUM | 2021-04-12 00:00:00 | 2020-04-12 00:00:00 |  | False | Because Same Entity ID has STANDARD and MEDIUM
8446725 | SG06983668-03 |  | Associated | SGP1131488 | STANDARD | 2022-04-12 00:00:00 | 2020-04-12 00:00:00 |  | False | Because Same Entity ID has STANDARD and MEDIUM
8446725 | SG06983668-02 |  | Associated | SGP1033223 | MEDIUM | 2020-04-12 00:00:00 | 2020-04-12 00:00:00 |  | False | Because Same Entity ID has STANDARD and MEDIUM
8446725 | SG06983668-04 |  | Associated | SGP1131488 | MEDIUM | 2021-04-12 00:00:00 | 2020-04-12 00:00:00 |  | False | Because Same Entity ID has STANDARD and MEDIUM
8446726 | SG06822888-01 |  | Main | SGP3282559 | MEDIUM | 2021-10-13 00:00:00 | 2021-10-13 00:00:00 |  | True | Because Same Entity ID has same MEDIUM
8446726 | SG06822888-01 |  | Associated | SGP2850107 | MEDIUM | 2021-10-13 00:00:00 | 2021-10-13 00:00:00 |  | True | Because Same Entity ID has same MEDIUM
8446726 | SG06661989-01 |  | Main | SGP2850107 | MEDIUM | 2021-10-13 00:00:00 | 2021-10-13 00:00:00 |  | True | Only Entity ID
8446729 | SG60967222-02 |  | Associated | SGP4101842 | LOW | 2024-08-26 00:00:00 | 2024-08-26 00:00:00 |  | True | Because Same Entity ID has same LOW
8446729 | SG60967222-01 |  | Main | SGP4101842 | LOW | 2024-08-26 00:00:00 | 2024-08-26 00:00:00 |  | True | Only Entity ID
8446732 | SG06712229-01 |  | Main | SGP1119518 | HIGH | 2022-06-12 00:00:00 | 2022-06-12 00:00:00 |  | True | Only Entity ID
8446739 | SG06639246-01 |  | Main | SGP3694406 | MEDIUM | 2022-06-25 00:00:00 | 2021-06-25 00:00:00 |  | False | Because Same Entity ID has MEDIUM and LOW
8446739 | SG06693168-01 |  | Main | SGP3694406 | MEDIUM | 2022-06-25 00:00:00 | 2021-06-25 00:00:00 |  | True | Only Entity ID
8446740 | SG03104116-01 |  | Main | SGP0012939 | MEDIUM | 2022-06-25 00:00:00 | 2021-06-25 00:00:00 |  | True | Only Entity ID
8446740 | SG03104226-01 |  | Main | SGP0012939 | MEDIUM | 2022-06-25 00:00:00 | 2021-06-25 00:00:00 |  | False | Because Same Entity ID has HIGH and MEDIUM
8446740 | SG03104226-02 |  | Associated | [NAME] | HIGH | 2021-06-25 00:00:00 | 2021-06-25 00:00:00 |  | False | Because Same Entity ID has HIGH and MEDIUM
8446722 | SG12312388-01 | SG12312388 | Associated | SGP3317783 | HIGH | 2021-02-12 00:00:00 | 2020-01-12 00:00:00 |  | False | Because Same Entity ID has HIGH and MEDIUM
8446729 | SG60967222-02 |  | Associated | SGP4101842 | LOW | 2024-08-26 00:00:00 | 2024-08-26 00:00:00 |  | True | Because Same Entity ID has same LOW
8446739 | SG06639246-01 |  | Main | SGP3694406 | LOW | 2022-06-25 00:00:00 | 2021-06-25 00:00:00 |  | False | Because Same Entity ID has MEDIUM and LOW