SPECIAL NOTE for the 060 Record Edits
Full Time Equivalents (FTEs) are calculated in the following manner:
Rule Applies To | ||||||||
---|---|---|---|---|---|---|---|---|
Legacy Edit # |
TEDS Rule # |
Legacy Edit Rule Text and Business Meaning |
Edit |
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. |