FTE, 159 (ver4.0.0)
This tables stores Full Time Equivalency information for a school in a given year for the various full time, part time, etc. and their associated attendance values.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Dflt_Att_Mode_Code | 4.0.4 | Varchar(13) | Default attendance mode code. Note: Updated 5.0.0. |
Dflt_Conversion_Mode_Code | 4.0.4 | Varchar(11) | Default conversion mode code. |
Description | 4.0.0 | CLOB | Text description for this FTE value record. |
FTE_Value | 4.0.0 | Float | Actual value of this FTE record. This value can be in decimals. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 4.0.0 | Varchar(80) | Name provided for this FTE value record. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
YearID | 4.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Indexed. |