Datasets: p_demog_employssnyyf and p_demog_employyf

Datasets: p_demog_employssnyyf and p_demog_employyf

Datasets

The file p_demog_employssnyyf provides demographic information for school district employees (e.g., race/ethnicity, gender). The file was discontinued after SY 2009-2010.

The file p_demog_employyf  provides demographic information for school district employees (e.g., race/ethnicity, gender) but without SSN. The file was discontinued after SY 2008-2009.

ERC Datasets

UTD-ERC Datasets

Start

End

ERC Datasets

UTD-ERC Datasets

Start

End

p_demog_employssnyyf

demog_employ

SY 1994-1995

SY 2019-2020

p_demog_employyf 

 

SY 2002-2003

SY 2008-2009

Variables

ERC Variable

UTD-ERC Variable

Item name

Description

Data Type

Length (Bytes)

Start

End

Matched Heading

ERC Variable

UTD-ERC Variable

Item name

Description

Data Type

Length (Bytes)

Start

End

Matched Heading

AMER_IND_ALASK

ethnativ

American Indian or Alaska Native Code

AMERICAN-INDIAN-ALASKA-NATIVE-CODE indicates a person having origins in any of the original peoples of North and South America (including Central America).

Character

1

SY 2009-2010

SY 2009-2010

E1059 – American Indian or Alaska Native Code

ASIAN

ethasian

Asian

ASIAN-CODE indicates a person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.

Character

1

SY 2009-2010

SY 2009-2010

E1060 – Asian

BLACK_AFRICAN_AMER

ethblack

Black African-American Code

BLACK-AFRICAN-AMERICAN-CODE indicates a person having origins in any of the black racial groups of Africa.

Character

1

SY 2009-2010

SY 2009-2010

E1061 – Black African-American Code

Date_Update

dupdate2

DTUPDATE (TEA)

DATE_UPDATE indicates when the dataset was created in the ERC database.

Character

10

SY 1994-1995

SY 2009-2010

DTUPDATE (TEA)

district

district

District ID

DISTRICT-ID indicates the district identification number registered with the Texas Education Agency.

Character

6

SY 1994-1995

SY 2009-2010

E0212 – District ID

dtupdate

dupdate1

DTUPDATE (TEA)

DTUPDATE indicates the date the row was updated.

Date

8

SY 1994-1995

SY 2009-2010

DTUPDATE (TEA)

ETH_RACE

eth_race

Ethnicity Race

ETH_RACE is a numeric value representing a unique combination of the 5 racial indicators (American Indian or Alaska native, Asian, Black or African American, Hawaiian or Pacific Islander, White) and the 1 ethnicity indicator (Hispanic) collected on the 043 or 101 demographic records.  Each combination is assigned to exactly one "reporting ethnicity" or aggregate ethnicity code, according to Federal reporting rules for the 1997 ethnicity standard.

Numeric

8

SY 1994-1995

SY 2009-2010

Ethnicity Race

ethnic

eth_tea and ethnic_old

Ethnicity Race

ETHNIC origin of the student.  

Character

1

SY 1994-1995

SY 2009-2010

Ethnicity Race

HAWAIIAN_PAC_ISLANDER

ethpacif

Hawaiian Pacific Islander

NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE indicates a person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

Character

1

SY 2009-2010

SY 2009-2010

E1062 – Hawaiian Pacific Islander

HISP_LATINO

ethhispa

Hispanic Latino

HISPANIC-LATINO-CODE indicates a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race.

Character

1

SY 2009-2010

SY 2009-2010

E1064 – Hispanic Latino

id1

pidrep

PEIMS ID Replacement (id1)

PEIMS Replacement (id1) is the identification number assigned if the employee has no Social Security Number. 

Character

9

SY 1994-1995

SY 2009-2010

PEIMS ID Replacement (id1)

id2

ssnrep

SSN Replacement (ID2)

SSN Replacement is the Social Security Number of the employee or the nine-digit identification number assigned if the employee has no Social Security Number.

Character

9

SY 1994-1995

SY 2009-2010

SSN Replacement (ID2)

SEX

sex

Sex

SEX indicates a person's gender.

Character

1

SY 1994-1995

SY 2009-2010

E1325 – Sex

WHITE

ethwhite

White

WHITE-CODE indicates a person having origins in any of the original peoples of Europe, the Middle East, or North Africa.

Character

1

SY 2009-2010

SY 2009-2010

E1063 – White