Design Name | IBG Oracle Data Model Diagram |
Version Date | 20.01.2024 01:10:39 |
Version Comment | |
Model Name | Logical |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize Business Intelligence (BI) artifacts. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize Business Intelligence (BI) artifacts. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | BI Object Type EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | BI Object Type 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | BI Object Type Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | BI Object Type Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
2 | BI Object Type 2NDL | A second-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
3 | BI Object Type Description EN | An English-language description of something. | |
4 | BI Object Type Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | BI Object Type EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Intelligence Object | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to note the status of the business metadata associated with an information asset in the Integrated Business Glossary (IBG). Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to note the status of the business metadata associated with an information asset in the Integrated Business Glossary (IBG). Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Metadata Status Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Business Metadata Status Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Business Metadata Status Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Business Metadata Status Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Metadata Status Code EN | The English-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
2 | Business Metadata Status Code 2NDL | The second-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
3 | Business Metadata Status Code Description EN | An English-language description of something. | |
4 | Business Metadata Status Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Business Metadata Status Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Subject Area | 1..*:1..1 | Y | |||||
IBG Business Intelligence Object | 1..*:1..1 | Y | |||||
IBG Business Entity | 1..*:1..1 | Y | |||||
IBG Business Attribute Core | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a list of business unit types. Examples include but are not limited to: - Agency - Branch - Crown Corporation - Department - Division - Non-Government - Organization - Section - Sub-Unit - Unit - Team Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a list of business unit types. Examples include but are not limited to: - Agency - Branch - Crown Corporation - Department - Division - Non-Government - Organization - Section - Sub-Unit - Unit - Team Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Unit Type EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Business Unit Type 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Business Unit Type Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Business Unit Type Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Unit Type EN | An English-language categorization for business units with respect to their place in the organizational hierarchy. Examples include but are not limited to: - Agency - Branch - Crown Corporation - Department - Division - Non-Government - Organization - Section - Sub-Unit - Unit - Team | |
2 | Business Unit Type 2NDL | A second-language categorization for business units with respect to their place in the organizational hierarchy. Examples include but are not limited to: - Agency - Branch - Crown Corporation - Department - Division - Non-Government - Organization - Section - Sub-Unit - Unit - Team | |
3 | Business Unit Type Description EN | An English-language description of something. | |
4 | Business Unit Type Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Business Unit Type EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Business Unit | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a hierarchical list of committees in our organization that are relevant to our data governance program. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a hierarchical list of committees in our organization that are relevant to our data governance program. Notes FR: La définition est à déterminer |
Number Of Attributes | 12 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Acronym EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Committee Acronym 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Committee Full Name EN | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
4 | Committee Full Name 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
5 | Parent Committee Acronym EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Parent Committee Acronym EN | Parent Business Unit Acronym EN | |
6 | Committee Terms Of Reference Hyperlink EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Committee Terms Of Reference Hyperlink 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Committee Meeting Minutes Folder Hyperlink EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | Committee Meeting Minutes Folder Hyperlink 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | Committee Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
11 | Committee Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
12 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Committee Acronym EN | The English-language acronym by which a committee is commonly known. | |
2 | Committee Acronym 2NDL | The second-language acronym by which a committee is commonly known. | |
3 | Committee Full Name EN | The English-language full name of a committee. | |
4 | Committee Full Name 2NDL | The second-language full name of a committee. | |
5 | Parent Committee Acronym EN | The English-language acronym by which a committee is commonly known. | |
6 | Committee Terms Of Reference Hyperlink EN | A hyperlink to the English-language folder for the committee's terms of reference/mandate. | |
7 | Committee Terms Of Reference Hyperlink 2NDL | A hyperlink to the second-language folder for the committee's terms of reference/mandate. | |
8 | Committee Meeting Minutes Folder Hyperlink EN | A hyperlink to the English-language folder for the committee's meeting minutes. | |
9 | Committee Meeting Minutes Folder Hyperlink 2NDL | A hyperlink to the second-language folder for the committee's meeting minutes. | |
10 | Committee Notes EN | Any English-language notes appropriate to record. | |
11 | Committee Notes 2NDL | Any second-language notes appropriate to record. | |
12 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Committee Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Committee Meeting History | 1..*:1..1 | Y | Y | ||||
Code Committee | 1..*:1..1 | Y | |||||
DG Committee Membership | 0..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to identify the roles that a person can have in data governance committees. Examples include: - Chairperson - Delegate - Secretariat - Standing Observer - Voting Member Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to identify the roles that a person can have in data governance committees. Examples include: - Chairperson - Delegate - Secretariat - Standing Observer - Voting Member Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Membership Role Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Committee Membership Role Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Committee Membership Role Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Committee Membership Role Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Committee Membership Role Code EN | An English-language code for the role that a person can have in a data governance committee. Examples include: - Chairperson - Delegate - Secretariat - Standing Observer - Voting Member | |
2 | Committee Membership Role Code 2NDL | A second-language code for the role that a person can have in a data governance committee. Examples include: - Chairperson - Delegate - Secretariat - Standing Observer - Voting Member | |
3 | Committee Membership Role Code Description EN | An English-language description of something. | |
4 | Committee Membership Role Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Committee Membership Role Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Committee Membership | 0..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of colors that our organization uses to provide a visualization of the quality of data associated with business attributes. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of colors that our organization uses to provide a visualization of the quality of data associated with business attributes. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | DQ Color Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | DQ Color Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | DQ Color Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | DQ Color Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | DQ Color Code EN | The English-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute. | |
2 | DQ Color Code 2NDL | The second-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute. | |
3 | DQ Color Code Description EN | An English-language description of something. | |
4 | DQ Color Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | DQ Color Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute DQ Colors | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize a business attribute in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the business asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the business attribute. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize a business attribute in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the business asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the business attribute. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | DQ Dimension Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | DQ Dimension Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | DQ Dimension Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | DQ Dimension Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | DQ Dimension Code EN | The English-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc. | |
2 | DQ Dimension Code 2NDL | The second-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc. | |
3 | DQ Dimension Code Description EN | An English-language description of something. | |
4 | DQ Dimension Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | DQ Dimension Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute DQ Rules | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to identify the roles that a person can have in the organization's data governance program. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to identify the roles that a person can have in the organization's data governance program. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Governance Role Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Data Governance Role Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Data Governance Role Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Data Governance Role Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
2 | Data Governance Role Code 2NDL | A second-language code for the roles that a person can have in the organization's data governance program. | |
3 | Data Governance Role Code Description EN | An English-language description of something. | |
4 | Data Governance Role Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Data Governance Role Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG RACI Application Software And Person | 1..*:1..1 | Y | |||||
DG Data Issue And Person | 1..*:1..1 | Y | |||||
DG RACI Business Attribute And Person | 1..*:1..1 | Y | |||||
DG RACI Business Entity and Person | 1..*:1..1 | Y | |||||
DG RACI BI Object and Person | 1..*:1..1 | Y | |||||
DG RACI Subject Area And Person | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize data issues in our organization. Examples include: - Data Quality - Personal Desktop Application (alson known as Black Books) - Application specific (by named application) - Communication (e.g. Customer = Client?) Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize data issues in our organization. Examples include: - Data Quality - Personal Desktop Application (alson known as Black Books) - Application specific (by named application) - Communication (e.g. Customer = Client?) Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue Category Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Data Issue Category Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Data Issue Category Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Data Issue Category Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue Category Code EN | An English-language code used to categorize data issues. | |
2 | Data Issue Category Code 2NDL | A second-language code used to categorize data issues. | |
3 | Data Issue Category Code Description EN | An English-language description of something. | |
4 | Data Issue Category Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Data Issue Category Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize the impact of data issues in our organization. Examples include: - Financial Cost 1 - $50K - Financial Cost 2 - $50K to $500K - Financial Cost 3 - $500K and Above - Personal Desktop Application - Risk: Decision Risk 1 - Modest Impact - $50K - Risk: Decision Risk 2 - Medium Impact - $50K to $500K - Risk: Decision Risk 3 - High Impact - $500K and Above - Risk: Key Person Risk Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize the impact of data issues in our organization. Examples include: - Financial Cost 1 - $50K - Financial Cost 2 - $50K to $500K - Financial Cost 3 - $500K and Above - Personal Desktop Application - Risk: Decision Risk 1 - Modest Impact - $50K - Risk: Decision Risk 2 - Medium Impact - $50K to $500K - Risk: Decision Risk 3 - High Impact - $500K and Above - Risk: Key Person Risk Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue Impact Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Data Issue Impact Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Data Issue Impact Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Data Issue Impact Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue Impact Code EN | An English-language code used to categorize the impact of data issues. Examples include: - Financial Cost 1 - $50K - Financial Cost 2 - $50K to $500K - Financial Cost 3 - $500K and Above - Personal Desktop Application - Risk: Decision Risk 1 - Modest Impact - $50K - Risk: Decision Risk 2 - Medium Impact - $50K to $500K - Risk: Decision Risk 3 - High Impact - $500K and Above - Risk: Key Person Risk | |
2 | Data Issue Impact Code 2NDL | A second-language code used to categorize the impact of data issues. Examples include: - Financial Cost 1 - $50K - Financial Cost 2 - $50K to $500K - Financial Cost 3 - $500K and Above - Personal Desktop Application - Risk: Decision Risk 1 - Modest Impact - $50K - Risk: Decision Risk 2 - Medium Impact - $50K to $500K - Risk: Decision Risk 3 - High Impact - $500K and Above - Risk: Key Person Risk | |
3 | Data Issue Impact Code Description EN | An English-language description of something. | |
4 | Data Issue Impact Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Data Issue Impact Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue And Business Unit | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize the severity of data issues in our organization. Examples include: 0 - Nuisance 1 - Low 2 - Medium 3 - High 4 - Critical, Must Resolve Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize the severity of data issues in our organization. Examples include: 0 - Nuisance 1 - Low 2 - Medium 3 - High 4 - Critical, Must Resolve Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue Severity Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Data Issue Severity Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Data Issue Severity Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Data Issue Severity Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue Severity Code EN | An English-language code used to categorize the severity of data issues. Examples include: 0 - Nuisance 1 - Low 2 - Medium 3 - High 4 - Critical, Must Resolve | |
2 | Data Issue Severity Code 2NDL | A second-language code used to categorize the severity of data issues. | |
3 | Data Issue Severity Code Description EN | An English-language description of something. | |
4 | Data Issue Severity Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Data Issue Severity Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to identify the status of data issues. Examples include: 01 - Open 02 - Work In Progress 03 - Closed - Not Resolved 04 - Closed - Resolved Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to identify the status of data issues. Examples include: 01 - Open 02 - Work In Progress 03 - Closed - Not Resolved 04 - Closed - Resolved Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue Status Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Data Issue Status Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Data Issue Status Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Data Issue Status Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue Status Code EN | An English-language code used to identify the status of data issues. Examples include: 01 - Open 02 - Work In Progress 03 - Closed - Not Resolved 04 - Closed - Resolved | |
2 | Data Issue Status Code 2NDL | A second-language code used to identify the status of data issues. Examples include: 01 - Open 02 - Work In Progress 03 - Closed - Not Resolved 04 - Closed - Resolved | |
3 | Data Issue Status Code Description EN | An English-language description of something. | |
4 | Data Issue Status Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Data Issue Status Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Status History | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize an application as either a system of record or a system of reference with respect to the business attributes that it contains. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize an application as either a system of record or a system of reference with respect to the business attributes that it contains. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Operational Reference Master Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Operational Reference Master Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Operational Reference Master Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Operational Reference Master Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Operational Reference Master Code EN | An English-language categorization of a piece of data as master data, reference data, or operational data. | |
2 | Operational Reference Master Code 2NDL | An second-language categorization of a piece of data as master data, reference data, or operational data. | |
3 | Operational Reference Master Code Description EN | An English-language description of something. | |
4 | Operational Reference Master Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Operational Reference Master Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize business units with respect to their assignment in one of the four major parts of the public service in the Government of New Brunswick (GNB). See https://gnbg.sharepoint.com/sites/About-A_propos/SitePages/PartsPSPartis.aspx Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize business units with respect to their assignment in one of the four major parts of the public service in the Government of New Brunswick (GNB). See https://gnbg.sharepoint.com/sites/About-A_propos/SitePages/PartsPSPartis.aspx Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Part Of Organization Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Part Of Organization Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Part Of Organization Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Part Of Organization Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Part Of Organization Code EN | An English-language code indicating which of the parts of the organization a given business unit belongs to. | |
2 | Part Of Organization Code 2NDL | A second-language code indicating which of the parts of the organization a given business unit belongs to. | |
3 | Part Of Organization Code Description EN | An English-language description of something. | |
4 | Part Of Organization Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Part Of Organization Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Business Unit | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to describe the level of injury that can occur if an information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to describe the level of injury that can occur if an information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Protected Level Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Protected Level Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Protected Level Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Protected Level Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Protected Level Code EN | An English-language categorization applied to an information asset that describes the level of injury that can occur if the information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf | |
2 | Protected Level Code 2NDL | A second-language categorization applied to an information asset that describes the level of injury that can occur if the information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf | |
3 | Protected Level Code Description EN | An English-language description of something. | |
4 | Protected Level Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Protected Level Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Entity | 1..*:1..1 | Y | |||||
IBG Business Intelligence Object | 1..*:1..1 | Y | |||||
IBG Business Attribute Core | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to identify the formal relationship that a person or business unit has with an information asset. There are four codes: Responsible, Accountable, Consulted, Informed. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to identify the formal relationship that a person or business unit has with an information asset. There are four codes: Responsible, Accountable, Consulted, Informed. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | RACI Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | RACI Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | RACI Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | RACI Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
2 | RACI Code 2NDL | The second-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
3 | RACI Code Description EN | An English-language description of something. | |
4 | RACI Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | RACI Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG RACI Application Software And Person | 1..*:1..1 | Y | |||||
DG RACI Application Software And Business Unit | 1..*:1..1 | Y | |||||
DG RACI Business Attribute And Person | 1..*:1..1 | Y | Y | ||||
DG RACI Business Attribute And Business Unit | 1..*:1..1 | Y | Y | ||||
DG RACI Business Entity and Person | 1..*:1..1 | Y | |||||
DG RACI Business Entity and Business Unit | 1..*:1..1 | Y | |||||
DG RACI BI Object and Person | 1..*:1..1 | Y | |||||
DG RACI BI Object and Business Unit | 1..*:1..1 | Y | |||||
DG RACI Subject Area And Person | 1..*:1..1 | Y | |||||
DG RACI Subject Area And Business Unit | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize an information asset in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" Notes FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to categorize an information asset in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Sensitivity Level Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Sensitivity Level Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Sensitivity Level Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Sensitivity Level Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Sensitivity Level Code EN | An English-language categorization applied to an information asset that is used in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the Information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" | |
2 | Sensitivity Level Code 2NDL | A second-language categorization applied to an information asset that is used in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the Information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" | |
3 | Sensitivity Level Code Description EN | An English-language description of something. | |
4 | Sensitivity Level Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Sensitivity Level Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | |||||
IBG Business Entity | 1..*:1..1 | Y | |||||
IBG Business Intelligence Object | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to categorize an application system's relationship to a business attribute. With respect to a business attreibute, an applicaiton system can be considered to be a system of record or a system of reference. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. Comments FR: La définition est à déterminer |
Notes | Comments EN: This entity/table contains codes used to categorize an application system's relationship to a business attribute. With respect to a business attreibute, an applicaiton system can be considered to be a system of record or a system of reference. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. Comments FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | System Of Record Or Reference Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | System Of Record Or Reference Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | System Of Record Or Reference Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | System Of Record Or Reference Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | System Of Record Or Reference Code EN | An English-language code used to indicate whether an application system can be considered to be a system of record or a system of reference with respect to a given business attribute. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. | |
2 | System Of Record Or Reference Code 2NDL | A second-language code used to indicate whether an application system can be considered to be a system of record or a system of reference with respect to a given business attribute. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. | |
3 | System Of Record Or Reference Code Description EN | An English-language description of something. | |
4 | System Of Record Or Reference Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | System Of Record Or Reference Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG XREF BA Column And Application | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains codes used to ensure that the terms Yes, No, TBD, and N/A (Not Applicable or Not Available), in both English and French, are spelled and used consistently in the IBG. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains codes used to ensure that the terms Yes, No, TBD, and N/A (Not Applicable or Not Available), in both English and French, are spelled and used consistently in the IBG. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Yes No Code EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Yes No Code 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Yes No Code Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Yes No Code Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Yes No Code EN | An English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available). | |
2 | Yes No Code 2NDL | A second-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available). | |
3 | Yes No Code Description EN | An English-language description of something. | |
4 | Yes No Code Description 2NDL | A second-language description of something. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Yes No Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | Personally Identifiable Information Indicator | 1..*:1..1 | Y | ||||
DG Business Unit | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a hierarchical list of business units in our organization and business units in other organization that are of interest to our organization. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a hierarchical list of business units in our organization and business units in other organization that are of interest to our organization. Notes FR: La définition est à déterminer |
Number Of Attributes | 13 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Unit Acronym EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Business Unit Acronym 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Business Unit Full Name EN | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
4 | Business Unit Full Name 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
5 | Parent Business Unit Acronym EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Parent Business Unit Acronym EN | Parent Business Unit Acronym EN | |
6 | Business Unit Hyperlink EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Business Unit Hyperlink 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Business Unit Type EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
9 | Part Of Organization Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
10 | Required In Data Gov Committees Indicator EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | TBD | Required In Data Gov Committees Indicator EN | Required In Data Gov Committees Code EN | |
11 | Business Unit Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
12 | Business Unit Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
13 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
2 | Business Unit Acronym 2NDL | The second-language acronym by which a business unit is commonly known. | |
3 | Business Unit Full Name EN | The English-language full name for a business unit. | |
4 | Business Unit Full Name 2NDL | The second-language full name for a business unit. | |
5 | Parent Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
6 | Business Unit Hyperlink EN | A hyperlink to the English-language home page for a given business unit. | |
7 | Business Unit Hyperlink 2NDL | A hyperlink to the second-language home page for a given business unit. | |
8 | Business Unit Type EN | An English-language categorization for business units with respect to their place in the organizational hierarchy. Examples include but are not limited to: - Agency - Branch - Crown Corporation - Department - Division - Non-Government - Organization - Section - Sub-Unit - Unit - Team | |
9 | Part Of Organization Code EN | An English-language code indicating which of the parts of the organization a given business unit belongs to. | |
10 | Required In Data Gov Committees Indicator EN | An English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available). | |
11 | Business Unit Notes EN | Any English-language notes appropriate to record. | |
12 | Business Unit Notes 2NDL | Any second-language notes appropriate to record. | |
13 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
Code BI Object Type PK | Y | Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG RACI Application Software And Business Unit | 1..*:1..1 | Y | Y | ||||
DG Data Issue And Business Unit | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | |||||
Code Business Unit Type | 1..*:1..1 | Y | |||||
Code Part Of Organization | 1..*:1..1 | Y | |||||
Code Yes No | 1..*:1..1 | Y | |||||
DG Person | 1..*:1..1 | Y | |||||
IBG Business Attribute DQ Rules | 1..*:1..1 | Y | |||||
DG RACI Business Attribute And Business Unit | 1..*:1..1 | Y | Y | ||||
DG RACI Business Entity and Business Unit | 1..*:1..1 | Y | Y | ||||
IBG Business Intelligence Object | 1..*:1..1 | Y | Y | ||||
DG RACI BI Object and Business Unit | 1..*:1..1 | Y | Y | ||||
DG RACI Subject Area And Business Unit | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains committee attendance history. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains committee attendance history. Notes FR: La définition est à déterminer |
Number Of Attributes | 6 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Committee Meeting Date | P | F | Y | Date | LT | ||||
3 | Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
4 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Committee Acronym EN | The English-language acronym by which a committee is commonly known. | |
2 | Committee Meeting Date | The date that a committee met. | |
3 | Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
4 | Notes EN | Any English-language notes appropriate to record. | |
5 | Notes 2NDL | Any second-language notes appropriate to record. | |
6 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Committee Meeting History PK | Y | Committee Acronym EN | A | ||
Committee Meeting Date | A | ||||
Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Committee Meeting History | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the history of when committees of interest to the data governance program have met. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the history of when committees of interest to the data governance program have met. Notes FR: La définition est à déterminer |
Number Of Attributes | 7 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Committee Meeting Date | P | Y | Date | LT | GETDATE() | ||||
3 | Committee Meeting Minutes Hyperlink EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
4 | Committee Meeting Minutes Hyperlink 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Committee Acronym EN | The English-language acronym by which a committee is commonly known. | |
2 | Committee Meeting Date | The date that a committee met. | |
3 | Committee Meeting Minutes Hyperlink EN | A hyperlink to the committee's English-language meeting minutes. | |
4 | Committee Meeting Minutes Hyperlink 2NDL | A hyperlink to the committee's second-language meeting minutes. | |
5 | Notes EN | Any English-language notes appropriate to record. | |
6 | Notes 2NDL | Any second-language notes appropriate to record. | |
7 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Committee Meeting History PK | Y | Committee Acronym EN | A | ||
Committee Meeting Date | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
Code Committee | 1..*:1..1 | Y | Y | ||||
DG Committee Meeting Attendance | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains the list of people and the committees for which they are members. |
Notes |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
3 | Committee Membership Role Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Committee Membership Start Date | Y | Date | LT | ||||||
5 | Committee Membership End Date | Y | Date | LT | ||||||
6 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Committee Acronym EN | The English-language acronym by which a committee is commonly known. | |
2 | Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
3 | Committee Membership Role Code EN | An English-language code for the role that a person can have in a data governance committee. Examples include: - Chairperson - Delegate - Secretariat - Standing Observer - Voting Member | |
4 | Committee Membership Start Date | The start date for membership in a committee. | |
5 | Committee Membership End Date | The end date for membership in a committee. | |
6 | Notes EN | Any English-language notes appropriate to record. | |
7 | Notes 2NDL | Any second-language notes appropriate to record. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Committee Membership PK | Y | Committee Acronym EN | A | ||
Person Name | A | ||||
Committee Membership Role Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
Code Committee | 0..*:1..1 | Y | Y | ||||
DG Person | 0..*:1..1 | Y | Y | ||||
Code Committee Membership Role | 0..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of data issues and their impacts to business units in our organization. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of data issues and their impacts to business units in our organization. Notes FR: La définition est à déterminer |
Number Of Attributes | 7 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Data Issue Impact Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Point Of Contact Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | Point Of Contact Person Name | |
5 | Data Issue Impact Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Data Issue Impact Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Data Issue Impact Code EN | An English-language code used to categorize the impact of data issues. Examples include: - Financial Cost 1 - $50K - Financial Cost 2 - $50K to $500K - Financial Cost 3 - $500K and Above - Personal Desktop Application - Risk: Decision Risk 1 - Modest Impact - $50K - Risk: Decision Risk 2 - Medium Impact - $50K to $500K - Risk: Decision Risk 3 - High Impact - $500K and Above - Risk: Key Person Risk | |
3 | Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
4 | Point Of Contact Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
5 | Data Issue Impact Notes EN | Any English-language notes appropriate to record for the data issue and its impact. | |
6 | Data Issue Impact Notes 2NDL | Any second-language notes appropriate to record for the data issue and its impact. | |
7 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Data Issue Impact PK | Y | Data Issue ID | A | ||
Data Issue Impact Code EN | A | ||||
Business Unit Acronym EN | A | ||||
Point Of Contact Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y | Y | ||||
Code Data Issue Impact | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of data issues and the individuals who identified the issues. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of data issues and the individuals who identified the issues. Notes FR: La définition est à déterminer |
Number Of Attributes | 6 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
3 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | Data Issue And Person Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Data Issue And Person Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
3 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
4 | Data Issue And Person Notes EN | Any English-language notes appropriate to record for the data issue and a person associated with the issue. | |
5 | Data Issue And Person Notes 2NDL | Any second-language notes appropriate to record for the data issue and a person associated with the issue. | |
6 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Data Issue And Person PK | Y | Data Issue ID | A | ||
Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of data issues that have been identified by data stewards in our organization. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of data issues that have been identified by data stewards in our organization. Notes FR: La définition est à déterminer |
Number Of Attributes | 12 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | Y | Integer | DOM | Integer | 0 | |||
2 | Data Issue Title EN | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
3 | Data Issue Title 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
4 | Data Issue Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Data Issue Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Data Issue Documentation Folder Hyperlink | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Data Issue Category Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
8 | Data Issue Severity Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
9 | Data Issue Identification Date | Y | Date | LT | GETDATE() | |||||
10 | Data Issue Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | Data Issue Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
12 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Data Issue Title EN | The English-language title of a data issue. | |
3 | Data Issue Title 2NDL | The second-language title of a data issue. | |
4 | Data Issue Description EN | The English-language description of a data issue. | |
5 | Data Issue Description 2NDL | The second-language description of a data issue. | |
6 | Data Issue Documentation Folder Hyperlink | A hyperlink to a folder that contains any documention that is relevant to this issue. | |
7 | Data Issue Category Code EN | An English-language code used to categorize data issues. | |
8 | Data Issue Severity Code EN | An English-language code used to categorize the severity of data issues. Examples include: 0 - Nuisance 1 - Low 2 - Medium 3 - High 4 - Critical, Must Resolve | |
9 | Data Issue Identification Date | The date that a data issue was identified. | |
10 | Data Issue Notes EN | Any English-language notes appropriate to record for the data issue. | |
11 | Data Issue Notes 2NDL | Any second-language notes appropriate to record for the data issue. | |
12 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Data Issue Register PK | Y | Data Issue ID | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
Code Data Issue Category | 1..*:1..1 | Y | |||||
Code Data Issue Severity | 1..*:1..1 | Y | |||||
DG Data Issue And Business Unit | 1..*:1..1 | Y | Y | ||||
DG Data Issue And Person | 1..*:1..1 | Y | Y | ||||
DG XREF Data Issue In Other Tracker | 1..*:1..1 | Y | Y | ||||
DG Data Issue Status History | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Data Issue And BI Object | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Data Issue And Application | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the lifecycle status history of data issues. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the lifecycle status history of data issues. Notes FR: La définition est à déterminer |
Number Of Attributes | 6 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Data Issue Status Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Data Issue Status History Date | P | Y | Date | LT | GETDATE() | ||||
4 | Data Issue Status History Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | GETDATE() | ||||
5 | Data Issue Status History Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | GETDATE() | ||||
6 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Data Issue Status Code EN | An English-language code used to identify the status of data issues. Examples include: 01 - Open 02 - Work In Progress 03 - Closed - Not Resolved 04 - Closed - Resolved | |
3 | Data Issue Status History Date | The date of the status of a data issue. | |
4 | Data Issue Status History Notes EN | Any English-language notes appropriate to record for the status of a data issue. | |
5 | Data Issue Status History Notes 2NDL | Any second-language notes appropriate to record for the status of a data issue. | |
6 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Data Issue Status History PK | Y | Data Issue Status Code EN | A | ||
Data Issue ID | A | ||||
Data Issue Status History Date | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
Code Data Issue Status | 1..*:1..1 | Y | Y | ||||
DG Data Issue Register | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of people of interest to our organization. Comments FR: La définition est à déterminer |
Notes | Comments EN: This entity/table contains the list of people of interest to our organization. Comments FR: La définition est à déterminer |
Number Of Attributes | 9 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Person Name | P | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | |||
2 | Reports To Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | Reports To Person Name | Reports To Person Name | |
3 | Person Email Address | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
4 | Job Title Role EN | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
5 | Job Title Role 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
6 | Business Unit Acronym EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
7 | Person Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Person Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
2 | Reports To Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
3 | Person Email Address | The email address for a person. | |
4 | Job Title Role EN | The English-language job title or role of a person. | |
5 | Job Title Role 2NDL | The second-language job title or role of a person. | |
6 | Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
7 | Person Notes EN | The English-language notes for a person of interest. | |
8 | Person Notes 2NDL | The second-language notes for a person of interest. | |
9 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG Person PK | Y | Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG RACI Application Software And Person | 1..*:1..1 | Y | Y | ||||
DG Data Issue And Person | 1..*:1..1 | Y | Y | ||||
DG Data Issue And Business Unit | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | |||||
DG Committee Meeting Attendance | 1..*:1..1 | Y | Y | ||||
DG Committee Membership | 0..*:1..1 | Y | Y | ||||
IBG Subject Area | 1..*:1..1 | Y | |||||
IBG Business Entity | 1..*:1..1 | Y | |||||
IBG Business Attribute Core | 1..*:1..1 | Y | |||||
DG Business Unit | 1..*:1..1 | Y | |||||
IBG Business Attribute DQ Rules | 1..*:1..1 | Y | |||||
IBG Business Attribute DQ Colors | 1..*:1..1 | Y | |||||
DG RACI Business Attribute And Person | 1..*:1..1 | Y | Y | ||||
DG RACI Business Entity and Person | 1..*:1..1 | Y | Y | ||||
DG RACI BI Object and Person | 1..*:1..1 | Y | Y | ||||
DG RACI Subject Area And Person | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of applications and software to a business unit.. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of applications and software to a business unit.. Notes FR: La définition est à déterminer |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | RACI Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
5 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
6 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | RACI Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
3 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
4 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
5 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
6 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
7 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Application Software And Business Unit PK | Y | Application Software Nickname EN | A | ||
RACI Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Application Software | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of applications and software to a person. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of applications and software to a person. Noyes FR: La définition est à déterminer |
Number Of Attributes | 9 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | RACI Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
3 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
5 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
6 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
7 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | IBG Create Date | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | RACI Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
3 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
4 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
5 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
6 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
7 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
8 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
9 | IBG Create Date | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Application Software And Person PK | Y | Application Software Nickname EN | A | ||
RACI Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Application Software | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | |||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business intelligence (BI) object to a business unit. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business intelligence (BI) object to a business unit. Notes FR: La définition est à déterminer |
Number Of Attributes | 10 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | BI Object Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Accountable Business Unit Acronym EN | |
4 | RACI Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | RACI Business Unit Acronym EN | |
5 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
6 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
7 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
8 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | SYSDATE |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
2 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
3 | BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
4 | RACI Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
5 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
6 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
7 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
8 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
9 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
10 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Intelligence Object and Business Unit PK | Y | BI Object Name EN | A | ||
BI Object Type EN | A | ||||
BI Accountable Business Unit Acronym EN | A | ||||
RACI Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Intelligence Object | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business intelligence (BI) object to a person. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business intelligence (BI) object to a person. Notes FR: La définition est à déterminer |
Number Of Attributes | 11 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | BI Object Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Accountable Business Unit Acronym EN | |
4 | RACI Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | RACI Person Name | |
5 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
6 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
7 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
8 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
9 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | IBG Create Date | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
2 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
3 | BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
4 | RACI Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
5 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
6 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
7 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
8 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
9 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
10 | RACI Notes 2NDL | Any second-language notes appropriate to record for RACI relationship. | |
11 | IBG Create Date | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Intelligence Object and Person PK | Y | BI Object Name EN | A | ||
BI Object Type EN | A | ||||
BI Accountable Business Unit Acronym EN | A | ||||
RACI Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Intelligence Object | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | |||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business attribute to a business unit.. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business attribute to a business unit.. Notes FR: La définition est à déterminer |
Number Of Attributes | 10 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | RACI Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | RACI Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
7 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
8 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | RACI Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
5 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
6 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
7 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
8 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
9 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
10 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Attribute And Business Unit PK | Y | Business Attribute Name EN | A | ||
Business Entity Name EN | A | ||||
Subject Area Name EN | A | ||||
RACI Business Unit Acronym EN | A | ||||
RACI Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business attribute to a person. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business attribute to a person. Notes FR: La définition est à déterminer |
Number Of Attributes | 11 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | RACI Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
5 | RACI Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
7 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
8 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
9 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | IBG Create Date | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | RACI Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
5 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
6 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
7 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
8 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
9 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
10 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
11 | IBG Create Date | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Attribute And Person PK | Y | Business Attribute Name EN | A | ||
Business Entity Name EN | A | ||||
Subject Area Name EN | A | ||||
RACI Person Name | A | ||||
RACI Code EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | Y | ||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business entity to a business unit. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business entity to a business unit. Notes FR: La définition est à déterminer |
Number Of Attributes | 9 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | RACI Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
5 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
6 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
7 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
3 | RACI Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
4 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
5 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
6 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
7 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
8 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
9 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Entity and Business Unit PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
RACI Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Entity | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a business entity to a person. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a business entity to a person. Notes FR: La définition est à déterminer |
Number Of Attributes | 10 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | RACI Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | ||
4 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
5 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
6 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
7 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
8 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | IBG Create Date | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
3 | RACI Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
4 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
5 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
6 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
7 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
8 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
9 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
10 | IBG Create Date | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Business Entity and Person PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
RACI Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Entity | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | |||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a subject area to a business unit. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a subject area to a business unit. Notes FR: La définition est à déterminer |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | RACI Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | RACI Business Unit Acronym EN | |
3 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
5 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
6 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
2 | RACI Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
3 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
4 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
5 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
6 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
7 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Subject Area And Business Unit PK | Y | Subject Area Name EN | A | ||
RACI Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Subject Area | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the RACI-based cross reference of a subject area to a business unit.. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the RACI-based cross reference of a subject area to a business unit.. Notes FR: La définition est à déterminer |
Number Of Attributes | 9 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | RACI Person Name | P | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | RACI Person Name | |
3 | RACI Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | Data Governance Role Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
5 | RACI Start Date | Y | Date | LT | 0001-01-01 | |||||
6 | RACI End Date | Y | Date | LT | 9999-12-31 | |||||
7 | RACI Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | RACI Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | SYSDATE |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
2 | RACI Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
3 | RACI Code EN | The English-language code that identifies the formal relationship that a person or business unit has with an information asset. There are four codes: 1. Responsible 2. Accountable 3. Consulted 4. Informed | |
4 | Data Governance Role Code EN | An English-language code for the roles that a person can have in the organization's data governance program. | |
5 | RACI Start Date | The date that a RACI-based relationship between a person or business unit and an information asset began. | |
6 | RACI End Date | The date that a RACI-based relationship between a person or business unit and an information asset ended. | |
7 | RACI Notes EN | Any English-language notes appropriate to record for a RACI relationship. | |
8 | RACI Notes 2NDL | Any second-language notes appropriate to record for a RACI relationship. | |
9 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG RACI Subject Area And Person PK | Y | Subject Area Name EN | A | ||
RACI Person Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Subject Area | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | Y | ||||
Code RACI | 1..*:1..1 | Y | |||||
Code Data Governance Role | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a list of data issues cross referenced to other defect tracking systems in our organization. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a list of data issues cross referenced to other defect tracking systems in our organization. Notes FR: La définition est à déterminer |
Number Of Attributes | 7 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Issue Tracking Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Data Issue ID In Other Issue Tracking Application | P | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | |||
4 | Data Issue Hyperlink In Other Issue Tracking Application | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Data Issue XREF Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Data Issue XREF Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Issue Tracking Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
3 | Data Issue ID In Other Issue Tracking Application | The identifier for a data issue that has been identified in another issue tracking software application in our organization. | |
4 | Data Issue Hyperlink In Other Issue Tracking Application | A hyperlink to a data issue in another issue tracking application in the organization. | |
5 | Data Issue XREF Notes EN | Any English-language notes appropriate to record for the cross reference of this data issue to something. | |
6 | Data Issue XREF Notes 2NDL | Any second-language notes appropriate to record for the cross reference of this data issue to something. | |
7 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
DG XREF Data Issue In Other Defect Tracking System PK | Y | Data Issue ID | A | ||
Issue Tracking Application Software Nickname EN | A | ||||
Data Issue ID In Other Issue Tracking Application | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y | Y | ||||
IBG Application Software | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of application systems of interest, and basic information for these application systems. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of application systems of interest, and basic information for these application systems. Notes FR: La définition est à déterminer |
Number Of Attributes | 11 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Application Software Nickname EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | Application Software Nickname 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||||
3 | Application Software Full Name EN | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
4 | Application Software Full Name 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
5 | Application Software Vendor Name | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
6 | Application Software Hyperlink | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Application Software Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Application Software Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | Application Software Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | Application Software Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | Application Software Nickname 2NDL | The second-language acronym by which an application system or software product is commonly known. | |
3 | Application Software Full Name EN | The English-language full name for an application system or software product. | |
4 | Application Software Full Name 2NDL | The second-language full name for an application system or software product. | |
5 | Application Software Vendor Name | A free-form text field containing the name of the vendor from whom an application system or software product was purchased. | |
6 | Application Software Hyperlink | A hyperlink to the home page, in our organization, for the application system or software product. | |
7 | Application Software Description EN | An English-language description of something. | |
8 | Application Software Description 2NDL | A second-language description of something. | |
9 | Application Software Notes EN | Any English-language notes appropriate to record. | |
10 | Application Software Notes 2NDL | Any second-language notes appropriate to record. | |
11 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG ETL Program | 1..*:1..1 | Y | Y | ||||
DG RACI Application Software And Person | 1..*:1..1 | Y | Y | ||||
DG RACI Application Software And Business Unit | 1..*:1..1 | Y | Y | ||||
DG XREF Data Issue In Other Tracker | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To BI Object | 1..*:1..1 | Y | Y | ||||
IBG Application Software Field | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To Application | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To Application | 1..*:1..1 | Y | Y | ||||
IBG Business Intelligence Object | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of windows and fields of interest in the application systems of interest. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of windows and fields of interest in the application systems of interest. Notes FR: La définition est à déterminer |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Application SW Window Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
3 | Application SW Field Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | Application SW Window Name 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||||
5 | Application SW Field Name 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||||
6 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | Application SW Window Name EN | The English-language name for a window in an application system. A window is part of the presentation layer for an application and presents fields representing the data for business attributes. | |
3 | Application SW Field Name EN | The English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes. | |
4 | Application SW Window Name 2NDL | The second-language name for a window in an application system. A window is part of the presentation layer for an application and presents fields representing the data for business attributes. | |
5 | Application SW Field Name 2NDL | The second-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes. | |
6 | Notes EN | Any English-language notes appropriate to record. | |
7 | Notes 2NDL | Any second-language notes appropriate to record. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System Window Field PK | Y | Application SW Window Name EN | A | ||
Application SW Field Name EN | A | ||||
Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Application Software | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Column And Application | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains core information forthe business attributes of interest in our organization. A business attribute is implemented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains core information forthe business attributes of interest in our organization. A business attribute is implemented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. Notes FR: La définition est à déterminer |
Number Of Attributes | 32 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||
4 | Business Attribute Name 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
5 | Business Attribute Definition EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
6 | Business Attribute Definition 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
7 | Business Metadata Status Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
8 | Business Metadata Approved By Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | Business Metadata Approved By Person Name | ||
9 | Business Metadata Approved Date | Y | Date | LT | 9999-12-31 | |||||
10 | Default Value EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
11 | Default Value 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
12 | Data Entry Guidelines EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
13 | Data Entry Guidelines 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
14 | Derivation Rule EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
15 | Derivation Rule 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
16 | Usage Guidelines EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
17 | Usage Guidelines 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
18 | Mosaic Caution EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
19 | Mosaic Caution 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
20 | Masking Rule EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
21 | Masking Rule 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
22 | Archive Rule EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
23 | Archive Rule 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
24 | Purge Rule EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
25 | Purge Rule 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
26 | Operational Reference Master Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
27 | Protected Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
28 | Sensitivity Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
29 | Personally Identifiable Information Indicator EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Personally Identifiable Information Indicator EN | ||
30 | Business Attribute Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
31 | Business Attribute Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
32 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | Business Attribute Name 2NDL | The second-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
5 | Business Attribute Definition EN | An English-language, business-approved definition of the business attribute. The structure of the definition should be compliant with guidelines in "ISO/IEC 11179-4:2004 Formulation of data definitions". | |
6 | Business Attribute Definition 2NDL | A second-language, business-approved definition of the business attribute. The structure of the definition should be compliant with guidelines in "ISO/IEC 11179-4:2004 Formulation of data definitions". | |
7 | Business Metadata Status Code EN | The English-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
8 | Business Metadata Approved By Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
9 | Business Metadata Approved Date | The date that business metadata was approved. | |
10 | Default Value EN | An English-language business rule containing the value to be used when the actual value for a business attribute is unknown. | |
11 | Default Value 2NDL | A second-language business rule containing the value to be used when the actual value for a business attribute is unknown. | |
12 | Data Entry Guidelines EN | An English-language business rule containing guidelines for creating data for a given business attribute in an application. These guidelines are established by the accountable data owner of the business attribute. | |
13 | Data Entry Guidelines 2NDL | A second-language business rule containing guidelines for creating data for a given business attribute in an application. These guidelines are established by the accountable data owner of the business attribute. | |
14 | Derivation Rule EN | An English-language business rule describing how the value for a given business attribute has been determined, calculated, or derived. For example, "Invoice Total Amount" is a derived value, and it's Derivation Rule could be: "The total of all amounts for all line items on an invoice plus delivery charges plus the amount of HST." | |
15 | Derivation Rule 2NDL | A second-language business rule describing how the value for a given business attribute has been determined, calculated, or derived. For example, "Invoice Total Amount" is a derived value, and it's Derivation Rule could be: "The total of all amounts for all line items on an invoice plus delivery charges plus the amount of HST." | |
16 | Usage Guidelines EN | An English-language business rule that provides guidance, if any, when using a given business attribute. An example could be "Do not rely on the value of this business attribute if it was created more than five business days in the past." | |
17 | Usage Guidelines 2NDL | A second-language business rule that provides guidance, if any, when using a given business attribute. An example could be "Do not rely on the value of this business attribute if it was created more than five business days in the past." | |
18 | Mosaic Caution EN | An English-language business rule describing any cautions to be observed when using a given business attribute with other business attributes. The mosaic effect occurs when multiple business attributes or datasets are linked to reveal significant new information. While such information could be used to gain insight for decisions, it could also be used by bad actors to do harm. | |
19 | Mosaic Caution 2NDL | A second-language business rule describing any cautions to be observed when using a given business attribute with other business attributes. The mosaic effect occurs when multiple business attributes or datasets are linked to reveal significant new information. While such information could be used to gain insight for decisions, it could also be used by bad actors to do harm. | |
20 | Masking Rule EN | An English-language business rule describing how the values of a business attribute must be modified when copying data from a production environment with appropriate security access rules to a non-production environment that may not have appropriate security controls. For example, Social Insurance Number may need to be modified, i.e. 'masked', when it's part of an extract of production data to be used by programmers in a test environment. | |
21 | Masking Rule 2NDL | A second-language business rule describing how the values of a business attribute must be modified when copying data from a production environment with appropriate security access rules to a non-production environment that may not have appropriate security controls. For example, Social Insurance Number may need to be modified, i.e. 'masked', when it's part of an extract of production data to be used by programmers in a test environment. | |
22 | Archive Rule EN | An English-language business rule used to determine when a given business attribute, as implemented in an application system, database table, and column, can be removed from the online environment and put onto near-online or offline media. The archived business attribute still exists in the organization and can be restored to the online environment. | |
23 | Archive Rule 2NDL | A second-language business rule used to determine when a given business attribute, as implemented in an application system, database table, and column, can be removed from the online environment and put onto near-online or offline media. The archived business attribute still exists in the organization and can be restored to the online environment. | |
24 | Purge Rule EN | An English-language business rule used to determine when a given business attribute, as implemented in an application system, database table, and column, can be can be deleted. Once deleted, it is no longer available to the organization. Note that the physical data may also be stored on near-online or offline media, and would be deleted from this secondary media. | |
25 | Purge Rule 2NDL | A second-language business rule used to determine when a given business attribute, as implemented in an application system, database table, and column, can be can be deleted. Once deleted, it is no longer available to the organization. Note that the physical data may also be stored on near-online or offline media, and would be deleted from this secondary media. | |
26 | Operational Reference Master Code EN | An English-language categorization of a piece of data as master data, reference data, or operational data. | |
27 | Protected Level Code EN | An English-language categorization applied to an information asset that describes the level of injury that can occur if the information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf | |
28 | Sensitivity Level Code EN | An English-language categorization applied to an information asset that is used in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the Information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" | |
29 | Personally Identifiable Information Indicator EN | An English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available). | |
30 | Business Attribute Notes EN | Any English-language notes appropriate to record. | |
31 | Business Attribute Notes 2NDL | Any second-language notes appropriate to record. | |
32 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Attribute PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Entity | 1..*:1..1 | Y | Y | ||||
Code Sensitivity Level | 1..*:1..1 | Y | |||||
Code Yes No | Personally Identifiable Information Indicator | 1..*:1..1 | Y | ||||
IBG XREF BA And Column | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | |||||
Code Operational Reference Master | 1..*:1..1 | Y | |||||
IBG Business Attribute DQ Rules | 1..*:1..1 | Y | |||||
IBG Business Attribute Document | 1..*:1..1 | Y | Y | ||||
DG RACI Business Attribute And Person | 1..*:1..1 | Y | Y | ||||
DG RACI Business Attribute And Business Unit | 1..*:1..1 | Y | Y | ||||
Code Business Metadata Status | 1..*:1..1 | Y | |||||
Code Protected Level | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the assignment of color codes to data quality dimensions for business attributes. In practice, colors are assigned to dimensions and business attributes based on the data quality profiling pass/fail percentage being compared to stated low and high percentage ranges. For example, if a profile test for uniqueness results in an 85% pass rate, this 85% is compared to DQ Color Low Range Percentage values and DQ High DQ Color Range Percentage values to determine the appropriate color to be presented. In practice, 85% must be greater than a DQ Color Low Range Percentage and less than or equal to the DQ High DQ Color Range Percentage for a given DQ dimension and DQ Color. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the assignment of color codes to data quality dimensions for business attributes. In practice, colors are assigned to dimensions and business attributes based on the data quality profiling pass/fail percentage being compared to stated low and high percentage ranges. For example, if a profile test for uniqueness results in an 85% pass rate, this 85% is compared to DQ Color Low Range Percentage values and DQ High DQ Color Range Percentage values to determine the appropriate color to be presented. In practice, 85% must be greater than a DQ Color Low Range Percentage and less than or equal to the DQ High DQ Color Range Percentage for a given DQ dimension and DQ Color. Notes FR: La définition est à déterminer |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | DQ Rule Number SKEY | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | DQ Color Code EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | DQ Color Low Range Percentage | Y | Integer | DOM | Integer | 0 | ||||
4 | DQ Color High Range Percentage | Y | Integer | DOM | Integer | 0 | ||||
5 | DQ Color Range Approved By Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | DQ Color Range Approved By Person Name | DQ Color Range Approved By Person Name | |
6 | DQ Color Range Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | DQ Color Range Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | DQ Rule Number SKEY | A meaningless but unique surrogate key identifying a data quality dimension rule for a given business attribute. | |
2 | DQ Color Code EN | The English-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute. | |
3 | DQ Color Low Range Percentage | The low percentage value for DQ dimension and DQ color range comparison tests. A range comparison test assesses the actual percentage that pass a data quality profiling test against low percentage values and high percentage values. For example, if a profile test for uniqueness results in an 85% pass rate, this 85% is compared to DQ Color Low Range Percentage values and DQ High DQ Color Range Percentage values to determine the appropriate color to be presented. In practice, 85% must be greater than a DQ Color Low Range Percentage and less than or equal to the DQ High DQ Color Range Percentage for a given DQ dimension and DQ Color. | |
4 | DQ Color High Range Percentage | The high percentage value for DQ dimension and DQ color range comparison tests. A range comparison test assesses the actual percentage that pass a data quality profiling test against low percentage values and high percentage values. For example, if a profile test for uniqueness results in an 85% pass rate, this 85% is compared to DQ Color Low Range Percentage values and DQ High DQ Color Range Percentage values to determine the appropriate color to be presented. In practice, 85% must be greater than a DQ Color Low Range Percentage and less than or equal to the DQ High DQ Color Range Percentage for a given DQ dimension and DQ Color. | |
5 | DQ Color Range Approved By Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
6 | DQ Color Range Notes EN | Any English-language notes appropriate to record. | |
7 | DQ Color Range Notes 2NDL | Any second-language notes appropriate to record. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Attribute DQ Color Ranges PK | Y | DQ Color Code EN | A | ||
DQ Rule Number SKEY | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute DQ Rules | 1..*:1..1 | Y | Y | ||||
Code DQ Color | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the assignment of data quality dimensions to business attributes, and the criteria to be used for a given dimension when profiling and monitoring data associated with the business attribute. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the assignment of data quality dimensions to business attributes, and the criteria to be used for a given dimension when profiling and monitoring data associated with the business attribute. Notes FR: La définition est à déterminer |
Number Of Attributes | 12 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | DQ Rule Number SKEY | P | Y | Integer | DOM | Integer | 0 | |||
2 | DQ Dimension Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
3 | Business Attribute Name EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
4 | Business Entity Name EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
5 | Subject Area Name EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
6 | DQ Rule Owner Business Unit Acronym EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | DQ Rule Owner Business Unit Acronym EN | ||
7 | DQ Rule Criteria Text EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | DQ Rule Criteria Text 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | DQ Rule Approved By Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | DQ Rule Approved By Person Name | DQ Dimension Criteria Approved By Person Name | |
10 | DQ Rule Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | DQ Rule Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
12 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | DQ Rule Number SKEY | A meaningless but unique surrogate key identifying a data quality dimension rule for a given business attribute. | |
2 | DQ Dimension Code EN | The English-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc. | |
3 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
4 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
5 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
6 | DQ Rule Owner Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
7 | DQ Rule Criteria Text EN | The English-language criteria used to assess a given data quality dimension against the data for a business attribute. | |
8 | DQ Rule Criteria Text 2NDL | The second-language criteria used to assess a given data quality dimension against the data for a business attribute. | |
9 | DQ Rule Approved By Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
10 | DQ Rule Notes EN | Any English-language notes appropriate to record for the business attribute and a DQ dimension. | |
11 | DQ Rule Notes 2NDL | Any second-language notes appropriate to record for the business attribute and a DQ dimension. | |
12 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Attribute DQ Rules PK | Y | DQ Rule Number SKEY | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute DQ Colors | 1..*:1..1 | Y | Y | ||||
IBG Business Attribute Core | 1..*:1..1 | Y | |||||
Code DQ Dimension | 1..*:1..1 | Y | |||||
DG Person | 1..*:1..1 | Y | |||||
DG Business Unit | 1..*:1..1 | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a list of hyperlinks to documents that are associated with business attributes. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a list of hyperlinks to documents that are associated with business attributes. Notes FR: La définition est à déterminer |
Number Of Attributes | 10 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Document Name EN | P | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | |||
5 | Document Name 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
6 | Document Hyperlink EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Document Hyperlink 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Business Attribute Document Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | Business Attribute Document Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | Document Name EN | The English-language name of a document. | |
5 | Document Name 2NDL | The second-language name of a document. | |
6 | Document Hyperlink EN | A hyperlink to to the English-language document. | |
7 | Document Hyperlink 2NDL | A hyperlink to to the second-language document. | |
8 | Business Attribute Document Notes EN | Any English-language notes appropriate to record. | |
9 | Business Attribute Document Notes 2NDL | Any second-language notes appropriate to record. | |
10 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Attribute Document PK | Y | Business Attribute Name EN | A | ||
Business Entity Name EN | A | ||||
Subject Area Name EN | A | ||||
Document Name EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains information regarding business entities, which themselves contain one or more business attributes. A business entity is implemented as one or more tables in databases. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains information regarding business entities, which themselves contain one or more business attributes. A business entity is implemented as one or more tables in databases. Notes FR: La définition est à déterminer |
Number Of Attributes | 13 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Entity Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||
3 | Business Entity Name 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
4 | Business Entity Definition EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | Business Entity Definition 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
6 | Business Metadata Status Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
7 | Business Metadata Approved By Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | Business Metadata Approved By Person Name | ||
8 | Business Metadata Approved Date | Y | Date | LT | 9999-12-31 | |||||
9 | Sensitivity Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
10 | Protected Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
11 | Business Entity Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
12 | Business Entity Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
13 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
3 | Business Entity Name 2NDL | The second-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
4 | Business Entity Definition EN | An English-language defintion of something. | |
5 | Business Entity Definition 2NDL | A second-language definition of something. | |
6 | Business Metadata Status Code EN | The English-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
7 | Business Metadata Approved By Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
8 | Business Metadata Approved Date | The date that business metadata was approved. | |
9 | Sensitivity Level Code EN | An English-language categorization applied to an information asset that is used in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the Information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" | |
10 | Protected Level Code EN | An English-language categorization applied to an information asset that describes the level of injury that can occur if the information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf | |
11 | Business Entity Notes EN | Any English-language notes associated with a given Business Entity. | |
12 | Business Entity Notes 2NDL | Any second-language notes associated with a given Business Entity. | |
13 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Subject Area PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | Y | ||||
Code Sensitivity Level | 1..*:1..1 | Y | |||||
Code Protected Level | 1..*:1..1 | Y | |||||
IBG XREF BE And Table Or View | 1..*:1..1 | Y | Y | ||||
DG Person | 1..*:1..1 | Y | |||||
Code Business Metadata Status | 1..*:1..1 | Y | |||||
IBG Subject Area | 1..*:1..1 | Y | Y | ||||
DG RACI Business Entity and Person | 1..*:1..1 | Y | Y | ||||
DG RACI Business Entity and Business Unit | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains information regarding business intelligence (BI) objects that exist in our organization. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains information regarding business intelligence (BI) objects that exist in our organization. Notes FR: La définition est à déterminer |
Number Of Attributes | 14 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | BI Object Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Accountable Business Unit Acronym EN | |
4 | BI Object Name 2NDL | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
5 | Business Metadata Status Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
6 | BI Application Software Nickname EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Application Software Nickname EN | ||
7 | BI Hyperlink | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | BI Object Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | BI Object Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | Protected Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
11 | Sensitivity Level Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
12 | Business Intelligence Object Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
13 | Business Intelligence Object Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
2 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
3 | BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
4 | BI Object Name 2NDL | The second-language name of a business intelliegnce (BI) object. | |
5 | Business Metadata Status Code EN | The English-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
6 | BI Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
7 | BI Hyperlink | A hyperlink to the home page in our organization for a given BI object. | |
8 | BI Object Description EN | An English-language description of something. | |
9 | BI Object Description 2NDL | A second-language description of something. | |
10 | Protected Level Code EN | An English-language categorization applied to an information asset that describes the level of injury that can occur if the information asset is disclosed to unauthoriazed individuals. See Treasury Board of Canada for the list of values at https://www.tpsgc-pwgsc.gc.ca/esc-src/documents/levels-of-security.pdf | |
11 | Sensitivity Level Code EN | An English-language categorization applied to an information asset that is used in two contexts. First, it describes the level of injury to provincial/national interests that could occur if the information asset was disclosed to unauthorized individuals or organizations. Second, it describes the authorization level that a person or organization should have in order to view the Information asset. The two contexts are demonstrated in this sentence: "This information is categorized as Secret. Is your security classification Secret or above?" | |
12 | Business Intelligence Object Notes EN | Any English-language notes appropriate to record for a given business intelligence object. | |
13 | Business Intelligence Object Notes 2NDL | Any second-language notes appropriate to record for a given business intelligence object. | |
14 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Intelligence Object PK | Y | BI Object Name EN | A | ||
BI Object Type EN | A | ||||
BI Accountable Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Lineage Application Column To BI Object | 1..*:1..1 | Y | Y | ||||
Code Protected Level | 1..*:1..1 | Y | |||||
Code Sensitivity Level | 1..*:1..1 | Y | |||||
Code Business Metadata Status | 1..*:1..1 | Y | |||||
IBG XREF BA Column And BI Object | 1..*:1..1 | Y | Y | ||||
Code BI Object Type | 1..*:1..1 | Y | Y | ||||
DG Business Unit | 1..*:1..1 | Y | Y | ||||
IBG Application Software | 1..*:1..1 | Y | |||||
DG RACI BI Object and Person | 1..*:1..1 | Y | Y | ||||
DG RACI BI Object and Business Unit | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the hierarchical path for a column implemented in a table or view, which is implemented in a schema, which is implemented in a database, which is managed by a database management system (DBMS). Columns are the physical implementation of a business attribute. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the hierarchical path for a column implemented in a table or view, which is implemented in a schema, which is implemented in a database, which is managed by a database management system (DBMS). Columns are the physical implementation of a business attribute. Notes FR: La définition est à déterminer |
Number Of Attributes | 8 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Column Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
2 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
3 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
4 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
6 | Notes EN | Any English-language notes appropriate to record. | |
7 | Notes 2NDL | Any second-language notes appropriate to record. | |
8 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | Column Name | A | ||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG XREF BA And Column | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To BI Object | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To Application | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To Application | 1..*:1..1 | Y | Y | ||||
IBG Table or View | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of databases of interest. Databases are managed by a database management system (DBMS). Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of databases of interest. Databases are managed by a database management system (DBMS). Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Database Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
4 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
2 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
3 | Notes EN | Any English-language notes appropriate to record. | |
4 | Notes 2NDL | Any second-language notes appropriate to record. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | Database Name | A | ||
DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Database Management System | 1..*:1..1 | Y | Y | ||||
IBG Schema | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of database management systems (DBMS) of interest. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of database management systems (DBMS) of interest. Notes FR: La définition est à déterminer |
Number Of Attributes | 5 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | DBMS Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | DBMS Vendor Name | Y | CHAR (256 CHAR) | DOM | CHAR-256 | To Be Determined/ Être déterminé | ||||
3 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
4 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
2 | DBMS Vendor Name | A free-form text field containing the name of the vendor from whom the DBMS was purchased. | |
3 | Notes EN | Any English-language notes appropriate to record. | |
4 | Notes 2NDL | Any second-language notes appropriate to record. | |
5 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Database | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a list of integration programs that are used to extract, and/or transform from a source and/or load it into a target. These programs are referred to as ETL programs, although not every program will perform every function. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a list of integration programs that are used to extract, and/or transform from a source and/or load it into a target. These programs are referred to as ETL programs, although not every program will perform every function. Notes FR: La définition est à déterminer |
Number Of Attributes | 7 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | ETL Program Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | ETL Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ETL Application Software Nickname EN | |
3 | Description EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
4 | Description 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | ETL Program Name | The name of program that is used to extract, and/or transform, and and/or load (ETL) data. Not every program will perform all three functions. | |
2 | ETL Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
3 | Description EN | An English-language description of something. | |
4 | Description 2NDL | A second-language description of something. | |
5 | Notes EN | Any English-language notes appropriate to record. | |
6 | Notes 2NDL | Any second-language notes appropriate to record. | |
7 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG ETL Program PK | Y | ETL Program Name | A | ||
ETL Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Application Software | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To BI Object | 1..*:1..1 | Y | Y | ||||
IBG Lineage Application Column To Application | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains the list of source columns in tables that are extracted, transformed, and loaded into target tables and columns. It also includes the name of the ETL program used to move the data from the source to the target. |
Notes |
Number Of Attributes | 17 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Source Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Application Software Nickname EN | |
2 | Source Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Column Name | |
3 | Source Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Table or View Name | |
4 | Source Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Schema Name | |
5 | Source Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Database Name | |
6 | Source DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source DBMS Name | |
7 | ETL Program Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | ETL Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ETL Application Software Nickname EN | |
9 | Target Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target Application Software Nickname EN | |
10 | Target Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target Column Name | |
11 | Target Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target Table or View Name | |
12 | Target Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target Schema Name | |
13 | Target Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target Database Name | |
14 | Target DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target DBMS Name | |
15 | Lineage Application Column To Application Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
16 | Lineage Application Column To Application Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
17 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Source Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | Source Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
3 | Source Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
4 | Source Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Source Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
6 | Source DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
7 | ETL Program Name | The name of program that is used to extract, and/or transform, and and/or load (ETL) data. Not every program will perform all three functions. | |
8 | ETL Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
9 | Target Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
10 | Target Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
11 | Target Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
12 | Target Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
13 | Target Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
14 | Target DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
15 | Lineage Application Column To Application Notes EN | Any English-language notes appropriate to record. | |
16 | Lineage Application Column To Application Notes 2NDL | Any second-language notes appropriate to record. | |
17 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Lineage Column To Column PK | Y | Source Application Software Nickname EN | A | ||
Source Column Name | A | ||||
Source Table or View Name | A | ||||
Source Schema Name | A | ||||
Source Database Name | A | ||||
Source DBMS Name | A | ||||
Target Application Software Nickname EN | A | ||||
Target Column Name | A | ||||
Target Table or View Name | A | ||||
Target Schema Name | A | ||||
Target Database Name | A | ||||
Target DBMS Name | A | ||||
ETL Program Name | A | ||||
ETL Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Application Software | 1..*:1..1 | Y | Y | ||||
IBG Column | 1..*:1..1 | Y | Y | ||||
IBG Application Software | 1..*:1..1 | Y | Y | ||||
IBG Column | 1..*:1..1 | Y | Y | ||||
IBG ETL Program | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains the list of columns in tables that are used to populate business intelligence objects. |
Notes |
Number Of Attributes | 14 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Source Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Application Software Nickname EN | |
2 | Source Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Column Name | |
3 | Source Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Table or View Name | |
4 | Source Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Schema Name | |
5 | Source Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source Database Name | |
6 | Source DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Source DBMS Name | |
7 | ETL Program Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | ETL Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ETL Application Software Nickname EN | |
9 | Target BI Object Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target BI Object Name EN | |
10 | Target BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target BI Object Type EN | |
11 | Target BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | Target BI Accountable Business Unit Acronym EN | |
12 | Lineage Application Column To BI Object Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
13 | Lineage Application Column To BI Object Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Source Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
2 | Source Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
3 | Source Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
4 | Source Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Source Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
6 | Source DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
7 | ETL Program Name | The name of program that is used to extract, and/or transform, and and/or load (ETL) data. Not every program will perform all three functions. | |
8 | ETL Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
9 | Target BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
10 | Target BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
11 | Target BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
12 | Lineage Application Column To BI Object Notes EN | Any English-language notes appropriate to record. | |
13 | Lineage Application Column To BI Object Notes 2NDL | Any second-language notes appropriate to record. | |
14 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Lineage Column To Business Intelligence Object PK | Y | ETL Program Name | A | ||
ETL Application Software Nickname EN | A | ||||
Target BI Object Name EN | A | ||||
Target BI Object Type EN | A | ||||
Target BI Accountable Business Unit Acronym EN | A | ||||
Source Application Software Nickname EN | A | ||||
Source Column Name | A | ||||
Source Table or View Name | A | ||||
Source Schema Name | A | ||||
Source Database Name | A | ||||
Source DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG ETL Program | 1..*:1..1 | Y | Y | ||||
IBG Business Intelligence Object | 1..*:1..1 | Y | Y | ||||
IBG Application Software | 1..*:1..1 | Y | Y | ||||
IBG Column | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains the list of schemas of interest. Schemas contain tables and views, are implemented in databases, which are managed in database management systems (DBMS). Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of schemas of interest. Schemas contain tables and views, are implemented in databases, which are managed in database management systems (DBMS). Notes FR: La définition est à déterminer |
Number Of Attributes | 6 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Schema Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
5 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
2 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
3 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
4 | Notes EN | Any English-language notes appropriate to record. | |
5 | Notes 2NDL | Any second-language notes appropriate to record. | |
6 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | Schema Name | A | ||
Database Name | A | ||||
DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Database | 1..*:1..1 | Y | Y | ||||
IBG Table or View | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains information regarding subject areas in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains information regarding subject areas in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". Notes FR: La définition est à déterminer |
Number Of Attributes | 10 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Subject Area Name EN | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
2 | Subject Area Name 2NDL | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | ||||
3 | Subject Area Definition EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
4 | Subject Area Definition 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
5 | Business Metadata Status Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To be determined/Être déterminé | |||
6 | Business Metadata Approved By Person Name | F | Y | CHAR (128) | DOM | CHAR-128 | To Be Determined/ Être déterminé | Business Metadata Approved By Person Name | ||
7 | Business Metadata Approved Date | Y | Date | LT | 9999-12-31 | |||||
8 | Subject Area Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
9 | Subject Area Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/Être déterminé | ||||
10 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
2 | Subject Area Name 2NDL | The second-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common suse, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
3 | Subject Area Definition EN | An English-language defintion of something. | |
4 | Subject Area Definition 2NDL | A second-language definition of something. | |
5 | Business Metadata Status Code EN | The English-language status of the business metadata associated with an information asset in the Integrated Business Glossary. Business metadata for an information asset includes its defintion, usage rules, derivation rules, archive and purge rules, etc. At this time, status codes include: 1. Not Started 2. Work In Progress 3. Approved | |
6 | Business Metadata Approved By Person Name | The name of a person in the organization, or of a person of interest to the organization. | |
7 | Business Metadata Approved Date | The date that business metadata was approved. | |
8 | Subject Area Notes EN | The English-language notes associated with a given Subject Area. | |
9 | Subject Area Notes 2NDL | The second-language notes associated with a given Subject Area. | |
10 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Subject Area PK | Y | Subject Area Name EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
Code Business Metadata Status | 1..*:1..1 | Y | |||||
DG Person | 1..*:1..1 | Y | |||||
IBG Business Entity | 1..*:1..1 | Y | Y | ||||
DG RACI Subject Area And Person | 1..*:1..1 | Y | Y | ||||
DG RACI Subject Area And Business Unit | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Notes EN: This entity/table contains the list of tables and views of interest. Tables and views contain columns, are iimplemented in a schema, which is implemented in a database, which is managed by a database management system (DBMS). Notes FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains the list of tables and views of interest. Tables and views contain columns, are iimplemented in a schema, which is implemented in a database, which is managed by a database management system (DBMS). Notes FR: La définition est à déterminer |
Number Of Attributes | 7 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Table or View Name | P | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
2 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
6 | Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
7 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
2 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
3 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
4 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
5 | Notes EN | Any English-language notes appropriate to record. | |
6 | Notes 2NDL | Any second-language notes appropriate to record. | |
7 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Application System PK | Y | Table or View Name | A | ||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG XREF BE And Table Or View | 1..*:1..1 | Y | Y | ||||
IBG Schema | 1..*:1..1 | Y | Y | ||||
IBG Column | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains a cross reference of business attributes to columns and tables or views. |
Notes |
Number Of Attributes | 11 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
9 | Business Attribute And Column Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
10 | Business Attribute And Column Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
11 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
6 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
7 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
8 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
9 | Business Attribute And Column Notes EN | Any English-language notes appropriate to record for the business attribute and column cross reference. | |
10 | Business Attribute And Column Notes 2NDL | Any second-language notes appropriate to record for the business attribute and column cross reference. | |
11 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG XREF BA And Column PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A | ||||
Column Name | A | ||||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Business Attribute Core | 1..*:1..1 | Y | Y | ||||
IBG Column | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Column And Application | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Column And BI Object | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains a cross reference of business attributes and columns to applications. |
Notes |
Number Of Attributes | 15 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
9 | Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
10 | Application SW Window Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
11 | Application SW Field Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
12 | System Of Record Or Reference Code EN | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | |||
13 | Business Attribute Column Application Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | Business Attribute Column Application Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
15 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
6 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
7 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
8 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
9 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
10 | Application SW Window Name EN | The English-language name for a window in an application system. A window is part of the presentation layer for an application and presents fields representing the data for business attributes. | |
11 | Application SW Field Name EN | The English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes. | |
12 | System Of Record Or Reference Code EN | An English-language code used to indicate whether an application system can be considered to be a system of record or a system of reference with respect to a given business attribute. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. | |
13 | Business Attribute Column Application Notes EN | Any English-language notes appropriate to record for the business attribute, column, and application cross reference. | |
14 | Business Attribute Column Application Notes 2NDL | Any second-language notes appropriate to record for the business attribute, column, and application cross reference. | |
15 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
XREF BA Column And Application PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A | ||||
Column Name | A | ||||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A | ||||
Application SW Window Name EN | A | ||||
Application SW Field Name EN | A | ||||
Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG XREF BA And Column | 1..*:1..1 | Y | Y | ||||
IBG Application Software Field | 1..*:1..1 | Y | Y | ||||
Code System Of Record Or Reference | 1..*:1..1 | Y | |||||
IBG XREF BA Data Issue And Application | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | This entity/table contains a cross reference of business attributes and columns to BI objects.. |
Notes |
Number Of Attributes | 14 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
9 | BI Object Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
10 | BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
11 | BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Accountable Business Unit Acronym EN | |
12 | Business Attribute Column BI Object Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
13 | Business Attribute Column BI Object Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
4 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
6 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
7 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
8 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
9 | BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
10 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
11 | BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
12 | Business Attribute Column BI Object Notes EN | Any English-language notes appropriate to record for the business attribute, column, and BI object cross reference. | |
13 | Business Attribute Column BI Object Notes 2NDL | Any second-language notes appropriate to record for the business attribute, column, and BI object cross reference. | |
14 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
XREF BA Column And BI Object PK | Y | Business Entity Name EN | A | ||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A | ||||
Column Name | A | ||||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A | ||||
BI Object Name EN | A | ||||
BI Object Type EN | A | ||||
BI Accountable Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG XREF BA And Column | 1..*:1..1 | Y | Y | ||||
IBG Business Intelligence Object | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Data Issue And BI Object | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a cross reference of business attributes, application systems, windows, and fields. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a cross reference of business attributes, application systems, windows, and fields. Notes FR: La définition est à déterminer |
Number Of Attributes | 15 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
9 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
10 | Application SW Window Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
11 | Application SW Field Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
12 | Application Software Nickname EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
13 | Data Issue BA Column And Application Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | Data Issue BA Column And Application Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
15 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
4 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
5 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
6 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
7 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
8 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
9 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
10 | Application SW Window Name EN | The English-language name for a window in an application system. A window is part of the presentation layer for an application and presents fields representing the data for business attributes. | |
11 | Application SW Field Name EN | The English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes. | |
12 | Application Software Nickname EN | The English-language acronym by which an application system or software product is commonly known. | |
13 | Data Issue BA Column And Application Notes EN | Any English-language notes appropriate to record for the data issue, business attribute, column, and application cross reference. | |
14 | Data Issue BA Column And Application Notes 2NDL | Any second-language notes appropriate to record for the data issue, business attribute, column, and application cross reference. | |
15 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG Business Attribute XREF Application and Column PK | Y | Data Issue ID | A | ||
Business Entity Name EN | A | ||||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A | ||||
Column Name | A | ||||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A | ||||
Application SW Window Name EN | A | ||||
Application SW Field Name EN | A | ||||
Application Software Nickname EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Column And Application | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a cross reference of business attributes to business intelligence (BI) objects, database management systems (DBMS), databases, schemas, tables or views, and columns. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a cross reference of business attributes to business intelligence (BI) objects, database management systems (DBMS), databases, schemas, tables or views, and columns. Notes FR: La définition est à déterminer |
Number Of Attributes | 15 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Data Issue ID | P | F | Y | Integer | DOM | Integer | 0 | ||
2 | Business Attribute Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Column Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
8 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
9 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
10 | BI Object Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
11 | BI Object Type EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
12 | BI Accountable Business Unit Acronym EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | BI Accountable Business Unit Acronym EN | |
13 | Data Issue BA Column And BI Object Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
14 | Data Issue BA Column And BI Object Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
15 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Data Issue ID | A meaningless but unique identifer for a data issue. | |
2 | Business Attribute Name EN | The English-language, business approved name for the business attribute. A business attribute is implented in one or more applications as a field in a window, as a column in reports and dashboards, and as a column in physical tables in databases. In general terms, the name of the business attribute should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
3 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
4 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
5 | Column Name | The name of a column in a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
6 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
7 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
8 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
9 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
10 | BI Object Name EN | The English-language name of a business intelliegnce (BI) object. | |
11 | BI Object Type EN | An English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report. | |
12 | BI Accountable Business Unit Acronym EN | The English-language acronym by which a business unit is commonly known. | |
13 | Data Issue BA Column And BI Object Notes EN | Any English-language notes appropriate to record for thedata issue, business attribute, column, and business intelligence object cross reference. | |
14 | Data Issue BA Column And BI Object Notes 2NDL | Any second-language notes appropriate to record for thedata issue, business attribute, column, and business intelligence object cross reference. | |
15 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG XREF Business Attribute And Business Intelligence Object PK | Y | Data Issue ID | A | ||
Business Entity Name EN | A | ||||
Subject Area Name EN | A | ||||
Business Attribute Name EN | A | ||||
Column Name | A | ||||
Table or View Name | A | ||||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A | ||||
BI Object Name EN | A | ||||
BI Object Type EN | A | ||||
BI Accountable Business Unit Acronym EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
DG Data Issue Register | 1..*:1..1 | Y | Y | ||||
IBG XREF BA Column And BI Object | 1..*:1..1 | Y | Y |
| Mapped Tables
|
Description | Comments EN: This entity/table contains a cross reference of business entities to database management systems (DBMS), databases, schemas, and tables or views. Comments FR: La définition est à déterminer |
Notes | Notes EN: This entity/table contains a cross reference of business entities to database management systems (DBMS), databases, schemas, and tables or views. Notes FR: La définition est à déterminer |
Number Of Attributes | 9 |
---|---|
Number Of Rows Min. | 0 |
Number Of Rows Max. | 9999999 |
Expected Number Of Rows | 0 |
Expected Growth | 0 |
Growth Interval | Year |
No | Attribute Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Preferred Abbreviation | Synonyms |
---|---|---|---|---|---|---|---|---|---|---|
1 | Business Entity Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
2 | Subject Area Name EN | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
3 | Table or View Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
4 | Schema Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
5 | Database Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
6 | DBMS Name | P | F | Y | CHAR (64 CHAR) | DOM | CHAR-064 | To Be Determined/ Être déterminé | ||
7 | Business Entity And Table View Notes EN | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
8 | Business Entity And Table View Notes 2NDL | Y | VARCHAR (8000 CHAR) | DOM | VARCHAR-8K | To be determined/ Être déterminé | ||||
9 | IBG Create Date Time | Y | Datetime | DOM | Create-Date-Time | GETDATE() |
No | Attribute Name | Description | Notes |
---|---|---|---|
1 | Business Entity Name EN | The English-language name of a business entity containing one or more business attributes. A business entity is implemented as one or more tables in databases. In general terms, the name of the business entity should be compliant with guidelines in "ISO/IEC 11179-5:2015 Naming and identification principles". | |
2 | Subject Area Name EN | The English-language name of the subject area in the Enterprise Data Model. In principle, "subject area" is a formal data architecture term, but is oberved informally in common use, such as "The subject of today's meeting is the data we need for Accounts Payable reporting." Note that the term "subject area" is sometimes synonomous with "data domain". | |
3 | Table or View Name | The name of a table or view in a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. A view is a representation of the columns selected from one or more tables. | |
4 | Schema Name | The name of a schema in a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
5 | Database Name | The name of a database in a database management system (DBMS). A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. | |
6 | DBMS Name | The name of a database management system (DBMS) in use in the organization. A DBMS is a software platform that contains databases, which contain schemas, which contain tables and views, which contain columns. Common DBMS software products include Oracle, SQL Server (from Microsoft), and DB2 (from IBM). | |
7 | Business Entity And Table View Notes EN | Any English-language notes appropriate to record for the business entity and table/view cross reference. | |
8 | Business Entity And Table View Notes 2NDL | Any second-language notes appropriate to record for the business entity and table/view cross reference. | |
9 | IBG Create Date Time | The date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary. |
Name | Primary Identifyer | Element Name | Element Type | Source Label | Target Label |
---|---|---|---|---|---|
IBG XREF Business Entity And Table Or View PK | Y | Table or View Name | A | ||
Schema Name | A | ||||
Database Name | A | ||||
DBMS Name | A | ||||
Business Entity Name EN | A | ||||
Subject Area Name EN | A |
Entity Name | Role | Other Role | In Arc | Cardinality | Dominant Role | Identifying | Transferable |
---|---|---|---|---|---|---|---|
IBG Table or View | 1..*:1..1 | Y | Y | ||||
IBG Business Entity | 1..*:1..1 | Y | Y |