All Entities Details


Design NameIBG Oracle Data Model Diagram
Version Date20.01.2024 01:10:39
Version Comment
Model NameLogical

SubViews
SubViewDescriptionNotesObject
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 NameCode BI Object Type
Preferred AbbreviationCode BI Object Type
Classification Type Name
Object Type Name
Super Type
SynonymsCode BI Object Type
Mapped Tables
Table Name
IBG_Physical_Model.Code BI Object Type

DescriptionComments EN: This entity/table contains codes used to categorize Business Intelligence (BI) artifacts. Comments FR: La définition est à déterminer
NotesNotes EN: This entity/table contains codes used to categorize Business Intelligence (BI) artifacts. Notes FR: La définition est à déterminer

Number Of Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1BI Object Type ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2BI Object Type 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3BI Object Type Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4BI Object Type Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
2BI Object Type 2NDLA second-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
3BI Object Type Description ENAn English-language description of something.
4BI Object Type Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYBI Object Type ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Intelligence Object1..*:1..1YY

 

Entity NameCode Business Metadata Status
Preferred AbbreviationCode Business Metadata Status
Classification Type Name
Object Type Name
Super Type
SynonymsCode 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Metadata Status Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Business Metadata Status Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Business Metadata Status Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Business Metadata Status Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Metadata Status Code ENThe 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
2Business Metadata Status Code 2NDLThe 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
3Business Metadata Status Code Description ENAn English-language description of something.
4Business Metadata Status Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYBusiness Metadata Status Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Subject Area1..*:1..1Y
IBG Business Intelligence Object1..*:1..1Y
IBG Business Entity1..*:1..1Y
IBG Business Attribute Core1..*:1..1Y

 

Entity NameCode Business Unit Type
Preferred AbbreviationCode Business Unit Type
Classification Type Name
Object Type Name
Super Type
SynonymsCode Business Unit Type
Mapped Tables
Table Name
IBG_Physical_Model.Code Business Unit Type

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Unit Type ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Business Unit Type 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Business Unit Type Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Business Unit Type Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Unit Type ENAn 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
2Business Unit Type 2NDLA 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
3Business Unit Type Description ENAn English-language description of something.
4Business Unit Type Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYBusiness Unit Type ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Business Unit1..*:1..1Y

 

Entity NameCode Committee
Preferred AbbreviationCode Committee
Classification Type Name
Object Type Name
Super Type
SynonymsCode Committee
Mapped Tables
Table Name
IBG_Physical_Model.Code Committee

DescriptionComments 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
NotesNotes 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 Attributes12
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Committee Acronym ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Committee Acronym 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Committee Full Name ENYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Committee Full Name 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Parent Committee Acronym ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéParent Committee Acronym ENParent Business Unit Acronym EN
6Committee Terms Of Reference Hyperlink ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Committee Terms Of Reference Hyperlink 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Committee Meeting Minutes Folder Hyperlink ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9Committee Meeting Minutes Folder Hyperlink 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10Committee Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
11Committee Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
12IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Committee Acronym ENThe English-language acronym by which a committee is commonly known.
2Committee Acronym 2NDLThe second-language acronym by which a committee is commonly known.
3Committee Full Name ENThe English-language full name of a committee.
4Committee Full Name 2NDLThe second-language full name of a committee.
5Parent Committee Acronym ENThe English-language acronym by which a committee is commonly known.
6Committee Terms Of Reference Hyperlink ENA hyperlink to the English-language folder for the committee's terms of reference/mandate.
7Committee Terms Of Reference Hyperlink 2NDLA hyperlink to the second-language folder for the committee's terms of reference/mandate.
8Committee Meeting Minutes Folder Hyperlink ENA hyperlink to the English-language folder for the committee's meeting minutes.
9Committee Meeting Minutes Folder Hyperlink 2NDLA hyperlink to the second-language folder for the committee's meeting minutes.
10Committee Notes ENAny English-language notes appropriate to record.
11Committee Notes 2NDLAny second-language notes appropriate to record.
12IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYCommittee Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Committee Meeting History1..*:1..1YY
Code Committee1..*:1..1Y
DG Committee Membership0..*:1..1YY

 

Entity NameCode Committee Membership Role
Preferred AbbreviationCode Committee Membership Role
Classification Type Name
Object Type Name
Super Type
SynonymsCode Committee Membership Role
Mapped Tables
Table Name
IBG_Physical_Model.Code Committee Membership Role

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Committee Membership Role Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Committee Membership Role Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Committee Membership Role Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Committee Membership Role Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Committee Membership Role Code ENAn 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
2Committee Membership Role Code 2NDLA 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
3Committee Membership Role Code Description ENAn English-language description of something.
4Committee Membership Role Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYCommittee Membership Role Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Committee Membership0..*:1..1YY

 

Entity NameCode DQ Color
Preferred AbbreviationCode DQ Color
Classification Type Name
Object Type Name
Super Type
SynonymsCode DQ Color
Mapped Tables
Table Name
IBG_Physical_Model.Code DQ Color

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1DQ Color Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2DQ Color Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3DQ Color Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4DQ Color Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1DQ Color Code ENThe English-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute.
2DQ Color Code 2NDLThe second-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute.
3DQ Color Code Description ENAn English-language description of something.
4DQ Color Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYDQ Color Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute DQ Colors1..*:1..1YY

 

Entity NameCode DQ Dimension
Preferred AbbreviationCode DQ Dimension
Classification Type Name
Object Type Name
Super Type
SynonymsCode DQ Dimension
Mapped Tables
Table Name
IBG_Physical_Model.Code DQ Dimension

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1DQ Dimension Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2DQ Dimension Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3DQ Dimension Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4DQ Dimension Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1DQ Dimension Code ENThe English-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc.
2DQ Dimension Code 2NDLThe second-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc.
3DQ Dimension Code Description ENAn English-language description of something.
4DQ Dimension Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYDQ Dimension Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute DQ Rules1..*:1..1Y

 

Entity NameCode Data Governance Role
Preferred AbbreviationCode Data Governance Role
Classification Type Name
Object Type Name
Super Type
SynonymsCode Data Governance Role
Mapped Tables
Table Name
IBG_Physical_Model.Code Data Governance Role

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Governance Role Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Data Governance Role Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Data Governance Role Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Data Governance Role Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
2Data Governance Role Code 2NDLA second-language code for the roles that a person can have in the organization's data governance program.
3Data Governance Role Code Description ENAn English-language description of something.
4Data Governance Role Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYData Governance Role Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG RACI Application Software And Person1..*:1..1Y
DG Data Issue And Person1..*:1..1Y
DG RACI Business Attribute And Person1..*:1..1Y
DG RACI Business Entity and Person1..*:1..1Y
DG RACI BI Object and Person1..*:1..1Y
DG RACI Subject Area And Person1..*:1..1Y

 

Entity NameCode Data Issue Category
Preferred AbbreviationCode Data Issue Category
Classification Type Name
Object Type Name
Super Type
SynonymsCode Data Issue Category
Mapped Tables
Table Name
IBG_Physical_Model.Code Data Issue Category

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue Category Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Data Issue Category Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Data Issue Category Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Data Issue Category Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue Category Code ENAn English-language code used to categorize data issues.
2Data Issue Category Code 2NDLA second-language code used to categorize data issues.
3Data Issue Category Code Description ENAn English-language description of something.
4Data Issue Category Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYData Issue Category Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1Y

 

Entity NameCode Data Issue Impact
Preferred AbbreviationCode Data Issue Impact
Classification Type Name
Object Type Name
Super Type
SynonymsCode Data Issue Impact
Mapped Tables
Table Name
IBG_Physical_Model.Code Data Issue Impact

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue Impact Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Data Issue Impact Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Data Issue Impact Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Data Issue Impact Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue Impact Code ENAn 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
2Data Issue Impact Code 2NDLA 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
3Data Issue Impact Code Description ENAn English-language description of something.
4Data Issue Impact Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYData Issue Impact Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue And Business Unit1..*:1..1YY

 

Entity NameCode Data Issue Severity
Preferred AbbreviationCode Data Issue Severity
Classification Type Name
Object Type Name
Super Type
SynonymsCode Data Issue Severity
Mapped Tables
Table Name
IBG_Physical_Model.Code Data Issue Severity

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue Severity Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Data Issue Severity Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Data Issue Severity Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Data Issue Severity Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue Severity Code ENAn 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
2Data Issue Severity Code 2NDLA second-language code used to categorize the severity of data issues.
3Data Issue Severity Code Description ENAn English-language description of something.
4Data Issue Severity Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYData Issue Severity Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1Y

 

Entity NameCode Data Issue Status
Preferred AbbreviationCode Data Issue Status
Classification Type Name
Object Type Name
Super Type
SynonymsCode Data Issue Status
Mapped Tables
Table Name
IBG_Physical_Model.Code Data Issue Status

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue Status Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Data Issue Status Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Data Issue Status Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Data Issue Status Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue Status Code ENAn 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
2Data Issue Status Code 2NDLA 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
3Data Issue Status Code Description ENAn English-language description of something.
4Data Issue Status Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYData Issue Status Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Status History1..*:1..1YY

 

Entity NameCode Operational Reference Master
Preferred AbbreviationCode Operational Reference Master
Classification Type Name
Object Type Name
Super Type
SynonymsCode Operational Reference Master
Mapped Tables
Table Name
IBG_Physical_Model.Code Operational Reference Master

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Operational Reference Master Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Operational Reference Master Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Operational Reference Master Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Operational Reference Master Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Operational Reference Master Code ENAn English-language categorization of a piece of data as master data, reference data, or operational data.
2Operational Reference Master Code 2NDLAn second-language categorization of a piece of data as master data, reference data, or operational data.
3Operational Reference Master Code Description ENAn English-language description of something.
4Operational Reference Master Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYOperational Reference Master Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1Y

 

Entity NameCode Part Of Organization
Preferred AbbreviationCode Part Of Organization
Classification Type Name
Object Type Name
Super Type
SynonymsCode Part Of Organization
Mapped Tables
Table Name
IBG_Physical_Model.Code Part Of Organization

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Part Of Organization Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Part Of Organization Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Part Of Organization Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Part Of Organization Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Part Of Organization Code ENAn English-language code indicating which of the parts of the organization a given business unit belongs to.
2Part Of Organization Code 2NDLA second-language code indicating which of the parts of the organization a given business unit belongs to.
3Part Of Organization Code Description ENAn English-language description of something.
4Part Of Organization Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYPart Of Organization Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Business Unit1..*:1..1Y

 

Entity NameCode Protected Level
Preferred AbbreviationCode Protected Level
Classification Type Name
Object Type Name
Super Type
SynonymsCode Protected Level
Mapped Tables
Table Name
IBG_Physical_Model.Code Protected Level

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Protected Level Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Protected Level Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Protected Level Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Protected Level Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Protected Level Code ENAn 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
2Protected Level Code 2NDLA 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
3Protected Level Code Description ENAn English-language description of something.
4Protected Level Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYProtected Level Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Entity1..*:1..1Y
IBG Business Intelligence Object1..*:1..1Y
IBG Business Attribute Core1..*:1..1Y

 

Entity NameCode RACI
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
SynonymsCode RACI
Mapped Tables
Table Name
IBG_Physical_Model.Code RACI

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1RACI Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2RACI Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3RACI Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4RACI Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1RACI Code ENThe 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
2RACI Code 2NDLThe 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
3RACI Code Description ENAn English-language description of something.
4RACI Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYRACI Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG RACI Application Software And Person1..*:1..1Y
DG RACI Application Software And Business Unit1..*:1..1Y
DG RACI Business Attribute And Person1..*:1..1YY
DG RACI Business Attribute And Business Unit1..*:1..1YY
DG RACI Business Entity and Person1..*:1..1Y
DG RACI Business Entity and Business Unit1..*:1..1Y
DG RACI BI Object and Person1..*:1..1Y
DG RACI BI Object and Business Unit1..*:1..1Y
DG RACI Subject Area And Person1..*:1..1Y
DG RACI Subject Area And Business Unit1..*:1..1Y

 

Entity NameCode Sensitivity Level
Preferred AbbreviationCode Sensitivity Level
Classification Type Name
Object Type Name
Super Type
SynonymsCode Sensitivity Level
Mapped Tables
Table Name
IBG_Physical_Model.Code Sensitivity Level

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Sensitivity Level Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Sensitivity Level Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Sensitivity Level Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Sensitivity Level Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Sensitivity Level Code ENAn 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?"
2Sensitivity Level Code 2NDLA 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?"
3Sensitivity Level Code Description ENAn English-language description of something.
4Sensitivity Level Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYSensitivity Level Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1Y
IBG Business Entity1..*:1..1Y
IBG Business Intelligence Object1..*:1..1Y

 

Entity NameCode System Of Record Or Reference
Preferred AbbreviationCode System Of Record Or Reference
Classification Type Name
Object Type Name
Super Type
SynonymsCode System Of Record Or Reference
Mapped Tables
Table Name
IBG_Physical_Model.Code System Of Record Or Reference

DescriptionComments 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
NotesComments EN: This entity/table contains codes used to categorize an application system's relationship to a business attribute. With respect to a business attreibute, an applicaiton system can be considered to be a system of record or a system of reference. A system of record is where the organization has agreed that it contains the 'golden record of truth' for a business attribute. A system of reference contains a copy as of a point in time. By example, an organization's HR system would be considered the system of record for employee information, whereas a data warehouse would be considered a system of reference for employee information. Comments FR: La définition est à déterminer

Number Of Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1System Of Record Or Reference Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2System Of Record Or Reference Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3System Of Record Or Reference Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4System Of Record Or Reference Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1System Of Record Or Reference Code ENAn 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.
2System Of Record Or Reference Code 2NDLA 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.
3System Of Record Or Reference Code Description ENAn English-language description of something.
4System Of Record Or Reference Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYSystem Of Record Or Reference Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG XREF BA Column And Application1..*:1..1Y

 

Entity NameCode Yes No
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
SynonymsCode Yes No
Mapped Tables
Table Name
IBG_Physical_Model.Code Yes No

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Yes No Code ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Yes No Code 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Yes No Code Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Yes No Code Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Yes No Code ENAn English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available).
2Yes No Code 2NDLA second-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available).
3Yes No Code Description ENAn English-language description of something.
4Yes No Code Description 2NDLA second-language description of something.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYYes No Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute CorePersonally Identifiable Information Indicator1..*:1..1Y
DG Business Unit1..*:1..1Y

 

Entity NameDG Business Unit
Preferred AbbreviationDG Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG Business Unit

DescriptionComments 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
NotesNotes 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 Attributes13
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Unit Acronym ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Business Unit Acronym 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Business Unit Full Name ENYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Business Unit Full Name 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Parent Business Unit Acronym ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéParent Business Unit Acronym ENParent Business Unit Acronym EN
6Business Unit Hyperlink ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Business Unit Hyperlink 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Business Unit Type ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9Part Of Organization Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10Required In Data Gov Committees Indicator ENFYCHAR (64 CHAR) DOMCHAR-064TBDRequired In Data Gov Committees Indicator ENRequired In Data Gov Committees Code EN
11Business Unit Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
12Business Unit Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
13IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
2Business Unit Acronym 2NDLThe second-language acronym by which a business unit is commonly known.
3Business Unit Full Name ENThe English-language full name for a business unit.
4Business Unit Full Name 2NDLThe second-language full name for a business unit.
5Parent Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
6Business Unit Hyperlink ENA hyperlink to the English-language home page for a given business unit.
7Business Unit Hyperlink 2NDLA hyperlink to the second-language home page for a given business unit.
8Business Unit Type ENAn 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
9Part Of Organization Code ENAn English-language code indicating which of the parts of the organization a given business unit belongs to.
10Required In Data Gov Committees Indicator ENAn English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available).
11Business Unit Notes ENAny English-language notes appropriate to record.
12Business Unit Notes 2NDLAny second-language notes appropriate to record.
13IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
Code BI Object Type PKYBusiness Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG RACI Application Software And Business Unit1..*:1..1YY
DG Data Issue And Business Unit1..*:1..1YY
DG Business Unit1..*:1..1Y
Code Business Unit Type1..*:1..1Y
Code Part Of Organization1..*:1..1Y
Code Yes No1..*:1..1Y
DG Person1..*:1..1Y
IBG Business Attribute DQ Rules1..*:1..1Y
DG RACI Business Attribute And Business Unit1..*:1..1YY
DG RACI Business Entity and Business Unit1..*:1..1YY
IBG Business Intelligence Object1..*:1..1YY
DG RACI BI Object and Business Unit1..*:1..1YY
DG RACI Subject Area And Business Unit1..*:1..1YY

 

Entity NameDG Committee Meeting Attendance
Preferred AbbreviationDG Committee Meeting Attendance
Classification Type Name
Object Type Name
Super Type
SynonymsDG Committee Meeting Attendance
Mapped Tables
Table Name
IBG_Physical_Model.DG Committee Meeting Attendance

DescriptionComments EN: This entity/table contains committee attendance history. Comments FR: La définition est à déterminer
NotesNotes EN: This entity/table contains committee attendance history. Notes FR: La définition est à déterminer

Number Of Attributes6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Committee Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Committee Meeting DatePFYDateLT
3Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
4Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Committee Acronym ENThe English-language acronym by which a committee is commonly known.
2Committee Meeting DateThe date that a committee met.
3Person NameThe name of a person in the organization, or of a person of interest to the organization.
4Notes ENAny English-language notes appropriate to record.
5Notes 2NDLAny second-language notes appropriate to record.
6IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Committee Meeting History PKYCommittee Acronym ENA
Committee Meeting DateA
Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Committee Meeting History1..*:1..1YY
DG Person1..*:1..1YY

 

Entity NameDG Committee Meeting History
Preferred AbbreviationDG Committee Meeting History
Classification Type Name
Object Type Name
Super Type
SynonymsDG Committee Meeting History
Mapped Tables
Table Name
IBG_Physical_Model.DG Committee Meeting History

DescriptionComments 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
NotesNotes 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 Attributes7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Committee Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Committee Meeting DatePYDateLTGETDATE()
3Committee Meeting Minutes Hyperlink ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
4Committee Meeting Minutes Hyperlink 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Committee Acronym ENThe English-language acronym by which a committee is commonly known.
2Committee Meeting DateThe date that a committee met.
3Committee Meeting Minutes Hyperlink ENA hyperlink to the committee's English-language meeting minutes.
4Committee Meeting Minutes Hyperlink 2NDLA hyperlink to the committee's second-language meeting minutes.
5Notes ENAny English-language notes appropriate to record.
6Notes 2NDLAny second-language notes appropriate to record.
7IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Committee Meeting History PKYCommittee Acronym ENA
Committee Meeting DateA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
Code Committee1..*:1..1YY
DG Committee Meeting Attendance1..*:1..1YY

 

Entity NameDG Committee Membership
Preferred AbbreviationDG Committee Membership
Classification Type Name
Object Type Name
Super Type
SynonymsDG Committee Membership
Mapped Tables
Table Name
IBG_Physical_Model.DG Committee Membership

DescriptionThis entity/table contains the list of people and the committees for which they are members.
Notes

Number Of Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Committee Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
3Committee Membership Role Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Committee Membership Start DateYDateLT
5Committee Membership End DateYDateLT
6Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Committee Acronym ENThe English-language acronym by which a committee is commonly known.
2Person NameThe name of a person in the organization, or of a person of interest to the organization.
3Committee Membership Role Code ENAn 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
4Committee Membership Start DateThe start date for membership in a committee.
5Committee Membership End DateThe end date for membership in a committee.
6Notes ENAny English-language notes appropriate to record.
7Notes 2NDLAny second-language notes appropriate to record.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Committee Membership PKYCommittee Acronym ENA
Person NameA
Committee Membership Role Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
Code Committee0..*:1..1YY
DG Person0..*:1..1YY
Code Committee Membership Role0..*:1..1YY

 

Entity NameDG Data Issue And Business Unit
Preferred AbbreviationDG Data Issue And Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG Data Issue And Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG Data Issue And Business Unit

DescriptionComments 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
NotesNotes 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 Attributes7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Data Issue Impact Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Point Of Contact Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéPoint Of Contact Person Name
5Data Issue Impact Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Data Issue Impact Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Data Issue Impact Code ENAn 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
3Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
4Point Of Contact Person NameThe name of a person in the organization, or of a person of interest to the organization.
5Data Issue Impact Notes ENAny English-language notes appropriate to record for the data issue and its impact.
6Data Issue Impact Notes 2NDLAny second-language notes appropriate to record for the data issue and its impact.
7IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Data Issue Impact PKYData Issue IDA
Data Issue Impact Code ENA
Business Unit Acronym ENA
Point Of Contact Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1YY
Code Data Issue Impact1..*:1..1YY
DG Business Unit1..*:1..1YY
DG Person1..*:1..1YY

 

Entity NameDG Data Issue And Person
Preferred AbbreviationDG Data Issue And Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG Data Issue And Person
Mapped Tables
Table Name
IBG_Physical_Model.DG Data Issue And Person

DescriptionComments 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
NotesNotes 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 Attributes6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
3Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Data Issue And Person Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Data Issue And Person Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Person NameThe name of a person in the organization, or of a person of interest to the organization.
3Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
4Data Issue And Person Notes ENAny English-language notes appropriate to record for the data issue and a person associated with the issue.
5Data Issue And Person Notes 2NDLAny second-language notes appropriate to record for the data issue and a person associated with the issue.
6IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Data Issue And Person PKYData Issue IDA
Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1YY
DG Person1..*:1..1YY
Code Data Governance Role1..*:1..1Y

 

Entity NameDG Data Issue Register
Preferred AbbreviationDG Data Issue Register
Classification Type Name
Object Type Name
Super Type
SynonymsDG Data Issue Register
Mapped Tables
Table Name
IBG_Physical_Model.DG Data Issue Register

DescriptionComments 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
NotesNotes 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 Attributes12
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPYIntegerDOMInteger0
2Data Issue Title ENYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
3Data Issue Title 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Data Issue Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Data Issue Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Data Issue Documentation Folder HyperlinkYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Data Issue Category Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8Data Issue Severity Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9Data Issue Identification DateYDateLTGETDATE()
10Data Issue Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11Data Issue Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
12IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Data Issue Title ENThe English-language title of a data issue.
3Data Issue Title 2NDLThe second-language title of a data issue.
4Data Issue Description ENThe English-language description of a data issue.
5Data Issue Description 2NDLThe second-language description of a data issue.
6Data Issue Documentation Folder HyperlinkA hyperlink to a folder that contains any documention that is relevant to this issue.
7Data Issue Category Code ENAn English-language code used to categorize data issues.
8Data Issue Severity Code ENAn 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
9Data Issue Identification DateThe date that a data issue was identified.
10Data Issue Notes ENAny English-language notes appropriate to record for the data issue.
11Data Issue Notes 2NDLAny second-language notes appropriate to record for the data issue.
12IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Data Issue Register PKYData Issue IDA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
Code Data Issue Category1..*:1..1Y
Code Data Issue Severity1..*:1..1Y
DG Data Issue And Business Unit1..*:1..1YY
DG Data Issue And Person1..*:1..1YY
DG XREF Data Issue In Other Tracker1..*:1..1YY
DG Data Issue Status History1..*:1..1YY
IBG XREF BA Data Issue And BI Object1..*:1..1YY
IBG XREF BA Data Issue And Application1..*:1..1YY

 

Entity NameDG Data Issue Status History
Preferred AbbreviationDG Data Issue Status History
Classification Type Name
Object Type Name
Super Type
SynonymsDG Data Issue Status History
Mapped Tables
Table Name
IBG_Physical_Model.DG Data Issue Status History

DescriptionComments EN: This entity/table contains the lifecycle status history of data issues. Comments FR: La définition est à déterminer
NotesNotes EN: This entity/table contains the lifecycle status history of data issues. Notes FR: La définition est à déterminer

Number Of Attributes6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Data Issue Status Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Data Issue Status History DatePYDateLTGETDATE()
4Data Issue Status History Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KGETDATE()
5Data Issue Status History Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KGETDATE()
6IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Data Issue Status Code ENAn 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
3Data Issue Status History DateThe date of the status of a data issue.
4Data Issue Status History Notes ENAny English-language notes appropriate to record for the status of a data issue.
5Data Issue Status History Notes 2NDLAny second-language notes appropriate to record for the status of a data issue.
6IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Data Issue Status History PKYData Issue Status Code ENA
Data Issue IDA
Data Issue Status History DateA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
Code Data Issue Status1..*:1..1YY
DG Data Issue Register1..*:1..1YY

 

Entity NameDG Person
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
Synonyms
Mapped Tables
Table Name
IBG_Physical_Model.DG Person

DescriptionComments EN: This entity/table contains the list of people of interest to our organization. Comments FR: La définition est à déterminer
NotesComments EN: This entity/table contains the list of people of interest to our organization. Comments FR: La définition est à déterminer

Number Of Attributes9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Person NamePYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
2Reports To Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéReports To Person NameReports To Person Name
3Person Email AddressYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Job Title Role ENYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Job Title Role 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
6Business Unit Acronym ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Person Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Person Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Person NameThe name of a person in the organization, or of a person of interest to the organization.
2Reports To Person NameThe name of a person in the organization, or of a person of interest to the organization.
3Person Email AddressThe email address for a person.
4Job Title Role ENThe English-language job title or role of a person.
5Job Title Role 2NDLThe second-language job title or role of a person.
6Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
7Person Notes ENThe English-language notes for a person of interest.
8Person Notes 2NDLThe second-language notes for a person of interest.
9IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG Person PKYPerson NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG RACI Application Software And Person1..*:1..1YY
DG Data Issue And Person1..*:1..1YY
DG Data Issue And Business Unit1..*:1..1YY
DG Person1..*:1..1Y
DG Committee Meeting Attendance1..*:1..1YY
DG Committee Membership0..*:1..1YY
IBG Subject Area1..*:1..1Y
IBG Business Entity1..*:1..1Y
IBG Business Attribute Core1..*:1..1Y
DG Business Unit1..*:1..1Y
IBG Business Attribute DQ Rules1..*:1..1Y
IBG Business Attribute DQ Colors1..*:1..1Y
DG RACI Business Attribute And Person1..*:1..1YY
DG RACI Business Entity and Person1..*:1..1YY
DG RACI BI Object and Person1..*:1..1YY
DG RACI Subject Area And Person1..*:1..1YY

 

Entity NameDG RACI Application Software And Business Unit
Preferred AbbreviationDG RACI Application Software And Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Application Software And Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Application Software And Business Unit

DescriptionComments 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
NotesNotes 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 Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2RACI Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4RACI Start DateYDateLT0001-01-01
5RACI End DateYDateLT9999-12-31
6RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2RACI Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
3RACI Code ENThe 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
4RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
5RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
6RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
7RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Application Software And Business Unit PKYApplication Software Nickname ENA
RACI Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Application Software1..*:1..1YY
DG Business Unit1..*:1..1YY
Code RACI1..*:1..1Y

 

Entity NameDG RACI Application Software And Person
Preferred AbbreviationDG RACI Application Software And Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Application Software And Person
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Application Software And Person

DescriptionComments 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
NotesNotes 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 Attributes9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2RACI Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
3RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5RACI Start DateYDateLT0001-01-01
6RACI End DateYDateLT9999-12-31
7RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9IBG Create DateYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2RACI Person NameThe name of a person in the organization, or of a person of interest to the organization.
3RACI Code ENThe 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
4Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
5RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
6RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
7RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
8RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
9IBG Create DateThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Application Software And Person PKYApplication Software Nickname ENA
RACI Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Application Software1..*:1..1YY
DG Person1..*:1..1YY
Code RACI1..*:1..1Y
Code Data Governance Role1..*:1..1Y

 

Entity NameDG RACI BI Object and Business Unit
Preferred AbbreviationDG RACI BI Object and Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI BI Object and Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI BI Object and Business Unit

DescriptionComments 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
NotesNotes 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 Attributes10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1BI Object Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Accountable Business Unit Acronym EN
4RACI Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéRACI Business Unit Acronym EN
5RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6RACI Start DateYDateLT0001-01-01
7RACI End DateYDateLT9999-12-31
8RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10IBG Create Date TimeYDatetimeDOMCreate-Date-TimeSYSDATE

Attributes Comments
NoAttribute NameDescriptionNotes
1BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
2BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
3BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
4RACI Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
5RACI Code ENThe 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
6RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
7RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
8RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
9RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
10IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Intelligence Object and Business Unit PKYBI Object Name ENA
BI Object Type ENA
BI Accountable Business Unit Acronym ENA
RACI Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Intelligence Object1..*:1..1YY
DG Business Unit1..*:1..1YY
Code RACI1..*:1..1Y

 

Entity NameDG RACI BI Object and Person
Preferred AbbreviationDG RACI BI Object and Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI BI Object and Person
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI BI Object and Person

DescriptionComments 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
NotesNotes 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 Attributes11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1BI Object Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Accountable Business Unit Acronym EN
4RACI Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéRACI Person Name
5RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7RACI Start DateYDateLT0001-01-01
8RACI End DateYDateLT9999-12-31
9RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11IBG Create DateYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
2BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
3BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
4RACI Person NameThe name of a person in the organization, or of a person of interest to the organization.
5RACI Code ENThe 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
6Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
7RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
8RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
9RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
10RACI Notes 2NDLAny second-language notes appropriate to record for RACI relationship.
11IBG Create DateThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Intelligence Object and Person PKYBI Object Name ENA
BI Object Type ENA
BI Accountable Business Unit Acronym ENA
RACI Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Intelligence Object1..*:1..1YY
DG Person1..*:1..1YY
Code RACI1..*:1..1Y
Code Data Governance Role1..*:1..1Y

 

Entity NameDG RACI Business Attribute And Business Unit
Preferred AbbreviationDG RACI Business Attribute And Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Business Attribute And Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Business Attribute And Business Unit

DescriptionComments 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
NotesNotes 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 Attributes10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4RACI Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5RACI Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6RACI Start DateYDateLT0001-01-01
7RACI End DateYDateLT9999-12-31
8RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4RACI Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
5RACI Code ENThe 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
6RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
7RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
8RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
9RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
10IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Attribute And Business Unit PKYBusiness Attribute Name ENA
Business Entity Name ENA
Subject Area Name ENA
RACI Business Unit Acronym ENA
RACI Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1YY
DG Business Unit1..*:1..1YY
Code RACI1..*:1..1YY

 

Entity NameDG RACI Business Attribute And Person
Preferred AbbreviationDG RACI Business Attribute And Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Business Attribute And Person
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Business Attribute And Person

DescriptionComments 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
NotesNotes 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 Attributes11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4RACI Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
5RACI Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7RACI Start DateYDateLT0001-01-01
8RACI End DateYDateLT9999-12-31
9RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11IBG Create DateYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4RACI Person NameThe name of a person in the organization, or of a person of interest to the organization.
5RACI Code ENThe 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
6Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
7RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
8RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
9RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
10RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
11IBG Create DateThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Attribute And Person PKYBusiness Attribute Name ENA
Business Entity Name ENA
Subject Area Name ENA
RACI Person NameA
RACI Code ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1YY
DG Person1..*:1..1YY
Code RACI1..*:1..1YY
Code Data Governance Role1..*:1..1Y

 

Entity NameDG RACI Business Entity and Business Unit
Preferred AbbreviationDG RACI Business Entity and Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Business Entity and Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Business Entity and Business Unit

DescriptionComments 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
NotesNotes 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 Attributes9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3RACI Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5RACI Start DateYDateLT0001-01-01
6RACI End DateYDateLT9999-12-31
7RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Entity Name ENThe 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".
2Subject Area Name ENThe 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".
3RACI Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
4RACI Code ENThe 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
5RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
6RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
7RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
8RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
9IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Entity and Business Unit PKYBusiness Entity Name ENA
Subject Area Name ENA
RACI Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Entity1..*:1..1YY
DG Business Unit1..*:1..1YY
Code RACI1..*:1..1Y

 

Entity NameDG RACI Business Entity and Person
Preferred AbbreviationDG RACI Business Entity and Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Business Entity and Person
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Business Entity and Person

DescriptionComments 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
NotesNotes 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 Attributes10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3RACI Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminé
4RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6RACI Start DateYDateLT0001-01-01
7RACI End DateYDateLT9999-12-31
8RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10IBG Create DateYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Entity Name ENThe 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".
2Subject Area Name ENThe 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".
3RACI Person NameThe name of a person in the organization, or of a person of interest to the organization.
4RACI Code ENThe 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
5Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
6RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
7RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
8RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
9RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
10IBG Create DateThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Business Entity and Person PKYBusiness Entity Name ENA
Subject Area Name ENA
RACI Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Entity1..*:1..1YY
DG Person1..*:1..1YY
Code RACI1..*:1..1Y
Code Data Governance Role1..*:1..1Y

 

Entity NameDG RACI Subject Area And Business Unit
Preferred AbbreviationDG RACI Subject Area And Business Unit
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Subject Area And Business Unit
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Subject Area And Business Unit

DescriptionComments 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
NotesNotes 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 Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2RACI Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéRACI Business Unit Acronym EN
3RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4RACI Start DateYDateLT0001-01-01
5RACI End DateYDateLT9999-12-31
6RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Subject Area Name ENThe 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".
2RACI Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
3RACI Code ENThe 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
4RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
5RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
6RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
7RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Subject Area And Business Unit PKYSubject Area Name ENA
RACI Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Subject Area1..*:1..1YY
DG Business Unit1..*:1..1YY
Code RACI1..*:1..1Y

 

Entity NameDG RACI Subject Area And Person
Preferred AbbreviationDG RACI Subject Area And Person
Classification Type Name
Object Type Name
Super Type
SynonymsDG RACI Subject Area And Person
Mapped Tables
Table Name
IBG_Physical_Model.DG RACI Subject Area And Person

DescriptionComments 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
NotesNotes 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 Attributes9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2RACI Person NamePFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéRACI Person Name
3RACI Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Data Governance Role Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5RACI Start DateYDateLT0001-01-01
6RACI End DateYDateLT9999-12-31
7RACI Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8RACI Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9IBG Create Date TimeYDatetimeDOMCreate-Date-TimeSYSDATE

Attributes Comments
NoAttribute NameDescriptionNotes
1Subject Area Name ENThe 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".
2RACI Person NameThe name of a person in the organization, or of a person of interest to the organization.
3RACI Code ENThe 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
4Data Governance Role Code ENAn English-language code for the roles that a person can have in the organization's data governance program.
5RACI Start DateThe date that a RACI-based relationship between a person or business unit and an information asset began.
6RACI End DateThe date that a RACI-based relationship between a person or business unit and an information asset ended.
7RACI Notes ENAny English-language notes appropriate to record for a RACI relationship.
8RACI Notes 2NDLAny second-language notes appropriate to record for a RACI relationship.
9IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG RACI Subject Area And Person PKYSubject Area Name ENA
RACI Person NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Subject Area1..*:1..1YY
DG Person1..*:1..1YY
Code RACI1..*:1..1Y
Code Data Governance Role1..*:1..1Y

 

Entity NameDG XREF Data Issue In Other Tracker
Preferred AbbreviationDG XREF Data Issue In Other Tracker
Classification Type Name
Object Type Name
Super Type
SynonymsDG XREF Data Issue In Other Tracker
Mapped Tables
Table Name
IBG_Physical_Model.DG XREF Data Issue In Other Tracker

DescriptionComments 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
NotesNotes 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 Attributes7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Issue Tracking Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Data Issue ID In Other Issue Tracking ApplicationPYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Data Issue Hyperlink In Other Issue Tracking ApplicationYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Data Issue XREF Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Data Issue XREF Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Issue Tracking Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
3Data Issue ID In Other Issue Tracking ApplicationThe identifier for a data issue that has been identified in another issue tracking software application in our organization.
4Data Issue Hyperlink In Other Issue Tracking ApplicationA hyperlink to a data issue in another issue tracking application in the organization.
5Data Issue XREF Notes ENAny English-language notes appropriate to record for the cross reference of this data issue to something.
6Data Issue XREF Notes 2NDLAny second-language notes appropriate to record for the cross reference of this data issue to something.
7IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
DG XREF Data Issue In Other Defect Tracking System PKYData Issue IDA
Issue Tracking Application Software Nickname ENA
Data Issue ID In Other Issue Tracking ApplicationA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1YY
IBG Application Software1..*:1..1YY

 

Entity NameIBG Application Software
Preferred AbbreviationIBG Application Software
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Application Software
Mapped Tables
Table Name
IBG_Physical_Model.IBG Application Software

DescriptionComments 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
NotesNotes 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 Attributes11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Application Software Nickname ENPYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Application Software Nickname 2NDLYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Application Software Full Name ENYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
4Application Software Full Name 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Application Software Vendor NameYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
6Application Software HyperlinkYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Application Software Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Application Software Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9Application Software Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10Application Software Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2Application Software Nickname 2NDLThe second-language acronym by which an application system or software product is commonly known.
3Application Software Full Name ENThe English-language full name for an application system or software product.
4Application Software Full Name 2NDLThe second-language full name for an application system or software product.
5Application Software Vendor NameA free-form text field containing the name of the vendor from whom an application system or software product was purchased.
6Application Software HyperlinkA hyperlink to the home page, in our organization, for the application system or software product.
7Application Software Description ENAn English-language description of something.
8Application Software Description 2NDLA second-language description of something.
9Application Software Notes ENAny English-language notes appropriate to record.
10Application Software Notes 2NDLAny second-language notes appropriate to record.
11IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYApplication Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG ETL Program1..*:1..1YY
DG RACI Application Software And Person1..*:1..1YY
DG RACI Application Software And Business Unit1..*:1..1YY
DG XREF Data Issue In Other Tracker1..*:1..1YY
IBG Lineage Application Column To BI Object1..*:1..1YY
IBG Application Software Field1..*:1..1YY
IBG Lineage Application Column To Application1..*:1..1YY
IBG Lineage Application Column To Application1..*:1..1YY
IBG Business Intelligence Object1..*:1..1Y

 

Entity NameIBG Application Software Field
Preferred AbbreviationIBG Application Software Field
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Application Software Field
Mapped Tables
Table Name
IBG_Physical_Model.IBG Application Software Field

DescriptionComments 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
NotesNotes 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 Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Application SW Window Name ENPYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Application SW Field Name ENPYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Application SW Window Name 2NDLYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Application SW Field Name 2NDLYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2Application SW Window Name ENThe 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.
3Application SW Field Name ENThe English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes.
4Application SW Window Name 2NDLThe 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.
5Application SW Field Name 2NDLThe second-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes.
6Notes ENAny English-language notes appropriate to record.
7Notes 2NDLAny second-language notes appropriate to record.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System Window Field PKYApplication SW Window Name ENA
Application SW Field Name ENA
Application Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Application Software1..*:1..1YY
IBG XREF BA Column And Application1..*:1..1YY

 

Entity NameIBG Business Attribute Core
Preferred AbbreviationIBG Business Attribute Core
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Attribute Core
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Attribute Core

DescriptionComments 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
NotesNotes 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 Attributes32
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
4Business Attribute Name 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
5Business Attribute Definition ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
6Business Attribute Definition 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
7Business Metadata Status Code ENFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
8Business Metadata Approved By Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéBusiness Metadata Approved By Person Name
9Business Metadata Approved DateYDateLT9999-12-31
10Default Value ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
11Default Value 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
12Data Entry Guidelines ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
13Data Entry Guidelines 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
14Derivation Rule ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
15Derivation Rule 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
16Usage Guidelines ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
17Usage Guidelines 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
18Mosaic Caution ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
19Mosaic Caution 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
20Masking Rule ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
21Masking Rule 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
22Archive Rule ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
23Archive Rule 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
24Purge Rule ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
25Purge Rule 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
26Operational Reference Master Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
27Protected Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
28Sensitivity Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
29Personally Identifiable Information Indicator ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéPersonally Identifiable Information Indicator EN
30Business Attribute Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
31Business Attribute Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
32IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4Business Attribute Name 2NDLThe 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".
5Business Attribute Definition ENAn 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".
6Business Attribute Definition 2NDLA 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".
7Business Metadata Status Code ENThe 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
8Business Metadata Approved By Person NameThe name of a person in the organization, or of a person of interest to the organization.
9Business Metadata Approved DateThe date that business metadata was approved.
10Default Value ENAn English-language business rule containing the value to be used when the actual value for a business attribute is unknown.
11Default Value 2NDLA second-language business rule containing the value to be used when the actual value for a business attribute is unknown.
12Data Entry Guidelines ENAn 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.
13Data Entry Guidelines 2NDLA 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.
14Derivation Rule ENAn 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."
15Derivation Rule 2NDLA 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."
16Usage Guidelines ENAn 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."
17Usage Guidelines 2NDLA 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."
18Mosaic Caution ENAn 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.
19Mosaic Caution 2NDLA 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.
20Masking Rule ENAn 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.
21Masking Rule 2NDLA 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.
22Archive Rule ENAn 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.
23Archive Rule 2NDLA 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.
24Purge Rule ENAn 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.
25Purge Rule 2NDLA 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.
26Operational Reference Master Code ENAn English-language categorization of a piece of data as master data, reference data, or operational data.
27Protected Level Code ENAn 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
28Sensitivity Level Code ENAn 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?"
29Personally Identifiable Information Indicator ENAn English-language code for Yes, No, To Be Determined/ Être déterminé, and N/A (Not Applicable or Not Available).
30Business Attribute Notes ENAny English-language notes appropriate to record.
31Business Attribute Notes 2NDLAny second-language notes appropriate to record.
32IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Attribute PKYBusiness Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Entity1..*:1..1YY
Code Sensitivity Level1..*:1..1Y
Code Yes NoPersonally Identifiable Information Indicator1..*:1..1Y
IBG XREF BA And Column1..*:1..1YY
DG Person1..*:1..1Y
Code Operational Reference Master1..*:1..1Y
IBG Business Attribute DQ Rules1..*:1..1Y
IBG Business Attribute Document1..*:1..1YY
DG RACI Business Attribute And Person1..*:1..1YY
DG RACI Business Attribute And Business Unit1..*:1..1YY
Code Business Metadata Status1..*:1..1Y
Code Protected Level1..*:1..1Y

 

Entity NameIBG Business Attribute DQ Colors
Preferred AbbreviationIBG Business Attribute DQ Colors
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Attribute DQ Colors
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Attribute DQ Colors

DescriptionComments 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
NotesNotes 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 Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1DQ Rule Number SKEYPFYIntegerDOMInteger0
2DQ Color Code ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3DQ Color Low Range PercentageYIntegerDOMInteger0
4DQ Color High Range PercentageYIntegerDOMInteger0
5DQ Color Range Approved By Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéDQ Color Range Approved By Person NameDQ Color Range Approved By Person Name
6DQ Color Range Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7DQ Color Range Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1DQ Rule Number SKEYA meaningless but unique surrogate key identifying a data quality dimension rule for a given business attribute.
2DQ Color Code ENThe English-language name for a color. Colors are used to provide a visual appreciation of the relative quality of data for a business attribute.
3DQ Color Low Range PercentageThe 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.
4DQ Color High Range PercentageThe 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.
5DQ Color Range Approved By Person NameThe name of a person in the organization, or of a person of interest to the organization.
6DQ Color Range Notes ENAny English-language notes appropriate to record.
7DQ Color Range Notes 2NDLAny second-language notes appropriate to record.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Attribute DQ Color Ranges PKYDQ Color Code ENA
DQ Rule Number SKEYA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute DQ Rules1..*:1..1YY
Code DQ Color1..*:1..1YY
DG Person1..*:1..1Y

 

Entity NameIBG Business Attribute DQ Rules
Preferred AbbreviationIBG Business Attribute DQ Rules
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Attribute DQ Rules
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Attribute DQ Rules

DescriptionComments 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
NotesNotes 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 Attributes12
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1DQ Rule Number SKEYPYIntegerDOMInteger0
2DQ Dimension Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Business Attribute Name ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Business Entity Name ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Subject Area Name ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6DQ Rule Owner Business Unit Acronym ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéDQ Rule Owner Business Unit Acronym EN
7DQ Rule Criteria Text ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8DQ Rule Criteria Text 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9DQ Rule Approved By Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéDQ Rule Approved By Person NameDQ Dimension Criteria Approved By Person Name
10DQ Rule Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11DQ Rule Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
12IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1DQ Rule Number SKEYA meaningless but unique surrogate key identifying a data quality dimension rule for a given business attribute.
2DQ Dimension Code ENThe English-language code for criteria (i.e. dimension) against which the data for business attributes can be measured. Examples include Accuracy, Consistency, Completeness, etc.
3Business Attribute Name ENThe 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".
4Business Entity Name ENThe 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".
5Subject Area Name ENThe 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".
6DQ Rule Owner Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
7DQ Rule Criteria Text ENThe English-language criteria used to assess a given data quality dimension against the data for a business attribute.
8DQ Rule Criteria Text 2NDLThe second-language criteria used to assess a given data quality dimension against the data for a business attribute.
9DQ Rule Approved By Person NameThe name of a person in the organization, or of a person of interest to the organization.
10DQ Rule Notes ENAny English-language notes appropriate to record for the business attribute and a DQ dimension.
11DQ Rule Notes 2NDLAny second-language notes appropriate to record for the business attribute and a DQ dimension.
12IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Attribute DQ Rules PKYDQ Rule Number SKEYA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute DQ Colors1..*:1..1YY
IBG Business Attribute Core1..*:1..1Y
Code DQ Dimension1..*:1..1Y
DG Person1..*:1..1Y
DG Business Unit1..*:1..1Y

 

Entity NameIBG Business Attribute Document
Preferred AbbreviationIBG Business Attribute Document
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Attribute Document
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Attribute Document

DescriptionComments 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
NotesNotes 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 Attributes10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Document Name ENPYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Document Name 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
6Document Hyperlink ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Document Hyperlink 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Business Attribute Document Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9Business Attribute Document Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4Document Name ENThe English-language name of a document.
5Document Name 2NDLThe second-language name of a document.
6Document Hyperlink ENA hyperlink to to the English-language document.
7Document Hyperlink 2NDLA hyperlink to to the second-language document.
8Business Attribute Document Notes ENAny English-language notes appropriate to record.
9Business Attribute Document Notes 2NDLAny second-language notes appropriate to record.
10IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Attribute Document PKYBusiness Attribute Name ENA
Business Entity Name ENA
Subject Area Name ENA
Document Name ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1YY

 

Entity NameIBG Business Entity
Preferred AbbreviationIBG Business Entity
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Entity
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Entity

DescriptionComments 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
NotesNotes 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 Attributes13
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Entity Name ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Business Entity Name 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
4Business Entity Definition ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5Business Entity Definition 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
6Business Metadata Status Code ENFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
7Business Metadata Approved By Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéBusiness Metadata Approved By Person Name
8Business Metadata Approved DateYDateLT9999-12-31
9Sensitivity Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10Protected Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11Business Entity Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
12Business Entity Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
13IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Entity Name ENThe 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".
2Subject Area Name ENThe 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".
3Business Entity Name 2NDLThe 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".
4Business Entity Definition ENAn English-language defintion of something.
5Business Entity Definition 2NDLA second-language definition of something.
6Business Metadata Status Code ENThe 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
7Business Metadata Approved By Person NameThe name of a person in the organization, or of a person of interest to the organization.
8Business Metadata Approved DateThe date that business metadata was approved.
9Sensitivity Level Code ENAn 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?"
10Protected Level Code ENAn 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
11Business Entity Notes ENAny English-language notes associated with a given Business Entity.
12Business Entity Notes 2NDLAny second-language notes associated with a given Business Entity.
13IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Subject Area PKYBusiness Entity Name ENA
Subject Area Name ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1YY
Code Sensitivity Level1..*:1..1Y
Code Protected Level1..*:1..1Y
IBG XREF BE And Table Or View1..*:1..1YY
DG Person1..*:1..1Y
Code Business Metadata Status1..*:1..1Y
IBG Subject Area1..*:1..1YY
DG RACI Business Entity and Person1..*:1..1YY
DG RACI Business Entity and Business Unit1..*:1..1YY

 

Entity NameIBG Business Intelligence Object
Preferred AbbreviationIBG Business Intelligence Object
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Business Intelligence Object
Mapped Tables
Table Name
IBG_Physical_Model.IBG Business Intelligence Object

DescriptionComments EN: This entity/table contains information regarding business intelligence (BI) objects that exist in our organization. Comments FR: La définition est à déterminer
NotesNotes 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 Attributes14
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1BI Object Name ENPYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Accountable Business Unit Acronym EN
4BI Object Name 2NDLYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
5Business Metadata Status Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6BI Application Software Nickname ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Application Software Nickname EN
7BI HyperlinkYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8BI Object Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9BI Object Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10Protected Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11Sensitivity Level Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
12Business Intelligence Object Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
13Business Intelligence Object Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
2BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
3BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
4BI Object Name 2NDLThe second-language name of a business intelliegnce (BI) object.
5Business Metadata Status Code ENThe 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
6BI Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
7BI HyperlinkA hyperlink to the home page in our organization for a given BI object.
8BI Object Description ENAn English-language description of something.
9BI Object Description 2NDLA second-language description of something.
10Protected Level Code ENAn 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
11Sensitivity Level Code ENAn 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?"
12Business Intelligence Object Notes ENAny English-language notes appropriate to record for a given business intelligence object.
13Business Intelligence Object Notes 2NDLAny second-language notes appropriate to record for a given business intelligence object.
14IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Intelligence Object PKYBI Object Name ENA
BI Object Type ENA
BI Accountable Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Lineage Application Column To BI Object1..*:1..1YY
Code Protected Level1..*:1..1Y
Code Sensitivity Level1..*:1..1Y
Code Business Metadata Status1..*:1..1Y
IBG XREF BA Column And BI Object1..*:1..1YY
Code BI Object Type1..*:1..1YY
DG Business Unit1..*:1..1YY
IBG Application Software1..*:1..1Y
DG RACI BI Object and Person1..*:1..1YY
DG RACI BI Object and Business Unit1..*:1..1YY

 

Entity NameIBG Column
Preferred AbbreviationIBG Column
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Column
Mapped Tables
Table Name
IBG_Physical_Model.IBG Column

DescriptionComments 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
NotesNotes 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 Attributes8
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Column NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Column NameThe 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.
2Table or View NameThe 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.
3Schema NameThe 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.
4Database 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.
5DBMS NameThe 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).
6Notes ENAny English-language notes appropriate to record.
7Notes 2NDLAny second-language notes appropriate to record.
8IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYColumn NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG XREF BA And Column1..*:1..1YY
IBG Lineage Application Column To BI Object1..*:1..1YY
IBG Lineage Application Column To Application1..*:1..1YY
IBG Lineage Application Column To Application1..*:1..1YY
IBG Table or View1..*:1..1YY

 

Entity NameIBG Database
Preferred AbbreviationIBG Database
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Database
Mapped Tables
Table Name
IBG_Physical_Model.IBG Database

DescriptionComments 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
NotesNotes 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 Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Database NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
4Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Database 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.
2DBMS NameThe 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).
3Notes ENAny English-language notes appropriate to record.
4Notes 2NDLAny second-language notes appropriate to record.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYDatabase NameA
DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Database Management System1..*:1..1YY
IBG Schema1..*:1..1YY

 

Entity NameIBG Database Management System
Preferred Abbreviation
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Database Management System
Mapped Tables
Table Name
IBG_Physical_Model.IBG Database Management System

DescriptionComments EN: This entity/table contains the list of database management systems (DBMS) of interest. Comments FR: La définition est à déterminer
NotesNotes EN: This entity/table contains the list of database management systems (DBMS) of interest. Notes FR: La définition est à déterminer

Number Of Attributes5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1DBMS NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2DBMS Vendor NameYCHAR (256 CHAR) DOMCHAR-256To Be Determined/ Être déterminé
3Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
4Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1DBMS NameThe 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).
2DBMS Vendor NameA free-form text field containing the name of the vendor from whom the DBMS was purchased.
3Notes ENAny English-language notes appropriate to record.
4Notes 2NDLAny second-language notes appropriate to record.
5IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYDBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Database1..*:1..1YY

 

Entity NameIBG ETL Program
Preferred AbbreviationIBG ETL Program
Classification Type Name
Object Type Name
Super Type
SynonymsIBG ETL Program
Mapped Tables
Table Name
IBG_Physical_Model.IBG ETL Program

DescriptionComments 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
NotesNotes 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 Attributes7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1ETL Program NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2ETL Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéETL Application Software Nickname EN
3Description ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
4Description 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1ETL Program NameThe 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.
2ETL Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
3Description ENAn English-language description of something.
4Description 2NDLA second-language description of something.
5Notes ENAny English-language notes appropriate to record.
6Notes 2NDLAny second-language notes appropriate to record.
7IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG ETL Program PKYETL Program NameA
ETL Application Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Application Software1..*:1..1YY
IBG Lineage Application Column To BI Object1..*:1..1YY
IBG Lineage Application Column To Application1..*:1..1YY

 

Entity NameIBG Lineage Application Column To Application
Preferred AbbreviationIBG Lineage Application Column To Application
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Lineage Application Column To Application
Mapped Tables
Table Name
IBG_Physical_Model.IBG Lineage Application Column To Application

DescriptionThis 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 Attributes17
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Source Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Application Software Nickname EN
2Source Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Column Name
3Source Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Table or View Name
4Source Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Schema Name
5Source Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Database Name
6Source DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource DBMS Name
7ETL Program NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8ETL Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéETL Application Software Nickname EN
9Target Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget Application Software Nickname EN
10Target Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget Column Name
11Target Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget Table or View Name
12Target Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget Schema Name
13Target Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget Database Name
14Target DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget DBMS Name
15Lineage Application Column To Application Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
16Lineage Application Column To Application Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
17IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Source Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2Source Column NameThe 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.
3Source Table or View NameThe 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.
4Source Schema NameThe 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.
5Source 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.
6Source DBMS NameThe 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).
7ETL Program NameThe 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.
8ETL Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
9Target Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
10Target Column NameThe 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.
11Target Table or View NameThe 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.
12Target Schema NameThe 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.
13Target 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.
14Target DBMS NameThe 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).
15Lineage Application Column To Application Notes ENAny English-language notes appropriate to record.
16Lineage Application Column To Application Notes 2NDLAny second-language notes appropriate to record.
17IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Lineage Column To Column PKYSource Application Software Nickname ENA
Source Column NameA
Source Table or View NameA
Source Schema NameA
Source Database NameA
Source DBMS NameA
Target Application Software Nickname ENA
Target Column NameA
Target Table or View NameA
Target Schema NameA
Target Database NameA
Target DBMS NameA
ETL Program NameA
ETL Application Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Application Software1..*:1..1YY
IBG Column1..*:1..1YY
IBG Application Software1..*:1..1YY
IBG Column1..*:1..1YY
IBG ETL Program1..*:1..1YY

 

Entity NameIBG Lineage Application Column To BI Object
Preferred AbbreviationIBG Lineage Application Column To BI Object
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Lineage Application Column To BI Object
Mapped Tables
Table Name
IBG_Physical_Model.IBG Lineage Application Column To BI Object

DescriptionThis entity/table contains the list of columns in tables that are used to populate business intelligence objects.
Notes

Number Of Attributes14
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Source Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Application Software Nickname EN
2Source Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Column Name
3Source Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Table or View Name
4Source Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Schema Name
5Source Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource Database Name
6Source DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéSource DBMS Name
7ETL Program NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8ETL Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéETL Application Software Nickname EN
9Target BI Object Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget BI Object Name EN
10Target BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget BI Object Type EN
11Target BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéTarget BI Accountable Business Unit Acronym EN
12Lineage Application Column To BI Object Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
13Lineage Application Column To BI Object Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Source Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
2Source Column NameThe 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.
3Source Table or View NameThe 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.
4Source Schema NameThe 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.
5Source 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.
6Source DBMS NameThe 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).
7ETL Program NameThe 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.
8ETL Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
9Target BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
10Target BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
11Target BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
12Lineage Application Column To BI Object Notes ENAny English-language notes appropriate to record.
13Lineage Application Column To BI Object Notes 2NDLAny second-language notes appropriate to record.
14IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Lineage Column To Business Intelligence Object PKYETL Program NameA
ETL Application Software Nickname ENA
Target BI Object Name ENA
Target BI Object Type ENA
Target BI Accountable Business Unit Acronym ENA
Source Application Software Nickname ENA
Source Column NameA
Source Table or View NameA
Source Schema NameA
Source Database NameA
Source DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG ETL Program1..*:1..1YY
IBG Business Intelligence Object1..*:1..1YY
IBG Application Software1..*:1..1YY
IBG Column1..*:1..1YY

 

Entity NameIBG Schema
Preferred AbbreviationIBG Schema
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Schema
Mapped Tables
Table Name
IBG_Physical_Model.IBG Schema

DescriptionComments 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
NotesNotes 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 Attributes6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Schema NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
5Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Schema NameThe 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.
2Database 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.
3DBMS NameThe 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).
4Notes ENAny English-language notes appropriate to record.
5Notes 2NDLAny second-language notes appropriate to record.
6IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYSchema NameA
Database NameA
DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Database1..*:1..1YY
IBG Table or View1..*:1..1YY

 

Entity NameIBG Subject Area
Preferred AbbreviationIBG Subject Area
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Subject Area
Mapped Tables
Table Name
IBG_Physical_Model.IBG Subject Area

DescriptionComments 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
NotesNotes 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 Attributes10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Subject Area Name ENPYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
2Subject Area Name 2NDLYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
3Subject Area Definition ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
4Subject Area Definition 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
5Business Metadata Status Code ENFYCHAR (64 CHAR) DOMCHAR-064To be determined/Être déterminé
6Business Metadata Approved By Person NameFYCHAR (128) DOMCHAR-128To Be Determined/ Être déterminéBusiness Metadata Approved By Person Name
7Business Metadata Approved DateYDateLT9999-12-31
8Subject Area Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
9Subject Area Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/Être déterminé
10IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Subject Area Name ENThe 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".
2Subject Area Name 2NDLThe 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".
3Subject Area Definition ENAn English-language defintion of something.
4Subject Area Definition 2NDLA second-language definition of something.
5Business Metadata Status Code ENThe 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
6Business Metadata Approved By Person NameThe name of a person in the organization, or of a person of interest to the organization.
7Business Metadata Approved DateThe date that business metadata was approved.
8Subject Area Notes ENThe English-language notes associated with a given Subject Area.
9Subject Area Notes 2NDLThe second-language notes associated with a given Subject Area.
10IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Subject Area PKYSubject Area Name ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
Code Business Metadata Status1..*:1..1Y
DG Person1..*:1..1Y
IBG Business Entity1..*:1..1YY
DG RACI Subject Area And Person1..*:1..1YY
DG RACI Subject Area And Business Unit1..*:1..1YY

 

Entity NameIBG Table or View
Preferred AbbreviationIBG Table or View
Classification Type Name
Object Type Name
Super Type
SynonymsIBG Table or View
Mapped Tables
Table Name
IBG_Physical_Model.IBG Table or View

DescriptionNotes 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
NotesNotes 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 Attributes7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Table or View NamePYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
6Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
7IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Table or View NameThe 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.
2Schema NameThe 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.
3Database 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.
4DBMS NameThe 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).
5Notes ENAny English-language notes appropriate to record.
6Notes 2NDLAny second-language notes appropriate to record.
7IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Application System PKYTable or View NameA
Schema NameA
Database NameA
DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG XREF BE And Table Or View1..*:1..1YY
IBG Schema1..*:1..1YY
IBG Column1..*:1..1YY

 

Entity NameIBG XREF BA And Column
Preferred AbbreviationIBG XREF BA And Column
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BA And Column
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BA And Column

DescriptionThis entity/table contains a cross reference of business attributes to columns and tables or views.
Notes

Number Of Attributes11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9Business Attribute And Column Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
10Business Attribute And Column Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
11IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4Column NameThe 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.
5Table or View NameThe 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.
6Schema NameThe 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.
7Database 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.
8DBMS NameThe 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).
9Business Attribute And Column Notes ENAny English-language notes appropriate to record for the business attribute and column cross reference.
10Business Attribute And Column Notes 2NDLAny second-language notes appropriate to record for the business attribute and column cross reference.
11IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG XREF BA And Column PKYBusiness Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA
Column NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Business Attribute Core1..*:1..1YY
IBG Column1..*:1..1YY
IBG XREF BA Column And Application1..*:1..1YY
IBG XREF BA Column And BI Object1..*:1..1YY

 

Entity NameIBG XREF BA Column And Application
Preferred AbbreviationIBG XREF BA Column And Application
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BA Column And Application
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BA Column And Application

DescriptionThis entity/table contains a cross reference of business attributes and columns to applications.
Notes

Number Of Attributes15
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10Application SW Window Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11Application SW Field Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
12System Of Record Or Reference Code ENFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
13Business Attribute Column Application Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14Business Attribute Column Application Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
15IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4Column NameThe 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.
5Table or View NameThe 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.
6Schema NameThe 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.
7Database 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.
8DBMS NameThe 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).
9Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
10Application SW Window Name ENThe 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.
11Application SW Field Name ENThe English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes.
12System Of Record Or Reference Code ENAn 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.
13Business Attribute Column Application Notes ENAny English-language notes appropriate to record for the business attribute, column, and application cross reference.
14Business Attribute Column Application Notes 2NDLAny second-language notes appropriate to record for the business attribute, column, and application cross reference.
15IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
XREF BA Column And Application PKYBusiness Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA
Column NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA
Application SW Window Name ENA
Application SW Field Name ENA
Application Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG XREF BA And Column1..*:1..1YY
IBG Application Software Field1..*:1..1YY
Code System Of Record Or Reference1..*:1..1Y
IBG XREF BA Data Issue And Application1..*:1..1YY

 

Entity NameIBG XREF BA Column And BI Object
Preferred AbbreviationIBG XREF BA Column And BI Object
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BA Column And BI Object
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BA Column And BI Object

DescriptionThis entity/table contains a cross reference of business attributes and columns to BI objects..
Notes

Number Of Attributes14
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9BI Object Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Accountable Business Unit Acronym EN
12Business Attribute Column BI Object Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
13Business Attribute Column BI Object Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Attribute Name ENThe 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".
2Business Entity Name ENThe 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".
3Subject Area Name ENThe 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".
4Column NameThe 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.
5Table or View NameThe 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.
6Schema NameThe 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.
7Database 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.
8DBMS NameThe 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).
9BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
10BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
11BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
12Business Attribute Column BI Object Notes ENAny English-language notes appropriate to record for the business attribute, column, and BI object cross reference.
13Business Attribute Column BI Object Notes 2NDLAny second-language notes appropriate to record for the business attribute, column, and BI object cross reference.
14IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
XREF BA Column And BI Object PKYBusiness Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA
Column NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA
BI Object Name ENA
BI Object Type ENA
BI Accountable Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG XREF BA And Column1..*:1..1YY
IBG Business Intelligence Object1..*:1..1YY
IBG XREF BA Data Issue And BI Object1..*:1..1YY

 

Entity NameIBG XREF BA Data Issue And Application
Preferred AbbreviationIBG XREF BA Data Issue And Application
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BA Data Issue And Application
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BA Data Issue And Application

DescriptionComments EN: This entity/table contains a cross reference of business attributes, application systems, windows, and fields. Comments FR: La définition est à déterminer
NotesNotes 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 Attributes15
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10Application SW Window Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11Application SW Field Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
12Application Software Nickname ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
13Data Issue BA Column And Application Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14Data Issue BA Column And Application Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
15IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Business Attribute Name ENThe 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".
3Business Entity Name ENThe 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".
4Subject Area Name ENThe 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".
5Column NameThe 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.
6Table or View NameThe 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.
7Schema NameThe 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.
8Database 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.
9DBMS NameThe 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).
10Application SW Window Name ENThe 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.
11Application SW Field Name ENThe English-language name for a field in an application system. Fields are presented in application windows, and fields present the data for business attributes.
12Application Software Nickname ENThe English-language acronym by which an application system or software product is commonly known.
13Data Issue BA Column And Application Notes ENAny English-language notes appropriate to record for the data issue, business attribute, column, and application cross reference.
14Data Issue BA Column And Application Notes 2NDLAny second-language notes appropriate to record for the data issue, business attribute, column, and application cross reference.
15IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG Business Attribute XREF Application and Column PKYData Issue IDA
Business Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA
Column NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA
Application SW Window Name ENA
Application SW Field Name ENA
Application Software Nickname ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1YY
IBG XREF BA Column And Application1..*:1..1YY

 

Entity NameIBG XREF BA Data Issue And BI Object
Preferred AbbreviationIBG XREF BA Data Issue And BI Object
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BA Data Issue And BI Object
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BA Data Issue And BI Object

DescriptionComments 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
NotesNotes 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 Attributes15
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Data Issue IDPFYIntegerDOMInteger0
2Business Attribute Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Column NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
8Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
9DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
10BI Object Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
11BI Object Type ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
12BI Accountable Business Unit Acronym ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminéBI Accountable Business Unit Acronym EN
13Data Issue BA Column And BI Object Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
14Data Issue BA Column And BI Object Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
15IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Data Issue IDA meaningless but unique identifer for a data issue.
2Business Attribute Name ENThe 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".
3Business Entity Name ENThe 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".
4Subject Area Name ENThe 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".
5Column NameThe 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.
6Table or View NameThe 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.
7Schema NameThe 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.
8Database 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.
9DBMS NameThe 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).
10BI Object Name ENThe English-language name of a business intelliegnce (BI) object.
11BI Object Type ENAn English-language categorization of Business Intelligence artifacts, categorizations such as Advanced Analytics Statistical Model, Dashboard, Multi-Dimensional Cube, and Report.
12BI Accountable Business Unit Acronym ENThe English-language acronym by which a business unit is commonly known.
13Data Issue BA Column And BI Object Notes ENAny English-language notes appropriate to record for thedata issue, business attribute, column, and business intelligence object cross reference.
14Data Issue BA Column And BI Object Notes 2NDLAny second-language notes appropriate to record for thedata issue, business attribute, column, and business intelligence object cross reference.
15IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG XREF Business Attribute And Business Intelligence Object PKYData Issue IDA
Business Entity Name ENA
Subject Area Name ENA
Business Attribute Name ENA
Column NameA
Table or View NameA
Schema NameA
Database NameA
DBMS NameA
BI Object Name ENA
BI Object Type ENA
BI Accountable Business Unit Acronym ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
DG Data Issue Register1..*:1..1YY
IBG XREF BA Column And BI Object1..*:1..1YY

 

Entity NameIBG XREF BE And Table Or View
Preferred AbbreviationIBG XREF BE And Table Or View
Classification Type Name
Object Type Name
Super Type
SynonymsIBG XREF BE And Table Or View
Mapped Tables
Table Name
IBG_Physical_Model.IBG XREF BE And Table Or View

DescriptionComments 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
NotesNotes 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 Attributes9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Attributes
NoAttribute NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
Preferred AbbreviationSynonyms
1Business Entity Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
2Subject Area Name ENPFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
3Table or View NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
4Schema NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
5Database NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
6DBMS NamePFYCHAR (64 CHAR) DOMCHAR-064To Be Determined/ Être déterminé
7Business Entity And Table View Notes ENYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
8Business Entity And Table View Notes 2NDLYVARCHAR (8000 CHAR) DOMVARCHAR-8KTo be determined/ Être déterminé
9IBG Create Date TimeYDatetimeDOMCreate-Date-TimeGETDATE()

Attributes Comments
NoAttribute NameDescriptionNotes
1Business Entity Name ENThe 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".
2Subject Area Name ENThe 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".
3Table or View NameThe 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.
4Schema NameThe 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.
5Database 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.
6DBMS NameThe 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).
7Business Entity And Table View Notes ENAny English-language notes appropriate to record for the business entity and table/view cross reference.
8Business Entity And Table View Notes 2NDLAny second-language notes appropriate to record for the business entity and table/view cross reference.
9IBG Create Date TimeThe date and time that a record for an information asset was created in the Data Governance Integrated Business Glossary.

Identifiers
NamePrimary
Identifyer
Element NameElement
Type
Source LabelTarget Label
IBG XREF Business Entity And Table Or View PKYTable or View NameA
Schema NameA
Database NameA
DBMS NameA
Business Entity Name ENA
Subject Area Name ENA

Has Relationships With
Entity NameRoleOther RoleIn ArcCardinalityDominant
Role
IdentifyingTransferable
IBG Table or View1..*:1..1YY
IBG Business Entity1..*:1..1YY


Business Attribute - Core

Code Protected Level * P Protected Level Code EN * Protected Level Code 2NDL * Protected Level Code Description EN * Protected Level Code Description 2NDL * IBG Create Date Time Code Business Metadata Status * P Business Metadata Status Code EN * Business Metadata Status Code 2NDL * Business Metadata Status Code Description EN * Business Metadata Status Code Description 2NDL * IBG Create Date Time IBG Subject Area * P Subject Area Name EN * Subject Area Name 2NDL * Subject Area Definition EN * Subject Area Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Subject Area Notes EN * Subject Area Notes 2NDL * IBG Create Date Time IBG Business Entity * P Business Entity Name EN * PF Subject Area Name EN * Business Entity Name 2NDL * Business Entity Definition EN * Business Entity Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * F Sensitivity Level Code EN * F Protected Level Code EN * Business Entity Notes EN * Business Entity Notes 2NDL * IBG Create Date Time IBG Business Attribute Document * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * P Document Name EN * Document Name 2NDL * Document Hyperlink EN * Document Hyperlink 2NDL * Business Attribute Document Notes EN * Business Attribute Document Notes 2NDL * IBG Create Date Time DG Person * P Person Name * F Reports To Person Name * Person Email Address * Job Title Role EN * Job Title Role 2NDL * F Business Unit Acronym EN * Person Notes EN * Person Notes 2NDL * IBG Create Date Time Code Operational Reference Master * P Operational Reference Master Code EN * Operational Reference Master Code 2NDL * Operational Reference Master Code Description EN * Operational Reference Master Code Description 2NDL * IBG Create Date Time IBG Business Attribute Core * P Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * Business Attribute Name 2NDL * Business Attribute Definition EN * Business Attribute Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Default Value EN * Default Value 2NDL * Data Entry Guidelines EN * Data Entry Guidelines 2NDL * Derivation Rule EN * Derivation Rule 2NDL * Usage Guidelines EN * Usage Guidelines 2NDL * Mosaic Caution EN * Mosaic Caution 2NDL * Masking Rule EN * Masking Rule 2NDL * Archive Rule EN * Archive Rule 2NDL * Purge Rule EN * Purge Rule 2NDL * F Operational Reference Master Code EN * F Protected Level Code EN * F Sensitivity Level Code EN * F Personally Identifiable Information Indicator EN * Business Attribute Notes EN * Business Attribute Notes 2NDL * IBG Create Date Time Code Sensitivity Level * P Sensitivity Level Code EN * Sensitivity Level Code 2NDL * Sensitivity Level Code Description EN * Sensitivity Level Code Description 2NDL * IBG Create Date Time Code Yes No * P Yes No Code EN * Yes No Code 2NDL * Yes No Code Description EN * Yes No Code Description 2NDL * IBG Create Date Time



Business Intelligence Object

Code BI Object Type * P BI Object Type EN CHAR (64) * BI Object Type 2NDL CHAR (64) * BI Object Type Description EN VARCHAR (8000) * BI Object Type Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Protected Level * P Protected Level Code EN CHAR (64) * Protected Level Code 2NDL CHAR (64) * Protected Level Code Description EN VARCHAR (8000) * Protected Level Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Business Intelligence Object * P BI Object Name EN CHAR (64) * PF BI Object Type EN CHAR (64) * PF BI Accountable Business Unit Acronym EN CHAR (64) * BI Object Name 2NDL CHAR (256) * F Business Metadata Status Code EN CHAR (64) * F BI Application Software Nickname EN CHAR (64) * BI Hyperlink VARCHAR (8000) * BI Object Description EN VARCHAR (8000) * BI Object Description 2NDL VARCHAR (8000) * F Protected Level Code EN CHAR (64) * F Sensitivity Level Code EN CHAR (64) * Business Intelligence Object Notes EN VARCHAR (8000) * Business Intelligence Object Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG XREF BA Data Issue And BI Object * PF Data Issue ID INTEGER * PF Business Attribute Name EN CHAR (64) * PF Business Entity Name EN CHAR (64) * PF Subject Area Name EN CHAR (64) * PF Column Name CHAR (64) * PF Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * PF BI Object Name EN CHAR (64) * PF BI Object Type EN CHAR (64) * PF BI Accountable Business Unit Acronym EN CHAR (64) * Data Issue BA Column And BI Object Notes EN VARCHAR (8000) * Data Issue BA Column And BI Object Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME DG Business Unit * P Business Unit Acronym EN CHAR (64) * Business Unit Acronym 2NDL CHAR (64) * Business Unit Full Name EN CHAR (256) * Business Unit Full Name 2NDL CHAR (256) * F Parent Business Unit Acronym EN CHAR (64) * Business Unit Hyperlink EN VARCHAR (8000) * Business Unit Hyperlink 2NDL VARCHAR (8000) * F Business Unit Type EN CHAR (64) * F Part Of Organization Code EN CHAR (64) * F Required In Data Gov Committees Indicator EN CHAR (64) * Business Unit Notes EN VARCHAR (8000) * Business Unit Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Business Metadata Status * P Business Metadata Status Code EN CHAR (64) * Business Metadata Status Code 2NDL CHAR (64) * Business Metadata Status Code Description EN VARCHAR (8000) * Business Metadata Status Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG XREF BA And Column * PF Business Attribute Name EN CHAR (64) * PF Business Entity Name EN CHAR (64) * PF Subject Area Name EN CHAR (64) * PF Column Name CHAR (64) * PF Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Business Attribute And Column Notes EN VARCHAR (8000) * Business Attribute And Column Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG XREF BA Column And BI Object * PF Business Attribute Name EN CHAR (64) * PF Business Entity Name EN CHAR (64) * PF Subject Area Name EN CHAR (64) * PF Column Name CHAR (64) * PF Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * PF BI Object Name EN CHAR (64) * PF BI Object Type EN CHAR (64) * PF BI Accountable Business Unit Acronym EN CHAR (64) * Business Attribute Column BI Object Notes EN VARCHAR (8000) * Business Attribute Column BI Object Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME DG RACI BI Object and Person * PF BI Object Name EN CHAR (64) * PF BI Object Type EN CHAR (64) * PF BI Accountable Business Unit Acronym EN CHAR (64) * PF RACI Person Name CHAR (128) * F RACI Code EN CHAR (64) * F Data Governance Role Code EN CHAR (64) * RACI Start Date DATE * RACI End Date DATE * RACI Notes EN VARCHAR (8000) * RACI Notes 2NDL VARCHAR (8000) * IBG Create Date DATETIME DG RACI BI Object and Business Unit * PF BI Object Name EN CHAR (64) * PF BI Object Type EN CHAR (64) * PF BI Accountable Business Unit Acronym EN CHAR (64) * PF RACI Business Unit Acronym EN CHAR (64) * F RACI Code EN CHAR (64) * RACI Start Date DATE * RACI End Date DATE * RACI Notes EN VARCHAR (8000) * RACI Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Application Software * P Application Software Nickname EN CHAR (64) * Application Software Nickname 2NDL CHAR (64) * Application Software Full Name EN CHAR (256) * Application Software Full Name 2NDL CHAR (256) * Application Software Vendor Name CHAR (256) * Application Software Hyperlink VARCHAR (8000) * Application Software Description EN VARCHAR (8000) * Application Software Description 2NDL VARCHAR (8000) * Application Software Notes EN VARCHAR (8000) * Application Software Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Lineage Application Column To BI Object * PF Source Application Software Nickname EN CHAR (64) * PF Source Column Name CHAR (64) * PF Source Table or View Name CHAR (64) * PF Source Schema Name CHAR (64) * PF Source Database Name CHAR (64) * PF Source DBMS Name CHAR (64) * PF ETL Program Name CHAR (64) * PF ETL Application Software Nickname EN CHAR (64) * PF Target BI Object Name EN CHAR (64) * PF Target BI Object Type EN CHAR (64) * PF Target BI Accountable Business Unit Acronym EN CHAR (64) * Lineage Application Column To BI Object Notes EN VARCHAR (8000) * Lineage Application Column To BI Object Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Sensitivity Level * P Sensitivity Level Code EN CHAR (64) * Sensitivity Level Code 2NDL CHAR (64) * Sensitivity Level Code Description EN VARCHAR (8000) * Sensitivity Level Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME



Code Tables

Code BI Object Type * P BI Object Type EN CHAR (64) * BI Object Type 2NDL CHAR (64) * BI Object Type Description EN VARCHAR (8000) * BI Object Type Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Committee * P Committee Acronym EN CHAR (64) * Committee Acronym 2NDL CHAR (64) * Committee Full Name EN CHAR (256) * Committee Full Name 2NDL CHAR (256) * F Parent Committee Acronym EN CHAR (64) * Committee Terms Of Reference Hyperlink EN VARCHAR (8000) * Committee Terms Of Reference Hyperlink 2NDL VARCHAR (8000) * Committee Meeting Minutes Folder Hyperlink EN VARCHAR (8000) * Committee Meeting Minutes Folder Hyperlink 2NDL VARCHAR (8000) * Committee Notes EN VARCHAR (8000) * Committee Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Protected Level * P Protected Level Code EN CHAR (64) * Protected Level Code 2NDL CHAR (64) * Protected Level Code Description EN VARCHAR (8000) * Protected Level Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Data Issue Category * P Data Issue Category Code EN CHAR (64) * Data Issue Category Code 2NDL CHAR (64) * Data Issue Category Code Description EN VARCHAR (8000) * Data Issue Category Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME DG Business Unit * P Business Unit Acronym EN CHAR (64) * Business Unit Acronym 2NDL CHAR (64) * Business Unit Full Name EN CHAR (256) * Business Unit Full Name 2NDL CHAR (256) * F Parent Business Unit Acronym EN CHAR (64) * Business Unit Hyperlink EN VARCHAR (8000) * Business Unit Hyperlink 2NDL VARCHAR (8000) * F Business Unit Type EN CHAR (64) * F Part Of Organization Code EN CHAR (64) * F Required In Data Gov Committees Indicator EN CHAR (64) * Business Unit Notes EN VARCHAR (8000) * Business Unit Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Data Governance Role * P Data Governance Role Code EN CHAR (64) * Data Governance Role Code 2NDL CHAR (64) * Data Governance Role Code Description EN VARCHAR (8000) * Data Governance Role Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Business Metadata Status * P Business Metadata Status Code EN CHAR (64) * Business Metadata Status Code 2NDL CHAR (64) * Business Metadata Status Code Description EN VARCHAR (8000) * Business Metadata Status Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Committee Membership Role * P Committee Membership Role Code EN CHAR (64) * Committee Membership Role Code 2NDL CHAR (64) * Committee Membership Role Code Description EN VARCHAR (8000) * Committee Membership Role Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Application Software * P Application Software Nickname EN CHAR (64) * Application Software Nickname 2NDL CHAR (64) * Application Software Full Name EN CHAR (256) * Application Software Full Name 2NDL CHAR (256) * Application Software Vendor Name CHAR (256) * Application Software Hyperlink VARCHAR (8000) * Application Software Description EN VARCHAR (8000) * Application Software Description 2NDL VARCHAR (8000) * Application Software Notes EN VARCHAR (8000) * Application Software Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Operational Reference Master * P Operational Reference Master Code EN CHAR (64) * Operational Reference Master Code 2NDL CHAR (64) * Operational Reference Master Code Description EN VARCHAR (8000) * Operational Reference Master Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Data Issue Status * P Data Issue Status Code EN CHAR (64) * Data Issue Status Code 2NDL CHAR (64) * Data Issue Status Code Description EN VARCHAR (8000) * Data Issue Status Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Data Issue Severity * P Data Issue Severity Code EN CHAR (64) * Data Issue Severity Code 2NDL CHAR (64) * Data Issue Severity Code Description EN VARCHAR (8000) * Data Issue Severity Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Data Issue Impact * P Data Issue Impact Code EN CHAR (64) * Data Issue Impact Code 2NDL CHAR (64) * Data Issue Impact Code Description EN VARCHAR (8000) * Data Issue Impact Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code DQ Dimension * P DQ Dimension Code EN CHAR (64) * DQ Dimension Code 2NDL CHAR (64) * DQ Dimension Code Description EN VARCHAR (8000) * DQ Dimension Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Business Unit Type * P Business Unit Type EN CHAR (64) * Business Unit Type 2NDL CHAR (64) * Business Unit Type Description EN VARCHAR (8000) * Business Unit Type Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Part Of Organization * P Part Of Organization Code EN CHAR (64) * Part Of Organization Code 2NDL CHAR (64) * Part Of Organization Code Description EN VARCHAR (8000) * Part Of Organization Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code System Of Record Or Reference * P System Of Record Or Reference Code EN CHAR (64) * System Of Record Or Reference Code 2NDL CHAR (64) * System Of Record Or Reference Code Description EN VARCHAR (8000) * System Of Record Or Reference Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code RACI * P RACI Code EN CHAR (64) * RACI Code 2NDL CHAR (64) * RACI Code Description EN VARCHAR (8000) * RACI Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Sensitivity Level * P Sensitivity Level Code EN CHAR (64) * Sensitivity Level Code 2NDL CHAR (64) * Sensitivity Level Code Description EN VARCHAR (8000) * Sensitivity Level Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code DQ Color * P DQ Color Code EN CHAR (64) * DQ Color Code 2NDL CHAR (64) * DQ Color Code Description EN VARCHAR (8000) * DQ Color Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME Code Yes No * P Yes No Code EN CHAR (64) * Yes No Code 2NDL CHAR (64) * Yes No Code Description EN VARCHAR (8000) * Yes No Code Description 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME



Data Issue Register

DG Data Issue Status History * PF Data Issue ID * PF Data Issue Status Code EN * P Data Issue Status History Date * Data Issue Status History Notes EN * Data Issue Status History Notes 2NDL * IBG Create Date Time Code Data Issue Category * P Data Issue Category Code EN * Data Issue Category Code 2NDL * Data Issue Category Code Description EN * Data Issue Category Code Description 2NDL * IBG Create Date Time DG Data Issue And Person * PF Data Issue ID * PF Person Name * F Data Governance Role Code EN * Data Issue And Person Notes EN * Data Issue And Person Notes 2NDL * IBG Create Date Time DG Business Unit * P Business Unit Acronym EN * Business Unit Acronym 2NDL * Business Unit Full Name EN * Business Unit Full Name 2NDL * F Parent Business Unit Acronym EN * Business Unit Hyperlink EN * Business Unit Hyperlink 2NDL * F Business Unit Type EN * F Part Of Organization Code EN * F Required In Data Gov Committees Indicator EN * Business Unit Notes EN * Business Unit Notes 2NDL * IBG Create Date Time Code Data Governance Role * P Data Governance Role Code EN * Data Governance Role Code 2NDL * Data Governance Role Code Description EN * Data Governance Role Code Description 2NDL * IBG Create Date Time DG Person * P Person Name * F Reports To Person Name * Person Email Address * Job Title Role EN * Job Title Role 2NDL * F Business Unit Acronym EN * Person Notes EN * Person Notes 2NDL * IBG Create Date Time DG Data Issue And Business Unit * PF Data Issue ID * PF Data Issue Impact Code EN * PF Business Unit Acronym EN * PF Point Of Contact Person Name * Data Issue Impact Notes EN * Data Issue Impact Notes 2NDL * IBG Create Date Time DG Data Issue Register * P Data Issue ID * Data Issue Title EN * Data Issue Title 2NDL * Data Issue Description EN * Data Issue Description 2NDL * Data Issue Documentation Folder Hyperlink * F Data Issue Category Code EN * F Data Issue Severity Code EN * Data Issue Identification Date * Data Issue Notes EN * Data Issue Notes 2NDL * IBG Create Date Time Code Data Issue Status * P Data Issue Status Code EN * Data Issue Status Code 2NDL * Data Issue Status Code Description EN * Data Issue Status Code Description 2NDL * IBG Create Date Time Code Data Issue Severity * P Data Issue Severity Code EN * Data Issue Severity Code 2NDL * Data Issue Severity Code Description EN * Data Issue Severity Code Description 2NDL * IBG Create Date Time Code Data Issue Impact * P Data Issue Impact Code EN * Data Issue Impact Code 2NDL * Data Issue Impact Code Description EN * Data Issue Impact Code Description 2NDL * IBG Create Date Time



Data Quality

IBG Business Attribute DQ Colors * PF DQ Rule Number SKEY * PF DQ Color Code EN * DQ Color Low Range Percentage * DQ Color High Range Percentage * F DQ Color Range Approved By Person Name * DQ Color Range Notes EN * DQ Color Range Notes 2NDL * IBG Create Date Time DG Business Unit * P Business Unit Acronym EN * Business Unit Acronym 2NDL * Business Unit Full Name EN * Business Unit Full Name 2NDL * F Parent Business Unit Acronym EN * Business Unit Hyperlink EN * Business Unit Hyperlink 2NDL * F Business Unit Type EN * F Part Of Organization Code EN * F Required In Data Gov Committees Indicator EN * Business Unit Notes EN * Business Unit Notes 2NDL * IBG Create Date Time IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG Application Software Field * PF Application Software Nickname EN * P Application SW Window Name EN * P Application SW Field Name EN * Application SW Window Name 2NDL * Application SW Field Name 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time DG Person * P Person Name * F Reports To Person Name * Person Email Address * Job Title Role EN * Job Title Role 2NDL * F Business Unit Acronym EN * Person Notes EN * Person Notes 2NDL * IBG Create Date Time DG Data Issue Register * P Data Issue ID * Data Issue Title EN * Data Issue Title 2NDL * Data Issue Description EN * Data Issue Description 2NDL * Data Issue Documentation Folder Hyperlink * F Data Issue Category Code EN * F Data Issue Severity Code EN * Data Issue Identification Date * Data Issue Notes EN * Data Issue Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time Code DQ Dimension * P DQ Dimension Code EN * DQ Dimension Code 2NDL * DQ Dimension Code Description EN * DQ Dimension Code Description 2NDL * IBG Create Date Time IBG Business Attribute Core * P Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * Business Attribute Name 2NDL * Business Attribute Definition EN * Business Attribute Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Default Value EN * Default Value 2NDL * Data Entry Guidelines EN * Data Entry Guidelines 2NDL * Derivation Rule EN * Derivation Rule 2NDL * Usage Guidelines EN * Usage Guidelines 2NDL * Mosaic Caution EN * Mosaic Caution 2NDL * Masking Rule EN * Masking Rule 2NDL * Archive Rule EN * Archive Rule 2NDL * Purge Rule EN * Purge Rule 2NDL * F Operational Reference Master Code EN * F Protected Level Code EN * F Sensitivity Level Code EN * F Personally Identifiable Information Indicator EN * Business Attribute Notes EN * Business Attribute Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And Application * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application SW Window Name EN * PF Application SW Field Name EN * PF Application Software Nickname EN * Data Issue BA Column And Application Notes EN * Data Issue BA Column And Application Notes 2NDL * IBG Create Date Time IBG Business Attribute DQ Rules * P DQ Rule Number SKEY * F DQ Dimension Code EN * F Business Attribute Name EN * F Business Entity Name EN * F Subject Area Name EN * F DQ Rule Owner Business Unit Acronym EN * DQ Rule Criteria Text EN * DQ Rule Criteria Text 2NDL * F DQ Rule Approved By Person Name * DQ Rule Notes EN * DQ Rule Notes 2NDL * IBG Create Date Time



Governing Body Management

Code Committee * P Committee Acronym EN * Committee Acronym 2NDL * Committee Full Name EN * Committee Full Name 2NDL * F Parent Committee Acronym EN * Committee Terms Of Reference Hyperlink EN * Committee Terms Of Reference Hyperlink 2NDL * Committee Meeting Minutes Folder Hyperlink EN * Committee Meeting Minutes Folder Hyperlink 2NDL * Committee Notes EN * Committee Notes 2NDL * IBG Create Date Time DG Committee Membership * PF Committee Acronym EN * PF Person Name * PF Committee Membership Role Code EN * Committee Membership Start Date * Committee Membership End Date * Notes EN * Notes 2NDL * IBG Create Date Time DG Business Unit * P Business Unit Acronym EN * Business Unit Acronym 2NDL * Business Unit Full Name EN * Business Unit Full Name 2NDL * F Parent Business Unit Acronym EN * Business Unit Hyperlink EN * Business Unit Hyperlink 2NDL * F Business Unit Type EN * F Part Of Organization Code EN * F Required In Data Gov Committees Indicator EN * Business Unit Notes EN * Business Unit Notes 2NDL * IBG Create Date Time Code Committee Membership Role * P Committee Membership Role Code EN * Committee Membership Role Code 2NDL * Committee Membership Role Code Description EN * Committee Membership Role Code Description 2NDL * IBG Create Date Time DG Person * P Person Name * F Reports To Person Name * Person Email Address * Job Title Role EN * Job Title Role 2NDL * F Business Unit Acronym EN * Person Notes EN * Person Notes 2NDL * IBG Create Date Time DG Committee Meeting Attendance * PF Committee Acronym EN * PF Committee Meeting Date * PF Person Name * Notes EN * Notes 2NDL * IBG Create Date Time DG Committee Meeting History * PF Committee Acronym EN * P Committee Meeting Date * Committee Meeting Minutes Hyperlink EN * Committee Meeting Minutes Hyperlink 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time



Lineage

IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG Lineage Application Column To Application * PF Source Application Software Nickname EN * PF Source Column Name * PF Source Table or View Name * PF Source Schema Name * PF Source Database Name * PF Source DBMS Name * PF ETL Program Name * PF ETL Application Software Nickname EN * PF Target Application Software Nickname EN * PF Target Column Name * PF Target Table or View Name * PF Target Schema Name * PF Target Database Name * PF Target DBMS Name * Lineage Application Column To Application Notes EN * Lineage Application Column To Application Notes 2NDL * IBG Create Date Time IBG Column * P Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time IBG ETL Program * P ETL Program Name * PF ETL Application Software Nickname EN * Description EN * Description 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time Code System Of Record Or Reference * P System Of Record Or Reference Code EN * System Of Record Or Reference Code 2NDL * System Of Record Or Reference Code Description EN * System Of Record Or Reference Code Description 2NDL * IBG Create Date Time IBG Lineage Application Column To BI Object * PF Source Application Software Nickname EN * PF Source Column Name * PF Source Table or View Name * PF Source Schema Name * PF Source Database Name * PF Source DBMS Name * PF ETL Program Name * PF ETL Application Software Nickname EN * PF Target BI Object Name EN * PF Target BI Object Type EN * PF Target BI Accountable Business Unit Acronym EN * Lineage Application Column To BI Object Notes EN * Lineage Application Column To BI Object Notes 2NDL * IBG Create Date Time



Person and Business Unit

DG Business Unit * P Business Unit Acronym EN * Business Unit Acronym 2NDL * Business Unit Full Name EN * Business Unit Full Name 2NDL * F Parent Business Unit Acronym EN * Business Unit Hyperlink EN * Business Unit Hyperlink 2NDL * F Business Unit Type EN * F Part Of Organization Code EN * F Required In Data Gov Committees Indicator EN * Business Unit Notes EN * Business Unit Notes 2NDL * IBG Create Date Time DG Person * P Person Name * F Reports To Person Name * Person Email Address * Job Title Role EN * Job Title Role 2NDL * F Business Unit Acronym EN * Person Notes EN * Person Notes 2NDL * IBG Create Date Time Code Business Unit Type * P Business Unit Type EN * Business Unit Type 2NDL * Business Unit Type Description EN * Business Unit Type Description 2NDL * IBG Create Date Time Code Part Of Organization * P Part Of Organization Code EN * Part Of Organization Code 2NDL * Part Of Organization Code Description EN * Part Of Organization Code Description 2NDL * IBG Create Date Time Code Yes No * P Yes No Code EN * Yes No Code 2NDL * Yes No Code Description EN * Yes No Code Description 2NDL * IBG Create Date Time



Physical Column

IBG Database Management System * P DBMS Name CHAR (64) * DBMS Vendor Name CHAR (256) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Column * P Column Name CHAR (64) * PF Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Table or View * P Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Schema * P Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Database * P Database Name CHAR (64) * PF DBMS Name CHAR (64) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME



RACI - Applications And BI Objects

IBG Business Intelligence Object * P BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * BI Object Name 2NDL * F Business Metadata Status Code EN * F BI Application Software Nickname EN * BI Hyperlink * BI Object Description EN * BI Object Description 2NDL * F Protected Level Code EN * F Sensitivity Level Code EN * Business Intelligence Object Notes EN * Business Intelligence Object Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And BI Object * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Data Issue BA Column And BI Object Notes EN * Data Issue BA Column And BI Object Notes 2NDL * IBG Create Date Time DG Data Issue And Person * PF Data Issue ID * PF Person Name * F Data Governance Role Code EN * Data Issue And Person Notes EN * Data Issue And Person Notes 2NDL * IBG Create Date Time DG RACI Application Software And Person * PF Application Software Nickname EN * PF RACI Person Name * F RACI Code EN * F Data Governance Role Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG XREF BA Column And BI Object * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Business Attribute Column BI Object Notes EN * Business Attribute Column BI Object Notes 2NDL * IBG Create Date Time DG RACI BI Object and Person * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * PF RACI Person Name * F RACI Code EN * F Data Governance Role Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date DG RACI BI Object and Business Unit * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * PF RACI Business Unit Acronym EN * F RACI Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time IBG Application Software * P Application Software Nickname EN * Application Software Nickname 2NDL * Application Software Full Name EN * Application Software Full Name 2NDL * Application Software Vendor Name * Application Software Hyperlink * Application Software Description EN * Application Software Description 2NDL * Application Software Notes EN * Application Software Notes 2NDL * IBG Create Date Time IBG Application Software Field * PF Application Software Nickname EN * P Application SW Window Name EN * P Application SW Field Name EN * Application SW Window Name 2NDL * Application SW Field Name 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time DG Data Issue And Business Unit * PF Data Issue ID * PF Data Issue Impact Code EN * PF Business Unit Acronym EN * PF Point Of Contact Person Name * Data Issue Impact Notes EN * Data Issue Impact Notes 2NDL * IBG Create Date Time DG RACI Application Software And Business Unit * PF Application Software Nickname EN * PF RACI Business Unit Acronym EN * F RACI Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time DG Data Issue Register * P Data Issue ID * Data Issue Title EN * Data Issue Title 2NDL * Data Issue Description EN * Data Issue Description 2NDL * Data Issue Documentation Folder Hyperlink * F Data Issue Category Code EN * F Data Issue Severity Code EN * Data Issue Identification Date * Data Issue Notes EN * Data Issue Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And Application * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application SW Window Name EN * PF Application SW Field Name EN * PF Application Software Nickname EN * Data Issue BA Column And Application Notes EN * Data Issue BA Column And Application Notes 2NDL * IBG Create Date Time



RACI - Business Attributes, Entities, Subject Areas

IBG XREF BE And Table Or View * PF Business Entity Name EN * PF Subject Area Name EN * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Entity And Table View Notes EN * Business Entity And Table View Notes 2NDL * IBG Create Date Time IBG Subject Area * P Subject Area Name EN * Subject Area Name 2NDL * Subject Area Definition EN * Subject Area Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Subject Area Notes EN * Subject Area Notes 2NDL * IBG Create Date Time DG RACI Business Attribute And Business Unit * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF RACI Business Unit Acronym EN * PF RACI Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG Business Entity * P Business Entity Name EN * PF Subject Area Name EN * Business Entity Name 2NDL * Business Entity Definition EN * Business Entity Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * F Sensitivity Level Code EN * F Protected Level Code EN * Business Entity Notes EN * Business Entity Notes 2NDL * IBG Create Date Time Code Operational Reference Master * P Operational Reference Master Code EN * Operational Reference Master Code 2NDL * Operational Reference Master Code Description EN * Operational Reference Master Code Description 2NDL * IBG Create Date Time DG Data Issue Register * P Data Issue ID * Data Issue Title EN * Data Issue Title 2NDL * Data Issue Description EN * Data Issue Description 2NDL * Data Issue Documentation Folder Hyperlink * F Data Issue Category Code EN * F Data Issue Severity Code EN * Data Issue Identification Date * Data Issue Notes EN * Data Issue Notes 2NDL * IBG Create Date Time DG RACI Business Entity and Person * PF Business Entity Name EN * PF Subject Area Name EN * PF RACI Person Name * F RACI Code EN * F Data Governance Role Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date DG RACI Business Entity and Business Unit * PF Business Entity Name EN * PF Subject Area Name EN * PF RACI Business Unit Acronym EN * F RACI Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time DG RACI Subject Area And Person * PF Subject Area Name EN * PF RACI Person Name * F RACI Code EN * F Data Governance Role Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time DG RACI Subject Area And Business Unit * PF Subject Area Name EN * PF RACI Business Unit Acronym EN * F RACI Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date Time IBG Business Attribute Core * P Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * Business Attribute Name 2NDL * Business Attribute Definition EN * Business Attribute Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Default Value EN * Default Value 2NDL * Data Entry Guidelines EN * Data Entry Guidelines 2NDL * Derivation Rule EN * Derivation Rule 2NDL * Usage Guidelines EN * Usage Guidelines 2NDL * Mosaic Caution EN * Mosaic Caution 2NDL * Masking Rule EN * Masking Rule 2NDL * Archive Rule EN * Archive Rule 2NDL * Purge Rule EN * Purge Rule 2NDL * F Operational Reference Master Code EN * F Protected Level Code EN * F Sensitivity Level Code EN * F Personally Identifiable Information Indicator EN * Business Attribute Notes EN * Business Attribute Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And Application * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application SW Window Name EN * PF Application SW Field Name EN * PF Application Software Nickname EN * Data Issue BA Column And Application Notes EN * Data Issue BA Column And Application Notes 2NDL * IBG Create Date Time DG RACI Business Attribute And Person * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF RACI Person Name * PF RACI Code EN * F Data Governance Role Code EN * RACI Start Date * RACI End Date * RACI Notes EN * RACI Notes 2NDL * IBG Create Date



XREF - Business Attribute 360 - WKRP

IBG Business Attribute DQ Colors * PF DQ Rule Number SKEY * PF DQ Color Code EN * DQ Color Low Range Percentage * DQ Color High Range Percentage * F DQ Color Range Approved By Person Name * DQ Color Range Notes EN * DQ Color Range Notes 2NDL * IBG Create Date Time IBG Business Intelligence Object * P BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * BI Object Name 2NDL * F Business Metadata Status Code EN * F BI Application Software Nickname EN * BI Hyperlink * BI Object Description EN * BI Object Description 2NDL * F Protected Level Code EN * F Sensitivity Level Code EN * Business Intelligence Object Notes EN * Business Intelligence Object Notes 2NDL * IBG Create Date Time IBG Database Management System * P DBMS Name * DBMS Vendor Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Subject Area * P Subject Area Name EN * Subject Area Name 2NDL * Subject Area Definition EN * Subject Area Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Subject Area Notes EN * Subject Area Notes 2NDL * IBG Create Date Time IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG XREF BA Column And BI Object * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Business Attribute Column BI Object Notes EN * Business Attribute Column BI Object Notes 2NDL * IBG Create Date Time IBG Column * P Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Business Entity * P Business Entity Name EN * PF Subject Area Name EN * Business Entity Name 2NDL * Business Entity Definition EN * Business Entity Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * F Sensitivity Level Code EN * F Protected Level Code EN * Business Entity Notes EN * Business Entity Notes 2NDL * IBG Create Date Time IBG Business Attribute Document * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * P Document Name EN * Document Name 2NDL * Document Hyperlink EN * Document Hyperlink 2NDL * Business Attribute Document Notes EN * Business Attribute Document Notes 2NDL * IBG Create Date Time IBG Table or View * P Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Application Software * P Application Software Nickname EN * Application Software Nickname 2NDL * Application Software Full Name EN * Application Software Full Name 2NDL * Application Software Vendor Name * Application Software Hyperlink * Application Software Description EN * Application Software Description 2NDL * Application Software Notes EN * Application Software Notes 2NDL * IBG Create Date Time IBG Application Software Field * PF Application Software Nickname EN * P Application SW Window Name EN * P Application SW Field Name EN * Application SW Window Name 2NDL * Application SW Field Name 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time IBG Schema * P Schema Name * PF Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Business Attribute Core * P Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * Business Attribute Name 2NDL * Business Attribute Definition EN * Business Attribute Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Default Value EN * Default Value 2NDL * Data Entry Guidelines EN * Data Entry Guidelines 2NDL * Derivation Rule EN * Derivation Rule 2NDL * Usage Guidelines EN * Usage Guidelines 2NDL * Mosaic Caution EN * Mosaic Caution 2NDL * Masking Rule EN * Masking Rule 2NDL * Archive Rule EN * Archive Rule 2NDL * Purge Rule EN * Purge Rule 2NDL * F Operational Reference Master Code EN * F Protected Level Code EN * F Sensitivity Level Code EN * F Personally Identifiable Information Indicator EN * Business Attribute Notes EN * Business Attribute Notes 2NDL * IBG Create Date Time IBG Database * P Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Business Attribute DQ Rules * P DQ Rule Number SKEY * F DQ Dimension Code EN * F Business Attribute Name EN * F Business Entity Name EN * F Subject Area Name EN * F DQ Rule Owner Business Unit Acronym EN * DQ Rule Criteria Text EN * DQ Rule Criteria Text 2NDL * F DQ Rule Approved By Person Name * DQ Rule Notes EN * DQ Rule Notes 2NDL * IBG Create Date Time



XREF - Business Attributes, Applications, and BI Objects

IBG Business Intelligence Object * P BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * BI Object Name 2NDL * F Business Metadata Status Code EN * F BI Application Software Nickname EN * BI Hyperlink * BI Object Description EN * BI Object Description 2NDL * F Protected Level Code EN * F Sensitivity Level Code EN * Business Intelligence Object Notes EN * Business Intelligence Object Notes 2NDL * IBG Create Date Time IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG XREF BA Column And BI Object * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Business Attribute Column BI Object Notes EN * Business Attribute Column BI Object Notes 2NDL * IBG Create Date Time IBG Column * P Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Notes EN * Notes 2NDL * IBG Create Date Time IBG Application Software * P Application Software Nickname EN * Application Software Nickname 2NDL * Application Software Full Name EN * Application Software Full Name 2NDL * Application Software Vendor Name * Application Software Hyperlink * Application Software Description EN * Application Software Description 2NDL * Application Software Notes EN * Application Software Notes 2NDL * IBG Create Date Time IBG Application Software Field * PF Application Software Nickname EN * P Application SW Window Name EN * P Application SW Field Name EN * Application SW Window Name 2NDL * Application SW Field Name 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time IBG Business Attribute Core * P Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * Business Attribute Name 2NDL * Business Attribute Definition EN * Business Attribute Definition 2NDL * F Business Metadata Status Code EN * F Business Metadata Approved By Person Name * Business Metadata Approved Date * Default Value EN * Default Value 2NDL * Data Entry Guidelines EN * Data Entry Guidelines 2NDL * Derivation Rule EN * Derivation Rule 2NDL * Usage Guidelines EN * Usage Guidelines 2NDL * Mosaic Caution EN * Mosaic Caution 2NDL * Masking Rule EN * Masking Rule 2NDL * Archive Rule EN * Archive Rule 2NDL * Purge Rule EN * Purge Rule 2NDL * F Operational Reference Master Code EN * F Protected Level Code EN * F Sensitivity Level Code EN * F Personally Identifiable Information Indicator EN * Business Attribute Notes EN * Business Attribute Notes 2NDL * IBG Create Date Time



XREF - Business Entity And Table or View

IBG XREF BE And Table Or View * PF Business Entity Name EN CHAR (64) * PF Subject Area Name EN CHAR (64) * PF Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Business Entity And Table View Notes EN VARCHAR (8000) * Business Entity And Table View Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Business Entity * P Business Entity Name EN CHAR (64) * PF Subject Area Name EN CHAR (64) * Business Entity Name 2NDL CHAR (64) * Business Entity Definition EN VARCHAR (8000) * Business Entity Definition 2NDL VARCHAR (8000) * F Business Metadata Status Code EN CHAR (64) * F Business Metadata Approved By Person Name CHAR (128) * Business Metadata Approved Date DATE * F Sensitivity Level Code EN CHAR (64) * F Protected Level Code EN CHAR (64) * Business Entity Notes EN VARCHAR (8000) * Business Entity Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME IBG Table or View * P Table or View Name CHAR (64) * PF Schema Name CHAR (64) * PF Database Name CHAR (64) * PF DBMS Name CHAR (64) * Notes EN VARCHAR (8000) * Notes 2NDL VARCHAR (8000) * IBG Create Date Time DATETIME



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

IBG Business Intelligence Object * P BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * BI Object Name 2NDL * F Business Metadata Status Code EN * F BI Application Software Nickname EN * BI Hyperlink * BI Object Description EN * BI Object Description 2NDL * F Protected Level Code EN * F Sensitivity Level Code EN * Business Intelligence Object Notes EN * Business Intelligence Object Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And BI Object * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Data Issue BA Column And BI Object Notes EN * Data Issue BA Column And BI Object Notes 2NDL * IBG Create Date Time DG Data Issue And Person * PF Data Issue ID * PF Person Name * F Data Governance Role Code EN * Data Issue And Person Notes EN * Data Issue And Person Notes 2NDL * IBG Create Date Time IBG XREF BA And Column * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * Business Attribute And Column Notes EN * Business Attribute And Column Notes 2NDL * IBG Create Date Time IBG XREF BA Column And BI Object * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF BI Object Name EN * PF BI Object Type EN * PF BI Accountable Business Unit Acronym EN * Business Attribute Column BI Object Notes EN * Business Attribute Column BI Object Notes 2NDL * IBG Create Date Time IBG Application Software Field * PF Application Software Nickname EN * P Application SW Window Name EN * P Application SW Field Name EN * Application SW Window Name 2NDL * Application SW Field Name 2NDL * Notes EN * Notes 2NDL * IBG Create Date Time DG Data Issue And Business Unit * PF Data Issue ID * PF Data Issue Impact Code EN * PF Business Unit Acronym EN * PF Point Of Contact Person Name * Data Issue Impact Notes EN * Data Issue Impact Notes 2NDL * IBG Create Date Time DG Data Issue Register * P Data Issue ID * Data Issue Title EN * Data Issue Title 2NDL * Data Issue Description EN * Data Issue Description 2NDL * Data Issue Documentation Folder Hyperlink * F Data Issue Category Code EN * F Data Issue Severity Code EN * Data Issue Identification Date * Data Issue Notes EN * Data Issue Notes 2NDL * IBG Create Date Time DG XREF Data Issue In Other Tracker * PF Data Issue ID * PF Issue Tracking Application Software Nickname EN * P Data Issue ID In Other Issue Tracking Application * Data Issue Hyperlink In Other Issue Tracking Application * Data Issue XREF Notes EN * Data Issue XREF Notes 2NDL * IBG Create Date Time IBG XREF BA Column And Application * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application Software Nickname EN * PF Application SW Window Name EN * PF Application SW Field Name EN * F System Of Record Or Reference Code EN * Business Attribute Column Application Notes EN * Business Attribute Column Application Notes 2NDL * IBG Create Date Time IBG XREF BA Data Issue And Application * PF Data Issue ID * PF Business Attribute Name EN * PF Business Entity Name EN * PF Subject Area Name EN * PF Column Name * PF Table or View Name * PF Schema Name * PF Database Name * PF DBMS Name * PF Application SW Window Name EN * PF Application SW Field Name EN * PF Application Software Nickname EN * Data Issue BA Column And Application Notes EN * Data Issue BA Column And Application Notes 2NDL * IBG Create Date Time