For staff payroll, there must be a staff person with a matching TX-UNIQUE-STAFF-ID.

For a payroll data reported, there must be staff data reported also.

Except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622), each district's data submission should contain at least one staff payroll where ORGANIZATION-CODE is not "701".

For each LEA's data submission (except for Texas School for the Deaf, Texas School for the Blind and Visually Impaired, and Texas Juvenile Justice Department), at least some staff payroll should be paid from a TX-OrganizationCode other than the Superintendent's Office.

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

If the staff person has payroll with a TX-ObjectCode indicating "salaries or wages for teachers and other professional personnel", then they must have a staff responsibility reported.

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

For staff payroll, the TX-ProgramIntentCode must not be reported as "no program".

PROGRAM-INTENT-CODE must not be "71"-"79" or "81"-"89".

For staff payroll, TX-ProgramIntentCode must not be programs reserved for use by Education Service Centers.

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

For staff payroll, TX-OrganizationCode 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).

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

For staff payroll, the TX-FundCode must not be "ESC state support" (102) or "school health" (400), which are reserved for use by Education Service Centers.

The combination of the following fields must be unique for each staff Payroll: DISTRICT-ID, TX-UNIQUE-STAFF-ID, FISCAL-YEAR, FUND-CODE, FUNCTION-CODE, OBJECT-CODE, ORGANIZATION-CODE, PROGRAM-INTENT-CODE, and PAYROLL-ACTIVITY-CODE.

The combination of the following fields must be unique for each staff Payroll: StateOrganizationId, StaffUniqueStateId, TX-FiscalYear, TX-FundCode, TX-FunctionCode, TX-ObjectCode, TX-OrganizationCode, TX-ProgramIntentCode, and TX-PayrollActivityCode.

For staff Payroll, the following must be provided: DISTRICT-ID, TX-UNIQUE-STAFF-ID, FISCAL-YEAR, PAYROLL-AMOUNT, FUND-CODE, FUNCTION-CODE, OBJECT-CODE, ORGANIZATION-CODE, PROGRAM-INTENT-CODE, PAYROLL-ACTIVITY-CODE.

For staff Payroll, the following must be provided: StateOrganizationId, StaffUniqueStateId, TX-FiscalYear, TX-Amount, TX-FundCode, TX-FunctionCode, TX-ObjectCode, TX-OrganizationCode, TX-ProgramIntentCode, TX-PayrollActivityCode.

FUNCTION-CODE must not be "00"

For staff payroll, the TX-FunctionCode must not be "no function".

FUNCTION-CODE must not be "62".

For staff payroll, TX-FunctionCode must not be "school district administrative support services", which is reserved for use by Education Service Centers.

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

For staff payroll, if the TX-FunctionCode is "instruction", then the TX-ProgramIntentCode must not be "athletics and related activities".

If ORGANIZATION-CODE is "751", then FUND-CODE must be a Shared Services Arrangement fund in code table C145.

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

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

For staff payroll, if the TX-Amount is $0, then the TX-PayrollActivityCode must be "non-salary".

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

For staff payroll, if the TX-PayrollActivityCode is Non-Salary, then the TX-Amount must be $0.

FUND-CODE must not be a Shared Services Arrangement fund in code table C145, "6XX", or "7XX".

For staff payroll reported for an open enrollment charter school, the TX-FundCode must not be a shared services arrangement fund, a capital project fund, or a proprietary fund.

If FUND-CODE is a Shared Services Arrangement fund in code table C145, then ORGANIZATION-CODE must be "751" or "999".

For staff payroll, if the TX-FundCode is a Shared Services Arrangement fund, then the TX-OrganizationCode must be "fiscal agent shared services arrangement" or "undistributed".

If there are no staff payroll where the FUND-CODE is a Shared Services Arrangement fund in code table C145, then ESC-SSA-STAFF-INDICATOR-CODE must be "1".

For an Education Service Center staff person, if there are no payroll where the TX-FundCode is a shared services arrangement fund, then all of their staff responsibilities must have TX-SharedServiceArrangementStaffIndicator indicating that the staff member is not part of an ESC Shared Services Arrangement.

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

For a Local Education Agency, at least some staff payroll should be paid from a TX-OrganizationCode for Superintendent's Office.

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

If a staff person has payroll with TX-PayrollActivityCode indicating "non-salary", they should not also have payroll with TX-PayrollActivityCode indicating "base salary".

If FUNCTION-CODE is "11", then there should be staff responsibility data with a matching TX-UNIQUE-STAFF-ID.

If a staff person has payroll with TX-FunctionCode indicating "instruction", then there should be staff responsibility data reported.

If ROLE-ID is always "033", then there should be staff payroll for that person where FUNCTION-CODE is "11", "12", or "31".

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

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

For an Education Service Center staff payroll, the TX-PayrollActivityCode should be "base salary" or "other supplemental duties".

FUND-CODE should not be "400", "403", or "405"-"408".

For staff payroll, the TX-FundCode 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.

FUNCTION-CODE should not be "9X".

For staff payroll reported for an open enrollment charter school, the TX-FunctionCode should not be "intergovernmental charges".

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

For staff payroll reported for an open enrollment charter school, the TX-OrganizationCode should not be "tax costs" or "fiscal agent shared services arrangement".

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

For staff payroll reporting, the fiscal year should indicate the current school year if the TX-FundCode 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).

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

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

If ORGANIZATION-CODE is less than "699", then DISTRICT-ID combined with ORGANIZATION-CODE must be a Campus ID registered with TEA as an active instructional or under construction campus.

For staff payroll, if the TX-OrganizationCode is an instructional campus organization type, then the StateOrganizationId combined with the TX-OrganizationCode must be a campus registered with TEA as an active instructional or under construction campus.

If PROGRAM-INTENT-CODE is "11", then FUND-CODE should be "102", "199", "212", "236", "238", "239", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "300", "301", "345", "347", "357", "364", "365", "366", "367", "379", "383", "384", "388", "391", "393", "399", "402", "404", "406", "408", "410", "414", "415", "420", "422", "429", "433", "439", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "basic educational services" (11), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "21", then FUND-CODE should be "102", "199", "212", "218", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "289", "301", "307", "345", "347", "357", "364", "367", "379", "383", "384", "388", "391", "393", "397", "402", "405", "410", "414", "420", "422", "429", "433", "439", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "gifted and talented" (21), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "22", then FUND-CODE should be "102", "199", "212", "244", "245", "246", "247", "248", "250", "251", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "289", "301", "331", "332", "333", "334", "335", "337", "338", "345", "347", "357", "364", "367", "379", "383", "384", "387", "388", "391", "393", "396", "410", "414", "420", "422", "429", "433", "439", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "career and technical" (22), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "23", then FUND-CODE should be "102", "199", "205", "224", "225", "226", "227", "228", "229", "230", "236", "238", "239", "253", "255", "258", "259", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "313", "314", "315", "316", "317", "319", "325", "327", "328", "340", "345", "347", "357", "364", "365", "366", "367", "379", "383", "384", "385", "386", "392", "393", "399", "402", "410", "414", "415", "416", "419", "420", "422", "429", "434", "435", "437", "439", "441", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "services to students with disabilities (special education)" (23), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "24", "26", "28", or "29", then FUND-CODE should be "102", "199", "205", "206", "211", "212", "220", "222", "223", "236", "238", "239", "255", "258", "259", "264", "265", "266", "267", "268", "269", "270", "271", "272", "273", "274", "275", "276", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "292", "294", "300", "301", "309", "311", "312", "325", "327", "328", "329", "342", "345", "347", "352", "354", "355", "357", "364", "365", "366", "367", "379", "381", "382", "383", "384", "388", "390", "391", "392", "393", "395", "396", "397", "398", "399", "402", "404", "409", "410", "412", "414", "415", "416", "419", "420", "422", "429", "431", "432", "433", "439", "441", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCodes "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 TX-FundCode 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.

If PROGRAM-INTENT-CODE is "25", then FUND-CODE should be "102", "199", "212", "255", "258", "259", "263", "266", "269", "270", "271", "272", "273", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "301", "345", "347", "350", "357", "364", "365", "366", "367", "379", "383", "388", "390", "391", "393", "399", "402", "407", "410", "412", "414", "415", "420", "422", "429", "433", "439", "442", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "bilingual education and special language programs" (25), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "30", then FUND-CODE should be "102", "199", "211", "266", "271", "272", "276", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "300", or "420".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "Title I, Part A schoolwide activities related to state compensatory education costs on campuses with 40% or more educationally disadvantaged students" (30), then the TX-FundCode 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.

If PROGRAM-INTENT-CODE is "91", then FUND-CODE should be "199", "266", "272", "277", "278", "281", "282", "283", "420", "461", "479", "499", or "699".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "athletics and related activities" (91), then the TX-FundCode 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).

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

For staff payroll, if TX-ProgramIntentCode is "athletics and related activities", then the TX-FunctionCode should be "extracurricular activities" (36), "facilities maintenance and operations" (51), or "security and monitoring services" (52).

If PROGRAM-INTENT-CODE is "99", then FUND-CODE should be "101", "102", "199", "203", "205", "206", "209", "211", "212", "218", "220", "222", "223", "236", "238", "239", "240", "241", "242", "253", "255", "258", "259", "263", "264", "265", "266", "267", "268", "269", "270", "271", "272", "273", "274", "277", "278", "279", "280", "281", "282", "283", "284", "285", "289", "292", "294", "298", "300", "301", "307", "309", "311", "312", "325", "327", "328", "329", "340", "342", "345", "347", "357", "364", "365", "366", "367", "379", "381", "382", "383", "384", "387", "388", "390", "391", "392", "393", "395", "396", "397", "398", "399", "400", "402", "403", "404", "406", "408", "409", "410", "412", "414", "415", "416", "419", "420", "422", "429", "431", "432", "433", "436", "438", "439", "441", "459", "461", "479", "499", "599", "699", "701", "749", "751", "752", "753", "754", "755", or "799".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "undistributed" (99), then the TX-FundCode 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).

If OBJECT-CODE is "6112" and FUNCTION-CODE is "11", then there should be staff responsibility data with a matching TX-UNIQUE-STAFF-ID where ROLE-ID is "047".

For staff payroll, if TX-ObjectCode is "salaries or wages for substitute teachers and other professionals" and TX-FunctionCode is "instruction", then TX-StaffRole on staff responsibility data 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.

For a particular TX-UNIQUE-STAFF-ID, if there is at least one payroll where the FUND-CODE is a Shared Services Arrangement fund in code table C145, then there should be at least one staff responsibility with a matching TX-UNIQUE-STAFF-ID where ESC-SSA-STAFF-INDICATOR-CODE is "2".

If an Education Service Center staff person has payroll where the TX-FundCode is a shared services arrangement fund in code table C145, then they should also have at least one responsibility with a TX-SharedServiceArrangementStaffIndicator indicating that they are part of the ESC Shared Services Arrangement, for which the ESC is the fiscal agent (2).

For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80" should not be between 10,001 and 25,000.

For staff payroll, total non-base salary for a staff person should not be between 10,001 and 25,000.

For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80" should not be greater than 25,000.

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

For a particular TX-UNIQUE-STAFF-ID, the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is "80" should be greater than the sum of all PAYROLL-AMOUNTs where PAYROLL-ACTIVITY-CODE is not "80".

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

For a particular TX-UNIQUE-STAFF-ID, for each unique PAYROLL-ACTIVITY-CODE except "02", "05", or "80", the sum of all PAYROLL-AMOUNTs should not be greater than 10,000.

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

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is always "033", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 30,000.

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

For a particular TX-UNIQUE-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 10,000 and 29,000.

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.

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "002", "005"-"008", "011", "013", "015", "018", "021"-"023", "026", "028", "032", "040"-"042", "047", "064", "065", or "079", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 68,000.

If a staff person has a TX-StaffRole 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.

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "026", "028", "032", "041", "042", "056", "106", or "114", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 70,000.

If a staff person has a TX-StaffRole of "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "026", "028", "032", "041", "042", "056", "106", or "114", then their total base salary should not be greater than $70,000.

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "003", "004", "012", "020", "040", "043"-"045", "061"-"065", or "079", then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be greater than 87,000.

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

For a particular TX-UNIQUE-STAFF-ID, 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 be greater than 120,000.

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

For a particular TX-UNIQUE-STAFF-ID, 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 105,000.

If a staff person has a TX-StaffRole of "003", "004", "012", "020", "027", "040", or "043"-"045", then their total base salary should not be greater than $105,000.

For a particular TX-UNIQUE-STAFF-ID, 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, then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE "80" should not be less than 44,000.

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

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is "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 25,000.

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

For a particular TX-UNIQUE-STAFF-ID, 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 35,000.

If a full-time staff person has a TX-StaffRole of "003", "004", "012", "020", "027", "040", or "043"-"045", then their total base salary should not be less than $35,000.

For a particular TX-UNIQUE-STAFF-ID, if ROLE-ID is only "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "024", "026", "028", "030", "032", "040", "041", "042", "054", "064", "065", "079", "106", and/or "114", 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 32,000.

If a full-time staff person is only the following TX-StaffRoles "002", "005", "006", "007", "008", "011", "013", "015", "016", "017", "018", "021", "022", "023", "024", "026", "028", "030", "032", "040", "041", "042", "054", "064", "065", "079", "106", and/or "114", then their total base salary should not be less than $32,000.

For a particular TX-UNIQUE-STAFF-ID, 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 65,000.

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

If no staff responsibility data exists for a staff person, then the sum of all PAYROLL-AMOUNTs should not be greater than 100,000.

If a staff person does not have any responsibility data, then the sum of their payroll amounts should not be greater than $100,000.

FTE Salary should not be greater than 350,000.

For staff payroll, the FTE Salary should not be greater than $350,000.

If staff responsibility data exists for a staff person, then FTE Salary should be between 5,000 and 90,000.

For staff payroll for a staff person having responsibility data, the FTE Salary should be between $5,000 and $90,000.

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 0-5, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 27,320 and 50,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 0-5 should be between $27,320 and $50,000.

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 6-10, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 32,800 and 56,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 6-10 should be between $32,800 and $56,000.

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 be between 37,960 and 59,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience of 11-20 should be between $37,960 and $59,000.

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 20, PERCENT-DAY-EMPLOYED is 100, and NUMBER-DAYS-EMPLOYED is greater than or equal to 187 should be between 44,270 and 68,000.

The average base salary for all full-time Librarians and Teachers with TX-TotalYearsProfessionalExperience greater than 20 should be between $44,270 and $68,000.

If PROGRAM-INTENT-CODE is "33", then FUND-CODE should be "199", "205", "206", "211", "212", "263", "266", "269", "270", "272", "274", "275", "276", "277", "278", "279", "280", "281", "282", "283", "289", "294", "300", "301", "345", "347", "350", "367", "379", "388", "390", "391", "393", "395", "396", "402", "404", "410", "414", "415", "416", "419", "420", "422", "429", "439", "441", "442", "459", "461", "479", or "499".

If the staff payroll data reported includes amounts for the TX-ProgramIntentCode "pre-kindergarten-special education" (33), then the TX-FundCode 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.

The Texas School For the Blind and Visually Impaired (227905), the Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622) must not submit staff payroll data.

The Texas School for the Blind and Visually Impaired, the Texas School for the Deaf, and the Texas Juvenile Justice Department must not report staff payroll data.

If OBJECT-CODE is "6129", then either ROLE-ID must be "033" or "036" on staff responsibility data (StaffResponsibilitiesExtension complex type) or AUXILIARY-ROLE-ID must be reported and must not be blank on staff employment payroll summary data (StaffEducationOrgEmploymentAssociationExtension complex type) for this staff member.

If the staff person has payroll with a TX-ObjectCode indicating "Salaries or Wages for Support Personnel" (6129), then they must have either a paraprofessional TX-StaffRole (Educational Aide or Certified Interpreter) on staff responsibility data (30090 StaffResponsibilitiesExtension complex type) or a TX-AuxiliaryRoleID on staff employment payroll summary data (30050 StaffEducationOrgEmploymentAssociationExtension complex type).

If FUND-CODE is "266", "269", "278", "279", "280", "281", "282", "283", "284", "285", "345", or "366", then FUNCTION-CODE must not be "71".

TX-FunctionCode must not be "Debt Service" (71) when TX-FundCode is certain federal funds or federally funded SSAs related to the CARES Act, the CRRSA Act, the ARP Act, and ESEA Title V, Part B, Subpart 1 (The Small, Rural School Achievement Program).

If FUND-CODE is "269", "277", "278", "279", "280", "284", "285", or "345", then FUNCTION-CODE must not be "81".

TX-FunctionCode must not be “Facilities Acquisition And Construction" (81) when TX-FundCode is certain federal funds or federally funded SSAs related to the CARES Act, the ARP Act, and ESEA Title V, Part B, Subpart 1 (The Small, Rural School Achievement Program).

If FUNCTION-CODE is "23", and there is staff responsibility data with a matching TX-UNIQUE-STAFF-ID where ROLE-ID is "003" or "020", then ORGANIZATION-CODE must be "001"-"699".

For staff payroll, if TX-FunctionCode is "School Leadership" (23), and this staff person is reported with a staff responsibility for TX-StaffRole "Assistant Principal" (003) or "Principal" (020), then TX-OrganizationCode must be an instructional campus organization (001-699).