Maintain Payroll RP20 Or RP25 Records - Salary Distribution tab
This tab displays the detailed distribution salary records for the pay runs included in that month's loaded data. Additionally, flags indicate the amount to be charged. Only the Statutory Minimum, Non-OASDI, TRS Eligible, Federal, and New Member flags may be charged. Additionally, if an RP20 record is added for an employee who is excluded from the load, Salary Distribution records are created to charge their fringe amounts accurately.
The following table describes the fields on the Salary Distribution tab of the TX Team Report - Payroll (RP20/RP25) page.
Field | Description | Load logic - Data source and Valid values |
|---|---|---|
Account Number | The full account number. This field is displayed when the Full Account Format is enabled. | Calculated during the data load process. The calculated value represents the combined organization and account segments from the employee's payroll distribution records, formatted according to the district's account translation mask (trans_acct table) when Full Account Format is enabled. |
Budget Code | The budget code. This field is displayed when the Full Account Format is turned off. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the organization and/or project code from the employee's payroll distribution records (detdist table). This value is automatically populated based on how the employee's salary was charged during payroll processing. The field value is stored in the tx_team_saldist.orgn_proj field. |
Account | The account code. This field is displayed when the Full Account Format is turned off. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value corresponds to the general ledger account code in the employee's payroll distribution records. This is the account to which the salary expense was posted during payroll processing. If Full Account Structure is enabled, the value represents the complete account string, combining the budget code and account fields. The field value is stored in the tx_team_saldist.acct field. |
Position | The position code. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the TRS position code (00-09) determined by the system based on the employee's job classification, pay rate, and position assignment for the reporting period. The field value is stored in the tx_team_saldist.position field. |
Pay Code | The pay code. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value corresponds to the pay code in the payroll distribution that identifies the type of compensation (regular pay, overtime, stipends, etc.). The field value is stored in the tx_team_saldist.code field. |
Amount | The amount for the salary distribution. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the gross salary amount distributed to this particular account/position combination from the employee's payroll records for the reporting month. The field value is stored in the tx_team_saldist.amount field. |
Statutory Minimum | Indicates whether the salary is subject to the statutory minimum. | Calculated based on the employee's setup, deductions, and fund sources. The field value is stored in the tx_team_saldist.stat_min field. |
Non-OASDI | Indicates whether the salary is exempt from OASDI taxation. | Calculated based on the employee's setup, deductions, and fund sources. The field value is stored in the tx_team_saldist.non_oasdi field. |
TRS Eligible | Indicates whether the salary is TRS eligible. This will not affect the information on the ED40 or payroll process charges. | Calculated based on the employee's setup, deductions, and fund sources. The field value is stored in the tx_team_saldist.fed_fund field. |
Federal Flag | Indicates whether the salary is paid from a federal fund. | Calculated based on the employee's setup, deductions, and fund sources. The field value is stored in the tx_team_saldist.fed_flg field. |
New Member | Indicates whether the salary is subject to new member benefits. This will not affect the information on the ED40 or payroll process charges. | Calculated based on the employee's setup, deductions, and fund sources. The field value is stored in the tx_team_saldist.new_member field. |
Redistributed | Indicates whether the salary was redistributed. Otherwise, it is blank. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents whether this salary distribution record was redistributed (marked with 'R'). This flag is automatically set based on payroll system redistribution transactions. The field value is stored in the tx_team_saldist.redist field. |
Check Number | The salary check number. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value corresponds to the check or direct deposit number associated with this salary payment in the payroll system. The field value is stored in the tx_team_saldist.check_no field. |
Pay Run | The pay run code for the employee's salary. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the payroll run identifier for the payment (e.g., regular, supplemental, or off-cycle). The field value is stored in the tx_team_saldist.pay_run field. |
Pay Group | The pay group to which the employee is assigned. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the pay group code assigned to the employee that determines their pay frequency and processing schedule. The field value is stored in the tx_team_saldist.pay_group field. |
Date Changed | The date that the salary distribution was changed. This field is view-only and cannot be updated. | Calculated during the data load process. The calculated value represents the system date when the salary distribution record was loaded or last modified by the TEAM load process. The field value is stored in the tx_team_saldist.date_changed field. |
Change Type | The type of change that was made. This field is view-only and cannot be updated. | Valid values:
Calculated during the data load process. The calculated value indicates the type of change made to the record during the data load. The field value is stored in the tx_team_saldist.change_code field. |