GMEFFORT – Actual Grant Effort
- System
- GM (GM)
- Prefix
EFH- Primary key
HR-COMPANY,EMPLOYEE,BEGIN-DATE,END-DATE,SEQUENCE-NBR- Fields
- 25
- Updated by
- 0 programs
- Referenced by
- 0 programs
GMEFFORT is the Actual Grant Effort table in Lawson GM (prefix EFH). It is indexed by HR-COMPANY, EMPLOYEE, BEGIN-DATE, END-DATE, SEQUENCE-NBR (EFHSET1); alternate indexes: EFHSET2 and EFHSET3. It is related 1:1 to DEPTCODE, EMPLOYEE and PRSYSTEM. The table has 25 fields, 3 indexes and 8 documented relations.
About 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.
Fields (25)
Column = COBOL field name without the EFH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EFH-HR-COMPANY PKHR_COMPANY | Numeric 4 | Contains the HR company for which effort reporting is run. | — |
EFH-EMPLOYEE PKEMPLOYEE | 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 PKBEGIN_DATE | Numeric 8 (yyyymmdd) | The begin date for this effort period. | — |
EFH-END-DATE PKEND_DATE | Numeric 8 (yyyymmdd) | The ending date for this effort period. | — |
EFH-SEQUENCE-NBR PKSEQUENCE_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
EFH-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | — | — |
EFH-DEPARTMENTDEPARTMENT | Alpha 5 | Contains the department. | — |
EFH-STATUSSTATUS | 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.
| — |
EFH-PRMCERT-IDPRMCERT_ID | 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-IDPRMCERT_USR_ID | 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-DATEPRMCERT_DATE | Numeric 8 (yyyymmdd) | The primary certifier login date used for audit purposes. | — |
EFH-PRMCERT-TIMEPRMCERT_TIME | Numeric 8 | The Primary Certifier login time, used for audit purposes. | — |
EFH-SNDCERT-IDSNDCERT_ID | 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-IDSNDCERT_USR_ID | 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-DATESNDCERT_DATE | Numeric 8 (yyyymmdd) | The Secondary Certifier login date, used for audit purposes. | — |
EFH-SNDCERT-TIMESNDCERT_TIME | Numeric 8 | The Secondary Certifier login time, used for audit purposes. | — |
EFH-JOB-CODEJOB_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-POSITIONPOSITION | 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-PCTTOT_PLAN_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-EFRTTOT_ACTL_EFRT | 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-SHARETOT_COST_SHARE | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
EFH-TOT-CALC-PAYTOT_CALC_PAY | 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-EFRTTOT_CMTD_EFRT | 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-COPRM_CERT_HR_CO | Numeric 4 | Identifies the HR company for the Primary Certifier. | — |
EFH-SND-CERT-HR-COSND_CERT_HR_CO | Numeric 4 | Identifies the HR company for the Secondary Certifier. | — |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EFHSET1 | HR-COMPANY, EMPLOYEE, BEGIN-DATE, END-DATE, SEQUENCE-NBR | Primary | BN305, HR11.1, HR11.2, HR11.3, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source) | |
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* | — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
No Lawson programs are documented as updating or referencing this table.