SPECIAL NOTE for the 060 Record Edits
Full Time Equivalents (FTEs) are calculated in the following manner:
Edit Not Applicable To | |||||||
|---|---|---|---|---|---|---|---|
Edit # |
Edit Rule Text |
Edit |
Sub |
ESC |
District |
Campus |
Charter |
06004 |
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 |
|||
06006 |
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 |
|||
06007 |
PROGRAM-INTENT-CODE must not be “00”. |
F |
1 |
X |
|||
06008 |
If FUNCTION-CODE is “11”, then PROGRAM-INTENT-CODE must not be “91’. |
F |
1 |
X |
|||
06009 |
If ROLE-ID is always “033” or “036”, PERCENT-DAY-EMPLOYED is “100”, NUMBER-DAYS-EMPLOYED is greater than or equal to “187”, and for that staff member the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE “80” is less than “10000” or greater than “29000”. |
SW |
1 |
X |
|||
06010 |
If ROLE-ID is always “033” or “036”, 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 “8000”. |
SW |
1 |
X |
|||
06011 |
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 |
|||
06012 |
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” must not be less than “32000”. |
SW |
1 |
X |
|||
06013 |
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 |
|||
06014 |
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 |
|||
06015 |
If PAYROLL-ACTIVITY-CODE is not “80” and the sum of all PAYROLL-AMOUNTs is greater than “10000”. |
W |
1 |
X |
|||
06022 |
If OBJECT-CODE is “6119”, then at least one 090 record must exist for that staff member. |
F |
1 |
X |
|||
06023 |
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 |
|||
06028 |
The sum of all PAYROLL-AMOUNTs for each unique PAYROLL-ACTIVITY-CODE, except “02”, “05”, or “80” must not exceed “10000”. |
SW |
1 |
X |
|||
06029 |
If ROLE-ID is always “033”, then for that staff member the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE “80” must not exceed “30000”. |
SW |
1 |
X |
|||
06031 |
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” must not exceed “120000”. |
SW |
1 |
X |
|||
06033 |
If PAYROLL-ACTIVITY-CODE is not “80”, then the sum of all PAYROLL-AMOUNTs must not be greater than “25000”. |
SW |
1 |
X |
|||
06036 |
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 |
|||
06037 |
If no 090 record exists for a staff member, then the sum of all PAYROLL-AMOUNTs must not exceed “100000”. |
F |
1 |
X |
|||
06040 |
There must be at least one record where ORGANIZATION-CODE is “701”. |
W |
1 |
X |
X |
||
06041 |
There must be at least one record where ORGANIZATION-CODE is not “701”. |
F |
1 |
X |
X |
||
06044 |
ORGANIZATION-CODE must not be “000”. |
F |
1 |
||||
06045 |
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 |
|||
06046 |
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” must not be less than “27320” or greater than “50000”. |
SW |
1 |
X |
|||
06047 |
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” must not be less than “32800” or greater than “56000”. |
SW |
1 |
X |
|||
06048 |
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” must not be less than “37960” or greater than “59000”. |
SW |
1 |
X |
|||
06049 |
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” must not be less than “44270” or greater than “68000”. |
SW |
1 |
X |
|||
06050 |
If ROLE-ID is always “013” or “087”, then the sum of all PAYROLL-AMOUNTs for PAYROLL-ACTIVITY-CODE “80” must not be greater than “65000”. |
SW |
1 |
X |
|||
06051 |
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” must not be greater than “70000”. |
SW |
1 |
X |
|||
06052 |
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” must not be less than “35000”. |
SW |
1 |
X |
|||
06053 |
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” must not be greater than “105000”. |
W |
1 |
X |
|||
06054 |
If a ROLE-ID is reported for the staff member, then FTE Salary must not be less than “5000”. |
SW |
1 |
X |
|||
06055 |
FTE Salary must not be greater than “350,000”. |
SW |
1 |
X |
|||
06056 |
If a ROLE-ID is reported for the staff member, then FTE Salary must not be greater than “90,000”. |
SW |
1 |
X |
|||
06057 |
If PAYROLL-AMOUNT is “000000”, then PAYROLL-ACTIVITY-CODE must be “78”. |
F |
1 |
X |
|||
06058 |
If PAYROLL-ACTIVITY-CODE is “78”, then PAYROLL-AMOUNT must be “000000”. |
F |
1 |
X |
|||
06059 |
If PAYROLL-ACTIVITY-CODE is “78”, then there must not be a record where PAYROLL-ACTIVITY-CODE is “80”. |
SW |
1 |
X |
|||
06065 |
If ROLE-ID is always “033”, then there must be at least one record where FUNCTION-CODE is “11”, “12”, or “31”. |
SW |
1 |
X |
|||
06081 |
If PROGRAM-INTENT-CODE is “11”, then FUND-CODE must 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”, “411”, “413”, “414”, “415”, “420”-“422”, “424” - “426”, “429”, “433”, “439”, “440”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06082 |
If PROGRAM-INTENT-CODE is “21”, then FUND-CODE must 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”, “411”, “413”, “414”, “420”-“422”, “425”, “426”, “429”, “433”, “439”, “440”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06083 |
If PROGRAM-INTENT-CODE is “22”, then FUND-CODE must 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”, “411”, “413”, “414”, “417”, “420”-“422”, “425”, “426”, “429”, “433”, “439”, “440”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06084 |
If PROGRAM-INTENT-CODE is “23”, then FUND-CODE must 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”, “411”, “413”-“416”, “419”, “420”-“422”, “425”, “426”, “429”, “434”, “435”, “437”, “439”, “440”, “441”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06085 |
If PROGRAM-INTENT-CODE is “24”, “26”, “28”, or “29”, then FUND-CODE must be “102”, “199”, “204”-“206”, “208”, “211”-“213”, “220”, “222”, “223”, “236”-“239”, “255”, “256”, “258”, “259”, “261”, “262”, “264”-“276”, "285", “287”, “289”, “292”-“295”, “297”, “300”-“302”, “309”, “311”, “312”, “325”, “326”, “327”, “328”, “329”, “342”, “343”, “347”-“349”, “351”-“352”, “354”-“358”, “379”, “381”-“384”, “388” -“399”, “401”, “402”, “404”, “409”, “410”-“416”, “419”-“422”, “429”, “431”-”433”, “439”, “440”, “441”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06086 |
If PROGRAM-INTENT-CODE is “25”, then FUND-CODE must be “102”, “199”, “204”, “208”, “212”, “255”, “258”, “259”, “263”, “269”-“273”, “287”, “289”, “293”, “297”, “301”, “347”, “350”, “357”, “379”, “383”, “388”, “389”, “390”, “391”, “393”, “402”, “407”, “410”-“415”, “420”-“423”, “425”, “426”, “429”, “433”, “439”, “440”, “442”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||
06087 |
If PROGRAM-INTENT-CODE is “91”, then FUND-CODE must be “199”, “272”, “420”, “461”, “479”, “499”, or “699”. |
SW |
1 |
X |
|||
06088 |
If PROGRAM-INTENT-CODE is “99”, then FUND-CODE must 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”-”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 |
|||
06089 |
FUND-CODE must not be “102” or "400". |
F |
1 |
X |
X |
||
06090 |
If PROGRAM-INTENT-CODE is “91”, then FUNCTION-CODE must be “36”, “51”, or “52”. |
SW |
1 |
X |
|||
06091 |
If FUNCTION-CODE is “11”, then there must be an 090 record with a matching STAFF-ID. |
SW |
1 |
X |
|||
06092 |
FUNCTION-CODE must not be “62”. |
F |
1 |
X |
X |
||
06093 |
PROGRAM-INTENT-CODE must not be “71”-“79” or “81”-“89”. |
F |
1 |
X |
X |
||
06095 |
ORGANIZATION-CODE must not be “700”, “704”-“719”, “721”-“749”, or “752”-“997”. |
F |
1 |
||||
06096 |
If ORGANIZATION-CODE is less than “699”, and ORGANIZATION-CODE is not found in the CAMPUS-ID table. |
SW |
1 |
X |
|||
0601A |
PAYROLL-ACTIVITY-CODE must be “79” or “80”. |
SW |
1 |
X |
X |
X | |
0601C |
ORGANIZATION-CODE must not be “703” or “751”. |
SW |
1 |
X |
X |
X |
|
0601D |
FUNCTION-CODE must not be “9X”. |
SW |
1 |
X |
X |
X |
|
0601E |
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 |
X |
X |
|
0601F |
If FUND-CODE is “400”, “403”, or “405”-“408”, then DISTRICT-ID must be registered with the TEA as an ESC. |
SW |
1 |
X |
|||
0601G |
FUNCTION-CODE must not be “00”. |
F |
1 |
X |
|||
0601H |
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 | ||
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 |
|||
0601K |
The value of STAFF-ID on this record must match the value of STAFF-ID on some 040 record. |
F |
1 |
X |
|||
0601L |
Each district’s data submission must contain one 060 record for each payroll account that can be specified using the Resource Guide account codes that are found in the Data Standards. |
F |
1 |
X |
|||
0601O |
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 must be "2". |
SW |
1 |
X |
X |
X | |
0601P |
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 |
X |
X | |
0601Q |
If PROGRAM-INTENT-CODE is “30”, then FUND-CODE must be “102”, “199”, “211”, “266”, “271”, “272”, “276”, “285”-“287”, “289”, “300”, “358”-“360”, “366”, or “420”. |
SW |
1 |
X |
|||
0601R |
If FUND-CODE is “101”, “102”, “199”, “240”, “420”, or “701”, then FISCAL-YEAR must be “2”. |
SW |
1 |
X |
|||
0601S |
FISCAL-YEAR must be “9”, “0”, “1”, or "2" if FUND-CODE is “2XX”-“429”. |
SW |
1 |
X |
|||
0601T |
If PROGRAM-INTENT-CODE is “31”, then FUND-CODE must be “199” or “420”. |
W |
1 |
X |
|||
0601U |
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 |
||
0601V |
Former edit deleted. |
||||||
0601W |
If SERVICE-ID on the 090 record is “01010000”’, then PROGRAM-INTENT-CODE must be “32”. |
SW |
1 |
X |
|||
0601X |
If PROGRAM-INTENT-CODE is “32”, then FUND-CODE must 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”-“411”, “413”-“416”, “419”-“423”, “426”, “429”, “439”-“442”, “459”, “461”, “479”, or “499”. |
SW |
1 |
X |
|||