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. |