S_SC_RPTADDONEXTRACT_C (ver 14.9.3)
This table is a child table of the S_SC_RPTADDONHEADER_S table and stores the detail information for the Add On Weightings Extract.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.9.3 | Number(11,0) | Primary Key. |
| S-SC_RPTADDONHEADER_SID | 14.9.3 | Number(11,0) | Foreign Key to link to the Header table. |
AddOnCode | 14.9.3 | Varchar2(5) | The code that determines the Add On Weighting classification. |
CountGrade0 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 0. |
CountGrade1 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 1. |
CountGrade2 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 2. |
CountGrade3 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 3. |
CountGrade4 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 4. |
CountGrade5 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 4. |
CountGrade6 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 6. |
CountGrade7 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 7. |
CountGrade8 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 8. |
CountGrade9 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 9. |
CountGrade10 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 10. |
CountGrade11 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 11. |
CountGrade12 | 14.9.3 | Number(11,0) | The total number of records for the AddOnCode for Grade 12. |
| CreatedDateTime | 14.9.3 | Date | The date and time the extract was created. |
| Day_Number | 14.9.3 | Number(11,0) | The day number for the extract record. |
| District_Code | 14.9.3 | Varchar2(10) | The District Number for the extract. |
| LineTotal | 14.9.3 | Number(11,0) | The total of all of the counts for this record ID. |
| School_Code | 14.9.3 | Varchar2(10) | The School Number for the extract. |
| SchoolID | 14.9.3 | Number(11,0) | The internal School ID. |