S_ON_STU_FrenchCards_C ver 19.5.1.0
This table is a child table of Students and stores French Card information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 19.5.1.0 | Number(11,0) | Primary key |
StudentsDCID | 19.5.1.0 | Number(10,0) | Primary key that relates the extended table to the [Students] table |
YearID | 19.5.1.0 | Number(11) | For report generated data, Year ID will have the [Terms] table yearID for the Year |
| SchoolID | 19.5.1.0 | Number(11) | For report generated data and for user entered data, School ID will have the [Schools] table school_number |
| YearPercentage | 19.5.1.0 | Number(11) | Year Percentage is derived and based on percent of Days Enrolled to Total In Session Days for class. |
| SchoolYearStart | 19.5.1.0 | Varchar2(4) | For user entered data, School Year Start should be the start of the school year for data entered (format YYYY) |
| SchoolYearEnd | 19.5.1.0 | Varchar2(4) | For user entered data, School Year End should be the end of the school year for data entered (format YYYY) |
| SchoolName | 19.5.1.0 | Varchar2(60) | For user entered data, the School Name can be entered |
| GradeLevel | 19.5.1.0 | Number(11) | Grade Level - report generated from [Students/Reenrollments] table grade_level |
| GradeLevelUser | 19.5.1.0 | Varchar2(10) | Grade Level - user entered. This can be one grade or a range of grades. |
| LanguageProgramType | 19.5.1.0 | Varchar2(3) | For report generated data, Lang_Pgm_Type[S_ON_CRS_X/S_ON_SEC_X] For user entered data, valid values are C, E, I, N and X (French Exempt) |
| CCDCID | 19.5.1.0 | Number(11) | Primary key that relates the extended table to the CC table |
| SpenrollmentsDCID | 19.5.1.0 | Number(11) | Primary key that relates the extended table to the Spenrollments table |
| FrenchExemptFlag | 19.5.1.0 | Number(1) | Flag indicating whether student is French Exempt. |
| EnrollmentSource | 19.5.1.0 | Varchar2(1) | For report generated data, EnrollmentSource indicates data coming from Students table / reenrollments table if values are 'S' and 'R' respectively |
| EnrollmentID | 19.5.1.0 | Number(11) | For report generated data, EnrollmentID[Students]/RecordID[Reenrollments] |
| ClassProgramStartDate | 19.5.1.0 | Date | For report generated data, Enter_Date[spEnrollments]/ DateEntered[CC] |
| ClassProgramEndDate | 19.5.1.0 | Date | For report generated data, Exit_Date[spEnrollments]/DataLeft[CC] |
| Subjects | 19.5.1.0 | Varchar2(4000) | Derived list of unique Subjects where the Sections language of instruction is set to French, not including the subject of French. The list is comma delimited. |
| Hours | 19.5.1.0 | Number(25,10) | When Report Generated, Hours is derived based on Days Enrolled and Minutes of Instruction for the Language Program Type. Format: round to one decimal place When User entered data, Hours can be entered by the user. Format with one decimal place. |
| SourceType | 19.5.1.0 | Varchar2(1) | For report generated data, 'R' For user generated data, 'U' |
| LockStatus | 19.5.1.0 | Number(1) | Flag indicating whether record is locked |
| BoardName | 19.5.1.0 | Varchar2(20) | districtnumber [Prefs] or anything entered on report UI |