|
Table |
Description |
|---|---|
|
Local PASI Data Store |
|
|
AB_ENROLMENT |
School Enrollments |
|
AB_CODE_VALUE |
Stores mapping codes from Alberta |
|
AB_COURSE |
PASI Course information |
|
AB_COURSE_AUTH |
Stores who authorized a course |
|
AB_COURSE_CREDIT |
Course credit value |
|
AB_COURSE_CREDIT_EQ |
Is credit allowed |
|
AB_COURSE_DESCRIPTION |
The description of the course |
|
AB_COURSE_ENROLL |
Student course enrolments |
|
AB_COURSE_ENROLL_MARK |
Course marks for course enrolments |
|
AB_COURSE_PREREQ |
Prerequisite course data from PASI |
|
AB_COURSE_SEQ |
Course sequence information |
|
AB_CRED_REQ_EXEMPT |
Placeholder |
|
AB_CTS_COURSE |
CTS Courses |
|
AB_ENROLMENT_EXT_INFO |
School Enrollments Extended Information |
|
AB_EVAL_MARK |
Evaluated marks |
|
AB_LOCAL_AUTH |
Local authority course data |
|
AB_OFF_MARK |
Placeholder |
|
AB_OFF_MARK_SELECT |
Placeholder |
|
AB_PASISCHAUTHSCHINFO |
School Authority and Schools Information |
|
AB_PASISCHEDULERSTATUS |
Tracks status of quartz jobs |
|
AB_PASISTATUS |
Status Messages or Core Alerts |
|
AB_PASISTATUSARGUMENT |
Arguments for Core Alerts |
|
AB_PASISTATUSARGUMENTASSOC |
Association between Status Messages and Arguments |
|
AB_PREF_STUDENT_ADDRESS |
Preferred Student Address |
|
AB_PREF_STUDENT_NAME |
Preferred Student Name |
|
AB_PREF_STUDENT_PHONE_NUMBER |
Preferred Student Phone Number |
|
AB_SECONDARY_ASN |
Secondary Alberta Student Number |
|
AB_SECTION |
Sections |
|
AB_SECTION_CRSE_CODE |
Section Course Codes |
|
AB_STUDENT_ADDRESS |
Student Address List - includes address other than the preferred mailing address |
|
AB_STUDENT_CITIZENSHIP_INFO |
Student Citizenship Information |
|
AB_STUDENT_EXT_INFO |
Student Extended Information – for future use. |
|
AB_STUDENT_IDENT_INFO |
Student Identification Information |
|
AB_STUDENT_INFO |
Student Information – includes Section 23 eligibility and deceased status. |
|
AB_STUDENT_NAME |
Student Name List – includes legal and other names but not preferred name. |
|
AB_STUDENT_PHONE_NUMBER |
Student Phone Number List - includes phone numbers other than the preferred phone. |
|
AB_STUDENT_PROTECT_INFO |
Student Disclosure Restriction List |
|
AB_STUDENT_TRANS_DTL |
Placeholder |
|
AB_TRANS_CRED_REQ_EX |
Placeholder |
|
AB_TRANSCRIPT_CRED |
Placeholder |
|
Synchronization |
|
|
AB_PASISTUDENTSIDVERSION |
PASI Student Identification Version – matches students and their versions in PowerSchool to PASI. |
|
AB_PASIENROLMENTIDVERSION |
PASI Enrolment Identification Version – matches enrolments and their versions in PowerSchool to PASI. |
|
AB_PASISTATUSIDVERSION |
PASI Status Identification Version – matches status messages and their versions in PowerSchool to PASI. |
|
AB_PASICONFIG |
PASI Configuration – contains all the parameters used in setting up PASI Direct Connect. |
|
AB_DATA_EVENT_QUEUE_ARC |
Archive of data events |
|
AB_PASIMAXIDVERSION |
PASI IsDataAvailable - core version of last request. |
|
AB_PASI_LOG_QUEUE |
Logging queue |
|
AB_PASI_UPLOAD_STATUS |
Bulk uploads log |
|
PSSR_DATA_EVENT_QUEUE |
PASI Data Events Queue – contains all the events generated on data required for submission to PASI. |