---
title: "Gold Compliance"
slug: "gold-compliance"
updated: 2026-06-25T07:48:18Z
published: 2026-06-25T07:48:25Z
canonical: "docs.thrivelearning.com/gold-compliance"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Gold Compliance

This section provides detailed descriptions for all data points related to mandatory training and certifications in Thrive. Each article includes the table name, the columns within each table, the data type for each column, and a user-friendly description of what each column represents.

## Table Relationships

To help you visualise how the tables connect, the following Entity-Relationship Diagram (ERD) serves as a visual map of the tables and their primary and foreign keys.

![Diagram illustrating relationships between various data entities in a compliance service system.](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/diagram(6).jpg?sv=2026-02-06&spr=https&st=2026-11-05T19%3A04%3A32Z&se=2026-11-05T20%3A04%3A32Z&sr=c&sp=r&sig=n1zoquCs27Mwov5TmjWvJPtzTPoM4hLKLytAeKKiN%2BA%3D)

```plaintext
erDiagram
FCT_COMPLIANCE_SERVICE_ASSIGNMENTS }o--|| DIM_AUDIENCE_SERVICE_AUDIENCES : "assigned to"
FCT_COMPLIANCE_SERVICE_ASSIGNMENTS ||--o{ FCT_COMPLIANCE_SERVICE_ENROLMENTS : "includes"
DIM_USER_SERVICE_USERS ||--o{ BRG_USER_AUDIENCE : "member of"
DIM_USER_SERVICE_USERS ||--o{ DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS : "extends"
FCT_COMPLIANCE_SERVICE_ENROLMENTS }o--|| DIM_CONTENT_SERVICE_CONTENTS : "assigns"
FCT_COMPLIANCE_SERVICE_ENROLMENTS }o--|| DIM_USER_SERVICE_USERS : "enrolled user"
DIM_AUDIENCE_SERVICE_AUDIENCES ||--o{ BRG_USER_AUDIENCE : "has users"
DIM_CONTENT_SERVICE_CONTENTS ||--o{ BRG_CONTENT_TAGS : "tagged with"
"DIM_USER_GROUPS" ||--o{ "BRG_USER_GROUPS" : "has users"
"DIM_USER_SERVICE_USERS" ||--o{ "BRG_USER_GROUPS" : "member of"
"DIM_SPACES"
DIM_CONTENT_SERVICE_CONTENTS ||--o{ BRG_CONTENT_TRANSLATIONS : "translations available"
FCT_CPD_ACTIVITY }o--|| DIM_USER_SERVICE_USERS : "users CPD activity"
FCT_CPD_REQUIREMENTS }o--|| DIM_USER_SERVICE_USERS : "users CPD requirements"

FCT_COMPLIANCE_SERVICE_ASSIGNMENTS {
    text Assignment_ID PK
    text Primary_Content_ID PK,FK
    text Tenant_ID PK,FK
}
DIM_USER_SERVICE_USERS {
    text User_ID PK, FK
    text Tenant_ID PK
}
DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS {
    text User_ID PK,FK
    text Additional_Field_Key PK
    text Tenant_ID PK,FK
}
DIM_AUDIENCE_SERVICE_AUDIENCES {
    text Audience_ID PK
    text Tenant_ID PK,FK
}
FCT_COMPLIANCE_SERVICE_ENROLMENTS {
    text Enrolments_ID PK
    text Assignment_ID PK,FK
    text User_ID PK,FK
    text Primary_Content_ID PK,FK
    text Tenant_ID PK,FK
}
DIM_CONTENT_SERVICE_CONTENTS {
    text Content_ID PK
    text Tenant_ID PK
}
BRG_USER_AUDIENCE {
    text User_ID PK,FK
    text Audience_ID PK,FK
    text Tenant_ID PK,FK
}
BRG_CONTENT_TAGS {
    text Content_Tag PK
    text Content_ID PK,FK
    text Tenant_ID PK,FK
}
BRG_USER_GROUPS {
    text Group_ID PK,FK
    text User_ID PK,FK
    text Tenant_ID PK,FK
}
DIM_USER_GROUPS {
    text Group_ID PK
    text Tenant_ID PK,FK
}
DIM_SPACES {
    text Space_ID PK
    text Page_ID PK
    text Tenant_ID PK
}
BRG_CONTENT_TRANSLATIONS {
    text Content_Translation_Code PK
    text Content_ID PK,FK
    text Tenant_ID PK,FK
}
FCT_CPD_ACTIVITY {
    text Activity_ID PK
    text User_ID PK,FK
    text Tenant_ID PK,FK
}
FCT_CPD_REQUIREMENTS {
    text User_ID PK,FK
    text Tenant_ID PK,FK
}
```

> [!NOTE]
> Note:
> 
> Underscores are included in the ERD for syntax compliance, but the corresponding field names in Snowflake do not include the underscore.