Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMEFFORT


                             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