Actual Grant Effort
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.
REFERENCED BY
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EFHSET1 |
HR-COMPANY EMPLOYEE BEGIN-DATE END-DATE SEQUENCE-NBR |
|
|||||||||||
EFHSET2 |
HR-COMPANY PROCESS-LEVEL DEPARTMENT EMPLOYEE BEGIN-DATE END-DATE SEQUENCE-NBR |
|
| ||||||||||
EFHSET3 |
HR-COMPANY EMPLOYEE BEGIN-DATE END-DATE SEQUENCE-NBR* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Deptcode | DEPTCODE |
Not Required
| |||||||||
Employee | EMPLOYEE |
Required
| |||||||||
Employee Crt1 | EMPLOYEE |
Not Required
| |||||||||
Employee Crt2 | EMPLOYEE |
Not Required
| |||||||||
Prsystem Comp | PRSYSTEM |
Required
| |||||||||
Prsystem Crt1 | PRSYSTEM |
Not Required
| |||||||||
Prsystem Crt2 | PRSYSTEM |
Not Required
| |||||||||
Prsystem Prlvl | PRSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.