Effort reporting and certification is a requirement for most sponsored research. Effort is defined as the percent of time and work an employees spends on a grant irrespective of how much the grant actually funded the effort. So an employee may have 30% actual effort on the grant, bu the gran is only funded for 25% of the salary. Thus, the remaining 5% becomes cost share activity effort.
UPDATED BY

BN305	HR00.1	HR01.1	HR02.1	HR11.1	HR11.2
HR28.1	HR511	LT101	ZH510	PA02.1	PA100
PA102	PA115	PA13.1	PA13.2	PA502	PA513
PA52.1	PA52.3	PA52.4	PA52.5	PR110	PR113
PR12.6	PR120	PR13.1	PR13.5	PR13.6	PR13.8
PR13.9	PR30.2

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
EFH-HR-COMPANY Element: Company Hr	Numeric 4 Contains the HR company for which effort reporting is run.
EFH-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
EFH-BEGIN-DATE Element: Begin Date	Numeric 8 (yyyymmdd) The begin date for this effort period.
EFH-END-DATE Element: End Date	Numeric 8 (yyyymmdd) The ending date for this effort period.
EFH-SEQUENCE-NBR Element: Sequence Nbr	Numeric 4 The user-assigned sequence number to keep the records unique and to determine order.
EFH-PROCESS-LEVEL Element: Process Lev Hr	Alpha 5
EFH-DEPARTMENT Element: Department	Alpha 5 Contains the department.
EFH-STATUS Element: Status	Numeric 1 This field displays the status of the effort records. Valid values: 1 - Calculated (GM165) has been run for the first time or with the recalculate option to create the GMEFFORT records. Actual effort has not yet been entered. 2 - Entered (GM65) Actual Effort percent is input via GM65, but it is not certified. 3 - Partially Certified (GM65) Certification action has occurred on the GM65 form for the primary certifier, but a secondary certifier exist and has not certified the record. 4 - Completely Certified (GM65) Certification action has occurred on the GM65 form for the primary certifier if no secondary certifier was specified, or it has been certified by both the primary and secondary certifiers if both are assigned. 1 = Calculated 2 = Entered 3 = Partially Certified 4 = Completely Certified
EFH-PRMCERT-ID Element: Employee	Numeric 9 This is the employee ID of the Primary Certifier as defined on the HR11.3 form for the employee on this record. GM165 populates this field when the record is created.
EFH-PRMCERT-USR-ID Element: User	Alpha 10 (Lower Case) Used as an audit along with Primary Certifier Employee ID. This is the login ID of the person who certifies the effort as the primary certifier.
EFH-PRMCERT-DATE Element: Date	Numeric 8 (yyyymmdd) The primary certifier login date used for audit purposes.
EFH-PRMCERT-TIME Element: Time	Numeric 8 The Primary Certifier login time, used for audit purposes.
EFH-SNDCERT-ID Element: Employee	Numeric 9 This is the employee ID of the Secondary Certifier as define on the HR11.3 form for the employee on this record. GM165 populates this field when the record is created.
EFH-SNDCERT-USR-ID Element: User	Alpha 10 (Lower Case) Used as an audit along with secondary certified employee ID. This is the login ID of the person who certified the effort as the secondary certifier.
EFH-SNDCERT-DATE Element: Date	Numeric 8 (yyyymmdd) The Secondary Certifier login date, used for audit purposes.
EFH-SNDCERT-TIME Element: Time	Numeric 8 The Secondary Certifier login time, used for audit purposes.
EFH-JOB-CODE Element: Job Code	Alpha 9 Contains a user-defined code that represents a type of job. This is the home job code for the employee if one is defined on HR11.1. It is stored here for historical purposes. This will always be the HR11.1 job code from the point in time when the Effort Report data was created.
EFH-POSITION Element: Position	Alpha 12 Contains the user-defined code that represents a position in the company. This is the home position for the employee if one is defined on HR11.1. It is stored here for historical purposes. This will always be the HR11.1 position from the point in time when the Effort Report data was created.
EFH-TOT-PLAN-PCT Element: Effort Pct	Signed 13.6 Total calculated pay percentage for this employee for this effort report. It is the sum of the plan percent values from the related GMEFFORTX records.
EFH-TOT-ACTL-EFRT Element: Effort Pct	Signed 13.6 Total actual entered effort percentage for this employee for this effort report. It is the sum of the actual effort percent values from the GMEFFORTX records. It must be 100 percent.
EFH-TOT-COST-SHARE Element: Effort Pct	Signed 13.6 Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted.
EFH-TOT-CALC-PAY Element: Effort Pct	Signed 13.6 Total calculated pay percentage for this employee for this effort report. It is the sum of the calculated pay percent values from the related GMEFFORTX records.
EFH-TOT-CMTD-EFRT Element: Effort Pct	Signed 13.6 The total committed effort (if any) from the GMEFFORTX lines. This total does not have to be 100 percent. The committed effort reflects the time and effort percentage a givenr esource is committed to expend on a grant, as identified in the award proposal.
EFH-PRM-CERT-HR-CO Element: Company	Numeric 4 Identifies the HR company for the Primary Certifier.
EFH-SND-CERT-HR-CO Element: Company	Numeric 4 Identifies the HR company for the Secondary Certifier.

GMEFFORT FILE INDEX

GMEFFORT FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.