PowerSchool ERP Texas
PowerSchool ERP Texas
Breadcrumbs

Entity: Staff

The following table lists the Element IDs, Element Names, Source fields, TX PEIMS fields, Valid values, and Additional Information for the Ed-Fi Staff entity.

Element ID

Element Name

Source field

TX PEIMS field

Valid values

Data type

Additional Information

E1524

StaffUniqueID

TSDS ID field on the Defined Page 32001 - State Required II page.

Database field:

empuser.ftext9 where page_no = '32001'

TX Unique Staff ID field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.staff_uid

Not applicable

varchar(32)

Not applicable

E0006

BirthDate

Birthdate field on the Employee Information page.

Database field:

employee.birthdate

Date of Birth field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.birth_date

Not applicable

smalldatetime

Not applicable

E0730

HighestCompletedLevelOfEducation

Type field (for the Highest Degree) on the Degree Data page.

Database field:

emp_degree.dtype

Highest Degree field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.education_level

  • 0 = NO BACHELOR'S DEGREE OR HIGHER

  • 1 = BACHELOR'S

  • 2 = MASTER'S

  • 3 = DOCTORATE

varchar(300)

Not applicable

E1064

HispanicLatinoEthnicity

Ethnicity field on the Race/Ethnicity tab of the Employee Information page.

Database field:

person.ethnic_code

Ethnicity (1997 Standard) field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.hisp_latino

H = Hispanic or Latino

bit

If the value is H, it is reported as 1; otherwise, it is reported as 0.

E3050

Race - American-Indian-Alaska-Native-Code 

Race field on the Race/Ethnicity tab of the Employee Information page.

Race Code, Federal Code, and State Code fields on the Race Code Table page.

Database field:

empl_races.race_code

Race field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.is_american_indian

I = American Indian/Alaskan

bit

The application looks up the fields on the Race Code Table page in the following order:

  1. State Code

  2. Federal Code

  3. Race Code

If the value is I, it is reported as 1; otherwise, it is reported as 0.

E3050

Race - Asian-Code

Race field on the Race/Ethnicity tab of the Employee Information page.

Race Code, Federal Code, and State Code fields on the Race Code Table page.

Database field:

empl_races.race_code

Race field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.is_asian

A = Asian

bit

The application looks up the fields on the Race Code Table page in the following order:

  1. State Code

  2. Federal Code

  3. Race Code

If the value is A, it is reported as 1; otherwise, it is reported as 0.

E3050

Race - Black-Africian-American-Code

Race field on the Race/Ethnicity tab of the Employee Information page.

Race Code, Federal Code, and State Code fields on the Race Code Table page.

Database field:

empl_races.race_code

Race field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.is_black

B = Black or African American

bit

The application looks up the fields on the Race Code Table page in the following order:

  1. State Code

  2. Federal Code

  3. Race Code

If the value is B, it is reported as 1; otherwise, it is reported as 0.

E3050

Race - Native-Hawaiian-Pacific-Islander-Code

Race field on the Race/Ethnicity tab of the Employee Information page.

Race Code, Federal Code, and State Code fields on the Race Code Table page.

Database field:

empl_races.race_code

Race field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.is_pacific_islander

P = Hawaiian/Pacific Islander

bit

The application looks up the fields on the Race Code Table page in the following order:

  1. State Code

  2. Federal Code

  3. Race Code

If the value is P, it is reported as 1; otherwise, it is reported as 0.

E3050

Race - White-Code

Race field on the Race/Ethnicity tab of the Employee Information page.

Race Code, Federal Code, and State Code fields on the Race Code Table page.

Database field:

empl_races.race_code

Race field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.is_white

W = White

bit

The application looks up the fields on the Race Code Table page in the following order:

  1. State Code

  2. Federal Code

  3. Race Code

If the value is W, it is reported as 1; otherwise, it is reported as 0.

E0004

Sex

Sex At Birth field on the Employee Information page.

Database field:

person.sex

Gender field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.sex_code

  • M = Male

  • F = Female

varchar(300)

Not applicable

E0706

GenerationCode

Suffix field on the Employee Information page.

Database field:

employee.name_suffix

Generation field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.generation_code

  • JR

  • JR.

  • SR

  • SR.

  • II,

  • II.

  • III

  • III.

  • IV

  • IV.

  • V

  • V.

  • VI

  • VI.

  • VII

  • VII.

  • VIII

  • VIII.

  • I

  • I.

  • IX

  • IX.

  • X

  • X.

This field can also be blank.

varchar(300)

The source values are translated to 1 through 9, A, B, or C as follows:

  • JR or JR. = 1

  • SR or SR. = 2

  • II or II. = 3

  • III or III. = 4

  • IV or IV. = 5

  • V or V. = 6

  • VI or VI. = 7

  • VII or VII. = 8

  • VIII or VIII. = 9

  • I or I. = A

  • IX or IX. = B

  • X or X. = C

E0130

TotalYearsProfExperience

Total Prof Yrs field on the Defined Page 32001 - State Required II page.

Database field:

empuser.tcode3 where page_no = '32001'

Total Professional Years field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.years_prof_exp

Not applicable

int

Zero filled

E1377

TotalYearsPriorTeachingExperience

Prior Prof field on the Defined Page 32001 - State Required II page.

Database field:

empuser.tcode4 where page_no = '32001'

Years of Prior Teaching Experience field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.years_prior_teach

Not applicable

int

Zero filled

E1721

CreditableYearOfService

The following fields on the Defined Page 32002 - State Required III page:

  • Board Cert

  • TIA Design

  • TIA LEA Pend

  • Non-Cred Year

Database fields:

  • empuser.ftext3

  • empuser.ftext4

  • empuser.ftext5

  • empuser.ftext8

where page_no = '32002'

Creditable Year of Service field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.creditable_year

  • Y

  • N

bit

If the Board Cert, TIA Design, or TIA LEA Pend field value is Y, the creditable year (ftext8) is reported as 1 for Y and 0 for N.

E0161

YearsExperienceInDistrict

Dist Prof Yrs field on the Defined Page 32001 - State Required II page.

Database field:

empuser.tcode1 where page_no = '32001'

District Years of Experience field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.years_in_district

Not applicable

int

Zero filled

E1581

PKTeacherRequirement

Pre-K Req field on the Payroll Information - State Required page.

Database field:

empuser.tcode8 where page_no = '32000'

PK Teacher Requirement field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.pk_teacher_req

  • 01 = Certification through a training center

  • 03 = Be employed as a PK teacher

  • 05 = Child Development Associate credential

  • 06 = Completion of Texas School Ready Training

  • 07 = Has a degree in early childhood education

  • 08 = At least 8 years experience

  • 09 = Contract - At least 2 years and CDA credential

  • 10 = Contract - At least 2 years and MAC certification

  • 11 = Contract - Been employed as a PK teacher

  • 12 = Contract - Has a degree in early childhood education

  • 13 = Contract - At least 8 years experience

  • 98 = PK Teacher in school district no additional HQPK Qualification

  • 99 = PK Teacher in LEA no additional HQPK Qualification

varchar(300)

Not applicable

E0505

StaffId

Social Security field on the Employee Information page.

Database field:

employee.ssn

Staff ID field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.staff_id

Not applicable

varchar(9)

Not applicable

E1722

TeacherIncentiveAllotmentDesignation

The following fields on the Defined Page 32002 - State Required III page:

  • Board Cert

  • TIA Design

  • TIA LEA Pend

Database fields:

  • empuser.ftext4

  • empuser.ftext5

  • empuser.ftext6

where page_no = '32002'

The following fields on the Demographic tab of the Staff Information page:

  • TIA National Board Certified

  • TIA Designation

  • TIA LEA Designation Pending

Database fields:

  • tx_staff.tia_natl_brd_cert

  • tx_staff.tia_teach_inc_allot

  • tx_staff.tia_lea_pending

  • Y

  • N

This field can also be blank.

bit

If Y, 1 is reported; otherwise, 0 is reported.

E3069

StaffDoNotReportTSDS

TSDS Excluded field on the Defined Page 32002 - State Required III page.

Database field:

empuser.ftext6 where page_no = '32002'

TSDS Excluded field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.do_not_report

  • Y

  • N

This field can also be blank.

bit

If Y, 1 is reported; otherwise, 0 is reported.

E1073

StaffType (StaffTypeSet)

Not applicable

Value field on the Staff Extensions tab of the Staff Information page.

Database field:

When the Entity Name is StaffTypeSet and the Field Name is StaffType, the database field is tx_staff_ext.field_value

where

staff_ext_key .entity_name= 'StaffTypeSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'StaffType'

  • 1 = District Employee

  • 3 = Contracted Professional Staff

  • 4 = Teacher Employed At In-District Charter Partner Campus

varchar(300)

Not applicable

E3010

BeginDate (StaffTypeSet)

Begin Date field on the TX Ed-Fi Staff Extensions page when Entity Name is StaffTypeSet.

Database field:

tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'StaffTypeSet'

Begin Date field on the Staff Extensions tab of the Staff Information page.

Database field:

tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'StaffTypeSet'  

Not applicable

smalldatetime

Not applicable

E3020

EndDate (StaffTypeSet)

End Date field on the TX Ed-Fi Staff Extensions page when Entity Name is StaffTypeSet.

Database field:

tx_staff_ext_key.end_date

where

staff_ext_key.entity_name = 'StaffTypeSet'

End Date field on the Staff Extensions tab of the Staff Information page.

Database field:

tx_staff_ext_key.end_date

where

staff_ext_key.entity_name = 'StaffTypeSet'

Not applicable

smalldatetime

Not applicable

E1670

ParaprofessionalCertification (ParaprofessionalCertificationSet)

Value field on the TX Ed-Fi Staff Extensions page when Entity Name is ParaprofessionalCertificationSet and Field Name is ParaprofessionalCertification.

Database field:

tx_staff_ext.field_value

where

staff_ext_key.entity_name= 'ParaprofessionalCertificationSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'ParaprofessionalCertification'

Value field on the Staff Extensions tab of the Staff Information page.

Database field:

tx_staff_ext.field_value

where

staff_ext_key .entity_name= 'ParaprofessionalCertificationSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'ParaprofessionalCertification'

  • 1 = Paraprofessional Certified

  • 0 = Not Certified

varchar(300)

Not applicable

E3010

BeginDate (ParaprofessionalCertificationSet)

Begin Date field on the TX Ed-Fi Staff Extensions page when Entity Name is ParaprofessionalCertification.

Database field:

"tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'ParaprofessionalCertificationSet'

Begin Date field on the Staff Extensions tab of the Staff Information page.

Database field:

tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'ParaprofessionalCertificationSet'  

Not applicable

smalldatetime

Not applicable

E3020

EndDate (ParaprofessionalCertificationSet)

End Date field on the TX Ed-Fi Staff Extensions page when Entity Name is ParaprofessionalCertification.

Database field:

tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'ParaprofessionalCertificationSet'

End Date field on the Staff Extensions tab of the Staff Information page.

Database field:

tx_staff_ext_key.begin_date

where

staff_ext_key.entity_name = 'ParaprofessionalCertificationSet'  

Not applicable

smalldatetime

Not applicable

E0703

FirstName

First Name field on the Employee Information page.

Database field:

employee.f_name

First Name field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.first_name

Not applicable

varchar(75)

Not applicable

E0704

MiddleName

Middle Name field on the Employee Information page.

Database field:

employee.m_name

Middle Name field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.middle_name

Not applicable

varchar(75)

Not applicable

E0705

LastSurname

Last Name field on the Employee Information page..

Database field:

employee.l_name

Last Name field on the Demographic tab of the Staff Information page.

Database field:

tx_staff.last_name

Not applicable

varchar(75)

Not applicable