|
Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
StudentUniqueStateId |
Texas Unique Student ID |
STUDENTS |
CUSTOM_400009369 |
Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information |
1,3,4,5,6 |
|
|
IdentificationCode |
Student ID |
STUDENTS |
CUSTOM_200000003 / If no value set use value from students.CUSTOM_400009167 |
Students.custom_200000003 (Student ID) where custom_200000003 is used in Student Information |
1,3,4,5,6 |
|
|
IdentificationCode |
Local Student ID |
STUDENTS |
STUDENT_ID |
Students.student_id where student_id is used in Student Information |
1,3,4,5,6 |
|
|
FirstName |
First Name |
STUDENTS |
FIRST_NAME |
Students.first_name where first_name is used in Student Information |
1,3,4,5,6 |
|
|
MiddleName |
Middle Name |
STUDENTS |
MIDDLE_NAME |
Students.middle_name where middle_name is used in Student Information |
1,3,4,5,6 |
|
|
LastSurname |
Last Name |
STUDENTS |
LAST_NAME |
Students.last_name where last_name is used in Student Information |
1,3,4,5,6 |
|
|
BirthDate |
Date of Birth |
STUDENTS |
CUSTOM_200000004 |
Students.custom_200000004 (Date of Birth) where custom_200000004 is used in Student Information |
1,3,4,5,6 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
1,3,4,5,6 |
|
|
Element Name |
Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|
TX-GenerationCode |
Generation Code |
STUDENTS |
NAME_SUFFIX |
Students.name_suffix where name_suffix is used in Student Information |
1,3,4,5,6 |
|
|
TX-Sex |
Sex Code |
STUDENTS |
CUSTOM_200000000 |
Students.custom_200000000 (Sex Code) where custom_200000000 is used in Student Information |
1,3,4,5,6 |
|
|
TX-HispanicLatinoEthnicity |
Hispanic Latino |
STUDENTS |
CUSTOM_100000105 |
Students.custom_100000105 (Hispanic Latino) where custom_100000105 is used in Student Information |
1,3,4,5,6 |
|
|
TX-AmericanIndianAlaskaNative |
American Indian Alaska Native |
STUDENTS |
CUSTOM_100000100 |
Students.custom_100000100 (American Indian Alaska Native) where custom_100000100 is used in Student Information |
1,3,4,5,6 |
|
|
TX-Asian |
Asian |
STUDENTS |
CUSTOM_100000101 |
Students.custom_100000101 (Asian) where custom_100000101 is used in Student Information |
1,3,4,5,6 |
|
|
TX-BlackAfricanAmerican |
Black African American |
STUDENTS |
CUSTOM_100000102 |
Students.custom_100000102 (Black African American) where custom_100000102 is used in Student Information |
1,3,4,5,6 |
|
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|
TX-NativeHawaiianPacificIslander |
Native Hawaiian Pacific Islander |
STUDENTS |
CUSTOM_100000103 |
Students.custom_100000103 (Native Hawaiian Pacific Islander) where custom_100000103 is used in Student Information |
1,3,4,5,6 |
|
|
TX-White |
White |
STUDENTS |
CUSTOM_100000104 |
Students.custom_100000104 (White) where custom_100000104 is used in Student Information |
1,3,4,5,6 |
|
|
TX-ADAEligibility |
ADA Eligibility |
STUDENT_ENROLLMENT_CODES |
SHORT_NAME / If submission = 3 or 4 or student is not enrolled for the current year output blank |
Student_Enrollment_Codes.short_name where short_name is used in Student_Enrollment_Codes where Student_Enrollment_Code.id equals Student_Enrollment.enrollment_code. If submission = 3 or 4 or student is not enrolled for the current year output blank |
1 |
|
|
TX-AtRiskStudent |
At Risk Indicator |
STUDENTS |
CUSTOM_400000068 |
Students.custom_400000068 (At Risk Indicator) where custom_400000068 is used in Student Information |
1 |
|
|
TX-HomelessStatus |
Homeless Status |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If submission = 4 output blank |
Custom_Field_Log_Entries for FIeld ID 400009732 used on the Homeless tab in Student Information |
400009732 |
1,3,4,5,6 |
|
TX-ImmigrantIndicator |
Immigrant Indicator |
STUDENTS |
CUSTOM_400000019 |
Students.custom_400000019 (Immigrant Indicator) where custom_400000019 is used in Student Information |
1 |
|
|
TX-LEPIndicator |
LEP Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD4 |
Custom_Field_Log_Entries for FIeld ID 400010549 used on the ELL tab in Student Information |
400010549 |
1,3,5,6 |
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|
TX-MigrantIndicator |
Migrant Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 |
Custom_Field_Log_Entries for FIeld ID 400011363 used on the Migrant tab in Student Information |
400011363 |
1,3,4,5,6 |
|
TX-SSIPromotionRetention |
SSI Promotion Retention |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 |
Custom_Field_Log_Entries for FIeld ID 400009175 used on the PEIMS tab in Student Information |
400009175 |
1 |
|
TX-UnaccompaniedYouthStatus |
Unaccompanied Youth Status |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If submission = 4 or value = 0 output blank |
Custom_Field_Log_Entries for FIeld ID 400009734 used on the Homeless tab in Student Information |
400009734 |
1,3,4,5,6 |
|
TX-UnschooledAsyleeRefugeeIndicator |
Unschooled Asylee Refugee |
STUDENTS |
CUSTOM_400000108 / If submission = 4 output blank else grab value, if value isn't set grab default value |
Students.custom_400000108 (Unschooled Asylee Refugee) where custom_400000108 is used in Student Information |
1,3,4,5,6 |
|
|
TX-EarlyReadingIndicator |
Early Reading Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If grade level is not in 'KG','01','02' and submission = 1 or 3 OR sub =4 output blank |
Custom_Field_Log_Entries for FIeld ID 400000124 used on the PEIMS tab in Student Information |
400000124 |
1,3,5,6 |
|
TX-FosterCareIndicator |
Foster Care Indicator |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If student is not enrolled in current year output blank |
Custom_Field_Log_Entries for FIeld ID 300000004 used on the Classified tab in Student Information |
300000004 |
1,3,4,5,6 |
|
TX-MilitaryConnectedStudentIndicator |
Military Connected Student |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If student is not enrolled in current year output blank |
Custom_Field_Log_Entries for FIeld ID 300000005 used on the PEIMS tab in Student Information |
300000005 |
1,3,5,6 |
|
TX-DyslexiaIndicator |
Dyslexia Indicator |
STUDENTS |
CUSTOM_400009824 / If Dyslexia date(custom_300000056) is null or less than the snapshot date then output blank |
Students.custom_400009824 (Dyslexia Indicator) where custom_400009824 is used in Student Information |
1 |
|
| TX-DyslexiaRiskCode |
Dyslexia Risk Code |
STUDENTS |
CUSTOM_300000106 |
Students.custom_300000106 (Dyslexia Risk Code) where custom_300000106 is used in Student Information |
3 |
|
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|
TX-TSTEMIndicator |
TSTEM Indicator |
LOGIC / If student has a entry in student log entries (field_id=300000043) for the current year (log_field1) AND log_field2 <= effective date AND log_field3 is null or log field3 >= effective date |
Use '1' if student is TSTEM or '0' if student is not TSTEM |
1,3,4,5,6 |
||
|
TX-ECHSIndicator |
ECHS Indicator |
LOGIC / If student has a entry in student log entries (field_id=300000044) for the current year (log_field1) AND log_field2 <= effective date AND log_field3 is null or log field3 >= effective date |
Use '1' if student is ECHS or '0' if student is not ECHS |
1,3,4,5,6 |
||
| TX-PTECHIndicator |
PTECH Indicator |
If student has a entry in student log entries (field_id=300000044) for the current year (log_field1) |
Use '1' if student is PTECH or '0' if student is not PTECH |
1,3,4,5,6 |
||
| TX-NewTechIndicator |
New Tech Indicator |
If student has a entry in student log entries (field_id=300000127) for the current year (log_field1) AND log_field2 <= effective date AND log_field3 is null or log field3 >= effective date then use 1 else use 0 |
Use '1' if student is NTECH or '0' if student is not NTECH |
1,3,4,5,6 |
||
|
TX-IEPContinuerIndicator |
IEP Continuer Indicator |
STUDENTS |
CUSTOM_300000058 |
Students.custom_300000058 (IEP Continuer Indicator) where custom_300000058 is used in Student Information |
1 |
|
|
TX-HomeLanguage |
Home Language |
STUDENTS |
CUSTOM_400000058 |
Students.custom_400000058 (Home Language) where custom_400000058 is used in Student Information |
1 |
|
|
TX-StudentLanguageCode |
Student Language |
STUDENTS |
CUSTOM_200000005 |
Students.custom_200000005 (Student Language) where custom_200000005 is used in Student Information |
1 |
|
| TX-AsOfStatusCode |
As Of Status |
IS_WINDOW = student_enrollment.start_date <= window date IS_SNAPSHOT = student_enrollment.start_date <= snapshot date and end_date is null or end_date <= snapshot date ============================================= If submission = 4 then output blank Else If student_enrollment.syear is from last year output A Else If grade level = 'EE','PK','KG','01','02','03','04','05','06' OR submission = 1 and grade level = 07 & grade level was 06 last year output X Else If submission = 1 AND IS_WINDOW and IS_SNAPSHOT OUTPUT B else C Else if submission = 1 AND IS_Snapshot and student's wasn't enrolled prior year then output D else F Else if submission = 1 and student wasn't enrolled prior year output E else G Else if submission = 3 or 5 and student is currently enrolled with no drop date output H else I If none of the above are met output blank |
"IS_WINDOW = student_enrollment.start_date <= window date IS_SNAPSHOT = student_enrollment.start_date <= snapshot date and end_date is null or end_date <= snapshot date ============================================= If submission = 4 then output blank Else If student_enrollment.syear is from last year output A Else If grade level = 'EE','PK','KG','01','02','03','04','05','06' OR submission = 1 and grade level = 07 & grade level was 06 last year output X Else If submission = 1 AND IS_WINDOW and IS_SNAPSHOT OUTPUT B else C Else if submission = 1 AND IS_SNAPSHOT and student's wasn't enrolled prior year then output D else F Else if submission = 1 and student wasn't enrolled prior year output E else G Else if submission = 3 or 5 and student is currently enrolled with no drop date output H else I If none of the above are met output blank" |
1,3,5,6 |
||
|
TX-EconomicDisadvantaged |
Economic Disadvantage |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD1 / If submission = 4 output blank, if no value or default is present, output zeros |
Custom_Field_Log_Entries for FIeld ID 400000009 used on the Classified tab in Student Information |
400000009 |
1,3,5,6 |
| TX-StudentCensusBlockGroup |
Census Block |
CUSTOM_FIELD_LOG_ENTRIES |
If educational_disadvantage.log_field1 (field_id=300000127) = 0 OR ADA Eligibility = 0, 4, 5 or 8 OR homeless_status.log_field1 (field_id=400009732) != 0 OR student_attribution.log_field2 (field_id=400009173) = 21 or 23 then use blank else use texas_census_block.geoid |
Use Blank if educational_disadvantage.log_field1 (field_id=300000127) = 0 OR ADA Eligibility = 0, 4, 5 or 8 OR homeless_status.log_field1 (field_id=400009732) != 0 OR student_attribution.log_field2 (field_id=400009173) = 21 or 23 otherwise use texas_census_block.geoid |
1 |
|
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|
TX-CrisisIndicator |
Crisis |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 |
Custom_Field_Log_Entries for FIeld ID 300000020 used on the PEIMS tab in Student Information |
300000020 |
1,3,4,5,6 |
|
TX-ParentalPermission |
Parental Permission |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD5 |
Custom_Field_Log_Entries for FIeld ID 400010549 used on the ELL tab in Student Information |
400010549 |
1 |
| TX-AssociateDegreeIndicator |
Associate Degree |
STUDENTS |
CUSTOM_300000071 |
Students.custom_300000071 (Associate Degree Indicator Code) where custom_300000071 is used in Student Information. |
1,3,5,6 |
|
| TX-StarOfTexasIndicator |
Star of Texas |
STUDENTS |
CUSTOM_300000076 |
"Students.custom_300000076 (Star of Texas Indicator) where custom_300000076 is used in Student Information. If the stuednt is not PK, then use Blank, otherwise use custom_300000076." |
1,3,6 |
|
| TX-ResidentialFacilityIndicator |
Residential Facility |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD2 |
If trim of residential_facility.log_field2 not equal to blank use true otherwise use false. |
300000095 |
3 |
| TX-PKEligiblePreviousYear |
PK Previous |
STUDENTS |
CUSTOM_300000128 |
Students.custom_300000128 (PK Eligible Previous Year) where custom_300000128 is used in Student Information |
1,3 |
|
| TX-IndustryCertifications |
Industry Certs |
CUSTOM_FIELD_LOG_ENTRIES |
LOG_FIELD3 and LOG_FIELD2 |
Use all appropriate Cert IDs and associated Cert Dates |
1,3 |
Student
Updated on