Understanding Expense Participation Calculation Revisions

After you generate expense participation calculations in the E.P. Calculation Generation program (R15110), use the E.P. Calculation Revisions program (P15382) to review, revise, and recalculate the expense participation amounts. The system displays the expense participation calculations in the P15382 program in the same format as on the E.P. Calculation Register report (R1538).

This table lists the fields on the Page 1 tab in the E.P. Calculation Revisions program (P15382), navigation information for the program, and form from which the system retrieves information:

Field in the E.P. Calculation Revisions Program (P15382)

Program and Form Name

Class Exp. (E.P. tenant class exposure)

In the E.P. Class Information program (P1530), access the E.P. Class Information Revisions form.

Common Adj.(common adjustment)

In the E.P. Class Information program (P1530), select Class Adjustments from the Form menu to access the E.P. Class Adjustment Revisions form.

Admin Fee (administration fee)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

In the E.P. Class Information program (P1530), access the E.P. Class Information Revisions form.

In the E.P. Class Information program (P1530), select Account Overrides from the Row or Form menu to access the E.P. Class Account Overrides form.

Admin B/R Code

Access the EP Class Revisions program (P1530)

Access the EP Information Revisions program (P15012)

Excl. Value (exclusion value)

Access the Tenant Exclusion Rule program (P150120).

Access the E.P. Information program (P15012).

Adj. Factor Amnt. (adjustment factor amount)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

In the E.P. Class Information program (P1530), access the E.P. Class Account Overrides form.

In the E.P. Class Information program (P1530), access the E.P. Class Information Revisions form.

Trans Excl. (transaction exclusion)

Access the EP Calculation Revisions program (P15382).

Acct. Adj. (account adjustment)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

Acct Exclusions (E.P account exclusions)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

Redistrib. Adj (redistribution adjustment)

System-calculated

Gross Up Adj (gross up adjustment)

In the EP Class Information program (P1530), access the Account Overrides form.

In the EP Information Revisions program (P15012), access the EP Adjustment form.

Adj. Amount (1) (class adjustment amount)

In the E.P. Class Information program (P1530), access the E.P. Class Adjustments Revisions form.

Cap Adj. (C) (cap adjustment)

Access the EP Class Information program (P1530)

Adj. Amount (2) (class adjustment amount)

Access the EP Class Information program (P1530), access the E.P. Class Adjustments Revisions form.

Max Limit (C) (E.P. class expense limit)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

Min Limit (C) (E.P. minimum class limit)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

This table lists the fields on the Page 2 tab in the E.P. Calculation Revisions program (P15382), navigation information for the program, and form from which the system retrieves information:

Field in the E.P. Calculation Revisions Program (P15382)

Program and Form Name

Cmpd. Excl. (compounded base exclusion), Base (base exclusion), Cmpnd. (compound factor), Yr (year), Base Excl. Per Sq. Ft. (base exclusion per square foot) and Base Excl. Group (base exclusion group)

Access the E.P. Information program (P15012)

Share Factor

Access the E.P. Information program (P15012)

Comp. (computation method)

Access the E.P. Information program (P15012)

Max Limit (L) (E.P. tenant share limit)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

Min Limit (L) (E.P. minimum lease limit)

In the E.P. Information program (P15012), access the Expense Participation Adjustments form.

Sub Group Limit

Access the E.P. Information program (P15012)

Group Limit

Access the E.P. Information program (P15012)

Occup. Adj (occupancy adjustment)

Access the E.P. Information program (P15012)

Est Billing (estimated billing)

Access the E.P. Information program (P15012)

You can use the P15382 program to revise an amount or calculation, to add a transaction exclusion amount to the class exposure, or to delete one or more calculations from the batch. For example, if one the calculations was not set up correctly, you can delete it without affecting the remaining records in the batch. Each adjustment that you specify affects the tenant's expense share amount differently

When you revise an amount, you must recalculate the remaining amounts to update them correctly. When you select Recalculate from the Form menu, the system displays a message to notify the user that the calculated amounts were overridden. You can revise and recalculate amounts as often as necessary before you generate expense participation billing records.

To revise amounts after you generate billing records, you can delete the calculation batch using the E.P. Batch Delete program (R158061), and then regenerate it after making the desired revisions. Although the system enables deletion, if you delete an expense participation calculation record after the billing records are generated, you lose the audit trail to how the system derived the expense participation amounts.

On the EP Calculation Revisions form, you can also access audit programs by selecting the link attached to the following field names:

  • Select Common Adj to access the Class Adjustments Audit File form.

    You cannot revise records in this audit file.

  • Select Adj Factor Amt to access the Adjustment Factor Audit File form.

    You cannot revise records in this audit file.

  • Select Acct Adj to access the Account Adjustment Audit File form.

    You cannot revise records in this audit file.

  • Select Acct Exclusions to access the Account Exclusions Audit File form.

    You cannot revise records in this audit file.

  • Select Redistrib Adj to access the Exclusion/Redistibution Audit Revisions form.

  • Select Gross Up Adj to access the Gross Up Adjustment Audit Revisions form.

    You can modify the gross up factor on this form.

  • Select Adj Amount (1) or Adj Amount (2) to access the Class Adjustments Audit File form.

    You cannot revise records in this audit file.

  • Select Cap Adj (C) to access the Expense Cap Detail form.

  • Select Share Factor Denominator to access the Share Factor Denominator Audit form.

  • Select Cap Adj (L) to access the Lease Cap Detail form.

Note: You cannot use the P15382 program to make changes to records that contain group and subgroup limits. The program looks only at individual records, not records that may be connected due to group limitations.

The system updates information in the EP Billing Register table (F1538B).