The Employee Time Cards file contains information that is used to compute an
employee's pay. It is the primary input file to PR140 (Earnings and Deductions
Calculation). There are many programs that create time records. PR199 (Payroll
Close) deletes the Employee Time Cards file records that were used during the
payroll cycle.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
TRD-COMPANY Element: Company Hr | Numeric 4
|
|
TRD-EMPLOYEE Element: Employee | 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.
|
|
TRD-TIME-SEQ Element: Time Seq | Numeric 12 Contains the sequence number of the
time record.
|
|
TRD-STATUS Element: Status | Numeric 1 Contains the status of the time record.
0 = Unreleased (Batch) 1 = Future 2 = Current 3 = Error 4 = Processed 5 = Manual |
|
TRD-BATCH-NBR Element: Batch Nbr | Numeric 6 Contains the batch number to which the
entered time records belong.
|
|
TRD-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the employee's home process
level.
|
|
TRD-DEPARTMENT Element: Department | Alpha 5 Contains the employee's home
department.
|
|
TRD-PAY-SUM-GRP Element: Pay Sum Grp | Alpha 3 Contains the pay summary group
associated with the pay code.
|
|
TRD-JOB-CODE Element: Job Code | Alpha 9 Contains a user-defined code that
identifies a type of job.
|
|
TRD-PAY-CODE Element: Pay Code | Alpha 4 Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
|
|
TRD-HOURS Element: Hours | Signed 7.2 Contains the hours associated with the
time record.
|
|
TRD-RATE Element: Rate | Signed 13.4 Contains the rate of pay associated
with the time record.
|
|
TRD-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Contains the total wage amount for the
time record as calculated according to
the calculation type defined for the pay
code, the employee's rate of pay, salary
class, and the number of hours entered.
|
|
TRD-SHIFT Element: Shift | Numeric 1 Contains the shift number associated
with the pay.
|
|
TRD-CHECK-GRP Element: Check Grp | Alpha 1 Contains a value that identifies a
check group. All time records with a
common entry in this field are grouped
on one payment record for the employee.
A number in this field indicates the
deduction cycle the system uses for
calculating deductions on the payment.
|
|
TRD-PROCESS-GRP Element: Process Grp | Alpha 1 Identifies a process group. All time
records with a common value in this
field are grouped for taxing purposes
within a check group for an employee. A
number in this field indicates the
deduction cycle the application uses for
calculating deductions on the payment.
|
|
TRD-TR-DATE Element: Tr Date | Numeric 8 (yyyymmdd) Contains the time record date. The
application uses the time record date to
determine which time records to process
in PR38.1 (Time Record Selection) or
PR137 (Batch Time Record Update).
|
|
TRD-DIST-PROC-LEV Element: Process Lev Hr | Alpha 5 Contains the process level to which the
system distributes wage expenses.
|
|
TRD-DIST-DEPART Element: Department | Alpha 5 Contains the department to which the
system distributes wage expenses.
|
|
TRD-DST-ACCT-UNIT Element: Acct Unit | Alpha 15 Contains the general ledger accounting
unit to which the application posts the
wage expense amount
|
|
TRD-DST-ACCOUNT Element: Account | Numeric 6 Contains the general ledger account to
which the application posts the wage
expense amount.
|
|
TRD-DST-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the general ledger subaccount
to which the application posts the wage
expense amount.
|
|
TRD-DIST-COMPANY Element: Company | Numeric 4 Contains the company number to which a
transaction is posted. A valid
intercompany relationship must be
defined in the General Ledger
application.
|
|
TRD-PCT-DIST-FLAG Element: Pct Dist Flag | Alpha 1 Contains the value that indicates if
employee override distributions exist in
the Emp Acct Distribution Override file.
When the value is Y (Yes), PR150
(Distribution Edit) and PR199 (Payroll
Close) use the override accounts to
create Employee Payment Distribution
file and GL Interface File records.
Y = Distribution override exists N = No override exists |
|
TRD-ERROR-FLAG Element: Error Flag | Alpha 1 A value of Y (Yes) in this field
indicates an error in processing the
time record. PR130 (Time Record
Interface) uses this field to indicate
if a field from the interface time
record does not pass the edits. If a
field from the interface time record
does not pass the edits, the system
creates the time record with this field
set to Y (Yes). Time record entry
programs then use this field to
determine if editing is still necessary.
Y = Created with errors |
|
TRD-CHECK-ID Element: Check Id | Numeric 12 Contains the payment identification
number generated by the time record.
|
|
TRD-CHECK-TYPE Element: Check Type | Alpha 1 Contains the payment type.
S = System M = Manual J = Adjustment G = Gross Up |
|
TRD-SCHEDULE Element: Schedule | Alpha 9 Contains the value that identifies a
step and grade schedule.
|
|
TRD-PAY-STEP Element: Pay Step | Numeric 2 Contains the step number from the step
and grade schedule.
|
|
TRD-PAY-GRADE Element: Pay Grade | Alpha 3 Contains the grade from the step and
grade schedule.
|
|
TRD-ANNUAL-SALARY Element: Annual Salary | Signed 13.4 Contains the calculated annual salary
used for salaried employees when the
time record contains step and grade
information or is using an alternate pay
rate.
|
|
TRD-ATTEND-CODE Element: Attend Code | Alpha 2 Contains the attendance code used for
creating Employee Attendance History
records in PR199 (Payroll Close) The
Time and Attendance system uses this
field.
|
|
TRD-OCCURRENCE Element: Occurrence | Alpha 1 Contains the value that indicates if
the referenced time is a new occurrence
or a continuation of an existing
occurrence. The Time and Attendance
application uses this field.
Y = Yes N = No |
|
TRD-PCD-SEQ-NBR Element: Pcd Seq Nbr | Numeric 8 Contains the sequence number associated
with the time record relative to the pay
code.
|
|
TRD-TAX-STATE Element: Tax State | Alpha 2 Contains the 2-digit state code that
represents the employee's resident
state.
|
|
TRD-WORK-STATE Element: Work State | Alpha 2 Identifies the state in which the
workers' compensation plan is effective.
This field stores the work state for
withholding purposes.
|
|
TRD-UNION-CODE Element: Union Code | Alpha 10 Contains the union code associated with
the time record.
|
|
TRD-PER-BEG-DATE Element: Per Beg Date | Numeric 8 (yyyymmdd)
|
|
TRD-PER-END-DATE Element: Per End Date | Numeric 8 (yyyymmdd) Contains the pay period end date which
is determined by the employee's pay plan
and the time record date.
|
|
TRD-OT-PREM-AMT Element: Ot Prem Amt | Signed 13.2 Contains the overtime amount associated
with the time record.
|
|
TRD-SHIFT-DIFF Element: Shift Diff | Signed 13.2 Contains the differential from the pay
code for the shift entered on the time
record.
|
|
TRD-WC-CLASS Element: Wc Class | Alpha 4 Contains the workers' compensation
classification associated with the job
code entered on the time record.
|
|
TRD-OT-RECORD Element: Ot Record | Alpha 1 Contains the value that indicates if
the time record was created for
retroactive, overtime, flex time, or
tips pay.
Y = Yes R = Retro F = Flex T = Tips U = Updated X = Exception Processed O = Offset Time Record P = Payout C = Created by Employee Contract I = Created by BN150 |
|
TRD-WRK-BEG-DATE Element: Wrk Beg Date | Numeric 8 (yyyymmdd)
|
|
TRD-WRK-END-DATE Element: Wrk End Date | Numeric 8 (yyyymmdd) Contains the work period end date which
is determined by the employee's pay plan
and the time record date.
|
|
TRD-SUPP-TAX-CODE Element: Supp Tax Code | Alpha 2 Contains the supplementary tax code
associated with the time record.
|
|
TRD-LOCAT-CODE Element: Locat Code | Alpha 10
|
|
TRD-WC-STATE Element: Wc State | Alpha 2 Contains the workers' compensation
state associated with the time record.
|
|
TRD-PAY-PERIODS Element: Pay Periods | Numeric 2 Contains the number of times a bonus is
paid during the year. The system uses
this value to annualize the payment.
This is used with bonus type pay codes
and is referred to as the Aggregation
with Pay Periods method.
|
|
TRD-POSITION Element: Position | Alpha 12 Contains the user-defined code that
represents a position in the company.
|
|
TRD-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
|
|
TRD-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
|
|
TRD-ATN-OBJ-ID Element: 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.
|
|
TRD-GLT-OBJ-ID Element: 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.
|
|
TRD-TIME-ACC-FLAG Element: Time Acc Flag | Alpha 1 Contains an L (Last) if an employee is
terminating employment with the company
and you are issuing the final payment
through PR80.1 (Manual Payment).
A = Created by LP Neg Bal Options |
|
TRD-SHFT-DIFF-RATE Element: Shft Diff Rate | Signed 13.4 The rate used to calculate the shift
differential.
|
|
TRD-SH-OBJ-ID Element: Sh Obj Id | Numeric 12 The object id of the shift table used
in calculating the SHIFT-DIFF and
SHIFT-DIFF-RATE.
|
|
TRD-OT-RATE Element: Ot Rate | Signed 13.4 Contains the overtime rate.
|
|
TRD-AC-UPDATED Element: Ac191 Updated | Alpha 1
Y = Yes " " = No |
|
TRD-TAX-COUNTY Element: Tax County | Alpha 10 Contains the county taxing authority
code.
|
|
TRD-TAX-CITY Element: Tax City | Alpha 10 Contains the city taxing authority code.
|
|
TRD-TAX-SCHOOL Element: Tax School | Alpha 10 Contains the tax school.
|
|
TRD-TAX-TRANSPORT Element: Tax Transport | Alpha 10 Contains the transport tax code.
|
|
TRD-SEGMENT-FLAG Element: Segment Flag | Alpha 1 Defines if segment block data exists
for the time record.
|
|
TRD-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
TRD-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
TRD-TAX-FREQ-OVER Element: Tax Freq Over | Numeric 3 Number of Pay Periods Per Year that is
used to determine how to calculate
amount of taxes withheld.
001 = Weekly 002 = Biweekly 003 = Semi-monthly 004 = Monthly 005 = Daily 006 = Quarterly 007 = Semi-annually 008 = Annually 009 = 9 Month Academic Monthly 010 = 10 Month Academic Monthly |
|
TRD-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
|
|
TRD-PAYMENT-TYPE Element: Payment Type | Alpha 2 Contains the payment type.
|
|
TRD-REMUN-CODE Element: Remun Code | Alpha 4 Contains the remuneration code. Valid
value is C001 = Bonus.
E002 = US Pay Advances E003 = US Athletic Facilities E004 = US Non-Qual Plan Awrds and Prz E005 = US Back Pay E006 = US Bonuses E007 = US Business Expense E009 = US Gifts E010 = US Commissions E013 = US Discounts E014 = US Dismissal/Severance E015 = US Educational Assistance E016 = US Employment Agency E017 = US Qual Equip/Tool/Uniform E018 = US Business Use of Company Car E019 = US Personal Use of Company Car E020 = US No Additional Cost Services E021 = US Golden Parachute E022 = US Group Legal Services E023 = US Guaranteed Wage E024 = US Jury Duty Pay E025 = US Below Market Loans to Empl E026 = US Meals and Lodging E027 = US Supplemental Military Pay E028 = US Qualified Moving Expenses E029 = US Non-Cash Fringe E030 = US Outplacement Services E031 = US Overtime E032 = US Qualified Parking E033 = US Pre-employment Reimbursmnt E034 = US Probationary Pay E035 = US Regular Wages E036 = US Scholarships E037 = US Sick/Disability Pay E038 = US Standby/Idle Time E039 = US Stock Purch & Incentive Pln E040 = US Supper Money E041 = US Supplemental Unemployment E042 = US Taxes Paid by Employer E043 = US Tips E044 = US Travel; Exp Reimbursement E045 = US Tuition Reimbursement E046 = US Union Pay E047 = US Vacation Pay E048 = US Group Term Life G.T. 50000 E049 = US Ministers Housing Allowance E999 = US Custom Earnings E051 = US Income Under Section 409A E052 = US Transportation CHV E055 = US Commuter Benefits E067 = US Tips Non-Taxable E068 = US Diff Pay - Active Mil Duty E070 = US EE Adult Child Hlth Ins E071 = US ER Adult Child Hlth Ins |
|
TRD-REPORT-ENTITY Element: Report Entity | Alpha 5 Contains the report entity.
Report Entity is the Process Level or
Company that this Process Level reports
to for tax reporting. If the Process
Level itself is independent then the
independent Process Level is the Report
Entity. If the Process Level is non
independent and is associated to a
independent head Process Level then the
independent head Process Level is the
Report Entity. If the Process Level is
non independent and is not associated to
a independent head Process Level then
the Company is the Report Entity.
|
|
TRD-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group.
|
|
TRD-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec enterprise number
group.
|
|
TRD-CA-WC-CLASS Element: Ca Wc Class | Alpha 10 Contains the Canadian WC Class from
employees job. Use to identify the
PRTIME wages by WC Class.
|
|
TRD-PENS-SEQ-NBR Element: Pens Seq Nbr | Numeric 4
|
|
TRD-PAY-UNITS Element: Pay Units | Signed 7.2
|
|
TRD-UNIT-MEASURE Element: Unit Measure | Alpha 12
|
|
TRD-USER-ID Element: User | Alpha 10 (Lower Case)
|
|
TRD-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
TRD-NON-EARNINGS Element: Non Earnings | Numeric 1
0 = No - wages 1 = Yes - other remuneration |
|
TRD-ORIG-OBJ-ID Element: Orig Obj Id | Numeric 12
|
|
TRD-RECORD-TYPE Element: Record Type | Alpha 1 Identifies adjustment status for
Databasics and Grants.
Blank = Normal (not adjusted)
1 = Adjustment Offset
2 = Adjustment Entry
3 = Adjustment on Adjustment
Additional values identify time records
created from GM170:
4 = Cost Transfer Reversing Entry
5 = Cost Transfer Adjusting Entry
|
|
TRD-LEAVE-STATUS Element: Leave Status | Numeric 1
|
|
TRD-REASON-CODE Element: Ta Reason Cd | Alpha 4
|
|
TRD-TES-OBJ-ID Element: Tes Obj Id | Numeric 12
|
|
TRD-RETRO-PENSION Element: Retro Pension | Alpha 1
" " = No N = No Y = Yes; open payment |
|
TRD-SERVICE-CODE Element: Ta Service Cd | Alpha 10
|
|
TRD-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
TRD-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
TRD-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
TRD-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who
last changed this record.
|
|
TRD-LNK-TIME-SEQ Element: Time Seq | Numeric 12 Used to associate user created time
records with LP created time records.
|
|
TRD-CONT-SEQ-NBR Element: Cw Cont Seq No | Numeric 12
|
|
TRD-CONTRACT-YEAR Element: Contract Year | Numeric 4
|
|
TRD-CWC-EFFECT-DT Element: Effective Dt | Numeric 8 (yyyymmdd)
|
|
TRD-CONTRACT-NBR Element: Seq Number | Numeric 6
|
|
TRD-SEGMENT-NBR Element: Seq Number | Numeric 6
|
|
TRD-CYC-START-DATE Element: Pay Start Date | Numeric 8 (yyyymmdd)
|
|
TRD-CYC-END-DATE Element: Pay End Date | Numeric 8 (yyyymmdd)
|
|
TRD-CM-REG-FLAG Element: Flag Num | Numeric 1
0 = Non-contract 1 = Regular pay 2 = Reserve pay 3 = Docking pay 4 = Adjustment 5 = Summer Deferral |
|
TRD-CM130-FLAG Element: Flag Num | Numeric 1
0 = No 1 = Yes |
|
TRD-MEMO Element: Text Comment | Alpha 64 (Lower Case)
|
|
TRD-ABN-OBJ-ID Element: Abn Obj Id | Numeric 12
|
|
TRD-EXP-RPT-NBR Element: Invoice | Alpha 22
|
|
TRD-REC-TYPE Element: Seq Nbr | Numeric 4
|
|
TRD-NOTIONAL Element: Notional | Signed 13.4
|
|
TRD-ADDTL-RATE Element: Addtl Rate | Numeric 1
|
|