Skip to main content
Skip table of contents


This table stores course sections data.

Column Name


Data Type





Primary Key

Credits_Offered16.5.0Varchar2(20)The amount of credit awarded for completing a course.
Delivery_Sched16.5.0Varchar2(20)Indicates the funding/delivery schedule of this section. Valid values: REG=Regular, ENG=Evening, SAT=Weekend.
Description16.5.0NUMBER(19,0)The description of the section in PASI. Is made up of (Course Number).(Section Number) - (Course Name) in PowerSchool.
Effective_Date16.5.0DATEDate this section is valid.
End_Date16.5.0DATEDate this section ends.
Instruct_Lang16.5.0Varchar2(5)Language the section is taught.
Instruct_Mins16.5.0NUMBER(5,0)Indicates the amount of minutes the section is taught.

Indicates whether this section is deleted. Valid values: 1=Yes, 0=No. Required.

Local_Section_ID16.5.0Varchar2(20)The SectionID of the Section record in PowerSchool.
PASI_CoreVersion16.5.0NUMBER(19,0)Unique number allowing easy identification of when an entity has changed.
Primary_Del_Method16.5.0Varchar2(5)Indicates the primary delivery method of this section.

Unique system identifier.

School_Code16.5.0Varchar2(10)The Alberta school code.
School_Year16.5.0NUMBER(5,0)A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. 
Section_Term16.5.0Varchar2(50)Term the section is offered.
Start_Date16.5.0DATEDate this section starts.
WhoCreated16.5.0Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated16.5.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified16.5.0Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified16.5.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date

The DCID of the Section record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables.

JavaScript errors detected

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

If this problem persists, please contact our support.