S_VA_STU_CRDNTLEXAMRSLT_C (ver 14.6.0)
This table is a child table of the [Students] table and stores students' credential exam results.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.6.0 | Number(10,0) | System generated primary key. |
CredentialAwarded | 14.6.0 | Number(1,0) | Flag to indicate the credential was awarded. |
CTECourseCode | 14.6.0 | Varchar2(4) | The CTE Course Code associated with the exam. |
ExamCost | 14.6.0 | Number(25,10) | The actual cost of the examination to a student or school division. |
ExamDate | 14.6.0 | Date | Date the exam was administered. |
ExamPassed | 14.6.0 | Number(1,0) | Flag to indicate the student passed the exam. |
| SCEDCode | 17.3.0 | Varchar2(10) | SCED code - concatenates SCED_Subject_Area + SCED_Course_Identifier |
| SCEDExtendedDescription | 17.3.0 | Varchar2(10) | Extended Description - comes from S_VA_CRS_X.ExtendedDescription |
ServingSchoolID | 14.6.0 | Number(11,0) | The Serving School associated with the student's exam result. |
State_ExcludeFromReporting | 14.6.0 | Number(1,0) | Flag indicating the exam result should be excluded from state reports. |
StudentsDCID | 14.6.0 | Number(10,0) | Foreign key to [Students]DCID. |
S_VA_CredentialExams_SID | 14.6.0 | Number(11,0) | Foreign key to [S_VA_CredentialExams_S]ID. |
UsedForVerifiedCredit | 14.6.0 | Number(1,0) | Flag indicating the exam result may be used as verified credit. |