Attendance_Conversion_Items, 132 (ver3.6.1)
Defines the number of periods in which the student must be present in order to receive the number of points defined, such as full attendance = 1.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Attendance_Conversion_ID | 3.6.1 | Number(10,0) | The internal number for the Attendance Conversion with which this record is associated. Indexed. |
Attendance_Value | 4.0.0 | Float | Changed name from Membership_Percentage to better reflect the data. This is the attendance value to use for a student for a day based on the Conversion_Mode_CD, FTEID and Input_Value specified (and DayPartID, if day part processing is enabled). This value is a real number and typically, but not necessarily, reflects a fraction of 1 where 1 is a full attendance value. Used in conjunction with ADA to aggregate attendance. |
Comment_Value | 3.6.1 | CLOB | Information regarding this Conversion Item to help in its clarity. |
Conversion_Mode_Code | 4.0.0 | Varchar(10) | Changed name from Att_Mode_CD to better reflect the data. One of three values: periodday, codeday, timeday. This field indicates the conversion mode associated with the specific conversion item. Section attendance will use periodday, daily attendance will use codeday and all can use timeday. Used in conjunction with Input_Value and FTEID (and DayPartID, if day part processing is enabled) that determines which record to use to return the Attendance_Value. |
DayPartI D | 7.2.2 | Number(10,0) | Day part with which this attendance conversion item is associated. Optional, used only if day part processing is enabled (att_daypartenabled is set to true). |
DCID | 4.0.0. | Number(10,0) | Unique identifier for this table. Indexed. Required. |
FTEID | 4.0.0 | Number(10,0) | The internal number for the FTE with which this record is associated. Indexed. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Input_Value | 4.0.0 | Number(10,0) | Changed name from Number_Of_Periods to better reflect the data. Used to only support periodday conversion. Now the application supports two other conversion modes, codeday and timeday. Therefore, this field name was changed to be more generic. |
Unused | 4.0.0 | Number(10,0) | Unused at this time. |