Entity: PayrollExt

Not applicable

LocalEducationAgency

PEIMS Profile page

This field is not displayed on the user interface.

Database field:

pem_profile.district_id

Database field:

tx_payroll.lea_id

Not applicable

int

Not applicable

Not applicable

Staff

Staff Information page

This field is not displayed on the user interface.

Database field:

tx_staff.staff_id

Database field:

tx_payroll.staff_id

Not applicable

varchar(9)

Not applicable

E0974

FiscalYear

Pay Rate Information page

and

State Year field on the Account Translations page.

Database field:

trn_acct.pem_yr

Year field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.fiscal_year

Not applicable

int

Not applicable

E0425

PayrollAmount

On the Pay Rate Information page, if Contract Position is selected, the source is the Contract Limit field.

If Contract Position is not selected, the source is the Annual Salary field.

Database field:

If Contract Position is selected, the calculation is payrate.cont_lim *dist_orgn.prcent.

If Contract Position is not selected, the calculation is payrate.annl_sal * dist_orgn.prcent.

Pay Amount field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.amount

Not applicable

int

• Rates are not included if the contract end date is less than the contract end date entered when loading data, or the pay rate is terminated or inactive, and terminated and/or inactive rates are not included for the load.

• Salary is distributed across distributions and then grouped/summed by distribution and begin and end dates.

E0316P

PayrollFund

Pay Rate Information page

and

State Fund field on the Account Translations page.

Database field:

trn_acct.pem_fund

Fund field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.fund_code

Not applicable

varchar(300)

Not applicable

E0317P

PayrollFunction

Pay Rate Information page

and

State Function field on the Account Translations page.

Database field:

trn_acct.pem_func

Function field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.function_code

Not applicable

varchar(300)

Not applicable

E0318P

PayrollObject

Pay Rate Information page

and

State Object field on the Account Translations page.

Database field:

trn_acct.pem_object

Object field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.object_code

Not applicable

varchar(300)

Not applicable

E0319

Organization

Pay Rate Information page

and

State Organization field on the Account Translations page.

Database field:

trn_acct.pem_orgn

Organization field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.organization_id

Not applicable

varchar(3)

Not applicable

E0320P

PayrollProgramIntent

Pay Rate Information page

and

State Program field on the Account Translations page.

Database field:

trn_acct.pem_prog

Program Code field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.program_code

The valid values are stored on the PEIMS Programs Table page.

varchar(300)

Not applicable

E0424

PayrollActivity

PEIMS Code field on the General tab of the Pay Codes page.

Database field:

SELECT peims_cd FROM etx_paytable

WHERE

pay_code = payrate.pay_cd

The pay rate is skipped if peims_cd is not found.

Activity Code field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.activity_code

The valid values are stored on the PEIMS Activity Table page.

varchar(300)

Not applicable

E3010

BeginDate

Start Date field on the Pay Rate Information page.

Database field:

payrate.cont_start

Begin Date field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.begin_date

Not applicable

smalldatetime

Not applicable

E3020

EndDate

End Date field on the Pay Rate Information page.

Database field:

payrate.cont_end

End Date field on the Payroll Accounting tab of the Staff Information page.

Database field:

tx_payroll.end_date

Not applicable

smalldatetime

Not applicable