|
|
GMEFFORT FILE
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
BN305 HR11.1 HR11.2 HR511 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 HR00.1
HR01.1 HR02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EFH-HR-COMPANY Numeric 4
Element: Company Hr Contains the HR company for which
effort reporting is run.
EFH-EMPLOYEE Numeric 9
Element: Employee 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 Numeric 8 (yyyymmdd)
Element: Begin Date The begin date for this effort period.
EFH-END-DATE Numeric 8 (yyyymmdd)
Element: End Date The ending date for this effort period.
EFH-SEQUENCE-NBR Numeric 4
Element: Sequence Nbr The user-assigned sequence number to
keep the records unique and to determine
order.
EFH-PROCESS-LEVEL Alpha 5
Element: Process Lev Hr
EFH-DEPARTMENT Alpha 5
Element: Department Contains the department.
EFH-STATUS Numeric 1
Element: Status 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 Numeric 9
Element: Employee 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 Alpha 10 (Lower Case)
Element: User 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 Numeric 8 (yyyymmdd)
Element: Date The primary certifier login date used
for audit purposes.
EFH-PRMCERT-TIME Numeric 8
Element: Time The Primary Certifier login time, used
for audit purposes.
EFH-SNDCERT-ID Numeric 9
Element: Employee 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 Alpha 10 (Lower Case)
Element: User 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 Numeric 8 (yyyymmdd)
Element: Date The Secondary Certifier login date, used
for audit purposes.
EFH-SNDCERT-TIME Numeric 8
Element: Time The Secondary Certifier login time, used
for audit purposes.
EFH-JOB-CODE Alpha 9
Element: Job Code 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 Alpha 12
Element: Position 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 Signed 13.6
Element: Effort Pct 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 Signed 13.6
Element: Effort Pct 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 Signed 13.6
Element: Effort Pct Percentage of planned effort to be
transferred to the activity and GL
account specified; negatives are not
permitted.
EFH-TOT-CALC-PAY Signed 13.6
Element: Effort Pct 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 Signed 13.6
Element: Effort Pct 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 Numeric 4
Element: Company Identifies the HR company for the
Primary Certifier.
EFH-SND-CERT-HR-CO Numeric 4
Element: Company Identifies the HR company for the
Secondary Certifier.
GMEFFORT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EFHSET1 HR-COMPANY BN305 HR11.1
EMPLOYEE HR11.2 HR511
BEGIN-DATE PA02.1 PA100
END-DATE PA102 PA115
SEQUENCE-NBR PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
EFHSET2 HR-COMPANY KeyChange HR00.1 HR01.1
PROCESS-LEVEL HR02.1
DEPARTMENT
EMPLOYEE
BEGIN-DATE
END-DATE
SEQUENCE-NBR
EFHSET3 HR-COMPANY
EMPLOYEE
BEGIN-DATE
END-DATE
SEQUENCE-NBR*
GMEFFORT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
