All Entities Details

Design Name	IBG Oracle Data Model Diagram
Version Date	20.01.2024 01:10:39
Version Comment
Model Name	Logical

SubViews

SubView	Description	Notes	Object
Business Attribute - Core			Code Business Metadata Status Code Operational Reference Master Code Protected Level Code Sensitivity Level Code Yes No DG Person IBG Business Attribute Core IBG Business Attribute Document IBG Business Entity IBG Subject Area
Business Intelligence Object			Code BI Object Type Code Business Metadata Status Code Protected Level Code Sensitivity Level DG Business Unit DG RACI BI Object and Business Unit DG RACI BI Object and Person IBG Application Software IBG Business Intelligence Object IBG Lineage Application Column To BI Object IBG XREF BA And Column IBG XREF BA Column And BI Object IBG XREF BA Data Issue And BI Object
Code Tables			Code BI Object Type Code Business Metadata Status Code Business Unit Type Code Committee Code Committee Membership Role Code DQ Color Code DQ Dimension Code Data Governance Role Code Data Issue Category Code Data Issue Impact Code Data Issue Severity Code Data Issue Status Code Operational Reference Master Code Part Of Organization Code Protected Level Code RACI Code Sensitivity Level Code System Of Record Or Reference Code Yes No DG Business Unit IBG Application Software
Data Issue Register			Code Data Governance Role Code Data Issue Category Code Data Issue Impact Code Data Issue Severity Code Data Issue Status DG Business Unit DG Data Issue And Business Unit DG Data Issue And Person DG Data Issue Register DG Data Issue Status History DG Person
Data Quality			Code DQ Dimension DG Business Unit DG Data Issue Register DG Person IBG Application Software Field IBG Business Attribute Core IBG Business Attribute DQ Colors IBG Business Attribute DQ Rules IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Data Issue And Application
Governing Body Management			Code Committee Code Committee Membership Role DG Business Unit DG Committee Meeting Attendance DG Committee Meeting History DG Committee Membership DG Person
Lineage			Code System Of Record Or Reference IBG Column IBG ETL Program IBG Lineage Application Column To Application IBG Lineage Application Column To BI Object IBG XREF BA And Column IBG XREF BA Column And Application
Person and Business Unit			Code Business Unit Type Code Part Of Organization Code Yes No DG Business Unit DG Person
Physical Column			IBG Column IBG Database IBG Database Management System IBG Schema IBG Table or View
RACI - Applications And BI Objects			DG Data Issue And Business Unit DG Data Issue And Person DG Data Issue Register DG RACI Application Software And Business Unit DG RACI Application Software And Person DG RACI BI Object and Business Unit DG RACI BI Object and Person IBG Application Software IBG Application Software Field IBG Business Intelligence Object IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Column And BI Object IBG XREF BA Data Issue And Application IBG XREF BA Data Issue And BI Object
RACI - Business Attributes, Entities, Subject Areas			Code Operational Reference Master DG Data Issue Register DG RACI Business Attribute And Business Unit DG RACI Business Attribute And Person DG RACI Business Entity and Business Unit DG RACI Business Entity and Person DG RACI Subject Area And Business Unit DG RACI Subject Area And Person IBG Business Attribute Core IBG Business Entity IBG Subject Area IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Data Issue And Application IBG XREF BE And Table Or View
XREF - Business Attribute 360 - WKRP			IBG Application Software IBG Application Software Field IBG Business Attribute Core IBG Business Attribute DQ Colors IBG Business Attribute DQ Rules IBG Business Attribute Document IBG Business Entity IBG Business Intelligence Object IBG Column IBG Database IBG Database Management System IBG Schema IBG Subject Area IBG Table or View IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Column And BI Object
XREF - Business Attributes, Applications, and BI Objects			IBG Application Software IBG Application Software Field IBG Business Attribute Core IBG Business Intelligence Object IBG Column IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Column And BI Object
XREF - Business Entity And Table or View			IBG Business Entity IBG Table or View IBG XREF BE And Table Or View
XREF - Data Issue, Business Attribute, Application, and BI Object			DG Data Issue And Business Unit DG Data Issue And Person DG Data Issue Register DG XREF Data Issue In Other Tracker IBG Application Software Field IBG Business Intelligence Object IBG XREF BA And Column IBG XREF BA Column And Application IBG XREF BA Column And BI Object IBG XREF BA Data Issue And Application IBG XREF BA Data Issue And BI Object

Entity Name	Code BI Object Type
Preferred Abbreviation	Code BI Object Type
Classification Type Name
Object Type Name
Super Type
Synonyms	Code BI Object Type

Mapped Tables

Table Name

IBG_Physical_Model.Code BI Object Type

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	BI Object Type EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Business Intelligence Object				1..*:1..1		Y	Y

Entity Name	Code Business Metadata Status
Preferred Abbreviation	Code Business Metadata Status
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Business Metadata Status

Mapped Tables

Table Name

IBG_Physical_Model.Code Business Metadata Status

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Business Metadata Status Code EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	Code Business Unit Type
Preferred Abbreviation	Code Business Unit Type
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Business Unit Type

Mapped Tables

Table Name

IBG_Physical_Model.Code Business Unit Type

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Business Unit Type EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Business Unit				1..*:1..1			Y

Entity Name	Code Committee
Preferred Abbreviation	Code Committee
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Committee

Mapped Tables

Table Name

IBG_Physical_Model.Code Committee

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

Attributes

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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Committee Acronym EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	Code Committee Membership Role
Preferred Abbreviation	Code Committee Membership Role
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Committee Membership Role

Mapped Tables

Table Name

IBG_Physical_Model.Code Committee Membership Role

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Committee Membership Role Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Committee Membership				0..*:1..1		Y	Y

Entity Name	Code DQ Color
Preferred Abbreviation	Code DQ Color
Classification Type Name
Object Type Name
Super Type
Synonyms	Code DQ Color

Mapped Tables

Table Name

IBG_Physical_Model.Code DQ Color

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	DQ Color Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Business Attribute DQ Colors				1..*:1..1		Y	Y

Entity Name	Code DQ Dimension
Preferred Abbreviation	Code DQ Dimension
Classification Type Name
Object Type Name
Super Type
Synonyms	Code DQ Dimension

Mapped Tables

Table Name

IBG_Physical_Model.Code DQ Dimension

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	DQ Dimension Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Business Attribute DQ Rules				1..*:1..1			Y

Entity Name	Code Data Governance Role
Preferred Abbreviation	Code Data Governance Role
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Data Governance Role

Mapped Tables

Table Name

IBG_Physical_Model.Code Data Governance Role

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Data Governance Role Code EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	Code Data Issue Category
Preferred Abbreviation	Code Data Issue Category
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Data Issue Category

Mapped Tables

Table Name

IBG_Physical_Model.Code Data Issue Category

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Data Issue Category Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Data Issue Register				1..*:1..1			Y

Entity Name	Code Data Issue Impact
Preferred Abbreviation	Code Data Issue Impact
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Data Issue Impact

Mapped Tables

Table Name

IBG_Physical_Model.Code Data Issue Impact

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Data Issue Impact Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Data Issue And Business Unit				1..*:1..1		Y	Y

Entity Name	Code Data Issue Severity
Preferred Abbreviation	Code Data Issue Severity
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Data Issue Severity

Mapped Tables

Table Name

IBG_Physical_Model.Code Data Issue Severity

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Data Issue Severity Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Data Issue Register				1..*:1..1			Y

Entity Name	Code Data Issue Status
Preferred Abbreviation	Code Data Issue Status
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Data Issue Status

Mapped Tables

Table Name

IBG_Physical_Model.Code Data Issue Status

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Data Issue Status Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Data Issue Status History				1..*:1..1		Y	Y

Entity Name	Code Operational Reference Master
Preferred Abbreviation	Code Operational Reference Master
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Operational Reference Master

Mapped Tables

Table Name

IBG_Physical_Model.Code Operational Reference Master

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Operational Reference Master Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Business Attribute Core				1..*:1..1			Y

Entity Name	Code Part Of Organization
Preferred Abbreviation	Code Part Of Organization
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Part Of Organization

Mapped Tables

Table Name

IBG_Physical_Model.Code Part Of Organization

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Part Of Organization Code EN	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
DG Business Unit				1..*:1..1			Y

Entity Name	Code Protected Level
Preferred Abbreviation	Code Protected Level
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Protected Level

Mapped Tables

Table Name

IBG_Physical_Model.Code Protected Level

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Protected Level Code EN	A

Has Relationships With

Entity Name	Cardinality	Transferable
IBG Business Entity	1..*:1..1	Y
IBG Business Intelligence Object	1..*:1..1	Y
IBG Business Attribute Core	1..*:1..1	Y

Entity Name	Code RACI
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
Synonyms	Code RACI

Mapped Tables

Table Name

IBG_Physical_Model.Code RACI

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	RACI Code EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	Code Sensitivity Level
Preferred Abbreviation	Code Sensitivity Level
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Sensitivity Level

Mapped Tables

Table Name

IBG_Physical_Model.Code Sensitivity Level

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Sensitivity Level Code EN	A

Has Relationships With

Entity Name	Cardinality	Transferable
IBG Business Attribute Core	1..*:1..1	Y
IBG Business Entity	1..*:1..1	Y
IBG Business Intelligence Object	1..*:1..1	Y

Entity Name	Code System Of Record Or Reference
Preferred Abbreviation	Code System Of Record Or Reference
Classification Type Name
Object Type Name
Super Type
Synonyms	Code System Of Record Or Reference

Mapped Tables

Table Name

IBG_Physical_Model.Code System Of Record Or Reference

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

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG XREF BA Column And Application				1..*:1..1			Y

Entity Name	Code Yes No
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
Synonyms	Code Yes No

Mapped Tables

Table Name

IBG_Physical_Model.Code Yes No

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Yes No Code EN	A

Has Relationships With

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

Entity Name	DG Business Unit
Preferred Abbreviation	DG Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG Business Unit

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

Attributes

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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
Code BI Object Type PK	Y	Business Unit Acronym EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG Committee Meeting Attendance
Preferred Abbreviation	DG Committee Meeting Attendance
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Committee Meeting Attendance

Mapped Tables

Table Name

IBG_Physical_Model.DG Committee Meeting Attendance

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
DG Committee Meeting History PK	Y	Committee Acronym EN	A
		Committee Meeting Date	A
		Person Name	A

Has Relationships With

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

Entity Name	DG Committee Meeting History
Preferred Abbreviation	DG Committee Meeting History
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Committee Meeting History

Mapped Tables

Table Name

IBG_Physical_Model.DG Committee Meeting History

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

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

Entity Name	DG Committee Membership
Preferred Abbreviation	DG Committee Membership
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Committee Membership

Mapped Tables

Table Name

IBG_Physical_Model.DG Committee Membership

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
DG Committee Membership PK	Y	Committee Acronym EN	A
		Person Name	A
		Committee Membership Role Code EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG Data Issue And Business Unit
Preferred Abbreviation	DG Data Issue And Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Data Issue And Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG Data Issue And Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG Data Issue And Person
Preferred Abbreviation	DG Data Issue And Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Data Issue And Person

Mapped Tables

Table Name

IBG_Physical_Model.DG Data Issue And Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG Data Issue Register
Preferred Abbreviation	DG Data Issue Register
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Data Issue Register

Mapped Tables

Table Name

IBG_Physical_Model.DG Data Issue Register

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
DG Data Issue Register PK	Y	Data Issue ID	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG Data Issue Status History
Preferred Abbreviation	DG Data Issue Status History
Classification Type Name
Object Type Name
Super Type
Synonyms	DG Data Issue Status History

Mapped Tables

Table Name

IBG_Physical_Model.DG Data Issue Status History

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
DG Data Issue Status History PK	Y	Data Issue Status Code EN	A
		Data Issue ID	A
		Data Issue Status History Date	A

Has Relationships With

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

Entity Name	DG Person
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
Synonyms

Mapped Tables

Table Name

IBG_Physical_Model.DG Person

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

Attributes

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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
DG Person PK	Y	Person Name	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI Application Software And Business Unit
Preferred Abbreviation	DG RACI Application Software And Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Application Software And Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Application Software And Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	Identifying	Transferable
IBG Application Software	1..*:1..1	Y	Y
DG Business Unit	1..*:1..1	Y	Y
Code RACI	1..*:1..1		Y

Entity Name	DG RACI Application Software And Person
Preferred Abbreviation	DG RACI Application Software And Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Application Software And Person

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Application Software And Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI BI Object and Business Unit
Preferred Abbreviation	DG RACI BI Object and Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI BI Object and Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI BI Object and Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI BI Object and Person
Preferred Abbreviation	DG RACI BI Object and Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI BI Object and Person

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI BI Object and Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI Business Attribute And Business Unit
Preferred Abbreviation	DG RACI Business Attribute And Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Business Attribute And Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Business Attribute And Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI Business Attribute And Person
Preferred Abbreviation	DG RACI Business Attribute And Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Business Attribute And Person

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Business Attribute And Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI Business Entity and Business Unit
Preferred Abbreviation	DG RACI Business Entity and Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Business Entity and Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Business Entity and Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	Identifying	Transferable
IBG Business Entity	1..*:1..1	Y	Y
DG Business Unit	1..*:1..1	Y	Y
Code RACI	1..*:1..1		Y

Entity Name	DG RACI Business Entity and Person
Preferred Abbreviation	DG RACI Business Entity and Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Business Entity and Person

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Business Entity and Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
DG RACI Business Entity and Person PK	Y	Business Entity Name EN	A
		Subject Area Name EN	A
		RACI Person Name	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG RACI Subject Area And Business Unit
Preferred Abbreviation	DG RACI Subject Area And Business Unit
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Subject Area And Business Unit

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Subject Area And Business Unit

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	Identifying	Transferable
IBG Subject Area	1..*:1..1	Y	Y
DG Business Unit	1..*:1..1	Y	Y
Code RACI	1..*:1..1		Y

Entity Name	DG RACI Subject Area And Person
Preferred Abbreviation	DG RACI Subject Area And Person
Classification Type Name
Object Type Name
Super Type
Synonyms	DG RACI Subject Area And Person

Mapped Tables

Table Name

IBG_Physical_Model.DG RACI Subject Area And Person

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	DG XREF Data Issue In Other Tracker
Preferred Abbreviation	DG XREF Data Issue In Other Tracker
Classification Type Name
Object Type Name
Super Type
Synonyms	DG XREF Data Issue In Other Tracker

Mapped Tables

Table Name

IBG_Physical_Model.DG XREF Data Issue In Other Tracker

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

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

Entity Name	IBG Application Software
Preferred Abbreviation	IBG Application Software
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Application Software

Mapped Tables

Table Name

IBG_Physical_Model.IBG Application Software

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
IBG Application System PK	Y	Application Software Nickname EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Application Software Field
Preferred Abbreviation	IBG Application Software Field
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Application Software Field

Mapped Tables

Table Name

IBG_Physical_Model.IBG Application Software Field

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Application System Window Field PK	Y	Application SW Window Name EN	A
		Application SW Field Name EN	A
		Application Software Nickname EN	A

Has Relationships With

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

Entity Name	IBG Business Attribute Core
Preferred Abbreviation	IBG Business Attribute Core
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Attribute Core

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Attribute Core

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Business Attribute PK	Y	Business Entity Name EN	A
		Subject Area Name EN	A
		Business Attribute Name EN	A

Has Relationships With

Entity Name	Other Role	Cardinality	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

Entity Name	IBG Business Attribute DQ Colors
Preferred Abbreviation	IBG Business Attribute DQ Colors
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Attribute DQ Colors

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Attribute DQ Colors

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

Attributes

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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Business Attribute DQ Rules
Preferred Abbreviation	IBG Business Attribute DQ Rules
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Attribute DQ Rules

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Attribute DQ Rules

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

Attributes

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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
IBG Business Attribute DQ Rules PK	Y	DQ Rule Number SKEY	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Business Attribute Document
Preferred Abbreviation	IBG Business Attribute Document
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Attribute Document

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Attribute Document

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Business Attribute Core				1..*:1..1		Y	Y

Entity Name	IBG Business Entity
Preferred Abbreviation	IBG Business Entity
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Entity

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Entity

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Business Intelligence Object
Preferred Abbreviation	IBG Business Intelligence Object
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Business Intelligence Object

Mapped Tables

Table Name

IBG_Physical_Model.IBG Business Intelligence Object

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Business Intelligence Object PK	Y	BI Object Name EN	A
		BI Object Type EN	A
		BI Accountable Business Unit Acronym EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Column
Preferred Abbreviation	IBG Column
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Column

Mapped Tables

Table Name

IBG_Physical_Model.IBG Column

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Application System PK	Y	Column Name	A
		Table or View Name	A
		Schema Name	A
		Database Name	A
		DBMS Name	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Database
Preferred Abbreviation	IBG Database
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Database

Mapped Tables

Table Name

IBG_Physical_Model.IBG Database

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
IBG Application System PK	Y	Database Name	A
		DBMS Name	A

Has Relationships With

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

Entity Name	IBG Database Management System
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Database Management System

Mapped Tables

Table Name

IBG_Physical_Model.IBG Database Management System

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

Attributes

No	Attribute Name	PK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
IBG Application System PK	Y	DBMS Name	A

Has Relationships With

Entity Name	Role	Other Role	In Arc	Cardinality	Dominant Role	Identifying	Transferable
IBG Database				1..*:1..1		Y	Y

Entity Name	IBG ETL Program
Preferred Abbreviation	IBG ETL Program
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG ETL Program

Mapped Tables

Table Name

IBG_Physical_Model.IBG ETL Program

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Lineage Application Column To Application
Preferred Abbreviation	IBG Lineage Application Column To Application
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Lineage Application Column To Application

Mapped Tables

Table Name

IBG_Physical_Model.IBG Lineage Application Column To Application

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Lineage Application Column To BI Object
Preferred Abbreviation	IBG Lineage Application Column To BI Object
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Lineage Application Column To BI Object

Mapped Tables

Table Name

IBG_Physical_Model.IBG Lineage Application Column To BI Object

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Schema
Preferred Abbreviation	IBG Schema
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Schema

Mapped Tables

Table Name

IBG_Physical_Model.IBG Schema

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Application System PK	Y	Schema Name	A
		Database Name	A
		DBMS Name	A

Has Relationships With

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

Entity Name	IBG Subject Area
Preferred Abbreviation	IBG Subject Area
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Subject Area

Mapped Tables

Table Name

IBG_Physical_Model.IBG Subject Area

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type	Source Label	Target Label
IBG Subject Area PK	Y	Subject Area Name EN	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG Table or View
Preferred Abbreviation	IBG Table or View
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG Table or View

Mapped Tables

Table Name

IBG_Physical_Model.IBG Table or View

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
IBG Application System PK	Y	Table or View Name	A
		Schema Name	A
		Database Name	A
		DBMS Name	A

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG XREF BA And Column
Preferred Abbreviation	IBG XREF BA And Column
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BA And Column

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BA And Column

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG XREF BA Column And Application
Preferred Abbreviation	IBG XREF BA Column And Application
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BA Column And Application

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BA Column And Application

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG XREF BA Column And BI Object
Preferred Abbreviation	IBG XREF BA Column And BI Object
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BA Column And BI Object

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BA Column And BI Object

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

Entity Name	Cardinality	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

Entity Name	IBG XREF BA Data Issue And Application
Preferred Abbreviation	IBG XREF BA Data Issue And Application
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BA Data Issue And Application

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BA Data Issue And Application

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

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

Entity Name	IBG XREF BA Data Issue And BI Object
Preferred Abbreviation	IBG XREF BA Data Issue And BI Object
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BA Data Issue And BI Object

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BA Data Issue And BI Object

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Preferred Abbreviation
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

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

Entity Name	IBG XREF BE And Table Or View
Preferred Abbreviation	IBG XREF BE And Table Or View
Classification Type Name
Object Type Name
Super Type
Synonyms	IBG XREF BE And Table Or View

Mapped Tables

Table Name

IBG_Physical_Model.IBG XREF BE And Table Or View

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

Attributes

No	Attribute Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)
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()

Attributes Comments

No	Attribute Name	Description
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.

Identifiers

Name	Primary Identifyer	Element Name	Element Type
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

Has Relationships With

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

Business Attribute - Core

Business Intelligence Object

Code Tables

Data Issue Register

Data Quality

Governing Body Management

Lineage

Person and Business Unit

Physical Column

RACI - Applications And BI Objects

RACI - Business Attributes, Entities, Subject Areas

XREF - Business Attribute 360 - WKRP

XREF - Business Attributes, Applications, and BI Objects

XREF - Business Entity And Table or View

XREF - Data Issue, Business Attribute, Application, and BI Object