User Tools

Site Tools


Sidebar

Table of Contents

general:staff_extract_automatic_crosswalks

Staff Extract Automatic Crosswalks

If your district maintains staff payroll data in greater detail than the state-mandated level, the detail is summarized to the state-mandated level. The automatic crosswalks in the extract program perform the summarization.

The state-mandated level of detail for staff payroll data can be found in the TEA Financial Accountability System Resource Guide.

The program only extracts staff payroll records where the object is 6148, 6149, or ≤ 6139, and the fund is ≤ 799. The extract program will automatically make the following changes to the staff payroll data being extracted:

Account Code DescriptionAccount CodePEIMS Code
fund> 160 and < 199199
fund> 287 and < 289289
fund> 367 and < 379379
fund> 426 and < 428429
fund> 445 and < 459459
fund> 471 and < 479479
fund> 479 and < 499499
fund> 510 and < 599599
fund> 615 and < 699699
fund> 710 and < 749749
object> 6115 and < 61196119
object> 6124 and < 61296129
object> 6133 and < 61396139
object= 61486149
org> 708 and < 720720
org> 725 and < 750750
org> 799 and < 998999
object= 6XXX, function <> 11, and program = 00program = 99
general/staff_extract_automatic_crosswalks.txt · Last modified: 2020/07/15 07:43 by 127.0.0.1