35.8 Lineage Properties
Select the Lineage Properties required to be generated.
The following Lineage Properties (columns) are available in the Metadata Report Screen.
Table 35-6 Lineage Properties
| Sl. No. | Lineage Property | Property Description |
|---|---|---|
| 1 | Metadata Code | Stores the Metadata Code of the Lineage Report generated for the given Cell ID, Cell Group ID, and Derived Entity. |
| 2 | Metadata Description | Stores the Metadata Description of the Lineage Report generated for the given Cell ID, Cell Group ID, and Derived Entity. |
| 3 | Metadata Type | Stores the Metadata Type of the Lineage Report generated for the given Cell ID, Cell Group ID, and Derived Entity. |
| 4 | Metadata Sub Code | Stores the Metadata Sub Code of the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, and Metadata Code. Metadata Sub Code represents direct Metadata (Metadata Sub Code is the same Metadata Code) or derived Metadata Code like Datasets/Expressions. |
| 5 | Metadata Sub Description | Stores the Metadata Sub Description of the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, and Metadata Code. Metadata Sub Code represents direct Metadata (Metadata Sub Code is the same Metadata Code) or derived Metadata Code like Datasets/Expressions. |
| 6 | Metadata Sub Type | Stores the Metadata Sub Type of the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, and Metadata Code. Metadata Sub Code represents direct Metadata (Metadata Sub Code is the same Metadata Code) or derived Metadata Code like Datasets/Expressions. |
| 7 | Result Area Table Application | Stores the Results Area Table Application of the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, Metadata Code, and Metadata Sub Code. The Results Area Table application is the responsible OFSAA Application to populate the table. |
| 8 | Result Area Table Type | Stores the Results Area Table Type of the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, Metadata Code, and Metadata Sub Code. The Results Area Table Type represents how the table is populated. For example Data Flow, Seeded Data, and so on. |
| 9 | Result Area Table | Stores the Results Area Table the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, Metadata Code, and Metadata Sub Code. The Results Area Table is the OFSAA data model table that populates or helps to populate the given Cell (MDRM) in the Reporting Layer. |
| 10 | Result Area Column | Stores the Results Area Column the Lineage Report generated for the given Cell ID, Cell Group ID, Derived Entity, Metadata Code, Metadata Sub Code, and Results Area Table. The Results Area Table column is the OFSAA data model column that populates or helps to populate the given Cell (MDRM) in Reporting Layer. |
| 11 | Target Metadata Operator | Stores the Target Metadata Operator of the Lineage Report generated for the given Results Area Column and Member Code embedded inside the Metadata like Business Processor, Hierarchy, or Dataset. The operator is derived after a standardization process like Reverting all <>, =, IN, NOT IN conditions to equal operator. |
| 12 | Target Metadata Member | Stores the Target Metadata Operator of the Lineage Report generated for the given Results Area Column and Member Code embedded inside the Metadata like Business Processor, Hierarchy, or Dataset. The Member Code presents its ultimate form through a standardization process like Reverting all <>, =, IN, NOT IN conditions to the equal operator and getting the respective Member Codes. |
| 13 | Reporting Run Name | Stores the Regulatory Reporting Run Name for Jurisdiction Code of Lineage Report generated. |
| 14 | Lineage Run or Batch Level1 | Stores the Level1 Run Name or Batch Name of Lineage Report generated for populating the Results Area Table and Column. |
| 15 | Lineage Data Flow Name Level1 | Stores the Level1 Data Flow Name of Lineage Report generated for populating the Results Area Table and Column. |
| 16 | Lineage Data Flow Type Level1 | Stores the Level1 Data Flow Type of Lineage Report generated for populating the Results Area Table and Column. |
| 17 | Lineage Element Table Level1 | Stores the Level1 Source Table of Lineage Report generated for populating the Results Area Table and Column. |
| 18 | Lineage Element Column Level1 | Stores the Level1 Source Column of Lineage Report generated for populating the Results Area Table and Column. |
| 19 | Lineage Run or Batch Level2 | Stores the Level2 Run Name or Batch Name of Lineage Report generated for populating the Level1 Source Table and Column. |
| 20 | Lineage Data Flow Name Level2 | Stores the Level2 Data Flow Name of Lineage Report generated for populating the Level1 Source Table and Column. |
| 21 | Lineage Data Flow Type Level2 | Stores the Level2 Data Flow Type of Lineage Report generated for populating the Level1 Source Table and Column. |
| 22 | Lineage Element Table Level2 | Stores the Level2 Source Table of Lineage Report generated for populating the Level1 Source Table and Column. |
| 23 | Lineage Element Column Level2 | Stores the Level2 Source Column of Lineage Report generated for populating the Level1 Source Table and Column. |
| 24 | Lineage Run or Batch Level3 | Stores the Level3 Run Name or Batch Name of Lineage Report generated for populating the Level2 Source Table and Column. |
| 25 | Lineage Data Flow Name Level3 | Stores the Level3 Data Flow Name of Lineage Report generated for populating the Level2 Source Table and Column. |
| 26 | Lineage Data Flow Type Level3 | Stores the Level3 Data Flow Type of Lineage Report generated for populating the Level2 Source Table and Column. |
| 27 | Lineage Element Table Level3 | Stores the Level3 Source Table of Lineage Report generated for populating the Level2 Source Table and Column. |
| 28 | Lineage Element Column Level3 | Stores the Level3 Source Column of Lineage Report generated for populating the Level2 Source Table and Column. |
| 29 | Lineage Run or Batch Level4 | Stores the Level4 Run Name or Batch Name of Lineage Report generated for populating the Level3 Source Table and Column. |
| 30 | Lineage Data Flow Name Level4 | Stores the Level4 Data Flow Name of Lineage Report generated for populating the Level3 Source Table and Column. |
| 31 | Lineage Data Flow Type Level4 | Stores the Level4 Data Flow Type of Lineage Report generated for populating the Level3 Source Table and Column. |
| 32 | Lineage Element Table Level4 | Stores the Level4 Source Table of Lineage Report generated for populating the Level3 Source Table and Column. |
| 33 | Lineage Element Column Level4 | Stores the Level4 Source Column of Lineage Report generated for populating the Level3 Source Table and Column. |
| 34 | Lineage Run or Batch Level5 | Stores the Level5 Run Name or Batch Name of Lineage Report generated for populating the Level4 Source Table and Column. |
| 35 | Lineage Data Flow Name Level5 | Stores the Level5 Data Flow Name of Lineage Report generated for populating the Level4 Source Table and Column. |
| 36 | Lineage Data Flow Type Level5 | Stores the Level5 Data Flow Type of Lineage Report generated for populating the Level4 Source Table and Column. |
| 37 | Lineage Element Table Level5 | Stores the Level5 Source Table of Lineage Report generated for populating the Level4 Source Table and Column. |
| 38 | Lineage Element Column Level5 | Stores the Level5 Source Column of Lineage Report generated for populating the Level4 Source Table and Column. |
| 39 | Lineage Run or Batch Level6 | Stores the Level6 Run Name or Batch Name of Lineage Report generated for populating the Level5 Source Table and Column. |
| 40 | Lineage Data Flow Name Level6 | Stores the Level6 Data Flow Name of Lineage Report generated for populating the Level5 Source Table and Column. |
| 41 | Lineage Data Flow Type Level6 | Stores the Level6 Data Flow Type of Lineage Report generated for populating the Level5 Source Table and Column. |
| 42 | Lineage Element Table Level6 | Stores the Level6 Source Table of Lineage Report generated for populating the Level5 Source Table and Column. |
| 43 | Lineage Element Column Level6 | Stores the Level6 Source Column of Lineage Report generated for populating the Level5 Source Table and Column. |
| 44 | Lineage Run or Batch Level7 | Stores the Level7 Run Name or Batch Name of Lineage Report generated for populating the Level6 Source Table and Column. |
| 45 | Lineage Data Flow Name Level7 | Stores the Level7 Data Flow Name of Lineage Report generated for populating the Level6 Source Table and Column. |
| 46 | Lineage Data Flow Type Level7 | Stores the Level7 Data Flow Type of Lineage Report generated for populating the Level6 Source Table and Column. |
| 47 | Lineage Element Table Level7 | Stores the Level7 Source Table of Lineage Report generated for populating the Level6 Source Table and Column. |
| 48 | Lineage Element Column Level7 | Stores the Level7 Source Column of Lineage Report generated for populating the Level6 Source Table and Column. |
| 49 | Lineage Run or Batch Level8 | Stores the Level8 Run Name or Batch Name of Lineage Report generated for populating the Level7 Source Table and Column. |
| 50 | Lineage Data Flow Name Level8 | Stores the Level8 Data Flow Name of Lineage Report generated for populating the Level7 Source Table and Column. |
| 51 | Lineage Data Flow Type Level8 | Stores the Level8 Data Flow Type of Lineage Report generated for populating the Level7 Source Table and Column. |
| 52 | Lineage Element Table Level8 | Stores the Level8 Source Table of Lineage Report generated for populating the Level7 Source Table and Column. |
| 53 | Lineage Element Column Level8 | Stores the Level8 Source Column of Lineage Report generated for populating the Level7 Source Table and Column. |
| 54 | Lineage Run or Batch Level9 | Stores the Level9 Run Name or Batch Name of Lineage Report generated for populating the Level8 Source Table and Column. |
| 55 | Lineage Data Flow Name Level9 | Stores the Level9 Data Flow Name of Lineage Report generated for populating the Level8 Source Table and Column. |
| 56 | Lineage Data Flow Type Level9 | Stores the Level9 Data Flow Type of Lineage Report generated for populating the Level8 Source Table and Column. |
| 57 | Lineage Element Table Level9 | Stores the Level9 Source Table of Lineage Report generated for populating the Level8 Source Table and Column. |
| 58 | Lineage Element Column Level9 | Stores the Level9 Source Column of Lineage Report generated for populating the Level8 Source Table and Column. |
| 59 | Lineage Run or Batch Level10 | Stores the Level10 Run Name or Batch Name of Lineage Report generated for populating the Level9 Source Table and Column. |
| 60 | Lineage Data Flow Name Level10 | Stores the Level10 Data Flow Name of Lineage Report generated for populating the Level9 Source Table and Column. |
| 61 | Lineage Data Flow Type Level10 | Stores the Level10 Data Flow Type of Lineage Report generated for populating the Level9 Source Table and Column. |
| 62 | Lineage Element Table Level10 | Stores the Level10 Source Table of Lineage Report generated for populating the Level9 Source Table and Column. |
| 63 | Lineage Element Column Level10 | Stores the Level10 Source Column of Lineage Report generated for populating the Level9 Source Table and Column. |
| 64 | Data Element Table Application | Stores the Ultimate Source Table Application of Lineage Report generated for populating the Results Area Table and Column. The application is responsible for sourcing the data. |
| 65 | Data Element Table Type | Stores the Ultimate Source Table Type of Lineage Report generated for populating the Results Area Table and Column. This represents the Type of the Source Table like Download, Mapper Download, Seeded Data, Run Parameters, and so on. |
| 66 | Data Element Table | Stores the Ultimate Source Table of Lineage Report generated for populating the Results Area Table and Column. |
| 67 | Data Element Column | Stores the Ultimate Source Column of Lineage Report generated for populating the Results Area Table and Column. |
| 68 | Data Element Metadata Operator | Stores the Ultimate Source Table Column Operator Code of Lineage Report generated concerning Target Metadata Operator in Results Area. This is the derived representation of the Target Metadata Operator in the Results Area. |
| 69 | Data Element Metadata Member | Stores the Ultimate Source Table Column Member Code of Lineage Report generated concerning Target Metadata Member Code in Results Area. This is the derived representation of the Target Metadata Member Code in the Results Area. |