PTR Header

 
UCLA Home / Campus Services / Finance / Payroll / Manuals / PTR Manual
PTR MANUAL, REFERENCE

PTR FIELD/SCREEN CROSS REFERENCE TABLE


Looking for a specific screen label?  Use the find command in your web browser.  For information on how to use the find command, select here to view our helpful hints page.

Screen Label Data Dictionary Name Data Values / Comments Screen
Accrued Through Date Vacation Accrued Through Date The date through which the associated Vacation Leave has been accrued.

Format: MMDDYY
EDTL
AH Pay Rate Type Code Code indicating the nature of the Pay Rate or Amount.

A - Salaried or By Agreement Amount
H - Hourly Rate
EDAP
EDLR
Amount Pay Rate Or Amount The full-time hourly rate, monthly rate, or by agreement amount associated with a payment transaction.

Format: nnn.nnnn (hourly) or nnnnn.nn (monthly or by agreement)
EDFT
Benefits Original Benefits-Amount The total amount of benefits associated with a salary or wage expense.

Format: nnnnn.nn
EDTS
C Line Command Code Code entered by the user or Payroll Services to specify an action, such as "retrieve" "copy". or "bypass"

B - Bypass (Payroll Services Only)
C - Copy
R - Retrieve
EDAP
EDFT
EDLA
EDLR
EDRA
CheckDate Check Date The date on which the pay is available.
 
Format: MMDDYY
EDAP
EDFT
EDLA
EDLR
EDRA
EDTL
EDTM
EDTS
IDTC
IDTL
CheckList Check List Selection Code Code indicating whether the Time Report check list is to be produced.

S - Select checklist
blank - Do not select checklist
IDTC
Cost Center Cost Center This is the number of a cost center against which salary or wage expenses are charged. IDTC
DOS Description Of Service Code Code indicating the type of service or type of pay associated with the payment transaction. EDAP
EDFT
EDLR
EDRA
Dst Distribution Number A number which uniquely identifies a payroll distribution associated with an appointment. EDAP
EDLR
DUC
D
Distribution Unit Code Code indicating a group, within a bargaining unit, to which a distribution for an appointment is assigned for collective bargaining purposes, excluding range adjustments. (Not in use at UCLA) EDFT
EDAP
EDLR
EDRA
ERC

E

Employee Relations Code Code indicating the designation of an individual for purposes of collective bargaining.

A - Manager, not confidential
B - Manager, confidential
C - Supervisor, not confidential
D - Supervisor, confidential
E - All others, not confidential
F - All others, confidential
G - Not covered by HEERA(out of state)
I - Student Academic not covered by HEERA
J - Student Academic covered by HEERA
EDFT
EDAP
EDLR
EDRA
ELMT Data Element Number The number of the Employee Data Base (EDB) data element by which the associated data value is identified.

5185 = vacation
5186 = sick leave
5187 = TRIP
EDLA
ET MONTH Expense Transfer Month The month and year of the Distribution of Payroll Expense (PPP 5302) that contains the applicable payment transaction.

Format: "YYMM" where 'YY'-Fiscal Year, 'MM'-Month
EDTM
EDTS
ET PAGE Expense Transfer Page The page of the Distribution of Payroll Expense (PPP5302) that records the applicable payment transaction. EDTM
EDTS
Full Accounting Unit Full Accounting Unit This field is made up of the Location, Account, Cost Center, Fund, Project Code and Subaccount. IDTC
H% Hours/Percent of Time Code Code indicating whether the associated Time represents hours or percent.

% - Percent
H - Hours
EDAP
EDLR
EDRA
Home Department Code Home Department Code Code indicating the department or other administrative unit that has coordinating responsibility for an individual's employment and/or pay disposition. IDTC
Hourly Pay Rate Hourly Pay Rate The hourly pay rate to be used in the calculation of costs associated with accrued vacation leave.

Format: nnn.nnnn
EDTL
Hours Leave Hours The number of hours associated with a Leave Balance transaction.

Format: nnnnn.nnnnnn
EDLA
Hr Time The number of hours or percentage of time associated with the payment transaction.

Format: nnn.nn (hours) or n.nnnn (percent of time)
EDAP
EDLR
Last Day To Enter Time Last Date To Enter Time The last day in which time may be entered on the roster screens for the associated pay period.

Format: MM/DD/YY
IDTC
Leave (Vacation) Hours Leave (vacation) Hours The number of accrued vacation leave hours to be used in the calculation of costs to be transferred from one expenditure account to another.

Format: nnn.nn
EDTL
Loc/Acct/CC/Fund/PC/Sub

LACFPS

Expenditure Account Location Number, Account Number, Cost Center, Fund Number, Project Code, Subaccount Number Full accounting unit for transaction. EDTL
EDTS
EDTM
EDAP
EDFT
EDLR
EDRA
Original Gross Earnings Original Gross Earnings-Amount The amount of the original gross earnings associated with a single pay transaction (single transfer of expense) or with a group of pay transactions (mass transfer of expense.

Format: nnnnn.nn
EDTS
EDTM
Override Employee ID Override Employee Id Employee number that replaces a previous number which uniquely identified an employee's record. EDTS
PayCyc Transaction Pay Cycle Code Code indicating the pay schedule on which the payment is to be made using the primary pay cycle for the employee.

B - Biweekly
M - Monthly
EDAP
EDLR
EDRA
Pay Cycle Processing Pay Cycle Code Code indicating the pay schedule on which the payment is scheduled by the preparer to be processed.

B1 - Biweekly-first
B2 - Biweekly-second
MO - Monthly Current
EDAP
EDFT
EDLA
EDLR
EDRA
EDTL
EDTS
EDTM
IDTC
IDTL
Pay End Processing Pay Period End Date The end date of the pay period in which the transaction is scheduled by the preparer to be processed.

Format: MMDDYY
EDAP
EDFT
EDLA
EDLR
EDTL
EDRA
EDTS
EDTM
IDTC
Per End Transaction Pay Period End Date The end date of the pay period in which the employee worked or used leave.

Format: MMDDYY
EDAP
EDFT
EDLR
EDRA
IDTL
RAI Rate Adjustment Indicator Code indicating whether the transaction is an adjustment to a previously reported pay rate. EDRA
Rate Pay Rate or Amount The full-time hourly rate, monthly rate, or by agreement amount associated with a monthly payment transaction.

Format: nnn.nnnn (hourly) or nnnnn.nn (pay period or by agreement)
EDAP
EDLR
EDRA
Reason Reason Code Code identifying the reason for the transfer of the payroll expenditure.
 
A. One-time expenditure adjustment: Employee is not expected to perform services again under this account/fund.
B. Employee is expected to perform services again under this account/fund .
C. Other
EDTS
Roster Roster Selection Code Code indicating whether the Time Report roster is to be produced.

S - Select roster
blank - Do not select roster
IDTC
S Transaction-Numeric Sign Code indicating whether an amount is negative or positive.

(-) negative
(blank) positive
EDLA
EDRA
Seq Transaction Sequence Number The number that uniquely identifies a transaction on the Transaction Holding File which the system assigns automatically. EDAP
EDFT
EDRA
EDLR
EDLA
IDTL
Sign Original Gross-Numeric Sign Code indicating whether the Original Gross Earnings-Amount is negative or positive.

(blank) Positive Original Gross Earnings-Amt
( -) Negative Original Gross Earnings-Amt
EDTS
EDTM
Time Time The number of hours or percentage of time associated with the payment transaction.

Format: nnn.nn (hours) or n.nnnn (percent of time)
EDAP
EDLR
EDRA
Title Code

Ttl

Title Code Code indicating the position classification associated with a payment transaction. EDTL
EDAP
EDFT
EDLR
Tran

Tr

Transaction Type Code Code indicating the nature of the transaction.

AP - Additional pay
C2 - Cancellation
DS - Deduction
E1 - Expense transfer 1
E3 - Expense transfer 3
FT - One-time payment
H2 - Handdrawn check
LX - Late pay
O2 - Overpayment
PS - Prepayment
RA - Retroactive pay
RF - Refund
RX - Reduction/Reversal of pay or leave
R2 - Rush handdrawn check
ST - Payment in lieu of notice
TE - Exception time
TX - Positive time
IDTL
EDLR
Transfer Gross Earnings Transfer Gross Earnings-Amount The amount of the gross earnings to be transferred from one expenditure account to another.

Format: nnnnn.nn
EDTS
TYP

T

Appointment Type Code Code indicating the type of appointment.

1 - Contract
2 - Regular/Career
3 - Limited
4 - Casual/Restricted
5 - Academic
6 - Per Diem
7 - Partial Year Career
9 - UNEX
EDFT
EDAP
EDLR
EDRA
WSP Work Study Program Code Code indicating the type of work-study program associated with a payment transaction.

Program:
Academic
Year

Summer
America Reads
Bruin Corp
Community Serv
Federal
President's
A
B
C
R
P
D
E
G
H
R
EDAP
EDFT
EDLR
EDRA

  Go to Payroll Home Page to top 

Footer