Dict-Physical

Table MD_GLFactAnnotation

Card of table MD_GLFactAnnotation

Name	MD_GLFactAnnotation
Dimensional Type	Dimension
Comment	Contains annotations that are attached to general-ledger transactions. Essentially, every transaction (debit, credit) that hits the general ledger gets an annotation. Many of these are hardcoded, meaning that there is a lot of repetition. The purpose of this dimensions is to reduce repetition/redundancy at the database level. Normally storage space isn't a big concern for our data warehouse, but this data is relative big and useless, so it makes sense (acc. to Kimball) to tuck it away in a real dimension rather than leaving it on fact rows as a degenerate dimension.

Check constraint name of the table MD_GLFactAnnotation

CKT_MD_GLFACTANNOTATION

List of incoming references of the table MD_GLFactAnnotation

Relationship_38

MF_GLFact

MD_GLFactNote_SurrogateKey

List of referencing views of the table MD_GLFactAnnotation

VMD_GLFactAnnotation

VMD_GLFACTANNOTATION

VW_GLInfoWithDynamicSecurity

VW_GLINFOWITHDYNAMICSECURITY

List of diagrams containing the table MD_GLFactAnnotation

StarsBusinessDiagram

List of columns of the table MD_GLFactAnnotation

MD_GLFactNote_SurrogateKey

<None>

numeric

MD_GLFactNote_Text

Text attached to general-ledger entry (contains some explanation of the transaction).

This field is best used in filters, not rows or columns in reports. It's too big. Everything here is also mapped to uppercase (ugh), because GL annotations often vary with respect to case.

<None>

varchar(128)

128

MD_GLFactNote_AuditKey

DW_AuditKey

bigint

MD_GLFactNote_Timestamp

<None>

timestamp