S_MD_LOG_X (ver 14.7.0)
This table is an extension of the [Log] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Logdcid | 14.7.0 | Number (10,0) | Primary Key |
CRDC_Corporal_Punishment_TF | 14.7.0 | Number (1,0) | Student received Corporal Punishment. |
CRDC_Exp_ZeroTolerance_TF | 14.7.0 | Number (1,0) | Student received an Expulsion under Zero Tolerance Policies. |
| CRDC_Harass_Religion_TF | 16.1.0 | Number (1,0) | Harassment or Bullying on the basis of Religion |
| CRDC_Harass_Orientation_TF | 16.1.0 | Number (1,0) | Harassment or Bullying on the basis of Sexual Orientation |
| CRDC_Offense_Category | 16.1.0 | Varchar2 (4) | Offense Category |
| ELL | 21.7.2.0 | Varchar2(1) | ELL Indicator |
| Sec504_Plan_YN | 22.12.1.0 | Varchar2 (1) | 504 Indicator with a string value. |
| FARMS_Expanded | 18.7.0 | Number (1,0) | When reporting a Log Entry, this field will specify a students lunch status on the incident date. |
| Migrant_YN | 22.12.1.0 | Varchar2 (1) | Migrant Indicator with a string value. |
| Special_Education | 22.12.1.0 | Varchar2 (2) | Special Education with a string value. |
| SPED | 16.12.3 | Number (1,0) | SPED |
| Title_One_YN | 22.12.1.0 | Varchar2 (1) | Title I Indicator with a string value. |
| Suspension_Date | 16.12.3 | Date | Suspension Date |
| Suspension_Num_Days | 16.12.3 | Double | Suspension Days |
| Administrator_Code | 16.12.3 | Varchar2 (100) | Administrator Code |
| Disability_Code | 16.12.3 | Varchar2 (20) | Disability Codes |
| Disposition_Code | 16.12.3 | Varchar2 (20) | Disposition Code |
| Ed_Services | 16.12.3 | Varchar2 (10) | Educational Services Provided |
| Infraction_Code | 16.12.3 | Varchar2 (20) | Offense Code |
| Length_Removal | 16.12.3 | Varchar2 (5) | Length of Removal |
| Location_Code | 16.12.3 | Varchar2 (20) | Location Code |
| Physical_Injury | 16.12.3 | Varchar2 (1) | Physical Injury |
| Suspension_Day_Of_Week | 16.12.3 | Varchar2 (1) | Suspension Day of Week |
| Teacher_Referral | 16.12.3 | Varchar2 (4000) | Teacher Referral |
| FARMS | 16.12.3 | Number (1,0) | Obsolete. Replaced by FARMS_Expanded. |
| LEP | 16.12.3 | Number (1,0) | LEP Indicator - Obsolete replaced by ELL |
| Migrant | 16.12.3 | Number (1,0) | Migrant Indicator. Obsolete replaced by Migrant_YN in 22.12.1.0 |
| Sec504_Plan | 16.12.3 | Number (1,0) | 504 Indicator. Obsolete replaced by Sec504_Plan_YN in 22.12.1.0. |
| Special_Ed | 16.12.3 | Number (1,0) | Special Education. Obsolete replaced by Special_Education in 22.12.1.0 |
| Title_One | 16.12.3 | Number (1,0) | Title I Indicator. Obsolete replaced by Title_One_YN in 22.12.1.0 |