GMEFFORT

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EFHSET1 HR-COMPANY
EMPLOYEE
BEGIN-DATE
END-DATE
SEQUENCE-NBR
BN305 HR11.1
HR11.2 HR11.3
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
EFHSET2 HR-COMPANY
PROCESS-LEVEL
DEPARTMENT
EMPLOYEE
BEGIN-DATE
END-DATE
SEQUENCE-NBR
KeyChange
HR00.1 HR01.1
HR02.1
EFHSET3 HR-COMPANY
EMPLOYEE
BEGIN-DATE
END-DATE
SEQUENCE-NBR*


GMEFFORT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Deptcode DEPTCODE Not Required
EFH-HR-COMPANY->DPT-COMPANY (DPTSET1)
EFH-PROCESS-LEVEL->DPT-PROCESS-LEVEL
EFH-DEPARTMENT->DPT-DEPARTMENT
Employee EMPLOYEE Required
EFH-HR-COMPANY->EMP-COMPANY
EFH-EMPLOYEE->EMP-EMPLOYEE
Employee Crt1 EMPLOYEE Not Required
EFH-HR-COMPANY->EMP-COMPANY
EFH-PRMCERT-ID->EMP-EMPLOYEE
Employee Crt2 EMPLOYEE Not Required
EFH-HR-COMPANY->EMP-COMPANY
EFH-SNDCERT-ID->EMP-EMPLOYEE
Prsystem Comp PRSYSTEM Required
EFH-HR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Prsystem Crt1 PRSYSTEM Not Required
EFH-PRM-CERT-HR-CO->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Prsystem Crt2 PRSYSTEM Not Required
EFH-SND-CERT-HR-CO->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Prsystem Prlvl PRSYSTEM Required
EFH-HR-COMPANY->PRS-COMPANY
EFH-PROCESS-LEVEL->PRS-PROCESS-LEVEL


File created: Thu Jun 09 11:14:23 2016

Home
Contact Us



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