Internal Costing Journal
The Internal Costing Journal (ICJ) inquiry page stores labor, equipment, mileage, materials testing usage, interfaced payroll and interfaced equipment information. This inquiry page is updated by the Internal Costing Usage Transaction and the Internal Costing system process.
Once a journal record is selected and processed, the Internal Cost Process Date field is populated by the Internal Cost Update job step (part of the Internal Costing system process). Similarly, when a journal record is processed by the Charge Transaction XML Generation job step (also part of the Internal Costing system process) the Internal Cost Charge Generation Date.
Field InformationField Information
The table below lists only those fields not already mentioned above (the two indications of system processing) and those listed in the Internal Costing Transaction section.
Field Name |
Description |
Standard Salary |
This amount is calculated by multiplying the Regular Labor/Usage Units by the Salary Rate from the Employee Information or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple Employee Information records. |
Standard Employee Benefits 1 – 5 |
These amounts are calculated by multiplying the Standard Salary amount by the applicable Employee Benefits Multiplier rate(s) from Employee Benefits Multiplier or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Benefits Multiplier. |
Overtime Salary |
This amount is calculated by multiplying the Overtime Labor/Usage Units by the Salary Rate from Employee Information or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Information. If an Overtime Multiplier Code was specified, then each Salary Rate used in the calculation of Overtime Salary is multiplied by the Overtime Multiplier Rate. |
Overtime Employee Benefits 1 - 5 |
These amounts are calculated by multiplying the Overtime Salary amount by the benefit rates from Internal Cost Rate or Employee Benefits Multiplier. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Benefits Multiplier. |
Standard Cost |
This amount is calculated by one of three ways based on Usage Group:
|
Fixed Cost |
This amount is calculated when the Rate Category is Fixed by multiplying Regular Labor/Usage Units by the Equipment Rate from Equipment or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Equipment. |
Equipment Surcharge |
This amount is calculated by multiplying the Regular Labor/Usage Units with the Equipment Surcharge Rate from Equipment or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Equipment. |
Total Costs |
This amount is calculated in one of three ways based on Usage Type:
|
Overhead Basis |
This field stores the sum of the Standard Salary, Standard Overtime, Standard Employee Benefits, and Standard Unpaid Employee Benefits fields. The Overhead Basis is multiplied by various overhead rates during the Internal Costing process to determine the overhead amounts. |
Overhead Fiscal Year |
The fiscal year derived from the Usage From Date. The Overhead Fiscal Year can differ from the Fiscal Year for Pay Periods 1 and 26. |
Division Overhead Group Overhead Section Overhead District Overhead Bureau Overhead Unit Overhead Sitewide Overhead Overhead 1 - 4 |
Each is a separate amount updated by the Internal Costing process based on the Usage Group, COA, and rates setup on Internal Cost Overhead Rate (OHRTIC). For Equipment, Chargebacks, and Other Usage Group, Unit Overhead is not applicable and is set to zero. |