AssetCourseAssoc (ver21.4.0)

This table stores the course association details for an asset type. A foreign key for assetId (mapped to the id of the asset table) and courseDcid (mapped to the dcid of the courses table) is in place for data integrity.

Column Name

Initial Version

Data Type

Description

ASSETID21.4.0NUMBER(19,0)The primary key of Asset table. FK has been created which maps to ASSET.ID. Required. Indexed.
COURSESDCID21.4.0NUMBER(10,0)Reference to the DCID of the course record associated with this asset type. Required. Indexed.
ID21.4.0NUMBER(19,0)The unique sequential number generated by the application. Indexed. Required.
WhenCreated21.4.0TIMESTAMP(6)The date and time the record was created. Defaults to system date. Required.
WhenModified21.4.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated21.4.0VARCHAR2(100 CHAR)The name of the person who created the record. Defaults to user. Required.
WhoModifed21.4.0VARCHAR2(100 CHAR)The name of the person who modified the record. Defaults to the user. Required.

Copyright © 2021 PowerSchool Group LLC