Skip to main content

Table

competencyassessments

Each row represents a competency assessment definition with title and metadata, scoped to a company.

statusgroupRedshift
All tables

competencyassessments

Each row represents a competency assessment definition with title and metadata, scoped to a company.

Full schema

View all columns and table relationships (SchemaSpy)

Status group

Yes, this table includes a statusgroup column. See Status Group for details.

Column details

ColumnType
idvarchar(36)
companyidvarchar(36)
titlevarchar(256)
createdattimestamp
updatedattimestamp
statusgroupvarchar(256)
statusgroupupdatedattimestamp

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

Platform Documentation

Sample query

select
  t.title
from competencyassessments as t
limit 100