S_LA_STU_X (ver 14.11.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.11.0 | Number (10,0) | Primary key that relates the extended table to the Students table. |
| AwaitingFosterCare_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_AwaitingFosterCare |
| CalendarCode | 17.4.0 | VarChar2 (3) | Migrated from: [STUDENTS]LA_CalendarCd |
| DropoutReasonCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_DropReason |
| FAFSAApplication | 16.7.1 | VarChar2 (2) | Indicates if the student has completed the FAFSA application or if the requirement has been waived. |
| FreeReduced | 17.4.0 | VarChar2 (1) | Migrated from: [STUDENTS]LA_FreeReduced |
| HomeBasedSiteCode | 17.4.0 | VarChar2 (6) | Migrated from: [STUDENTS]LA_HomeBased |
| Homeless_TypeOfStudent | 20.8.2.0 | Varchar2(2) | Type of Student (Public school student / Underage sibling of public school student / Nonpublic school student). |
| HomelessCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_Homeless |
| HomelessReasonCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_HomelessReason |
| HomelessServicesProvided_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_SvcsProv |
| LOSFAConsentDate | 14.11.1 | Date | The date the parent or guardian signed the consent form to disclose transcript information to outside parties. |
| LOSFAConsentFlag | 14.11.1 | VarChar (1) | Flag to indicate whether or not parental consent has been given to disclose transcript information to outside parties. |
| MilitaryAffiliation | 17.6.0 | Number (1,0) | Flag to indicate if student has military affiliation. |
| MilitaryBaseAddressInd_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_Address_Military_Base |
| NameSuffix | 17.4.0 | VarChar2 (3) | Migrated from: [STUDENTS]LA_SuffName |
NonDistrictBldgFlag | 14.11.0 | VarChar2 (1) | Flag used to override the school level non-district building flag and indicates whether or not the student attends classes in a building not owned by the district. |
| NoShow_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_NoShow |
| OptionCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_OptionCd |
| ParentOfChild | 17.6.0 | Number (1,0) | Flag to indicate if the student is parent or expected parent of a child. |
| ParishOverrideCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_dist_cd |
| PreGEDSkillsLevelCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_PreGed |
| PreKFundingSourceCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_PreKFund |
| PriorEducationExperienceKGCode | 17.4.0 | VarChar2 (2) | Migrated from: [STUDENTS]LA_PreKindergarten |
| Retained_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_Retained |
| RetainedYear | 17.4.0 | Number (11) | Migrated from: [STUDENTS]LA_RetainedYr |
| SiteCodeOverride | 17.4.0 | VarChar2 (6) | Migrated from: [STUDENTS]LA_StudentSchoolOverride |
| State_ExcludeEnrollment | 17.4.0 | Number (1) | Migrated from: [STUDENTS]state_excludeenrollment |
| State_ExcludeFromSTS | 17.6.0 | Number (1,0) | Migrated from: [STUDENTS]LA_ExcludeSTS |
| StateIDReassignment | 17.4.0 | VarChar2 (9) | Migrated from: [STUDENTS]LA_ReassignID |
| Truant_TF | 17.4.0 | Number (1) | Indicates the calculated Truancy value of a student (23.9.3.0) |
| UnaccompaniedYouth_TF | 17.4.0 | Number (1) | Migrated from: [STUDENTS]LA_Youth |
| EnrollPercent_Override | 21.4.2 | Number(25,10) | This field will be used by the LA EdLink Enrollment extract to report a student's enrollment percentage |
| Act567ParentalConsentFlag | 22.11.2 | VarChar2 (1) | Flag to indicate Act567 Parental Consent Flag for the student |
| Truancy_Ind_Override | 23.8.2 | VarChar2(2) | Values entered here will override the calculated Truancy value from the Truant Report |