Skip to main content
Skip table of contents

S_TX_STU_ASSMT_X (ver 22.10.2)

This table is an extension of the students' table and holds Student Assessment Pre-Code information for the state assessments.

Column Name

Version

Data Type

Description

StudentsDCID

22.10.2

Number(10,0)

The foreign key that relates the extended table to the [Students] table.

ALG1_ALT2

22.10.2

Boolean

Algebra I STAAR Alt2

ALG1_ASL

22.10.2

Boolean

Algebra I ASL Videos

ALG1_ATS

22.10.2

Boolean

Algebra I Auto Text-to-Speech

ALG1_CAL

22.10.2

Boolean

Algebra I Basic TI Calculator

ALG1_CLS

22.10.2

Boolean

Algebra I Content and Language Supports

ALG1_DEC

22.10.2

Boolean

Algebra I December Eligibility

ALG1_DEC_RT

22.10.2

Boolean

Algebra I December Retester

ALG1_EXTRA

22.10.2

Boolean

Algebra I Extra Day

ALG1_INT

22.10.2

Boolean

Algebra I Interim

ALG1_JUN

22.10.2

Boolean

Algebra I June Eligibility

ALG1_JUN_RT

22.10.2

Boolean

Algebra I June Retester

ALG1_OTHDESSUP

22.10.2

Boolean

Algebra I Other Designated Supports

ALG1_PAPERFORMAT

22.10.2

Varchar(2)3

Algebra I Paper Test Format

ALG1_PER

22.10.2

Boolean

Algebra I Permissive Mode

ALG1_PROC

23.8.2

Boolean

Algebra I Proctored Administration

ALG1_STT

22.10.2

Boolean

Algebra I Speech-to-Text

ALG1_SPR

22.10.2

Boolean

Algebra I Spring Eligibility

ALG1_SPR_RT

22.10.2

Boolean

Algebra I Spring Retester

ALG1_TESTMODE

22.10.2

Varchar(2)2

Algebra I Paper (Test Mode)

ALG1_TTS

22.10.2

Boolean

Algebra I Text-to-Speech

BIO_ALT2

22.10.2

Boolean

Biology STAAR Alt2

BIO_ASL

22.10.2

Boolean

Biology ASL Videos

BIO_ATS

22.10.2

Boolean

Biology Auto Text-to-Speech

BIO_CAL

22.10.2

Boolean

Biology Basic TI Calculator

BIO_CLS

22.10.2

Boolean

Biology Content and Language Supports

BIO_DEC

22.10.2

Boolean

Biology December Eligibility

BIO_DEC_RT

22.10.2

Boolean

Biology December Retester

BIO_EXTRA

22.10.2

Boolean

Biology Extra Day

BIO_INT

22.10.2

Boolean

Biology Interim

BIO_JUN

22.10.2

Boolean

Biology June Eligibility

BIO_JUN_RT

22.10.2

Boolean

Biology June Retester

BIO_OTHDESSUP

22.10.2

Boolean

Biology Other Designated Supports

BIO_TESTMODE

22.10.2

Varchar(2)2

Biology Paper (Test Mode)

BIO_PAPERFORMAT

22.10.2

Varchar(2)3

Biology Paper Test Format

BIO_PER

22.10.2

Boolean

Biology Permissive Mode

BIO_PROC

23.8.2

Boolean

Biology Proctored Administration

BIO_SPL

22.10.2

Boolean

Biology Spelling Assistance

BIO_STT

22.10.2

Boolean

Biology Speech-to-Text

BIO_SPR

22.10.2

Boolean

Biology Spring Eligibility

BIO_SPR_RT

22.10.2

Boolean

Biology Spring Retester

BIO_TTS

22.10.2

Boolean

Biology Text-to-Speech

BIO_WORD

23.8.2

Boolean

Biology Word Prediction

ENG1_ALT2

22.10.2

Boolean

English I STAAR Alt2

ENG1_ASL

22.10.2

Boolean

English I ASL Videos

ENG1_ATS

22.10.2

Boolean

English I Auto Text-to-Speech

ENG1_CLS

22.10.2

Boolean

English I Content and Language Supports

ENG1_DEC

22.10.2

Boolean

English I December Eligibility

ENG1_DEC_RT

22.10.2

Boolean

English I December Retester

ENG1_EXTRA

22.10.2

Boolean

English I Extra Day

ENG1_INT

22.10.2

Boolean

English I Interim

ENG1_JUN

22.10.2

Boolean

English I June Eligibility

ENG1_JUN_RT

22.10.2

Boolean

English I June Retester

ENG1_OTHDESSUP

22.10.2

Boolean

English I Other Designated Supports

ENG1_PAPERFORMAT

22.10.2

Varchar(2)3

English I Paper Test Format

ENG1_PER

22.10.2

Boolean

English I Permissive Mode

ENG1_PROC

23.8.2

Boolean

English I Proctored Administration

ENG1_PRS

22.10.2

Varchar(2)2

English I Presentation

ENG1_STT

22.10.2

Boolean

English I Speech-to-Text

ENG1_SPL

22.10.2

Boolean

English I Spelling Assistance

ENG1_SPR

22.10.2

Boolean

English I Spring Eligibility

ENG1_SPR_RT

22.10.2

Boolean

English I Spring Retester

ENG1_TESTMODE

22.10.2

Varchar(2)2

English I Paper (Test Mode)

ENG1_TTS

22.10.2

Boolean

English I Text-to-Speech

ENG1_WORD

23.8.2

Boolean

English I Word Prediction

ENG2_ALT2

22.10.2

Boolean

English II STAAR Alt2

ENG2_ASL

22.10.2

Boolean

English II ASL Videos

ENG2_ATS

22.10.2

Boolean

English II Auto Text-to-Speech

ENG2_CLS

22.10.2

Boolean

English II Content and Language Supports

ENG2_DEC

22.10.2

Boolean

English II December Eligibility

ENG2_DEC_RT

22.10.2

Boolean

English II December Retester

ENG2_EXTRA

22.10.2

Boolean

English II Extra Day

ENG2_INT

22.10.2

Boolean

English II Interim

ENG2_JUN

22.10.2

Boolean

English II June Eligibility

ENG2_JUN_RT

22.10.2

Boolean

English II June Retester

ENG2_OTHDESSUP

22.10.2

Boolean

English II Other Designated Supports

ENG2_PAPERFORMAT

22.10.2

Varchar(2)3

English II Paper Test Format

ENG2_PER

22.10.2

Boolean

English II Permissive Mode

ENG2_PROC

23.8.2

Boolean

English II Proctored Administration

ENG2_PRS

22.10.2

Varchar(2)2

English II Presentation

ENG2_SPL

22.10.2

Boolean

English II Spelling Assistance

ENG2_SPR

22.10.2

Boolean

English II Spring Eligibility

ENG2_SPR_RT

22.10.2

Boolean

English II Spring Retester

ENG2_STT

22.10.2

Boolean

English II Speech-to-Text

ENG2_TESTMODE

22.10.2

Varchar(2)2

English II Paper (Test Mode)

ENG2_TTS

22.10.2

Boolean

English II Text-to-Speech

ENG2_WORD

23.8.2

Boolean

English II Word Prediction

MA_ABOVE_GR

22.10.2

Varchar(2)2

Math Above Grade

MA_ASL

22.10.2

Boolean

Math ASL Videos

MA_ATS

22.10.2

Boolean

Math Auto Text-to-Speech

MA_CAL

22.10.2

Boolean

Math Basic TI Calculator

MA_CLS

22.10.2

Boolean

Math Content and Language Supports

MA_EXTRA

22.10.2

Boolean

Math Extra Day

MA_INT_GR

22.10.2

Varchar(2)2

Math Interim Grade

MA_OTHDESSUP

22.10.2

Boolean

Math Other Designated Supports

MA_TESTMODE

22.10.2

Varchar(2)2

Math Paper (Test Mode)

MA_PAPERFORMAT

22.10.2

Varchar(2)3

Math Paper Test Format

MA_PER

22.10.2

Boolean

Math Permissive Mode

MA_PROC

23.8.2

Boolean

Math Proctored Administration

MA_PRS

22.10.2

Varchar(2)2

Math Presentation

MA_STT

22.10.2

Boolean

Math Speech-to-Text

MA_TTS

22.10.2

Boolean

Math Text-to-Speech

NEW_TX

22.10.2

Boolean

New to Texas 

RE_ABOVE_GR

22.10.2

Varchar(2)2

RLA Above Grade

RE_ASL

22.10.2

Boolean

RLA ASL Videos

RE_ATS

22.10.2

Boolean

RLA Auto Text-to-Speech

RE_CLS

22.10.2

Boolean

RLA Content and Language Supports

RE_EXTRA

22.10.2

Boolean

RLA Extra Day

RE_INT_GR

22.10.2

Varchar(2)2

RLA Interim Grade

RE_OTHDESSUP

22.10.2

Boolean

RLA Other Designated Supports

RE_TESTMODE

22.10.2

Varchar(2)2

RLA Paper (Test Mode)

RE_PAPERFORMAT

22.10.2

Varchar(2)3

RLA Paper Test Format

RE_PER

22.10.2

Boolean

RLA Permissive Mode

RE_PROC

23.8.2

Boolean

RLA Proctored Administration

RE_PRS

22.10.2

Varchar(2)2

RLA Presentation

RE_STT

22.10.2

Boolean

RLA Speech-to-Text

RE_SPL

22.10.2

Boolean

RLA Spelling Assistance

RE_TTS

22.10.2

Boolean

RLA Text-to-Speech

RE_WORD

23.8.2

Boolean

RLA Word Prediction

SC_ABOVE_GR

22.10.2

Varchar(2)2

Science Above Grade

SC_ASL

22.10.2

Boolean

Science ASL Videos

SC_ATS

22.10.2

Boolean

Science Auto Text-to-Speech

SC_CAL

22.10.2

Boolean

Science Basic TI Calculator

SC_CLS

22.10.2

Boolean

Science Content and Language Supports

SC_EXTRA

22.10.2

Boolean

Science Extra Day

SC_INT_GR

22.10.2

Varchar(2)2

Science Interim Grade

SC_OTHDESSUP

22.10.2

Boolean

Science Other Designated Supports

SC_TESTMODE

22.10.2

Varchar(2)2

Science Paper (Test Mode)

SC_PAPERFORMAT

22.10.2

Varchar(2)3

Science Paper Test Format

SC_PER

22.10.2

Boolean

Science Permissive Mode

SC_PROC

23.8.2

Boolean

Science Proctored Administration

SC_PRS

22.10.2

Varchar(2)2

Science Presentation

SC_SPL

22.10.2

Boolean

Science Spelling Assistance

SC_STT

22.10.2

Boolean

Science Speech-to-Text

SC_TTS

22.10.2

Boolean

Science Text-to-Speech

SC_WORD

23.8.2

Boolean

Science Word Prediction

SS_ABOVE_GR

22.10.2

Varchar(2)2

Social Studies Above Grade

SS_ASL

22.10.2

Boolean

Social Studies ASL Videos

SS_ATS

22.10.2

Boolean

Social Studies Auto Text-to-Speech

SS_CLS

22.10.2

Boolean

Social Studies Content and Language Supports

SS_EXTRA

22.10.2

Boolean

Social Studies Extra Day

SS_INT_GR

22.10.2

Varchar(2)2

Social Studies Interim Grade

SS_OTHDESSUP

22.10.2

Boolean

Social Studies Other Designated Supports

SS_TESTMODE

22.10.2

Varchar(2)2

Social Studies Paper (Test Mode)

SS_PAPERFORMAT

22.10.2

Varchar(2)3

Social Studies Paper Test Format

SS_PER

22.10.2

Boolean

Social Studies Permissive Mode

SS_PROC

23.8.2

Boolean

Social Studies Proctored Administration

SS_PRS

22.10.2

Varchar(2)2

Social Studies Presentation

SS_SPL

22.10.2

Boolean

Social Studies Spelling Assistance

SS_STT

22.10.2

Boolean

Social Studies Speech-to-Text

SS_WORD

23.8.2

Boolean

Social Studies Word Prediction

STAAR_ALT2

22.10.2

Boolean

STAAR Alternate 2

TELPAS_ALT

22.10.2

Boolean

TELPAS Alternate

TELPAS_LS_EXTRA

22.10.2

Boolean

TELPAS LS Extra Day

TELPAS_LS_OTHDESSUP

22.10.2

Boolean

TELPAS LS Other Designated Supports

TELPAS_LS_TESTMODE

22.10.2

Varchar(2)2

TELPAS LS Test Mode: Holistic

TELPAS_RW_EXTRA

22.10.2

Boolean

TELPAS RW Extra Day

TELPAS_RW_OTHDESSUP

22.10.2

Boolean

TELPAS RW Other Designated Supports

TELPAS_RW_PAPERFORMAT

22.10.2

Varchar(2)3

TELPAS RW Paper Test Format

TELPAS_RW_PER

22.10.2

Boolean

TELPAS RW Permissive Mode

TELPAS_RW_PROC

23.8.2

Boolean

TEALPAS RW Proctored Administration

TELPAS_RW_PRS

22.10.2

Varchar(2)3

TELPAS RW Presentation

TELPAS_RW_STT

22.10.2

Boolean

TELPAS RW Speech-to-Text

TELPAS_RW_TESTMODE

22.10.2

Varchar(2)2

TELPAS RW Test Mode: Paper & Holistic

USH_ALT2

22.10.2

Boolean

US History STAAR Alt2

USH_ASL

22.10.2

Boolean

US History ASL Videos

USH_ATS

22.10.2

Boolean

US History Auto Text-to-Speech

USH_CLS

22.10.2

Boolean

US History Content and Language Supports

USH_DEC

22.10.2

Boolean

US History December Eligibility

USH_DEC_RT

22.10.2

Boolean

US History December Retester

USH_EXTRA

22.10.2

Boolean

US History Extra Day

USH_INT

22.10.2

Boolean

US History Interim

USH_JUN

22.10.2

Boolean

US History June Eligibility

USH_JUN_RT

22.10.2

Boolean

US History June Retester

USH_OTHDESSUP

22.10.2

Boolean

US History Other Designated Supports

USH_PAPERFORMAT

22.10.2

Varchar(2)3

US History Paper Test Format

USH_PER

22.10.2

Boolean

US History Permissive Mode

USH_PROC

23.8.2

Boolean

US History Proctored Administration

USH_PRS

22.10.2

Varchar(2)2

US History Presentation

USH_STT

22.10.2

Boolean

US History Speech-to-Text

USH_SPL

22.10.2

Boolean

US History Spelling Assistance

USH_SPR

22.10.2

Boolean

US History Spring Eligibility

USH_SPR_RT

22.10.2

Boolean

US History Spring Retester

USH_TESTMODE

22.10.2

Varchar(2)2

US History Paper (Test Mode)

USH_TTS

22.10.2

Boolean

US History Text-to-Speech

USH_WORD

23.8.2

Boolean

US History Word Prediction


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.