Budget/EAC Errors Subtask

Use this screen to view the generated errors during validation and other details from the Excel import file.

This subtask displays the errors that were generated during validation of the import file. The details populate after you click Validate Input File and Import Budget/EACs on the Action menu.

A few columns in the subtask display details about the report itself, such as the ID of the logged in user, but otherwise, the column headings in the subtask map to the column headings of the Excel import file.

A separate row displays for each error that occurred.

Contents

Field Description
Upload ID This column displays the system generated ID number that is associated with the upload.
Input File Name This column displays the name of the file that you selected for processing.
Session ID This column displays the auto-generated ID assigned to the session.
User ID This column displays the login ID of the user who processed the parameter.
Error Message This column displays the error that prevented the record from being processed for import.
Project ID This column displays the ID of the project where the error occurred.
ID Type This column maps to the ID_Type column of the Excel import file. Possible values from that field include:
  • Employee
  • Contractor Employee
  • Vendor
  • Vendor Employee
  • Generic
  • Key Entry
  • GLC
  • PLC
For some ID Types, the value that displays in the subtask might be abbreviated. For example, the letter “E” substitutes for the word “Employee.”
ID This column displays the ID of the resource. For example, if the resource type is E, the ID for that employee displays in this column.
Account ID This column displays the labor or non-labor account ID of the resource.
Org ID This column displays the organization ID of the resource.
PLC This column displays the project labor category of the resource.
Hourly Rate This column displays the hourly rate of the resource, if applicable.
Period End Date This column displays the period ending date of the budget or EAC.
Amount This column displays the amount for the non-labor account of the resource.
Hours This column displays the number of hours that are being imported for that resource.
Burd Flag This column indicates whether the Burden column in the Excel import template is selected as Yes or No, represented here by either a 1 or a 2. For example:
  • 1: The corresponding column is selected as Yes, so burden will be calculated.
  • 2: The corresponding column is selected as No, so burden will not be calculated.
Rev Flag This column indicates whether the Revenue column in the Excel import template is selected as Yes or No, represented here by either a 1 or a 2. For example:
  • 1: The corresponding column is selected as Yes, so revenue will be calculated.
  • 2: The corresponding column is selected as No, so revenue will not be calculated.