Skip to main content
Skip table of contents

AB_COURSE_CREDIT_VERSION

This table is child table of AB_COURSE_PERMISSION, stores information on locally developed courses identifying which organizations can offer the course and at what credit level(s).  

Column Name

Version

Data Type

Description

ID

16.5.0

NUMBER(19,0)

Primary Key

COURSEPERMISSIONID16.5.0NUMBER(19,0)The ID from the AB_COURSE_PERMISSION table
CREDITVERSION22.7.1NUMBER(5)

Identifies the number of credits for which the course can be offered. Typically, this is 1, 3 or 5 credits but can be any number.

EFFECTIVEENDDATE22.7.1DATEThe effective end date for the credit version on the course permission.
EFFECTIVESTARTDATE16.5.0DATE

The effective start date for the credit version on the course permission.

FIRSTSCHOOLYEAR16.5.0NUMBER(4)Identifies the first school year the school authority is permitted to offer the course.
LASTSCHOOLYEAR16.5.0NUMBER(4)Identifies the last school year the school authority is permitted to offer the course.
USEEFFECTIVEDATES22.7.1NUMBER(1)Determine whether to use the FirstSchoolYear/LastSchoolYear or the EffectiveStartDate and EffectiveEndDate. If TRUE then the effective dates should be used.
WHOCREATED16.5.0Varchar2(100)The name of the person who created the record. Defaults to the user.
WHENCREATED16.5.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WHOMODIFIED16.5.0Varchar2(100)The name of the person who modified the record. Defaults to the user.
WHENMODIFIED16.5.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.