PEIMS Data Standards app_pet_context

After a PET Extract File is successfully validated against the PET XSD and transferred to TEA, the system places the file in a queue for further processing. As resources are available, the file is opened and the PET Records in the file are validated and loaded. As illustrated below, the PET validation and load process is divided into two logical stages:

PET Context Edits are used in both stages. If the system does not find an exact match for the student ID and major demographics in the TSDS Unique ID System, an error will result. If the system does find an exact match in the TSDS Unique ID System, the PET events are validated against appropriate PET Context Edits before being loaded into the PET Event table. Each of the PET Context Edits is presented in the next section.

Each PET Context Edit is traced to its associated PEIMS Edit Number, if applicable. A PET Context Edit is not required for any of the following data elements because data quality is assured through the XSD validation process:

PET Context Edits have been defined for BirthDate, SexCode, GenerationCode, AmericanIndianAlaskanNativeCd, AsianCd, BlackAfricanAmericanCd, NativeHawaiianPacificIslandCd, WhiteCd, and HispanicLatinoCd in support of the PET Student Add process. See “PET Edits” section.

PET Context Edits
PET EDIT #	Data Element(s)	Edit Rule Text	PEIMS Edit #
P001	StudentID	The first character of StudentID must be “S” or “0”-“8”.	10001
P002	StudentID	Each character of StudentID must not be the same number.	10002
P003	StudentID	The first three characters of StudentID must not be “000”.	10003
P004	StudentID	If first character of StudentID is not an “S”, the fourth and fifth characters must not be “00”.	10005
P005	StudentID	If first character of StudentID is not an “S”, the last four characters must not be “0000”.	10006
P006	FirstName, MiddleName, LastName	Former edit deleted.
P007	FirstName, MiddleName, LastName	The FirstName, MiddleName, and/or LastName must only contain the following characters: A-Z 0-9 Apostrophe Hyphen Space character	10015
P008	FirstName, MiddleName, LastName	Name must not contain only apostrophes.	10015
P009	FirstName, MiddleName, LastName	Name must not contain only hyphens.	10015
P010	FirstName, LastName	Name must not contain only spaces.	10015
P011	MiddleName	Former edit deleted
P012	FirstName, MiddleName, LastName	The FirstName, MiddleName, and/or LastName must not contain only “0” – “9”.	10017
P013	DistrictID	The DistrictID contained within the CampusIDofEnrollment must match an entry registered with the TEA.	01001
P014	CampusIDof Enrollment	The first six characters of the CampusIDofEnrollment must be the same as the ID of the district transferring the PET Extract File.	11011 40002 40808
P015	CampusIDof Enrollment	CampusIDofEnrollment must match an entry registered with the TEA as an active instructional campus and is not a budgeted campus.	11011 40002 40808
P018	CampusIDof Enrollment	When creating or maintaining a PET Event, the first six characters of the CampusIDof Enrollment must match the district-level user’s Agent ID.	NA
P019	CampusIDof Enrollment	When creating or maintaining a PET Event, the CampusIDofEnrollment must match the campus-level user’s Agent ID.	NA
P020	EnrollDate	When creating or maintaining a PET Event, the EnrollDate must fall within the date range defined for the PET School Year in context. In general, the school year begins on June 1 and extends through August 31 of the following year.	NA
P021	EnrollDate	The EnrollDate must not be greater than the PET file submission date.	NA
P022	WithdrawDate	When creating or maintaining a PET Event, if a prior enrollment record for the CampusIDofEnrollment does not exist, the withdrawal event is invalid.	NA
P023	WithdrawDate	When creating or maintaining a PET Event, the WithdrawDate must fall within the date range defined for the PET School Year in context. In general, the school year begins on June 1 and extends through August 31 of the following year.	NA
P024	WithdrawDate	The WithdrawDate must not be greater than the PET file submission date.	NA
P025	LocalID	When creating or maintaining a PET Event, the Local ID must be consistent with the PEIMS Data Standards’ Name Field pattern. In addition to the space character, this pattern allows any of the following characters: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 ~ ! @ # $ % ^ & * ( ) - _ + = : ; " ' , . / < > ?	NA
P026	CampusData	Two or more CampusData elements for the same CampusIDofEnrollment for one Student are invalid. Note: All the PET Events for one Student at a given CampusIDofEnrollment should be clustered together in one or more PETEventSet elements.	NA
P027	PETEventSet	Two or more incomplete PETEventSets for the same CampusIDofEnrollment for one Student are invalid.	NA
P028	EnrollDate / WithdrawDate	Two or more equal PET Event dates for the same CampusIDofEnrollment for one Student in two different PET Event Sets are invalid.	NA
P029	BirthDate	BirthDate must be a valid date.	10141
P030	BirthDate	BirthDate must be less than the enrollment date.	NA
P031	AmericanIndianAlaskanNativeCd, AsianCd, BlackAfricanAmericanCd, NativeHawaiianPacificIslandCd, or WhiteCd	AmericanIndianAlaskanNativeCd, AsianCd, BlackAfricanAmericanCd, NativeHawaiianPacificIslandCd, or WhiteCd must be ‘1’.	1011M

For assistance with the PEIMS Data Standards contact the PEIMS Office at PeimsCustomerSupport@tea.state.tx.us

This version of the PEIMS Data Standards is a programmatically converted HTML version of the PEIMS Data Standards. It is intended as a job aid to facilitate navigation of the PEIMS Data Standards documentation and should not be used to submit PEIMS data or to reach final conclusions about individual public schools. All of the information provided is reviewed for accuracy and reliability; however, TEA assumes no responsibility for any errors appearing in the HTML version of the PEIMS Data Standards.