This table stores evaluated marks information.
The Alberta Course Code
The amount of credit awarded for completing a course.
|Effective_UTC||16.5.0||DATE||Date the mark is valid.|
|Eval_Date||16.5.0||DATE||Date the mark was awarded.|
|Eval_Method||16.5.0||Varchar2(10)||Indicates the course evaluation method.|
|Is_Deleted||16.5.0||NUMBER(1,0)||Indicates whether the mark is deleted. Valid values: 1=Yes, 0=No. Required.|
|Is_Funding_Req||16.5.0||NUMBER(1,0)||Indicates whether funding has been requested for this mark. Valid values: 1=Yes, 0=No. Required.|
|Is_Mark_Approved||16.5.0||NUMBER(1,0)||Indicates whether the mark is approved. Valid values: 1=Yes, 0=No. Required.|
|Mark_Format||16.5.0||Varchar2(10)||Indicates the format of the mark.|
|Mark_Value||16.5.0||Varchar2(3)||The student's awarded mark value.|
|ORG_Code||16.5.0||Varchar2(10)||Organization code with prefix|
|PASI_CoreVersion||16.5.0||NUMBER(19,0)||Unique number allowing for easy identification of when an entity has changed.|
|RefID||16.5.0||Varchar2(36)||Unique system identifier|
|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.|
The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school.
The DCID of the StoredGrade record in PowerSchool - This is the link between the PASI tables and the PowerSchool tables.
|WhoCreated||16.5.0||Varchar2(100)||The name of the person who created the record. Defaults to the 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 the person who modified the record. Defaults to the user.|
|WhenModified||16.5.0||TIMESTAMP(6)||The date and time the record was modified. Defaults to system date.|