PASI Direct Connect Tables
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. |