|
|
GMTRANEFRT FILE
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.
REFERENCED BY
HR11.1 HR11.2 HR511 PA02.1 PA100 PA102
PA115 PA502 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8
UPDATED BY
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GEF-OBJ-ID Numeric 12 PR197
Object Object Identifier. Ensures transaction
Identification 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.
GEF-RECORD-TYPE Alpha 1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
" "
1 = Gross Wages
2 = Employee Paid Expenses
GEF-TRAN-DATE Numeric 8 (yyyymmdd) PR197
Element: Transaction DaUpdated from the original transaction.
Timerecord date.
GEF-HR-COMPANY Numeric 4 PR197
Element: Company Hr
GEF-EMPLOYEE Numeric 9 PR197
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.
GEF-ACTIVITY Alpha 15 PR197
Element: Activity Not required, updated from the
employee's time record.
GEF-ACCT-CATEGORY Alpha 5 PR197
Element: Account CategoNot required, updated from time record's
account category.
GEF-COMPANY Numeric 4 PR197
Element: Company Required, updated from time record's GL
company (DIST-COMPANY).
GEF-ACCT-UNIT Alpha 15 PR197
Element: Accounting UniThe 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.
GEF-ACCOUNT Numeric 6 PR197
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
GEF-SUB-ACCT Numeric 4 PR197
Element: Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
GEF-SALARY-AMT Signed 18.2 PR197
Element: Intl Amt Identifies the calculated salary amount
from PR197 distribution. Calculated as
follows: Time record wage amount
multiplied times the GM labor
distribution salary percentage.
GEF-EFFORT-AMT Signed 18.2
Element: Intl Amt Identifies the calculated effort amount.
Calculated as follows: Time record wage
amount multiplied times the GM labor
distribution effort percentage.
GEF-CURRENCY-CODE Alpha 5 PR197
Element: Currency Code Required, identifies currenty for
SAL-AMT and EFFORT-AMT. Updated from
the employee's time record.
GEF-CURRENCY-ND Numeric 1 PR197
Element: Currency Nd Required, identifies number of decimals
for SAL-AMT and EFFORT-AMT.
GEF-SAL-RPT-AMT Signed 18.2 PR197
Element: Intl Amt Salary amount exchanged to effort
reporting currency.
GEF-EFFORT-RPT-AMT Signed 18.2 PR197
Element: Intl Amt Planned effort amount exchanged to the
effort reporting currency.
GEF-RPT-CURR Alpha 5 PR197
Element: Currency Code Identifies the effort reporting
currency. Effort reporting currency is
defined in the employee file.
GEF-RPT-CURR-ND Numeric 1 PR197
Element: Currency Nd Required, identifies number of decimals
for SAL-RPT-AMT and EFFORT-RPT-AMT.
GEF-PER-END-DATE Numeric 8 (yyyymmdd) PR197
Element: Period End DatIdentifies the pay period end date for
the effort transaction. Updated during
PR197 via the effort update API
(GMET90).
GEF-JOB-CODE Alpha 9 PR197
Element: Job Code Identifies the a user-defined code that
represents a type of job code from the
timerecord.
GEF-PAY-CODE Alpha 4 PR197
Element: Payment Code Contains the pay code from the
timerecord. A pay code is a
user-defined code that identifies a
kind of pay.
GEF-POSITION Alpha 12 PR197
Element: Position Contains the user-defined code that
represents a position in the company
from the time card.
GEF-CHECK-ID Numeric 12 PR197
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
GEF-OT-PLAN-CODE Alpha 4
Element: Ot Plan Code Identifies pay plan in effect for
employee when PRDISTRIB record was
created from PR197 (PRPRD).
GEF-GM-ADJ-TYPE Alpha 1
Element: Gm Adj Type Identifies labor cost transfer
adjustment type for PRDISTRIB adjustment
records created by GM170.
GEF-GMI-OBJ-ID-1 Numeric 12
Object
Identification
GEF-GMI-OBJ-ID-2 Numeric 12
Object
Identification
GEF-HOURS Signed 7.2
Element: Hours Contains the hours.
GEF-ATN-OBJ-ID Numeric 12
Element: Atn Object ID The system-defined object id
representing the Activity Management
commitment.
GEF-GLT-OBJ-ID Numeric 12
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
GEF-GML-OBJ-ID Numeric 12
Element: Gml Obj Id
GMTRANEFRT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GEFSET1 OBJ-ID
GEFSET2 HR-COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
ACTIVITY PA100 PA102
ACCT-CATEGORY PA115 PA502
COMPANY PA52.1 PA52.3
ACCT-UNIT PA52.4 PA52.5
ACCOUNT PR110 PR113
SUB-ACCT PR120 PR13.1
OBJ-ID PR13.5 PR13.6
PR13.8
GEFSET3 ACTIVITY KeyChange
ACCT-CATEGORY
OBJ-ID
GEFSET4 RECORD-TYPE
TRAN-DATE
CHECK-ID
JOB-CODE
POSITION
PAY-CODE
ACCOUNT
SUB-ACCT
ACCT-CATEGORY
OBJ-ID
GEFSET5 RECORD-TYPE
PER-END-DATE
CHECK-ID
JOB-CODE
POSITION
PAY-CODE
ACCOUNT
SUB-ACCT
ACCT-CATEGORY
OBJ-ID
GEFSET6 ATN-OBJ-ID
OBJ-ID
GEFSET7 GLT-OBJ-ID
OBJ-ID
GMTRANEFRT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
GEF-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Not Required
GEF-ACTIVITY -> ACV-ACTIVITY
Cucodes CUCODES Not Required
GEF-CURRENCY-CODE -> CUC-CURRENCY-CODE
Cucodes Rpt CUCODES Not Required
GEF-RPT-CURR -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
GEF-HR-COMPANY -> EMP-COMPANY
GEF-EMPLOYEE -> EMP-EMPLOYEE
Glnames GLNAMES Not Required
GEF-COMPANY -> GLN-COMPANY
GEF-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GEF-COMPANY -> GLS-COMPANY
Gmlabdist GMLABDIST Not Required
GEF-GML-OBJ-ID -> GML-OBJ-ID
Gmretdist1 GMRETDIST Not Required
GEF-GMI-OBJ-ID-1 -> GMI-OBJ-ID
Gmretdist2 GMRETDIST Not Required
GEF-GMI-OBJ-ID-2 -> GMI-OBJ-ID
Prsystem Comp PRSYSTEM Required
GEF-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
