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:
|
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:
|
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:
|
Parent Topic: Subtasks of Import Budget/EACs from Excel