 |
Lawson Insight Technical Documentation |
|
EMPLOYEE FILE
Employee
Contains all employee information needed in the Lawson Payroll system. The
Employee PA Information file stores additional employee information used by
the Lawson Human Resource, Personnel, and Benefits systems. HR11.1 (Employee)
is the primary program that updates this file.
REFERENCED BY
AC03.3 AC17.3 AC18.2 AC190 AC191 AC196
AC203 AC217 AC218 AC259 AC50.1 AC500
AC52.1 AC520 AC530 AC550 AC551 AC559
AC59.1 AC62.1 AC741 AC92.2 AC92.4 AC92.6
GR741 BN134 BN138 BN140 BN141 BN175
BN180 BN181 BN230 BN231 BN232 BN233
BN236 BN237 BN238 BN240 BN242 BN246
BN247 BN248 BN258 BN259 BN281 BN285
BN30.1 BN300 BN305 BN310 BN321 BN325
BN330 BN331 BN335 BN340 BN345 BN35.1
BN350 BN36.1 BN400 BN430 BN46.1 BN46.2
BN47.1 BN48.1 BN48.2 BN480 BN50.1 BN500
BN51.1 BN51.2 BN532 BN55.1 BN55.2 BN555
BN56.1 BN57.1 BN59.1 BN60.1 BN61.1 BN66.1
BN70.1 BN70.2 BN77.1 BN80.1 BN81.1 BN81.2
BN82.1 BN85.1 BN90.1 BS09.1 BS10.1 BS11.1
BS12.1 BS30.1 BS31.1 BS531 BR40.3 HC01.1
HC02.1 HCEM.1 HCOP.1 HCOP.2 HCSU.1 ES02.1
ES10.1 HCTC.1 HEMD.1 HEMP.1 HGLN.1 HHSU.1
HOSH.1 HPAE.1 HR00.1 HR01.1 HR07.1 HR105
HR125 HR13.1 HR15.1 HR155 HR16.2 HR16.3
HR16.4 HR16.5 HR16.6 HR16.7 HR16.8 HR17.1
HR17.2 HR17.3 HR17.4 HR17.5 HR17.6 HR17.7
HR17.8 HR17.9 HR170 HR18.1 HR18.2 HR18.3
HR18.4 HR207 HR211 HR212 HR213 HR217
HR220 HR255 HR30.1 HR507 HR513 HR515
HR521 HR54.1 HR55.1 HR55.2 HR70.1 HR90.1
HR90.2 HRS1.1 HRSC.1 HS10.1 HS10.2 HS11.1
HS12.1 HS13.1 HS14.1 HS15.1 HS50.1 HS50.2
HS50.3 HS50.4 HS50.5 HS51.1 HS51.2 HS52.1
HS52.2 PA03.2 PA09.1 PA105 PA111 PA113
PA12.1 PA125 PA130 PA14.1 PA149 PA16.1
PA17.1 PA18.1 PA19.1 PA201 PA208 PA211
PA212 PA213 PA214 PA215 PA216 PA217
PA218 PA219 PA220 PA221 PA222 PA224
PA225 PA23.1 PA241 PA242 PA243 PA244
PA248 PA249 PA25.1 PA259 PA26.1 PA262
PA272 PA290 PA295 PA296 PA300 PA305
PA31.1 PA310 PA311 PA313 PA315 PA320
PA325 PA33.1 PA330 PA335 PA340 PA341
PA345 PA349 PA350 PA355 PA360 PA370
PA372 PA390 PA391 PA393 PA402 PA406
PA41.1 PA42.1 PA43.1 PA44.1 PA45.1 PA49.1
PA49.2 PA49.3 PA490 PA50.1 PA512 PA53.1
PA531 PA532 PA533 PA54.1 PA549 PA55.1
PA59.1 PA59.2 PA590 PA62.1 PA64.1 PA64.2
PA66.1 PA66.2 PA66.3 PA66.4 PA67.1 PA81.1
PA81.2 PA90.1 PA90.2 PA90.3 PA91.1 PA96.1
TR07.1 TR08.1 TR09.1 TR114 TR12.1 TR120
TR121 TR13.1 TR13.2 TR14.1 TR15.1 TR20.1
TR20.2 TR20.3 TR200 TR201 TR202 TR204
TR207 TR210 TR22.1 TR220 TR221 TR222
TR500 HS20.1 HS21.1 HS22.1 HS22.2 HS34.1
HS35.1 HS36.1 HS535 PR114 PR135 PR137
PR139 PR141 PR142 PR155 PR162 PR195
PR197 PR198 PR212 PR214 PR216 PR223
PR226 PR229 PR23.1 PR230 PR239 PR247
PR260 PR265 PR270 PR275 PR276 PR277
PR278 PR280 PR281 PR282 PR283 PR289
PR290 PR291 PR292 PR293 PR294 PR295
PR297 PR298 PR313 PR37.1 PR418 PR45.1
PR50.1 PR50.2 PR50.3 PR50.4 PR51.1 PR512
PR52.1 PR55.1 PR560 PR70.1 PR83.1 PR85.1
PR86.1 PR89.1 PRSA.1 PRWC.1 UK210 UK330
UK52.1 TA125 TA170 TA175 TA180 TA260
TA265 TA270 TA290 TA310 TA570 TA60.1
TA65.1 TA65.2 TA65.3 TA70.1 TA70.2 TA80.1
TM240 TM245 TM250 TM255 TM300 TM470
TM50.1 TM52.1 TM70.1 TM71.1 UK220 UK260
UK270 UK60.1 UK70.1 HEP3.1 PR38.1 HEP4.1
HEP2.1 PR130 TA195 TA199
UPDATED BY
AC541 AC542 AC721 BN100 BN101 BN102
BN103 BN104 BN105 BN145 BN150 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 HR12.1 HR14.1 HR511 HR514
HR650 PA502 PA513 PR128 PR13.1 PR13.2
PR13.5 PR13.6 PR13.8 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR205 PR26.1
PR296 PR30.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR39.1 PR39.2 PR47.1 PR514 PR530
PR82.1 UK102 UK110 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMP-COMPANY Numeric 4 AC721 HR511
Company Contains the company number. HR650 PA502
PR13.1 PR13.5
PR13.6 PR13.8
PR33.2 PR33.3
EMP-EMPLOYEE Numeric 9 AC721 HR511
Employee Contains the number assigned to each HR650 PA502
employee. The employee number is used PR13.1 PR13.5
with the company number to uniquely PR13.6 PR13.8
identify the employee throughout the PR33.2 PR33.3
Lawson Human Resources systems.
EMP-LAST-NAME Alpha 30 (Lower Case) AC721 HR07.1
Last Name Contains the employee's last name. HR511 HR650
PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-FIRST-NAME Alpha 15 (Lower Case) AC721 HR07.1
First Name Contains the employee's first name. HR511 HR650
PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-MIDDLE-INIT Alpha 1 AC721 HR07.1
Middle Initial Contains the employee's middle initial. HR511 HR650
PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-MIDDLE-NAME Alpha 15 (Lower Case) HR511 HR650
Middle Name Contains the employee's middle name. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NICK-NAME Alpha 30 (Lower Case) AC721 HR511
Nick Name Contains the employee's nick name. HR650 PA502
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADDR1 Alpha 30 (Lower Case) AC721 HR511
Address 1 Contains the first line of the HR650 PA502
employee's address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADDR2 Alpha 30 (Lower Case) AC721 HR511
Address 2 Contains the second line of the HR650 PA502
employee's address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADDR3 Alpha 30 (Lower Case) AC721 HR511
Address 3 Contains the third line of the HR650 PA502
employee's address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADDR4 Alpha 30 (Lower Case) AC721 HR511
Address 4 Contains the fourth line of the HR650 PA502
employee's address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-CITY Alpha 18 (Lower Case) AC721 HR511
City Contains the city of the employee's HR650 PA502
address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-STATE Alpha 2 AC721 HR511
State or Province Contains the state of the employee's HR650 PA502
address. PR13.1 PR13.5
AL = Alabama PR13.6 PR13.8
AK = Alaska
AZ = Arizona
AR = Arkansas
CA = California
CO = Colorado
CT = Connecticut
DE = Delaware
DC = Dist of Columbia
FL = Florida
GA = Georgia
HI = Hawaii
ID = Idaho
IL = Illinois
IN = Indiana
IA = Iowa
KS = Kansas
KY = Kentucky
LA = Louisiana
ME = Maine
MD = Maryland
MA = Massachusetts
MI = Michigan
MN = Minnesota
MS = Mississippi
MO = Missouri
MT = Montana
NE = Nebraska
NV = Nevada
NH = New Hampshire
NJ = New Jersey
NM = New Mexico
NY = New York
NC = North Carolina
ND = North Dakota
OH = Ohio
OK = Oklahoma
OR = Oregon
PA = Pennsylvania
PR = Puerto Rico
RI = Rhode Island
SC = South Carolina
SD = South Dakota
TN = Tennessee
TX = Texas
UT = Utah
VT = Vermont
VA = Virginia
VI = Virgin Islands
WA = Washington
WV = West Virginia
WI = Wisconsin
WY = Wyoming
EMP-ZIP Alpha 10 AC721 HR511
Postal Code Contains the postal code of the HR650 PA502
employee's address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-EMP-STATUS Alpha 2 AC721 HCEM.1
Status Contains the employee's status, which HCOP.2 HR511
can be used to determine if this HR650 PA272
employee is paid. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-FICA-NBR Alpha 15 AC721 HR511
SSN (Social Contains the employee's Social Security HR650 PA502
Security Number) number. PR13.1 PR13.5
PR13.6 PR13.8
PR291 PR292
PR297 PR298
EMP-EIC-STATUS Numeric 1 AC721 HR511
EIC Status Indicates if the employee's EIC status HR650 PA502
is Single or Joint. PR13.1 PR13.5
0 = Not Applicable PR13.6 PR13.8
1 = Single
2 = Joint
EMP-PROCESS-LEVEL Alpha 5 AC721 HCEM.1
Process Level Contains the employee's process level. HCOP.2 HR511
HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-DEPARTMENT Alpha 5 AC721 HCOP.2
Department Contains the employee's department. HR511 HR650
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-USER-LEVEL Alpha 10 AC721 HCOP.2
User Level Contains the employee's user level. HR511 HR650
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-HM-DIST-CO Numeric 4 AC721 HCOP.2
Hm Dist Co Contains the employee's home general HR511 HR650
ledger distribution company for expense. PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-HM-ACCT-UNIT Alpha 15 AC721 HCOP.2
Expense Accounting Contains the employee's home general HR511 HR650
Unit ledger accounting unit for expense. PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-HM-ACCOUNT Numeric 6 AC721 HCOP.2
Expense Account Contains the employee's home general HR511 HR650
ledger account for expense. PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-HM-SUB-ACCT Numeric 4 AC721 HCOP.2
Expense Subaccount Contains the employee's home general HR511 HR650
ledger subaccount for expense. PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-JOB-CODE Alpha 9 AC721 HCOP.2
Job Code Contains the employee's job code. HR170 HR511
HR650 HR70.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-UNION-CODE Alpha 10 AC721 HCOP.2
Union Contains the employee's union code. HR511 HR650
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-SUPERVISOR Alpha 10 AC721 HCOP.2
Supervisor Contains the supervisor code that HR511 HR650
identifies the supervisor to whom the PA502 PA513
employee reports. PR13.1 PR13.5
PR13.6 PR13.8
EMP-DATE-HIRED Numeric 8 (yyyymmdd) AC721 HCOP.2
Hire Date Contains the employee's hire date. HR511 HR650
PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PAY-FREQUENCY Numeric 1 AC721 HR511
Pay Frequency Identifies the employee's pay frequency. HR650 PA502
1 = Weekly PR13.1 PR13.5
2 = Biweekly PR13.6 PR13.8
3 = Semimonthly PR32.1 PR32.2
4 = Monthly PR33.2 PR33.3
EMP-SHIFT Numeric 1 AC721 HCOP.2
Shift Identifies the shift with which the HR511 HR650
employee's pay is associated. PA502 PA513
1 = Shift 1 PR13.1 PR13.5
2 = Shift 2 PR13.6 PR13.8
3 = Shift 3
4 = Shift 4
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
EMP-SALARY-CLASS Alpha 1 AC721 HCOP.2
Salary Class Indicates if the rate of pay is hourly HR511 HR650
or salaried. PA502 PR13.1
H = Hourly PR13.5 PR13.6
S = Salaried PR13.8
EMP-EXEMPT-EMP Alpha 1 AC721 HCOP.2
Exempt Indicates if the employee is exempt HR511 HR650
from overtime pay. PA502 PR13.1
N = No PR13.5 PR13.6
Y = Yes PR13.8
EMP-PAY-RATE Signed 13.4 AC721 HR511
Rate of Pay Contains the employee's rate of pay. HR650 PA502
This can be an annual amount or an PA513 PR13.1
hourly amount. If this is a step and PR13.5 PR13.6
grade employee, this field is zero and PR13.8 PR33.2
the step, grade and schedule must exist. PR33.3
The system uses these fields to retrieve
the employee's rate of pay at
calculation time.
EMP-STAND-HOURS Signed 7.2 AC721 HR511
Standard Hours Contains the number of hours this HR650 PA502
employee usually works each pay period. PR13.1 PR13.5
If you enter a value in this field, PR13.6 PR13.8
additional edits occur at time entry.
EMP-STAND-AMT Signed 11.3 AC721 HR511
Standard Amount Contains the amount of money the HR650 PA502
employee usually makes per pay period. PR13.1 PR13.5
If you enter a value in this field, PR13.6 PR13.8
additional edits occur at time entry.
EMP-WARN-FLAG Alpha 1 AC721 HR511
Warning Message Indicates if a warning displays when HR650 PA502
the employee exceeds the standard hours PR13.1 PR13.5
or amount for a pay period. PR13.6 PR13.8
N = No
Y = Yes
EMP-ADD-ALLOW-PER Signed 7.3 AC721 HR511
Allowance Percent Contains the additional percent (hours HR650 PA502
or amount) allowed before a warning PR13.1 PR13.5
message displays. PR13.6 PR13.8
EMP-ADD-ALLOW-HRS Signed 7.2 AC721 HR511
Allowance Hours Contains the additional hours allowed HR650 PA502
before the warning message displays. PR13.1 PR13.5
PR13.6 PR13.8
EMP-ADD-ALLOW-AMT Numeric 9 HR511 HR650
Allowance Amount Contains the additional amount of pay PA502 PR13.1
allowed before the warning message PR13.5 PR13.6
displays. PR13.8
EMP-RPT-INS-COST Signed 11.2 AC721 HR511
Reportable Insurance Contains the reportable life insurance HR650 PA502
cost for W-2 reporting. If you are using PR13.1 PR13.5
the Lawson Benefits system, BN150 (Life PR13.6 PR13.8
Insurance Reportable Income) updates
this field.
EMP-AUTO-TIME-REC Alpha 1 AC721 HR511
Automatic Time Indicates if an employee is allowed to HR650 PA502
Record have generated standard time records. PR13.1 PR13.5
N = No PR13.6 PR13.8
S = Standard
T = Time Group
Y = Yes
EMP-LAST-DED-SEQ Numeric 4 AC541 AC542
Last Deduction Contains the last sequence number used AC721 BN100
Sequence Nbr when a deduction was created for the BN101 BN102
employee through the Lawson Benefits BN103 BN104
system. The Lawson Payroll system does BN105 BN145
not use this field. BN150 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR511 HR650
PA502 PA513
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR39.1 PR39.2
PR47.1 PR514
...
EMP-AUTO-DEPOSIT Alpha 1 AC721 HR511
Automatic Deposit Indicates if the employee is set up for HR650 PA502
automatic payroll deposit. PR13.1 PR13.5
N = No PR13.6 PR13.8
P = Partial
Y = Yes
EMP-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) AC721 HCOP.2
Adjusted Hire Date Contains the employee's adjusted hire HR511 HR650
date. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ANNIVERS-DATE Numeric 8 (yyyymmdd) AC721 HR511
Anniversary Date Contains the employee's anniversary HR650 PA502
date of employment. PR13.1 PR13.5
PR13.6 PR13.8
EMP-TERM-DATE Numeric 8 (yyyymmdd) AC721 HCOP.2
Termination Date Contains the date of employment HR511 HR650
termination. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-CMT-SEQ Numeric 4 AC721
Last Comment Contains the last sequence number used
Sequence Number when the last employee comment was
created.
EMP-CREATION-DATE Numeric 8 (yyyymmdd) AC721 HR511
Creation Date Contains the date the employee record HR650 PA502
was added to the database. PR13.1 PR13.5
PR13.6 PR13.8
EMP-NBR-FTE Signed 4.3 AC721 BN350
Full Time Equivalent Contains the employee's FTE (Full-time HCOP.2 HR511
Equivalency) factor which indicates the HR650 PA502
percent of annual hours the employee PA513 PR13.1
works. For example, if the employee PR13.5 PR13.6
works full-time, this field is 1.000. If PR13.8 PR195
this field is 0.5000, the employee works PR89.1 TA175
half of the hours of a full-time TA195 TA199
employee.
EMP-PENSION-PLAN Alpha 1 AC721 HR511
Pension Plan Indicates if the employee is a HR650 PA502
participant in a retirement plan PR13.1 PR13.5
maintained by the company. PR13.6 PR13.8
N = No
Y = Yes
EMP-PAY-STEP Numeric 2 AC721 HCOP.2
Step Contains the appropriate step if the HR511 HR650
employee's pay is based on a step and PA502 PA513
grade schedule. PR13.1 PR13.5
PR13.6 PR13.8
EMP-PAY-GRADE Alpha 3 AC721 HCOP.2
Grade Contains the appropriate grade if the HR511 HR650
employee is paid based on a step and PA502 PA513
grade schedule or is assigned to a grade PR13.1 PR13.5
range schedule. PR13.6 PR13.8
EMP-SCHEDULE Alpha 9 AC721 HCOP.2
Schedule Contains the schedule the employee is HR511 HR650
associated with. There are two types of PA502 PA513
schedules: step and grade and grade PR13.1 PR13.5
range. PR13.6 PR13.8
The step and grade schedule is a matrix
used to determine an employee's rate of
pay based on their particular "step" and
"grade." If the employee is associated
with a step and grade schedule, the
system requires a value in the Step and
Grade fields and that the Rate of Pay
field is blank.
The grade range schedule is a series of
grades with minimum, midpoint, and
maximum salary amounts that is used for
salary administration. If an employee is
associated with a grade range schedule,
you can enter the grade, schedule, and
rate of pay. You can associate an
employee with only one type of schedule.
EMP-EBE-AMOUNT Signed 9.2 AC721 HR511
Business Expense Contains the employee business expense HR650 PA502
amount for W-2 purposes. PR13.1 PR13.5
PR13.6 PR13.8
EMP-SICK-PAY Signed 11.2 AC721 HR511
Sick Pay Contains the employee's non-taxable HR650 PA502
sick pay reportable on the W-2 form. PR13.1 PR13.5
PR13.6 PR13.8
EMP-OT-PLAN-CODE Alpha 4 AC721 HCOP.2
Ot Plan Code Contains the pay plan with which the HR511 HR650
employee is associated. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-DECEASED Alpha 1 AC721 HR511
Deceased Indicates if the employee is deceased. HR650 PA502
Y = Yes PR13.1 PR13.5
N = No PR13.6 PR13.8
EMP-BSI-GROUP Alpha 11 AC721 HR511
Bsi Group Contains the employee's BSI group code. HR650 PA502
A BSI group code is a code defined in PR13.1 PR13.5
BSI to provide an override tax formula PR13.6 PR13.8
for specific employees.
EMP-WORK-STATE Alpha 2 AC721 HR511
Work State Contains the employee's work state HR650 PA502
abbreviation. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-STATE Alpha 2 AC721 HR511
Tax State Contains the employee's state taxing HR650 PA502
authority for income tax purposes. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-PROVINCE Alpha 2 HR511 HR650
Tax Province Contains the tax province of the PA502 PR13.1
employee that is used for Canada PR13.5 PR13.6
Payroll. PR13.8
EMP-WC-STATE Alpha 2 AC721 HR511
Wc State Contains the employee's work state HR650 PA502
abbreviation that is used for computing PA513 PR13.1
workers' compensation PR13.5 PR13.6
premiums. PR13.8
EMP-TAX-COUNTY Alpha 10 AC721 HR511
Tax County Contains the county taxing authority HR650 PA502
for income tax purposes. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-CITY Alpha 10 AC721 HR511
Tax City Contains the city taxing authority for HR650 PA502
income tax purposes. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-MOVING-EXP Signed 11.2 AC721 HR511
Moving Exp Contains the employee's qualified HR650 PA502
moving expenses that are reportable on PR13.1 PR13.5
the W-2 form. PR13.6 PR13.8
EMP-ALT-RATE-EXIST Alpha 1 AC721 HR14.1
Alt Rate Exist Indicates whether the employee has HR511 HR514
alternates pay rates defined for HR650 PA502
different job codes. PR13.1 PR13.5
Y = Yes PR13.6 PR13.8
Blank = No
EMP-PEND-ACT-DATE Numeric 8 (yyyymmdd) AC721 HR511
Pend Act Date Contains the date an action will take HR650 PA502
effect. PR13.1 PR13.5
PR13.6 PR13.8
UK110
EMP-PIN Alpha 10 (Lower Case) AC721
Pin Contains the employee Personal
Identification Number.
EMP-TIPPED Alpha 1 AC721 HR511
Tipped Contains a value that indicates whether HR650 PA502
the employee is a tipped employee. This PR13.1 PR13.5
field determines whether the system PR13.6 PR13.8
verifies minimum wage and whether to
perform the tip credit calculation.
C = Tipped Employee - Tip Credit
N = Not a Tipped Employee
T = Tipped Employee -No Tip Credit
EMP-FAX-COUNTRY Alpha 6 AC721
Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
EMP-FAX-NUMBER Alpha 15 AC721
Fax Number This field contains the fax number.
EMP-FAX-EXT Alpha 5 AC721
Fax Extension This field contains the fax number
extension.
EMP-EMAIL-ADDRESS Alpha 60 (Lower Case) AC721 HR511
Email Address Contains the employee's E-mail address. HR650 PA502
PR13.1 PR13.5
PR13.6 PR13.8
EMP-ACTIVITY Alpha 15 AC721 HCOP.2
Activity Contains the activity. HR511 HR650
PA502 PA513
Activities are the tasks that make up PR13.1 PR13.5
an activity group. Activities identify PR13.6 PR13.8
work being done, such as work orders,
phases, products, and so on. A variety
of costs, revenues, or both make up an
activity. The Activity Management system
stores information such as
responsibility and schedule for each
activity. The breakdown of activity
costs and revenues is defined by account
categories. An activity must belong to
an activity group.
EMP-ACCT-CATEGORY Alpha 5 AC721 HCOP.2
Account Category Contains the account category. HR511 HR650
PA502 PA513
Account categories are the Activity PR13.1 PR13.5
Management accounts by which activity PR13.6 PR13.8
transactions are grouped for budgeting
and reporting. Set up account categories
for an activity before you do any
budgeting or transaction processing.
Using account categories, you can sort
and combine incoming amounts into groups
for reporting and inquiry on activities.
EMP-MAX-LIMIT-OVRD Alpha 1 AC721 HR511
Max Limit Ovrd Indicates the default for the maximum HR650 PA502
compensation limit from Benefit Plan PR13.1 PR13.5
file has been overriden for this PR13.6 PR13.8
employee.
Y = Yes
N = No
EMP-SEC-LVL Numeric 1 AC721 HR12.1
Sec Lvl Contains the employee's security level. HR511 HR650
PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SEC-LOCATION Alpha 10 AC721 HR12.1
Sec Location Contains the employee's security HR511 HR650
location. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-POSITION Alpha 12 AC721 HCOP.2
Position Contains the user-defined code that HR511 HR650
represents a position in the company. PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-SCHED Alpha 10 AC721 HR511
Work Schedule Contains the employee's work schedule. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-SUPERVISOR-IND Alpha 10 AC721 HR511
Supervisor Ind Contains the employee's indirect HR650 PA502
supervisor. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-ANNUAL-HOURS Numeric 4 AC721 HR511
Annual Hours Contains the employee's annual hours. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-COUNTY Alpha 10 AC721 HR511
Work County Contains the employee's work county. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-CITY Alpha 10 AC721 HR511
Work City Contains the employee's work city. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-SCHOOL Alpha 10 AC721 HR511
Work School Contains the employee's work school. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-WORK-TRANSPORT Alpha 10 AC721
Work Transport Contains the employees work
transportation.
EMP-TAX-SCHOOL Alpha 10 AC721 HR511
Tax School Contains the employee's school tax HR650 PA502
authority. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-TAX-TRANSPORT Alpha 10 AC721
Tax Transport Contains the employee's tax
transportation authority.
EMP-FTE-TOTAL Signed 8.3 AC721 HCOP.2
Fte Total Contains the employee's total FTE. HR511 HR650
PA502 PA513
The total FTE is the sum of the FTEs PR13.1 PR13.5
for all of the employee's (Level 1 PR13.6 PR13.8
through 5) positions or jobs.
EMP-PRO-RATE-TOTAL Signed 13.4 AC721 HR511
Pro Rate Total HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-PRO-RATE-A-SAL Signed 13.4 AC721 HR511
Pro Rate A Sal HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-NEW-HIRE-DATE Numeric 8 (yyyymmdd) AC721 HR511
New Hire Date HR650 PA502
PR13.1 PR13.5
PR13.6 PR13.8
PR296
EMP-COMPA-RATIO Derived
Compensation Ratio
EMP-PENET-RATIO Derived
Penetration Ratio
EMP-SAL-MTH-RATE Derived
Sal Mth Rate
EMP-HOUR-MTH-RATE Derived
Hour Mth Rate
EMP-MONTHLY-RATE Derived
Monthly Rate
EMP-SAL-BIWK-RATE Derived
Sal Biwk Rate
EMP-HRY-BIWK-RATE Derived
Hry Biwk Rate
EMP-SAL-SEMI-RATE Derived
Sal Semi Rate
EMP-HRY-SEMI-RATE Derived
Hry Semi Rate
EMP-SAL-WKLY-RATE Derived
Sal Wkly Rate
EMP-HRY-WKLY-RATE Derived
Hry Wkly Rate
EMP-WEEKLY-RATE Derived
Weekly Rate
EMP-BIWEEKLY-RATE Derived
Biweekly Rate
EMP-SEMIMNTH-RATE Derived
Semimnth Rate
EMP-EMP-ANN-HRS Derived
Emp Ann Hrs
EMP-CURRENCY-CODE Alpha 5 AC721 HR511
Currency Code Contains the pay currency. HR650 PA502
PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-CURR-ND Numeric 1 AC721 HR511
Currency Number of Represents the number of decimals HR650 PA502
Decimals defined for the currency of the object. PA513 PR13.1
PR13.5 PR13.6
PR13.8
EMP-COUNTRY-CODE Alpha 2 AC721 HR511
Country Code Contains the country of the employee's HR650 PA502
home address. PR13.1 PR13.5
PR13.6 PR13.8
EMP-NAME-PREFIX Alpha 4 (Lower Case) AC721 HR511
Name Prefix Contains the prefix (title) of the HR650 PA502
employee's name. PR13.1 PR13.5
PR13.6 PR13.8
EMP-NAME-SUFFIX Alpha 4 (Lower Case) AC721 HR511
Name Suffix Contains the suffix of the employee's HR650 PA502
name. PR13.1 PR13.5
PR13.6 PR13.8
EMP-WORK-COUNTRY Alpha 2 AC721 HR511
Work Country Contains the employee's work country. HR650 PA502
PR13.1 PR13.5
PR13.6 PR13.8
EMP-LAST-NAME-PRE Alpha 30 (Lower Case) AC721 HR511
Last Name Pre Contains the employee's previous last HR650 PA502
name. PR13.1 PR13.5
PR13.6 PR13.8
EMP-EST-REMUN Signed 11.2 HR511 HR650
Est Remun Used for taxing Canada Commission PA502 PR13.1
Payments. PR13.5 PR13.6
PR13.8
EMP-EST-EXPENSE Signed 11.2 HR511 HR650
Est Expense Used for taxing Canada Commission PA502 PR13.1
Payments. PR13.5 PR13.6
PR13.8
EMP-BUS-NBR-GRP Alpha 4 HR511 HR650
Bus Nbr Grp Contains the business number group. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-QC-ENT-NBR-GRP Alpha 4 HR511 HR650
Qc Ent Nbr Grp Contains the Quebec enterprise number PA502 PR13.1
group. PR13.5 PR13.6
PR13.8
EMP-LAST-PRE Derived
Last Pre
EMP-LAST-SUF Derived
Last Suf
EMP-LAST-PRE-SUF Derived
Last Pre Suf
EMP-FIRST-MI Derived
First Mi
EMP-LAST-NAME-EXP Derived
Last Name Exp
EMP-FIRST-MI-EXP Derived
First Mi Exp
EMP-FULL-NAME Derived
Full Name
EMP-SHORT-NAME Derived
Short Name Contains the employee's short name.
EMP-LABEL-NAME-1 Derived
Label Name 1
EMP-WC-PROVINCE Alpha 2 AC721 HR511
Wc Province Contains the employees province for HR650 PA502
Canadian Workers Compensation. PR13.1 PR13.5
PR13.6 PR13.8
EMP-COUNTY Alpha 25 (Lower Case) HR511 HR650
County The county for the company address. PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-RAILROAD-CODE Numeric 1 HR511 HR650
Railroad Code 0 = Not Railroad Employee PA502 PR13.1
1 = Tier One Employee PR13.5 PR13.6
2 = Tier Two Employee PR13.8
EMP-FST-DAY-WORKED Numeric 8 (yyyymmdd) HR511 HR650
Fst Day Worked PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMP-LAST-DAY-PAID Numeric 8 (yyyymmdd) HR511 HR650
Last Day Paid PA502 PR13.1
PR13.5 PR13.6
PR13.8
EMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMPSET1 COMPANY AC03.3 AC17.3
EMPLOYEE AC18.2 AC190
AC191 AC196
AC203 AC217
AC218 AC259
AC50.1 AC500
AC52.1 AC520
AC530 AC541
AC542 AC550
AC551 AC559
AC59.1 AC62.1
AC721 AC741
AC92.2 AC92.4
AC92.6 GR741
BN100 BN101
...
EMPSET2 COMPANY KeyChange HEP3.1 HR12.1
PROCESS-LEVEL HR170 HR650
DEPARTMENT HR70.1 PA149
EMPLOYEE PA340 PR134
PR136 PR205
PR212 PR214
PR226 PR229
PR247 PR33.2
PR38.1 PR39.2
EMPSET4 COMPANY KeyChange HEP4.1 HR511
FICA-NBR HR650 PA502
EMPLOYEE PR13.1 PR13.5
PR13.6 PR13.8
EMPSET6 COMPANY KeyChange HEP2.1 HR212
LAST-NAME HS10.1 HS10.2
FIRST-NAME PA311 PA370
MIDDLE-INIT PR33.3
EMPLOYEE
EMPSET7 COMPANY KeyChange BN100 BN101
PROCESS-LEVEL BN102 BN103
EMPLOYEE BN150 BN242
BN245 BN331
HC01.1 HC02.1
HCEM.1 HCOP.1
HR00.1 HR01.1
HR217 HR220
PA113 PA149
PA218 PA335
PR128 PR130
PR139 PR141
PR197 PR212
PR214 PR226
PR229 PR230
...
EMPLOYEE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When EMP-ACCT-CATEGORY != Spaces
EMP-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When EMP-ACTIVITY != Spaces
EMP-ACTIVITY -> ACV-ACTIVITY
City PRTAXAUTH Required
When EMP-TAX-CITY != Spaces
EMP-TAX-CITY -> PRX-TAX-ID-CODE
Company PRSYSTEM Required
EMP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
County PRTAXAUTH Required
When EMP-TAX-COUNTY != Spaces
EMP-TAX-COUNTY -> PRX-TAX-ID-CODE
Currency CUCODES Required
When (EMP-CURRENCY-CODE != Spaces )
EMP-CURRENCY-CODE -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When EMP-DEPARTMENT != Spaces
EMP-COMPANY -> DPT-COMPANY
EMP-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
EMP-DEPARTMENT -> DPT-DEPARTMENT
Emp Status EMSTATUS Required
When EMP-EMP-STATUS != Spaces
EMP-COMPANY -> EMS-COMPANY
EMP-EMP-STATUS -> EMS-EMP-STATUS
Home Account GLMASTER Required
When EMP-HM-ACCT-UNIT != Spaces
Or EMP-HM-ACCOUNT != Zeroes
Or EMP-HM-SUB-ACCT != Zeroes
EMP-HM-DIST-CO -> GLM-COMPANY
EMP-HM-ACCT-UNIT -> GLM-ACCT-UNIT
EMP-HM-ACCOUNT -> GLM-ACCOUNT
EMP-HM-SUB-ACCT -> GLM-SUB-ACCOUNT
Indir Supv HRSUPER Required
When (EMP-SUPERVISOR-IND != Spaces )
EMP-COMPANY -> HSU-COMPANY
EMP-SUPERVISOR-IND -> HSU-CODE
Job Code JOBCODE Required
When EMP-JOB-CODE != Spaces
EMP-COMPANY -> JBC-COMPANY
EMP-JOB-CODE -> JBC-JOB-CODE
Location PCODES Required
When EMP-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
PEM-LOCAT-CODE -> PCO-CODE
Paemployee PAEMPLOYEE Not Required, Delete Cascades
EMP-COMPANY -> PEM-COMPANY
EMP-EMPLOYEE -> PEM-EMPLOYEE
Process Level PRSYSTEM Required
EMP-COMPANY -> PRS-COMPANY
EMP-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Required
EMP-COMPANY -> PQC-COMPANY
EMP-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
EMP-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Resident State PRSTATE Required
When EMP-TAX-STATE != Spaces
EMP-TAX-STATE -> PSA-STATE
Schedule PRSAGHEAD Required
When EMP-SCHEDULE != Spaces
EMP-COMPANY -> SGH-COMPANY
"S" -> SGH-INDICATOR
EMP-SCHEDULE -> SGH-SCHEDULE
Zeroes -> SGH-EFFECT-DATE
Step And Grade PRSAGDTL Required
When EMP-SCHEDULE != Spaces
And EMP-PAY-STEP != Zeroes
And EMP-PAY-GRADE != Spaces
EMP-COMPANY -> SGD-COMPANY
EMP-SCHEDULE -> SGD-SCHEDULE
EMP-PAY-GRADE -> SGD-PAY-GRADE
EMP-PAY-STEP -> SGD-PAY-STEP
Zeroes -> SGD-EFFECT-DATE
Supervisor HRSUPER Required
When EMP-SUPERVISOR != Spaces
EMP-COMPANY -> HSU-COMPANY
EMP-SUPERVISOR -> HSU-CODE
Tax Rpt State PREMPSTATE Not Required
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
EMP-TAX-STATE -> PES-STATE
Tax School PRTAXAUTH Not Required
Valid When EMP-TAX-SCHOOL != Spaces
EMP-TAX-SCHOOL -> PRX-TAX-ID-CODE
Union PCODES Required
When EMP-UNION-CODE != Spaces
"UN" -> PCO-TYPE
EMP-UNION-CODE -> PCO-CODE
User Level PCODES Required
When EMP-USER-LEVEL != Spaces
"UL" -> PCO-TYPE
EMP-USER-LEVEL -> PCO-CODE
Wc State PRSTATE Required
When EMP-WC-STATE != Spaces
EMP-WC-STATE -> PSA-STATE
Work City PRTAXAUTH Not Required
Valid When EMP-WORK-CITY != Spaces
EMP-WORK-CITY -> PRX-TAX-ID-CODE
Work County PRTAXAUTH Not Required
Valid When EMP-WORK-COUNTY != Spaces
EMP-WORK-COUNTY -> PRX-TAX-ID-CODE
Work Rpt State PREMPSTATE Not Required
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
EMP-WORK-STATE -> PES-STATE
Work Sched PCODES Required
When (EMP-WORK-SCHED != Spaces )
"WS" -> PCO-TYPE
EMP-WORK-SCHED -> PCO-CODE
Work School PRTAXAUTH Not Required
Valid When EMP-WORK-SCHOOL != Spaces
EMP-WORK-SCHOOL -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When EMP-WORK-STATE != Spaces
EMP-WORK-STATE -> PSA-STATE
EMPLOYEE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acassign ACASSIGN
EMP-COMPANY -> AAN-COMPANY
EMP-EMPLOYEE -> AAN-EMPLOYEE-ASSET
AAN-ACTIVITY-GRP
AAN-ACTIVITY
AAN-RESOURCE-TYPE
AAN-RESOURCE-CODE
Ach Deposits EMACHDEPST Delete Cascades
EMP-COMPANY -> EAD-COMPANY
EMP-EMPLOYEE -> EAD-EMPLOYEE
EAD-ACH-DIST-NBR
All Pos PAEMPPOS Delete Cascades
EMP-COMPANY -> PEP-COMPANY
EMP-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
Alt Pay Rates PRRATES Delete Cascades
EMP-COMPANY -> PRR-COMPANY
EMP-EMPLOYEE -> PRR-EMPLOYEE
PRR-SEQ-NBR
Attend Hist ATTENDHIST Delete Cascades
EMP-COMPANY -> ATH-COMPANY
EMP-EMPLOYEE -> ATH-EMPLOYEE
ATH-DATE
ATH-ATTEND-CODE
ATH-TIME-SEQ
Beneficiaries BENEFICRY
EMP-COMPANY -> BNF-COMPANY
EMP-EMPLOYEE -> BNF-EMPLOYEE
BNF-PLAN-TYPE
BNF-PLAN-CODE
BNF-SEQ-NBR
Benefit BENEFIT Delete Restricted
EMP-COMPANY -> BEN-COMPANY
EMP-EMPLOYEE -> BEN-EMPLOYEE
BEN-PLAN-TYPE
BEN-PLAN-CODE
BEN-START-DATE
Bnben BNBEN Delete Cascades
EMP-COMPANY -> BNB-COMPANY
EMP-EMPLOYEE -> BNB-EMPLOYEE
BNB-PLAN-TYPE
BNB-PLAN-CODE
BNB-START-DATE
Bnchange BNCHANGE Delete Cascades
EMP-COMPANY -> BNH-COMPANY
EMP-EMPLOYEE -> BNH-EMPLOYEE
BNH-EFFECT-DATE
BNH-SEQ-NBR
Bngrpchg BNGRPCHG Delete Cascades
EMP-COMPANY -> BNG-COMPANY
EMP-EMPLOYEE -> BNG-EMPLOYEE
BNG-EFFECT-DATE
BNG-SEQ-NBR
Bondbenseq BONDBENSEQ
EMP-COMPANY -> BBS-COMPANY
EMP-EMPLOYEE -> BBS-EMPLOYEE
BBS-PLAN-CODE
BBS-START-DATE
BBS-BOND-SEQ-NBR
Ck Comments PACOMMENTS Delete Cascades
EMP-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"CK" -> PAC-CMT-TYPE
EMP-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Coda CODA
EMP-COMPANY -> COD-COMPANY
EMP-EMPLOYEE -> COD-EMPLOYEE
COD-PLAN-TYPE
COD-PLAN-CODE
COD-PLAN-YEAR
Comphist COMPHIST
EMP-COMPANY -> CPH-COMPANY
EMP-EMPLOYEE -> CPH-EMPLOYEE
CPH-PLAN-TYPE
CPH-PLAN-CODE
CPH-PLAN-YEAR
Correspondence HRCORRESP
EMP-COMPANY -> HCP-COMPANY
"1" -> HCP-REQ-TYPE
EMP-EMPLOYEE -> HCP-ID-NBR
Zeroes -> HCP-DEPENDENT
HCP-SEQ-NBR
Cur Err Pro Tr TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-PROCESS-LEVEL -> TRD-PROCESS-LEVEL
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-REPORT-ENTITY
TRD-BUS-NBR-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Current Pos PAEMPPOS
EMP-COMPANY -> PEP-COMPANY
EMP-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
Ded History PREMDEDHST Delete Restricted
EMP-COMPANY -> PDH-COMPANY
EMP-EMPLOYEE -> PDH-EMPLOYEE
PDH-REPORT-ENTITY
PDH-DED-CODE
PDH-SEQ-NBR
PDH-YEAR
PDH-MONTH
Deduction EMDEDMASTR Delete Restricted
EMP-COMPANY -> EDM-COMPANY
EMP-EMPLOYEE -> EDM-EMPLOYEE
EDM-DED-CODE
EDM-SEQ-NBR
Emdistmast EMDISTMAST Delete Cascades
EMP-COMPANY -> DIP-COMPANY
EMP-EMPLOYEE -> DIP-EMPLOYEE
DIP-POSITION
DIP-PAY-CODE
DIP-DED-CODE
DIP-SEQ-NBR
Emp Garn PREMPGARN Delete Cascades
EMP-COMPANY -> PEG-COMPANY
EMP-EMPLOYEE -> PEG-EMPLOYEE
PEG-CASE-NUMBER
PEG-FILE-NUMBER
Emp Trans EMTATRANS
EMP-COMPANY -> ETT-COMPANY
EMP-EMPLOYEE -> ETT-EMPLOYEE
ETT-PLAN-NAME
ETT-DATE
ETT-SEQ-NBR
Emtamastr EMTAMASTR Delete Cascades
EMP-COMPANY -> ETM-COMPANY
EMP-EMPLOYEE -> ETM-EMPLOYEE
ETM-PLAN-NAME
Err Time Recs TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-PROCESS-LEVEL -> TRD-PROCESS-LEVEL
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-REPORT-ENTITY
TRD-BUS-NBR-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Flex Dollars EMPFLEXDOL
EMP-COMPANY -> EFD-COMPANY
EMP-EMPLOYEE -> EFD-EMPLOYEE
EFD-START-DATE
Flex Periods EMPFLEXREM
EMP-COMPANY -> EFR-COMPANY
EMP-EMPLOYEE -> EFR-EMPLOYEE
EFR-PLAN-START-DT
EFR-START-DATE
Fut Time Recs TIMERECORD
EMP-COMPANY -> TRD-COMPANY
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-TR-DATE
TRD-TIME-SEQ
Hrhistory HRHISTORY
EMP-COMPANY -> HRH-COMPANY
EMP-EMPLOYEE -> HRH-EMPLOYEE
Zeroes -> HRH-OBJ-ID
HRH-FLD-NBR
HRH-BEG-DATE
HRH-SEQ-NBR
Job Hist APPJOBHIST
EMP-COMPANY -> AJH-COMPANY
EMP-EMPLOYEE -> AJH-EMPLOYEE
AJH-SEQ-NBR
AJH-APPLICANT
One Time Ded ONETMDED
EMP-COMPANY -> OTD-COMPANY
EMP-EMPLOYEE -> OTD-EMPLOYEE
OTD-DED-CODE
OTD-EDM-SEQ-NBR
OTD-SEQ-NBR
Open Manuals PAYMASTR
EMP-COMPANY -> PYM-COMPANY
EMP-PROCESS-LEVEL -> PYM-PROCESS-LEVEL
EMP-EMPLOYEE -> PYM-EMPLOYEE
"M" -> PYM-CHECK-TYPE
PYM-CHECK-ID
Part Benefit PARTBEN Delete Restricted
EMP-COMPANY -> PTB-COMPANY
EMP-EMPLOYEE -> PTB-EMPLOYEE
PTB-PARTICIPNT
PTB-PLAN-TYPE
PTB-PLAN-CODE
PTB-START-DATE
Pathfind PATHFIND Delete Cascades
EMP-COMPANY -> PTF-COMPANY
EMP-EMPLOYEE -> PTF-EMPLOYEE
PTF-FLD-NBR
PTF-POS-LEVEL
Paymastr PAYMASTR Delete Restricted
EMP-COMPANY -> PYM-COMPANY
EMP-EMPLOYEE -> PYM-EMPLOYEE
PYM-CHECK-ID
Payments PAYMASTR Delete Restricted
EMP-COMPANY -> PYM-COMPANY
EMP-EMPLOYEE -> PYM-EMPLOYEE
PYM-CHECK-DATE
PYM-CHECK-NBR
PYM-CHECK-ID
Pbhstdtl PBHSTDTL
EMP-COMPANY -> PBH-COMPANY
EMP-EMPLOYEE -> PBH-EMPLOYEE
PBH-CHECK-ID
PBH-PROCESS-LEVEL
PBH-INVOICE
PBH-LINE-NBR
Pep Audit PAPEPAUDIT Delete Cascades
EMP-COMPANY -> PEA-COMPANY
EMP-EMPLOYEE -> PEA-EMPLOYEE
PEA-POS-LEVEL
PEA-EFFECT-DATE
PEA-UPDATE-DATE
PEA-FLD-NBR
PEA-ACT-OBJ-ID
Persacthst PERSACTHST
EMP-COMPANY -> PAH-COMPANY
EMP-EMPLOYEE -> PAH-EMPLOYEE
PAH-EFFECT-DATE
PAH-ACTION-CODE
PAH-ACTION-NBR
Pgemployee PGEMPLOYEE Delete Cascades
EMP-COMPANY -> PGE-COMPANY
EMP-EMPLOYEE -> PGE-EMPLOYEE
PGE-GROUP-NAME
Plan Name EMTAMASTR Delete Restricted
EMP-COMPANY -> ETM-COMPANY
EMP-EMPLOYEE -> ETM-EMPLOYEE
ETM-PLAN-NAME
Pos Chg Error PAPOSERR Delete Cascades
EMP-COMPANY -> PPE-COMPANY
EMP-EMPLOYEE -> PPE-EMPLOYEE
Zeroes -> PPE-REQUISITION
PPE-POSITION
PPE-EFFECT-DATE
PPE-UPDATE-TYPE
Position PAPOSITION
Valid When (EMP-POSITION != Spaces )
EMP-COMPANY -> POS-COMPANY
EMP-POSITION -> POS-POSITION
POS-EFFECT-DATE
Pr Distribs PRDISTRIB Delete Restricted
EMP-COMPANY -> PRD-COMPANY
EMP-EMPLOYEE -> PRD-EMPLOYEE
PRD-GL-DATE
PRD-CHECK-ID
PRD-OBJ-ID
Quartded QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-COUNTRY-CODE
QTD-DED-CODE
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
QTD-PENSION
Quartded All QUARTDED
EMP-COMPANY -> QTD-COMPANY
EMP-EMPLOYEE -> QTD-EMPLOYEE
QTD-PAYROLL-YEAR
QTD-QUARTER
QTD-COUNTRY-CODE
QTD-DED-CODE
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
QTD-PENSION
Quartwage QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
PRS-PAYROLL-YEAR -> QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-COUNTRY-CODE
QTW-PAY-SUM-GRP
QTW-REPORT-ENTITY
QTW-BUS-NBR-GRP
QTW-QC-ENT-NBR-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
QTW-PENSION
Quartwage All QUARTWAGE
EMP-COMPANY -> QTW-COMPANY
EMP-EMPLOYEE -> QTW-EMPLOYEE
QTW-PAYROLL-YEAR
QTW-QUARTER
QTW-COUNTRY-CODE
QTW-PAY-SUM-GRP
QTW-REPORT-ENTITY
QTW-BUS-NBR-GRP
QTW-QC-ENT-NBR-GRP
QTW-PROCESS-LEVEL
QTW-WORK-STATE
QTW-PENSION
Report States PREMPSTATE Delete Cascades
EMP-COMPANY -> PES-COMPANY
EMP-EMPLOYEE -> PES-EMPLOYEE
PES-STATE
Salary History PRRATEHIST
EMP-COMPANY -> PRH-COMPANY
EMP-EMPLOYEE -> PRH-EMPLOYEE
PRH-POS-LEVEL
PRH-BEG-DATE
PRH-SEQ-NBR
Standtime STANDTIME Delete Cascades
EMP-COMPANY -> STM-COMPANY
EMP-EMPLOYEE -> STM-EMPLOYEE
Spaces -> STM-TIME-GROUP
STM-PAY-CODE
STM-SEQ-NBR
Super Codes HRSUPER
EMP-COMPANY -> HSU-COMPANY
EMP-EMPLOYEE -> HSU-EMPLOYEE
HSU-CODE
Timerecord TIMERECORD Delete Restricted
EMP-COMPANY -> TRD-COMPANY
EMP-EMPLOYEE -> TRD-EMPLOYEE
TRD-TIME-SEQ
User Fields HREMPUSF Delete Cascades
EMP-COMPANY -> HEU-COMPANY
Zeroes -> HEU-EMP-APP
EMP-EMPLOYEE -> HEU-EMPLOYEE
HEU-FIELD-KEY
Vesthours VESTHOURS
EMP-COMPANY -> VES-COMPANY
EMP-EMPLOYEE -> VES-EMPLOYEE
VES-PLAN-TYPE
VES-PLAN-CODE
VES-PLAN-YEAR
Wages PRTIME
EMP-COMPANY -> PRT-COMPANY
EMP-EMPLOYEE -> PRT-EMPLOYEE
PRT-TR-DATE
PRT-TIME-SEQ
PRT-CHECK-ID
|