GMTRANEFRT – Grant Effort Transaction
- System
- GM (GM)
- Prefix
GEF- Primary key
OBJ-ID- Fields
- 32
- Updated by
- 2 programs
- Referenced by
- 32 programs
GMTRANEFRT is the Grant Effort Transaction table in Lawson GM (prefix GEF). It is indexed by OBJ-ID (GEFSET1); alternate indexes: GEFSET2, GEFSET3 and GEFSET4. It is related 1:1 to ACACCTCAT, ACACTIVITY, CUCODES, EMPLOYEE, GLNAMES, GLSYSTEM, GMLABDIST, GMRETDIST and 1 more. It is updated by PR197 and PR85.1 and referenced by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 24 more. The table has 32 fields, 4 indexes and 11 documented relations.
About GMTRANEFRT
The GMTRANEFRT file stores effort transaction used to calculate effort percentages during effort reporting. If a labor cost transfer occurs and the original transaction was subject to effort reporting, a cost transfer adjustment needs to be made in the effort file. The pay period end date is added to the effort transaction file so effort adjustmetns are properly calculated and created when GM170 is urn with the pro-rate distributions option.
Fields (32)
Column = COBOL field name without the GEF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#GEF-OBJ-ID PKOBJ_ID | Numeric 12 | Object Identifier. Ensures transaction is unique. Note: This does not track back to the ACTRANS or the PRDISTRIB object id's. It is possible to have an effort transaction with a zero salary amount and a planned effort amount. A zero amount transaction are not permitted in the ACTRANS or PRDISTRIB. | PR197, PR85.1 |
#GEF-RECORD-TYPERECORD_TYPE | Alpha 1 | This field identifies the type of record defined. Valid values are: " " = Record created by PR197
| PR197 |
#GEF-TRAN-DATE SET4TRAN_DATE | Numeric 8 (yyyymmdd) | Updated from the original transaction. Timerecord date. | PR197 |
#GEF-HR-COMPANY SET2 SET4HR_COMPANY | Numeric 4 | — | PR197 |
#GEF-EMPLOYEE SET2 SET4EMPLOYEE | 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. | PR197 |
#GEF-ACTIVITY SET2 SET3ACTIVITY | Alpha 15 | Not required, updated from the employee's time record. | PR197 |
#GEF-ACCT-CATEGORY SET2 SET3ACCT_CATEGORY | Alpha 5 | Not required, updated from time record's account category. | PR197 |
#GEF-COMPANY SET2COMPANY | Numeric 4 | Required, updated from time record's GL company (DIST-COMPANY). | PR197 |
#GEF-ACCT-UNIT SET2ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | PR197 |
#GEF-ACCOUNT SET2ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | PR197 |
#GEF-SUB-ACCT SET2SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | PR197 |
#GEF-SALARY-AMTSALARY_AMT | Signed 18.2 | Identifies the calculated salary amount from PR197 distribution. Calculated as follows: Time record wage amount multiplied times the GM labor distribution salary percentage. | PR197, PR85.1 |
#GEF-EFFORT-AMTEFFORT_AMT | Signed 18.2 | Identifies the calculated effort amount. Calculated as follows: Time record wage amount multiplied times the GM labor distribution effort percentage. | PR197, PR85.1 |
#GEF-CURRENCY-CODECURRENCY_CODE | Alpha 5 | Required, identifies currenty for SAL-AMT and EFFORT-AMT. Updated from the employee's time record. | PR197 |
#GEF-CURRENCY-NDCURRENCY_ND | Numeric 1 | Required, identifies number of decimals for SAL-AMT and EFFORT-AMT. | PR197 |
#GEF-SAL-RPT-AMTSAL_RPT_AMT | Signed 18.2 | Salary amount exchanged to effort reporting currency. | PR197, PR85.1 |
#GEF-EFFORT-RPT-AMTEFFORT_RPT_AMT | Signed 18.2 | Planned effort amount exchanged to the effort reporting currency. | PR197, PR85.1 |
#GEF-RPT-CURRRPT_CURR | Alpha 5 | Identifies the effort reporting currency. Effort reporting currency is defined in the employee file. | PR197 |
#GEF-RPT-CURR-NDRPT_CURR_ND | Numeric 1 | Required, identifies number of decimals for SAL-RPT-AMT and EFFORT-RPT-AMT. | PR197 |
#GEF-PER-END-DATE SET4PER_END_DATE | Numeric 8 (yyyymmdd) | Identifies the pay period end date for the effort transaction. Updated during PR197 via the effort update API (GMET90). | PR197 |
#GEF-JOB-CODEJOB_CODE | Alpha 9 | Identifies the a user-defined code that represents a type of job code from the timerecord. | PR197 |
#GEF-PAY-CODEPAY_CODE | Alpha 4 | Contains the pay code from the timerecord. A pay code is a user-defined code that identifies a kind of pay. | PR197 |
#GEF-POSITIONPOSITION | Alpha 12 | Contains the user-defined code that represents a position in the company from the time card. | PR197 |
#GEF-CHECK-ID SET4CHECK_ID | Numeric 12 | Contains the payment identification number (unique payment identifier used in tracking payment information). | PR197, PR85.1 |
#GEF-OT-PLAN-CODEOT_PLAN_CODE | Alpha 4 | Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD). | PR197 |
#GEF-GM-ADJ-TYPEGM_ADJ_TYPE | Alpha 1 | Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170. | PR197, PR85.1 |
#GEF-GMI-OBJ-ID-1GMI_OBJ_ID_1 | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | PR197 |
#GEF-GMI-OBJ-ID-2GMI_OBJ_ID_2 | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | PR197 |
#GEF-GML-OBJ-ID SET4GML_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | PR197 |
#GEF-UPDT-DATEUPDT_DATE | Numeric 8 (yyyymmdd) | — | PR197 |
#GEF-UPDT-TIMEUPDT_TIME | Numeric 8 | — | PR197 |
#GEF-OPERATOROPERATOR | Alpha 10 | — | PR197 |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GEFSET1 |
| Primary | PR85.1 | |
GEFSET2 |
| KeyChange | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source) | |
GEFSET3 |
| KeyChange | — | |
GEFSET4 |
| — |
Relations
One to one (11) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required |
| |||||||
| Acactivity | ACACTIVITY | Not Required |
| |||||||
| Cucodes | CUCODES | Not Required |
| |||||||
| Cucodes Rpt | CUCODES | Not Required |
| |||||||
| Employee | EMPLOYEE | Required |
| |||||||
| Glnames | GLNAMES | Not Required |
| |||||||
| Glsystem | GLSYSTEM | Not Required |
| |||||||
| Gmlabdist | GMLABDIST | Not Required |
| |||||||
| Gmretdist1 | GMRETDIST | Not Required |
| |||||||
| Gmretdist2 | GMRETDIST | Not Required |
| |||||||
| Prsystem Comp | PRSYSTEM | Required |
|
Programs
Updated by (2)
Referenced by (32)
- BN305 Highly Compensated Employees
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- ZH510 Update PCP from ZPENDPCP