S_TN_AUD_EXTRACT_080_S (ver 18.5.0)
This table is a stand alone audit table to record data changes related to the 080 extract.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ChangedCoreColumnNames | 18.5.0 | Varchar2(4000) | List of column names changed. |
| DataVersion | 18.5.0 | Varchar2(50) | Generated identifier of the data change event. |
| DMLDate | 18.5.0 | Date | Data Transaction Date. |
| DML_Type | 18.5.0 | Varchar2(5) | Data Transaction Type. |
| E_StoredGradesDCID | 18.5.0 | Number(11,0) | DCID of the StoredGrades record that changed (logical key). |
| E_SectionsDCID | 18.5.0 | Number(11,0) | DCID of the Sections record that changed (logical key). |
| E_CoursesDCID | 18.5.0 | Number(11,0) | DCID of the Courses record that changed (logical key). |
| E_StudentsDCID | 18.5.0 | Number(11,0) | DCID of the Students record that changed (logical key). |
| E_SchoolsDCID | 18.5.0 | Number(11,0) | DCID of the Schools record that changed (logical key). |
| E_StudentID | 18.5.0 | Number(11,0) | ID of the Student record that changed (logical key). |
| E_SSN | 18.5.0 | Varchar2(12) | SSN (logical key). |
| E_StudentPIN | 18.5.0 | Varchar2(9) | Student Pin (logical key). |
| E_State_StudentNumber | 18.5.0 | Varchar2(32) | State Student Number (logical key). |
| E_SchoolYear | 18.5.0 | Varchar2(4) | School Year associated with the changed record (logical key). |
| E_Track | 19.3.0 | Varchar2(20) | Track (logical key). |
| E_SectionID | 18.5.0 | Number(11,0) | ID of the Section record that changed (logical key). |
| E_TermID | 18.5.0 | Number(11,0) | ID of the Term record that changed (logical key). |
| E_SchoolID | 18.5.0 | Number(11,0) | ID of the School record associated with the student that changed (logical key). |
| E_SGSchoolID | 18.5.0 | Number(11,0) | ID of the School record associated with stored grade record that changed (logical key) |
| E_AlternateDistrictCourseNum | 18.5.0 | Varchar2(5) | Alternate District Course Number (logical key). |
| E_Alt_Course_Number | 18.5.0 | Varchar2(4000) | Alternate Course Number (logical key). |
| E_StoreCode | 19.3.0 | Varchar2(10) | Store Code associated with the historical grade record (logical key). |
| E_ExcludeStudent | 18.5.0 | Number(1,0) | Exclude student record from state reporting (logical key). |
| E_ExcludeSchool | 18.5.0 | Number(1,0) | Exclude school record from state reporting (logical key). |
| E_ExcludeSection | 18.5.0 | Number(1,0) | Exclude section record from state reporting (logical key). |
| E_ExcludeStoredGrade | 18.5.0 | Number(1,0) | Exclude historical grade record from state reporting (logical key). |
| IsCourseSection | 18.5.0 | Number(1,0) | Flag to report extracts as Course.Section. |
| N_StoreCode | 19.3.0 | Varchar2(10) | New store code associated with the historical grade record. |
| N_TransitionalGrade | 18.5.0 | Number(1,0) | New transitional grade flag. |
| N_PrivatePaid | 19.3.0 | Varchar2(2) | New private paid code. |
| N_Alt_Course_Number | 18.5.0 | Varchar2(4000) | New alternate course number. |
| N_CourseNumber | 18.5.0 | Varchar2(11) | New course number. |
| N_AlternateDistrictCourseNum | 18.5.0 | Varchar2(5) | New alternate district course number. |
| N_SectionNumber | 18.5.0 | Varchar2(11) | New section number. |
| N_CreditsAtt | 18.5.0 | Number(25,10) | New credits attempted. |
| N_CreditsEarned | 18.5.0 | Number(25,10) | New credits earned. |
| N_GradeLevel | 18.5.0 | Number(11,0) | New student grade level associated with this grade. |
| N_AlphaGrade | 18.5.0 | Varchar2(7) | New alpha grade value. |
| N_NumericGrade | 18.5.0 | Number(25,10) | New numeric grade value. |
| N_GradeScale_Name | 19.3.0 | Varchar2(50) | New grade scale name. |
| N_QualityPoints | 18.5.0 | Varchar2(2) | New quality points value. |
| N_ExcludeStudent | 18.5.0 | Number(1,0) | New exclude student record from state reporting flag. |
| N_ExcludeSchool | 18.5.0 | Number(1,0) | New exclude school record from state reporting flag. |
| N_ExcludeSection | 18.5.0 | Number(1,0) | New exclude section record from state reporting flag. |
| N_ExcludeStoredGrade | 18.5.0 | Number(1,0) | New exclude historical grade record from state reporting flag. |
| O_StoreCode | 19.3.0 | Varchar2(10) | Old store code associated with the historical grade record. |
| O_TransitionalGrade | 18.5.0 | Number(1,0) | Old transitional grade flag. |
| O_PrivatePaid | 19.3.0 | Varchar2(2) | Old private paid code. |
| O_Alt_Course_Number | 18.5.0 | Varchar2(4000) | Old alternate course number. |
| O_CourseNumber | 18.5.0 | Varchar2(11) | Old course number. |
| O_AlternateDistrictCourseNum | 18.5.0 | Varchar2(5) | Old alternate district course number. |
| O_SectionNumber | 18.5.0 | Varchar2(11) | Old section number. |
| O_CreditsAtt | 18.5.0 | Number(25,10) | Old credits attempted. |
| O_CreditsEarned | 18.5.0 | Number(25,10) | Old credits earned. |
| O_GradeLevel | 18.5.0 | Number(11,0) | Old student grade level associated with this grade. |
| O_AlphaGrade | 18.5.0 | Varchar2(7) | Old alpha grade value. |
| O_NumericGrade | 18.5.0 | Number(25,10) | Old numeric grade value. |
| O_GradeScale_Name | 19.3.0 | Varchar2(50) | Old grade scale name. |
| O_QualityPoints | 18.5.0 | Varchar2(2) | Old quality points value. |
| O_ExcludeStudent | 18.5.0 | Number(1,0) | Old exclude student record from state reporting flag. |
| O_ExcludeSchool | 18.5.0 | Number(1,0) | Old exclude school record from state reporting flag. |
| O_ExcludeSection | 18.5.0 | Number(1,0) | Old exclude section record from state reporting flag. |
| O_ExcludeStoredGrade | 18.5.0 | Number(1,0) | Old exclude historical grade record from state reporting flag. |
| StateEventQueueDCID | 18.5.0 | Number(11,0) | DCID of record saved in the StateEventQueue. |
| TableName | 18.5.0 | Varchar2(50) | Name of the updated table. |
| UserID | 18.5.0 | Varchar2(11) | User ID who made the change. |