060 Context Edits

SPECIAL NOTE for the 060 Record Edits

Full Time Equivalents (FTEs) are calculated in the following manner:

060 Context Edits

   

Rule Applies To

Legacy

Edit #

TEDS Rule #

Legacy Edit Rule Text and Business Meaning

Edit
Type

Sub

ESC

District

Campus

Charter

06004

30060-0042

If OBJECT-CODE is "6112" and FUNCTION-CODE is "11" and ROLE-ID is not "047", then a warning message will be issued asking for verification that this staff member is a substitute teacher serving in a classroom where the teacher has quit, died, or been terminated.

W

1

X

X

 

X

For staff payroll, if the object code is "salaries or wages for substitute teachers and other professionals", and the function code is "instruction"), then the staff role id should be "substitute teacher", indicating this staff person is a substitute teacher serving in a classroom where the teacher has quit, died, or been terminated.

06006

30060-0001

If STAFF-TYPE-CODE on the 040 record is "1", then there must be at least one 060 record for that person where PAYROLL-ACTIVITY-CODE is "80", Base Salary, or "78".

F

1

X

X

 

X

If a staff person is reported as a school district or charter school employee, then they must be reported with a 060 payroll record with payroll activity code "base salary" (80) or "non-salary" (78).

06007

30060-0006

PROGRAM-INTENT-CODE must not be "00".

F

1

X

X

 

X

For staff payroll data, the program intent code must not be reported as "no program".

06008

30060-0012

If FUNCTION-CODE is "11", then PROGRAM-INTENT-CODE must not be "91".

F

1

X

X

 

X

For staff payroll reporting, if the function code is "instruction", then the program intent code must not be "athletics and related activities".

06009

30060-0049

For a particular STAFF-ID, if ROLE-ID is always "033" or "036", PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should be between "10000" and "29000".

SW

1

X

X

 

X

If a full-time staff person is always an Educational Aide or Certified Interpreter, then their total Base Salary should be between $10,000 and $29,000 and reported with a payroll activity code of "base salary".

06010

 

Former Edit Deleted

           

06011

30060-0050

If ROLE-ID is "002", "005"-"008", "011", "013"-"015", "018", "021"-"023", "026", "028", "032", "040"-"042", "047", "064", "065", or "079" and the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" is greater than "68000".

W

1

X

X

 

X

If a staff person has a role id of "002", "005"-"008", "011", "013"-"015", "018", "021"-"023", "026", "028", "032", "040"-"042", "047", "064", "065", or "079", then their total base salary should not be greater than $68,000.

06012

30060-0058

If ROLE-ID is always "002", "005"-"008", "011", "013", "015"-"018", "021"-"024", "026", "028"-"030", "032", "040"-"042", "054", "058", "064", "065", or "079", and PERCENT-DAY-EMPLOYED is "100" and NUMBER-DAYS-EMPLOYED is greater than or equal to "187", then for that staff member the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than "32000".

SW

1

X

X

 

X

If a full-time staff person is only reported with the following role ids "002", "005"-"008", "011", "013", "015"-"018", "021"-"024", "026", "028"-"030", "032", "040"-"042", "054", "058", "064", "065", or "079", then their total base salary should not be less than $32,000.

06013

30060-0052

If ROLE-ID is "003", "004", "012", "020", "040", "043"-"045", "061"-"065", or "079", and the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" is greater than "87000".

SW

1

X

X

 

X

If a staff person has a role id of "003", "004", "012", "020", "040", "043"-"045", "061"-"065", or "079", then their total base salary should not be greater than $87,000.

06014

30060-0055

If ROLE-ID is "003", "004", "012", "020", "061"-"065", or "079", and PERCENT-DAY-EMPLOYED is "100" and NUMBER-DAYS-EMPLOYED is greater than or equal to "187" and the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" is less than "44000".

W

1

X

X

 

X

If a full-time staff person has a role id of "003", "004", "012", "020", "061"-"065", or "079", then their total base salary should not be less than $44,000.

06015

30060-0044

If PAYROLL-ACTIVITY-CODE is not "80" and the sum of all PAYROLL-AMOUNTs is greater than "10000".

W

1

X

X

 

X

For staff payroll reporting, the total non-base salary for a staff person should not be greater than $10,000.

06022

30060-0005

If OBJECT-CODE is "6119", then at least one 090 record must exist for that staff member.

F

1

X

X

 

X

If the staff person has a payroll record with a object code indicating "salaries or wages for teachers and other professional personnel", then they must have a 090 staff responsibility record reported.

06023

30060-0046

The sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is "80" must be greater than the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80".

SW

1

X

X

 

X

For staff payroll reporting, the total base salary amount for a staff person should be greater than their total non-base salary.

06028

30060-0047

The sum of all PAYROLL-AMOUNTs for each unique PAYROLL-ACTIVITY-CODE, except "02", "05", or "80" should not exceed "10000".

SW

1

X

X

 

X

For staff payroll for each payroll activity code (except UIL Athletics, Band or Orchestra, and Base Salary), the total of all payroll amounts should not be greater than $10,000.

06029

30060-0048

If ROLE-ID is always "033", then for that staff member the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not exceed "30000".

SW

1

X

X

 

X

If a staff person is always an educational aide, then their total base salary should not be greater than $30,000.

06031

30060-0053

If ROLE-ID is "003", "004", "012", "020", "027", "043"-"045", or "060"-"063", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not exceed "120000".

SW

1

X

X

 

X

If a staff person has a role id of "003", "004", "012", "020", "027", "043"-"045", or "060"-"063", then their total base salary should not be greater than $120,000.

06033

30060-0045

If PAYROLL-ACTIVITY-CODE is not "80", then the sum of all PAYROLL-AMOUNTs should not be greater than "25000".

SW

1

X

X

 

X

The total of the non-base salary amounts for a staff person should not be greater than $25,000.

06036

30060-0013

If ORGANIZATION-CODE is "751", then FUND-CODE must be "292"-"295", "297", "298", "300"-"302", "307", "309", "311"-"319", "325"-"340", "342", "343", "347"-"379", "431"-"459".

F

1

X

X

 

X

If the staff payroll data reported has a "fiscal agent shared services arrangement" (751) organization code, then the fund code reported must be a shared services arrangement fund code.

06037

30060-0060

If no 090 record exists for a staff member, then the sum of all PAYROLL-AMOUNTs must not exceed "100000".

F

1

X

X

 

X

If a staff person does not have any Staff Responsibility data reported on a 090 PEIMS record, then the sum of their payroll amounts must not be greater than 100,000.

06040

30060-0020

There should be at least one record where ORGANIZATION-CODE is "701".

W

1

 

X

 

X

There should be at least one staff member reported that is paid from the Superintendent’s Office organization code.

06041

30060-0004

There must be at least one record where ORGANIZATION-CODE is not "701".

F

1

 

X

 

X

There must be at least one staff member reported that is not paid from the Superintendent’s Office organization code.

06044

30060-0008

ORGANIZATION-CODE must not be "000", "700", "704"-"719", "721"-"725", "726"-"749", "752"-"799", or "800"-"997".

F

1

X

X

X

X

For staff payroll, the organization code must not indicate any of the following: no organization (000), general administration (700), direct costs-locally defined (709-719), indirect costs-locally defined (726-749), reserved for future state definition (704-708, 721-725, 752-799), or locally defined (800-997).

06045

30060-0056

If ROLE-ID is "043"-"045", PERCENT-DAY-EMPLOYED is "100", NUMBER-DAYS-EMPLOYED is greater than or equal to "187" and the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" is less than "25000".

W

1

X

X

 

X

If a full-time staff person has a role id of Business Manger, Tax Assessor/Collector, or Human resources Director, then their total base salary should not be less than $25,000.

06046

30060-0063

The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is "00"-"05", PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187" should not be less than "27320" or greater than "50000".

SW

1

X

X

 

X

Full-time Librarians and Teachers with up to 5 years of professional experience should have an average Base Salary between $27,320 and $50,000.

06047

30060-0064

The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is "06"-"10", PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187" should not be less than "32800" or greater than "56000".

SW

1

X

X

 

X

Full-time Librarians and Teachers with 6-10 years of professional experience should have an average base salary between $32,800 and $56,000.

06048

30060-0065

The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is "11"-"20", PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187" should not be less than "37960" or greater than "59000".

SW

1

X

X

 

X

Full-time Librarians and Teachers with 11-20 years of professional experience should have an average base salary between $37,960 and $59,000.

06049

30060-0066

The average salary (PAYROLL-ACTIVITY-CODE "80" PAYROLL-AMOUNTs only) for all staff where ROLE-ID is "013" or "087", TOTAL-YEARS-PROF-EXPERIENCE is greater than or equal to "21", PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187" should not be less than "44270" or greater than "68000".

SW

1

X

X

 

X

Full-time Librarians and Teachers with more than 20 years of professional experience should have an average base salary between $44,270 and $68,000.

06050

30060-0059

If ROLE-ID is always "013" or "087", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than "65000".

SW

1

X

X

 

X

If a staff person’s Role ID is a Librarian or Teacher, then their total base salary should not be greater than $65,000.

06051

30060-0051

If ROLE-ID is "002", "005"-"008", "011", "013", "015"-"018", "021"-"023", "026", "028", "032", "041"-"042", "056", or "058", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than "70000".

SW

1

X

X

 

X

If a staff person is an Art Therapist, Psychological Associate, Audiologist, Corrective Therapist, Educational Diagnostician, Librarian, Music Therapist, Occupational Therapist, COMS, Physical Therapist, Recreational Therapist, School Nurse, LSSP/Psychologist, Speech Therapist/Speech-Language Pathologist, Teacher Supervisor, Work-Based Learning Site Coordinator, Teacher Facilitator, Teacher Appraiser, Athletic Trainer, or Other Campus Professional Personnel, then their total base salary should not be greater than $70,000.

06052

30060-0057

If ROLE-ID is "003", "004", "012", "020", "027", "040", or "043"-"045", and PERCENT-DAY-EMPLOYED is "100", and NUMBER-DAYS-EMPLOYED is greater than or equal to "187", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than "35000".

SW

1

X

X

 

X

A full-time Assistant Principal, Assistant/Associate/Deputy Superintendent, District Instructional Program Director or Executive Director, Principal, Superintendent/Chief Administrative Officer/Chief Executive Officer/President, Athletic Director, Business Manager, Tax Assessor/ Collector, and Director of Personnel/Human Resources should not have a total base salary less than $35,000.

06053

30060-0054

If ROLE-ID is "003", "004", "012", "020", "027", "040", or "043"-"045", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than "105000".

W

1

X

X

 

X

An Assistant Principal, Assistant/Associate/Deputy Superintendent, District Instructional Program Director or Executive Director, District Instructional Program Director or Executive Director, Principal, Superintendent/Chief Administrative Officer/Chief Executive Officer/President, Athletic Director, Business Manager, Tax Assessor And/Or Collector, or Director Of Personnel/Human Resources should not have a total base salary greater than $105,000.

06054

30060-0062

If staff responsibility data exists for a staff person, then FTE Salary should be between "5000" and "90000".

SW

1

X

X

 

X

For staff payroll reporting, if a staff person is reported with 090 record staff responsibility data, then the Full-time Equivalent Salary should be between $5,000 and $90,000.

06055

30060-0061

FTE Salary should not be greater than "350,000".

SW

1

X

X

 

X

An staff person's FTE salary should not be greater than $350,000.

06056

 

Former Edit Deleted

           

06057

30060-0014

If PAYROLL-AMOUNT is "000000", then PAYROLL-ACTIVITY-CODE must be "78".

F

1

X

X

 

X

If staff payroll amount is $0, then the payroll activity code must be reported as "non-salary".

06058

0060-0015

If PAYROLL-ACTIVITY-CODE is "78", then PAYROLL-AMOUNT must be "000000".

F

1

X

X

 

X

If the payroll activity code reported for a staff person is "non-salary", then the staff payroll amount must be $0.

06059

30060-0021

If PAYROLL-ACTIVITY-CODE is "78", then there should not be a record where PAYROLL-ACTIVITY-CODE is "80".

SW

1

X

X

 

X

Staff reported with a "non-salary" payroll activity code should not have another payroll record where the payroll activity code is "base salary".

06065

30060-0023

If ROLE-ID is always "033", then there should be at least one record where FUNCTION-CODE is "11", "12", or "31".

SW

1

X

X

 

X

If a staff person is always and only an Educational Aide, then they should have staff payroll with function code indicating "instruction", "instructional resources and media services", or "guidance, counseling and evaluation services".

06081

30060-0031

If PROGRAM-INTENT-CODE is "11", then FUND-CODE should be "102", "199", "204", "208", "212", "236"-"239", "255", "258", "259", "262", "266", "269"-"273", "279", "287", "289", "293", "297", "300", "301", "347", "357", "361", "366", "379", "383", "384", "388", "389", "391", "393", "399", "402", "404", "406", "408", "410", "413", "414", "415", "420"-"422", "424" - "426", "429", "433", "439", "440", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "basic educational services" (11), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06082

30060-0032

If PROGRAM-INTENT-CODE is "21", then FUND-CODE should be "102", "199", "204", "208", "212", "218", "255", "258", "259", "266", "269-"273", "287", "289", "293", "301", "307", "347", "357", "366", "379", "383", "384", "388", "389", "391", "393", "397", "402", "405", "410", "413", "414", "420"-"422", "425", "426", "429", "433", "439", "440", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "gifted and talented" (21), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06083

30060-0033

If PROGRAM-INTENT-CODE is "22", then FUND-CODE should be "102", "199", "204", "208", "212", "243"-"252", "255", "258", "259", "266", "269"-"273", "287", "289", "293", "297", "301", "330"-"339", "347", "357", "366", "379", "383", "384", "387", "388", "389", "391", "393", "396", "410", "413", "414", "417", "420"-"422", "425", "426", "429", "433", "439", "440", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "career and technical" (22), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06084

30060-0034

If PROGRAM-INTENT-CODE is "23", then FUND-CODE should be "102", "199", "204", "205", "208", "224"-"230","236"-"239", "253", "255", "258"-"259", "266", "269"-"273", "282"-"284", "287"-"289", "293", "297", "313"-"317", "319", "325"-"328", "340", "347", "357", "362"-"366", "368", "379", "383", "384", "385", "386", "389", "392", "393", "399", "402", "410", "413"-"416", "419", "420"-"422", "425", "426", "429", "434", "435", "437", "439", "440", "441", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "services to students with disabilities (special education)" (23), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06085

30060-0035

If PROGRAM-INTENT-CODE is "24", "26", "28", or "29", then FUND-CODE should be "102", "199", "204"-"206", "208", "211"-"213", "220", "222", "223", "236"-"239", "255", "256", "258", "259", "261", "262", "264"-"276", "279"-"280", "285"-"287", "289", "292"-"295", "297", "300"-"302", "309", "311", "312", "325", "326", "327", "328", "329", "342", "343", "347"-"349", "351"-"352", "354"-"361", "366"-"367" "379", "381"-"384", "388" -"399", "401", "402", "404", "409", "410", "412"-"416", "419"-"422", "429", "431"-"433", "439", "440", "441", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent codes "accelerated education" (24), "non-disciplinary alternative education programs - AEP services" (26), "disciplinary alternative education programs - DAEP basic services" (28), or "disciplinary alternative education programs - DAEP state compensatory education supplemental costs" (29), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06086

30060-0036

If PROGRAM-INTENT-CODE is "25", then FUND-CODE should be "102", "199", "204", "208", "212", "255", "258", "259", "263", "266", "269"-"273", "287", "289", "293", "297", "301", "347", "350", "357", "366", "379", "383", "388", "389", "390", "391", "393", "399", "402", "407", "410", "412"-"415", "420"-"423", "425", "426", "429", "433", "439", "440", "442", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "bilingual education and special language programs" (25), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.

06087

30060-0039

If PROGRAM-INTENT-CODE is "91", then FUND-CODE should be "199", "272", "420", "461", "479", "499", or "699".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "athletics and related activities" (91), then the fund code should be "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (local programs)" funds, or "capital projects funds" (699).

06088

30060-0041

If PROGRAM-INTENT-CODE is "99", then FUND-CODE should be "101", "102", "199", "203"-"206", "208", "209", "211"-"213", "218", "220", "222", "223", "236"-"242", "253", "255", "256", "258", "259", "261"-"266", "267"-"274", "279"-"280", "285", "287", "289", "292"-"295", "297", "298", "300", "301", "302", "307", "309", "311", "312", "325"-"329", "340", "342", "343", "347", "356", "357", "359", "361", "366"-"367", "379", "381"-"384", "387", "388", "389", "390", "391", "392", "393", "394", "395", "396", "397", "398"-"400", "402"-"404", "406", "408", "409"-"410", "412"-"414", "415", "416", "417", "419", "420", "421", "422", "425", "426", "429", "431"-"433", "436", "438", "439", "440", "441", "459", "461", "479", "499", "599", "699", "701", "749", "751"-"755", or "799".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "undistributed" (99), then the fund code should be "food service" (101), "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, selected "special revenue (local programs)" funds, "debt service funds" (599), "capital projects funds" (699), "enterprise fund-National School Breakfast and Lunch Program" (701), "enterprise funds" (749), "transportation" (751), "print shop" (752), "insurance" (753), "computer operations" (754), public entity risk pool (755), or "internal service funds" (799).

06089

30060-0009

FUND-CODE must not be "102" or "400".

F

1

 

X

 

X

For school district and charter school staff payroll reporting, the fund code must not be "ESC state support" (102) or "school health" (400), which are reserved for use by Education Service Centers.

06090

30060-0040

If PROGRAM-INTENT-CODE is "91", then FUNCTION-CODE should be "36", "51", or "52".

SW

1

X

X

 

X

For staff payroll reporting, if the program intent code is "athletics and related activities", then the function code should be "extracurricular activities" (36), "facilities maintenance and operations" (51), or "security and monitoring services" (52).

06091

30060-0022

If FUNCTION-CODE is "11", then there should be an 090 record with a matching STAFF-ID.

SW

1

X

X

 

X

For staff payroll reporting, if a staff person has payroll with a function code indicating "instruction", then there should be a 090 staff responsibility data record reported for that person.

06092

30060-0011

FUNCTION-CODE must not be "62".

F

1

 

X

 

X

For school district and charter school staff payroll reporting, the function code must not be "school district administrative support services", which is reserved for use by Education Service Centers.

06093

30060-0007

If PROGRAM-INTENT-CODE is "71"-"79", or "81"-"89", then DISTRICT-ID must be registered with the TEA as an ESC.

F

1

 

X

 

X

For school district and charter school staff payroll reporting, the program intent code must not be programs reserved for use by Education Service Centers.

06095

 

Former Edit Deleted

           

06096

30060-0030

If ORGANIZATION-CODE is less than "699", and ORGANIZATION-CODE is not found in the CAMPUS-ID table.

SW

1

X

X

 

X

For staff payroll reporting, if the organization code is an instructional campus organization type, then the organization code should be registered with the TEA as an active or under construction campus.

0601A

30060-0024

PAYROLL-ACTIVITY-CODE should be "79" or "80".

SW

1

X

     

For ESC staff payroll reporting, the payroll activity code should be "base salary" or "other supplemental duties".

0601C

30060-0027

ORGANIZATION-CODE should not be "703" or "751".

SW

1

     

X

For charter school staff payroll reporting, the organization code should not be "tax costs" or "fiscal agent shared services arrangement".

0601D

30060-0026

FUNCTION-CODE should not be "9X".

SW

1

     

X

For charter school staff payroll reporting, the function code should not be "intergovernmental charges".

0601E

30060-0016

FUND-CODE must not be "292"-"295", "297", "298", "300"-"302", "307", "309", "311"-"317", "319", "325"-"340", "342", "343", "347"-"352", "354"-"368", "379", "431"-"442", "459", "6XX", or "7XX".

F

1

     

X

For charter school staff payroll reporting, the fund code must not be a shared services arrangement fund, a capital project fund, or a proprietary fund.

0601F

30060-0025

If FUND-CODE is "400", "403", or "405"-"408", then DISTRICT-ID should be registered with the TEA as an ESC.

SW

1

X

X

 

X

For staff payroll reporting, the fund code should not be "school health" (400), "certification" (403), "gifted and talented" (405), "teacher recruitment" (406), "bilingual education" (407), or "technology" (408), which are reserved for use by Education Service Centers.

0601G

30060-0010

FUNCTION-CODE must not be "00".

F

1

X

X

 

X

For staff payroll reporting, the function code must not be "no function". 

0601H

30060-0017

If FUND-CODE is "292"-"295", "297", "298", "300"-"302", "307", "309", "311"-"317", "319", "325"-"340", "342", "343", "347"-"352", "354"-"368", "379", or "431"-"442", "459", then ORGANIZATION-CODE must be "751" or "999".

F

1

X

X

   

For staff payroll reporting, if the fund code is a shared services arrangement fund, then the organization code must be "fiscal agent shared services arrangement" or "undistributed".

0601J

 

The value of DISTRICT-ID in this record must match the value of DISTRICT-ID on the district's 010 record.

F

1

X

X

 

X

The district id on the 060 record must match the district id on the 010 record.

0601K

30060-0003

The value of STAFF-ID on this record must match the value of STAFF-ID on some 040 record.

F

1

X

X

 

X

The value reported for the Social Security number on a 060 Payroll record must match the Social Security number on a 040 staff record. 

0601O

30060-0043

If there is at least one record where the FUND-CODE is "292"-"295", "297", "298", "300"-"302", "307", "309", "311"-"317", "319", "325"-"340", "342", "343", "347"-"352", "354"-"368", "379", "431"-"442", or "459" (a Shared Service Arrangement fund) then ESC-SSA-STAFF-INDICATOR-CODE should be "2".

SW

1

X

     

If a staff person has a payroll record where the fund code is a shared services arrangement fund in code table C145, then this person's ESC shared services arrangement staff indicator code should indicate they are part of the ESC Shared Services Arrangement, for which the ESC is the fiscal agent.

0601P

30060-0018

If there are no records where the FUND-CODE is "292"-"295", "297", "298", "300"-"302", "307", "309", "311"-"317", "319", "325"-"340", "342", "343", "347"-"352", "354"-"368", "379", or "431"-"442", "459" then ESC-SSA-STAFF-INDICATOR-CODE must be "1".

F

1

X

     

If there are no payroll records where the fund code is a shared services arrangement fund, then all of the 090 staff responsibilities records must have an ESC shared services arrangement staff indicator code indicating that the staff member is not part of an ESC Shared Services Arrangement.

0601Q

30060-0037

If PROGRAM-INTENT-CODE is "30", then FUND-CODE should be "102", "199", "211", "266", "271", "272", "276", "285"-"287", "289", "300", "358"-"360", "366", or "420".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "Title I, Part A schoolwide activities related to state compensatory education costs on campuses with 40% or more educationally disadvantaged students" (30), then the fund code should be "ESC state support" (102), "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, or selected "special revenue (state funded)" funds.

0601R

30060-0028

If FUND-CODE is "101", "102", "199", "240", "420", or "701", then FISCAL-YEAR should be "4".

SW

1

X

X

 

X

For staff payroll reporting, the fiscal year should indicate the current school year if the fund code is "food service" (101), "ESC state support" (102), "general fund" (199), "National School Breakfast and Lunch Program" (240), "foundation school program and other state aid" (420), or "enterprise fund-National School Breakfast and Lunch Program" (701).

0601S

30060-0029

FISCAL-YEAR should be "1", "2", "3" or "4" if FUND-CODE is "2XX"-"429".

SW

1

X

X

 

X

For staff payroll reporting in selected special revenue fund codes (2XX-429) the fiscal year should indicate the current or the three prior school years.

0601T

30060-0038

If PROGRAM-INTENT-CODE is "31", then FUND-CODE should be "199" or "420".

W

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent code "high school allotment" (31), then the fund code should be "general fund" (199), or "foundation school program and other state aid" (420).

0601U

30060-0002

If STAFF-TYPE-CODE on the 040 record is a "2", then there must not be a matching 060 record for that particular staff ID

F

1

 

X

 

X

If a staff person is reported as contracted instructional staff serving as a classroom teacher, then they must not have any 060 staff payroll records reported.

0601W

30060-0019

For a particular STAFF-ID, if SERVICE-ID on some 090 record is "01010000", then at least one 060 record with matching STAFF-ID should have a PROGRAM-INTENT-CODE of "32", "33", "34", or "35".

SW

1

X

X

 

X

For a staff person, if a 090 staff responsibility record has a service id for pre-kindergarten, then at least one 060 staff payroll record for that staff person should have a program intent code indicating pre-kindergarten.

0601X

30060-0067

If PROGRAM-INTENT-CODE is  "32", "33", "34", or "35", then FUND-CODE should be "199", "205"- "206", "212"-"213", "237", "263", "266", "269"-"270", "272", "274"-"276", "280", "286"-"287", "289", "294"-"295", "301"-"302", "326", "347", "350", "356", "358", "360", "366"-"367", "379", "388", "390"-"391", "393", "395"-"396", "401"-"402", "404", "410", "413"-"416", "419"-"423", "426", "429", "439"-"442", "459", "461", "479", or "499".

SW

1

X

X

 

X

If the staff payroll data reported includes amounts for the program intent codes "pre-kindergarten-regular education" (32), "pre-kindergarten-special education" (33), "pre-kindergarten-compensatory education" (34), or "pre-kindergarten-bilingual education" (35), then the fund code should be "general fund" (199), selected "special revenue (federal programs)" funds, selected "special revenue (federally funded SSAs)" funds, selected "special revenue (state funded)" funds, selected "special revenue (state/locally funded SSAs)" funds, or selected "special revenue (local programs)" funds.