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 4
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 or a K12 Teacher Contract
Assignment.
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 |
|
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
Identifies the Contract Segment record
for K12 Teacher Contract payouts.
|
|
TRD-CONTRACT-YEAR
Element: Contract Year | Numeric 4
|
|
TRD-CWC-EFFECT-DT
Element: Effective Dt | Numeric 8 (yyyymmdd)
|
|
