Employee Accounting Status
 Previous Top Next
The Employee Accounting Status File (files with extension ea.csv) specifies employee accounting status at the grant level. All updates to employee status for grants are handled through this file. 



Insertions and Modifications
The upload file can contain both new records, and updates to existing records. The combination of GrantID, Effective Date and Employee Accounting Status provides a unique record.

Whenever this record is provided it will add or replace the information for the unique key.


Deletions

To delete a specific record, the unique key only with no other information should be provided. This would be a record containing GrantID, Effective Date and Employee Accounting Status.



Deletion records can be in the same file as insertion and modification records.

File Format
       #
Field Name
P =Required
Field Type
Sample Field
Description
1
GrantID
P
Alpha-Numeric (40)
GR222
This must be a valid GrantID that was previously established in the system
2
Effective Date
P
Date
2/17/2005
The effective date of the change in employee status
3
Employee Accounting Status
P
List Selection (Enumeration)
 
Employee
The Employee Status is EMPLOYEE or NONEMPLOYEE
This is called an Employee Accounting Status because it is used for expense reporting and does not necessarily have a payroll or human resource meaning.


An example of valid lines in an Employee Accounting Status File are as follows:
Grant01, 1/1/2011,EMPLOYEE