AB_SECTION
This table stores course sections data.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_SectionID | 16.5.0 | NUMBER(19,0) | Primary Key |
Credits_Offered | 16.5.0 | Varchar2(20) | The amount of credit awarded for completing a course. |
Delivery_Sched | 16.5.0 | Varchar2(20) | Indicates the funding/delivery schedule of this section. Valid values: REG=Regular, ENG=Evening, SAT=Weekend. |
Description | 16.5.0 | NUMBER(19,0) | The description of the section in PASI. Is made up of (Course Number).(Section Number) - (Course Name) in PowerSchool. |
Effective_Date | 16.5.0 | DATE | Date this section is valid. |
End_Date | 16.5.0 | DATE | Date this section ends. |
Instruct_Lang | 16.5.0 | Varchar2(5) | Language the section is taught. |
Instruct_Mins | 16.5.0 | NUMBER(5,0) | Indicates the amount of minutes the section is taught. |
Is_Deleted | 16.5.0 | NUMBER(1,0) | Indicates whether this section is deleted. Valid values: 1=Yes, 0=No. Required. |
Local_Section_ID | 16.5.0 | Varchar2(20) | The SectionID of the Section record in PowerSchool. |
PASI_CoreVersion | 16.5.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
Primary_Del_Method | 16.5.0 | Varchar2(5) | Indicates the primary delivery method of this section. |
RefID | 16.5.0 | Varchar2(36) | Unique system identifier. |
School_Code | 16.5.0 | Varchar2(10) | The Alberta school code. |
School_Year | 16.5.0 | NUMBER(5,0) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
Section_Term | 16.5.0 | Varchar2(50) | Term the section is offered. |
Start_Date | 16.5.0 | DATE | Date this section starts. |
WhoCreated | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhenCreated | 16.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
WhoModified | 16.5.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
WhenModified | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
Local_ID | 16.5.0 | Varchar2(100) | The DCID of the Section record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables. |