EMPLOYEE – Employee

System
Human Resources (HR)
Prefix
EMP
Primary key
COMPANY, EMPLOYEE
Fields
152
Updated by
131 programs
Referenced by
661 programs

EMPLOYEE is the Employee table in Lawson Human Resources (prefix EMP). It is indexed by COMPANY, EMPLOYEE (EMPSET1); alternate indexes: EMPSET2, EMPSET3, EMPSET4, EMPSET6 and EMPSET7. It is related 1:1 to ACACCTCAT, ACACTIVITY, PRTAXAUTH, PRSYSTEM, CUCODES, DEPTCODE, EMSTATUS, EMPALTNAME and 10 more and 1:M to ACASSIGN, EMACHDEPST, PAEMPPOS, PRRATES, ATTENDHIST, BENEFICRY, BENEFIT, BNBEN and 60 more. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 123 more and referenced by AC03.3, AC03.7, AC145, AC17.3, AC18.2, AC190, AC191, AC197 and 653 more. The table has 152 fields, 6 indexes and 110 documented relations.

About 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.

Fields (152)

Column = COBOL field name without the EMP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EMP-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#EMP-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the number assigned to each employee. The employee number is used with the company number to uniquely identify the employee throughout the Lawson Human Capital Management applications.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#EMP-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the employee's last name.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +25 more
#EMP-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the employee's first name.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +25 more
#EMP-MIDDLE-INIT SET6
MIDDLE_INIT		Alpha 1Contains the employee's middle initial.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +25 more
#EMP-MIDDLE-NAME
MIDDLE_NAME		Alpha 15 (Lower Case)Contains the employee's middle name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-NICK-NAME
NICK_NAME		Alpha 30 (Lower Case)Contains the employee's nick name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADDR1
ADDR1		Alpha 57 (Lower Case)Contains the first line of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADDR2
ADDR2		Alpha 30 (Lower Case)Contains the second line of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADDR3
ADDR3		Alpha 30 (Lower Case)Contains the third line of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADDR4
ADDR4		Alpha 30 (Lower Case)Contains the fourth line of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-CITY
CITY		Alpha 58 (Lower Case)Contains the city of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-STATE
STATE		Alpha 2Contains the state of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ZIP
ZIP		Alpha 10Contains the postal code of the employee's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EMP-STATUS SET3
EMP_STATUS		Alpha 2Contains the employee's status, which can be used to determine if this employee is paid.BN305, HCEM.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +27 more
#EMP-FICA-NBR SET4
FICA_NBR		Alpha 20Contains the employee's Social Security number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#EMP-EIC-STATUS
EIC_STATUS		Numeric 1Indicates if the employee's EIC status is Single or Joint.
  • 0 Not Applicable
  • 1 Single
  • 2 Joint
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PROCESS-LEVEL SET2 SET7
PROCESS_LEVEL		Alpha 5Contains the employee's process level.BN305, HCEM.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +28 more
#EMP-DEPARTMENT SET2
DEPARTMENT		Alpha 5Contains the employee's department.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#EMP-USER-LEVEL
USER_LEVEL		Alpha 10Contains the employee's user level.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-HM-DIST-CO
HM_DIST_CO		Numeric 4Contains the employee's home general ledger distribution company for expense.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-HM-ACCT-UNIT
HM_ACCT_UNIT		Alpha 15Contains the employee's home general ledger accounting unit for expense.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-HM-ACCOUNT
HM_ACCOUNT		Numeric 6Contains the employee's home general ledger account for expense.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-HM-SUB-ACCT
HM_SUB_ACCT		Numeric 4Contains the employee's home general ledger subaccount for expense.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-JOB-CODE
JOB_CODE		Alpha 9Contains the employee's job code.BN305, HR11.1, HR11.2, HR11.4, HR170, HR28.1, HR511, HR70.1 +26 more
#EMP-UNION-CODE
UNION_CODE		Alpha 10Contains the employee's union code.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SUPERVISOR
SUPERVISOR		Alpha 10Contains the supervisor code that identifies the supervisor to whom the employee reports.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-DATE-HIRED
DATE_HIRED		Numeric 8 (yyyymmdd)Contains the employee's hire date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PAY-FREQUENCY
PAY_FREQUENCY		Numeric 1Identifies the employee's pay frequency.
  • 1 Weekly
  • 2 Biweekly
  • 3 Semimonthly
  • 4 Monthly
  • 5 UK Four-Weekly
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +28 more
#EMP-SHIFT
SHIFT		Numeric 1Identifies the shift with which the employee's pay is associated.
  • 1 Shift 1
  • 2 Shift 2
  • 3 Shift 3
  • 4 Shift 4
  • 5 Shift 5
  • 6 Shift 6
  • 7 Shift 7
  • 8 Shift 8
  • 9 Shift 9
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SALARY-CLASS
SALARY_CLASS		Alpha 1Select whether the rate of pay is hourly or salaried.
  • H Hourly
  • S Salaried
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EXEMPT-EMP
EXEMPT_EMP		Alpha 1Indicates if the employee is exempt from overtime pay.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PAY-RATE
PAY_RATE		Signed 13.4Contains the employee's rate of pay. This can be an annual amount or an hourly amount. If this is a step and grade employee, this field is zero and the step, grade and schedule must exist. The application uses these fields to retrieve the employee's rate of pay at calculation time.BN305, HLTM.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +27 more
#EMP-STAND-HOURS
STAND_HOURS		Signed 7.2Contains the number of hours this employee usually works each pay period. If you enter a value in this field, additional edits occur at time entry.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-STAND-AMT
STAND_AMT		Signed 11.3Contains the amount of money the employee usually makes per pay period. If you enter a value in this field, additional edits occur at time entry.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WARN-FLAG
WARN_FLAG		Alpha 1Indicates if a warning displays when the employee exceeds the standard hours or amount for a pay period.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADD-ALLOW-PER
ADD_ALLOW_PER		Signed 7.3Contains the additional percent (hours or amount) allowed before a warning message displays.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADD-ALLOW-HRS
ADD_ALLOW_HRS		Signed 7.2Contains the additional hours allowed before the warning message displays.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ADD-ALLOW-AMT
ADD_ALLOW_AMT		Numeric 9Contains the additional amount of pay allowed before the warning message displays.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-RPT-INS-COST
RPT_INS_COST		Signed 11.2Contains the reportable life insurance cost for W-2 reporting. If you are using the Lawson Benefits system, BN150 (Life Insurance Reportable Income) updates this field.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-AUTO-TIME-REC
AUTO_TIME_REC		Alpha 1Indicates if an employee is allowed to have generated standard time records.
  • N No
  • S Standard
  • T Time Group
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAST-DED-SEQ
LAST_DED_SEQ		Numeric 4Contains the last sequence number used when a deduction was created for the employee through the Lawson Benefits system. The Lawson Payroll system does not use this field.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#EMP-AUTO-DEPOSIT
AUTO_DEPOSIT		Alpha 1Indicates if the employee is set up for automatic payroll deposit.
  • N No
  • P Partial
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#EMP-ADJ-HIRE-DATE
ADJ_HIRE_DATE		Numeric 8 (yyyymmdd)Contains the employee's adjusted hire date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ANNIVERS-DATE
ANNIVERS_DATE		Numeric 8 (yyyymmdd)Contains the employee's anniversary date of employment.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TERM-DATE
TERM_DATE		Numeric 8 (yyyymmdd)Contains the date of employment termination.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4Contains the last sequence number used when the last employee comment was created.—
#EMP-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)Contains the date the employee record was added to the database.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-NBR-FTE
NBR_FTE		Signed 7.6Contains the employee's FTE (Full-time Equivalency) factor which indicates the percent of annual hours the employee works. For example, if the employee works full-time, this field is 1.000. If this field is 0.5000, the employee works half of the hours of a full-time employee.BN305, BN350, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +28 more
#EMP-PENSION-PLAN
PENSION_PLAN		Alpha 1Indicates if the employee is a participant in a retirement plan maintained by the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
#EMP-PAY-STEP
PAY_STEP		Numeric 2Contains the appropriate step if the employee's pay is based on a step and grade schedule.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PAY-GRADE
PAY_GRADE		Alpha 3Contains the appropriate grade if the employee is paid based on a step and grade schedule or is assigned to a grade range schedule.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SCHEDULE
SCHEDULE		Alpha 9Contains the schedule the employee is associated with. There are two types of schedules: step and grade and grade range. 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 application 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.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EBE-AMOUNT
EBE_AMOUNT		Signed 9.2Contains the employee business expense amount for W-2 purposes.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SICK-PAY
SICK_PAY		Signed 11.2Contains the employee's non-taxable sick pay reportable on the W-2 form.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-OT-PLAN-CODE
OT_PLAN_CODE		Alpha 4Contains the pay plan with which the employee is associated.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-DECEASED
DECEASED		Alpha 1Indicates if the employee is deceased.
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
#EMP-BSI-GROUP
BSI_GROUP		Alpha 11Contains the employee's BSI group code. A BSI group code is a code defined in BSI to provide an override tax formula for specific employees.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-STATE
WORK_STATE		Alpha 2Contains the employee's work state abbreviation.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-STATE
TAX_STATE		Alpha 2Contains the employee's state taxing authority for income tax purposes.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-PROVINCE
TAX_PROVINCE		Alpha 2Contains the tax province of the employee that is used for Canada Payroll.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WC-STATE
WC_STATE		Alpha 2Contains the employee's work state abbreviation that is used for computing workers' compensation premiums.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-COUNTY
TAX_COUNTY		Alpha 10Contains the county taxing authority for income tax purposes.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-CITY
TAX_CITY		Alpha 10Contains the city taxing authority for income tax purposes.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-MOVING-EXP
MOVING_EXP		Signed 11.2Contains the employee's qualified moving expenses that are reportable on the W-2 form.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ALT-RATE-EXIST
ALT_RATE_EXIST		Alpha 1Indicates whether the employee has alternates pay rates defined for different job codes.
  • Y Yes
  • Blank No
BN305, HR11.1, HR11.2, HR11.4, HR14.1, HR28.1, HR511, HR514 +26 more
#EMP-PEND-ACT-DATE
PEND_ACT_DATE		Numeric 8 (yyyymmdd)Contains the date an action will take effect.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +26 more
#EMP-PIN
PIN		Alpha 10 (Lower Case)Contains the employee Personal Identification Number.—
#EMP-TIPPED
TIPPED		Alpha 1Contains a value that indicates whether the employee is a tipped employee. This field determines whether the system 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
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)Contains the employee's E-mail address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#EMP-ACTIVITY
ACTIVITY		Alpha 15Contains the activity. Activities are the tasks that make up an activity group. Activities identify 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.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Contains the account category. Account categories are the Activity Management accounts by which activity 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.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-MAX-LIMIT-OVRD
MAX_LIMIT_OVRD		Alpha 1Indicates the default for the maximum compensation limit from Benefit Plan file has been overriden for this employee.
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SEC-LVL
SEC_LVL		Numeric 1Contains the employee's security level.BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more
#EMP-SEC-LOCATION
SEC_LOCATION		Alpha 10Contains the employee's security location.BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more
#EMP-POSITION
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-SCHED
WORK_SCHED		Alpha 10Contains the employee's work schedule.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SUPERVISOR-IND
SUPERVISOR_IND		Alpha 10Contains the employee's indirect supervisor.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4Contains the employee's annual hours.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-COUNTY
WORK_COUNTY		Alpha 10Contains the employee's work county.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-CITY
WORK_CITY		Alpha 10Contains the employee's work city.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-SCHOOL
WORK_SCHOOL		Alpha 10Contains the employee's work school.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-TRANSPORT
WORK_TRANSPORT		Alpha 10Contains the employees work transportation.—
#EMP-TAX-SCHOOL
TAX_SCHOOL		Alpha 10Contains the employee's school tax authority.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-TRANSPORT
TAX_TRANSPORT		Alpha 10Contains the employee's tax transportation authority.—
#EMP-FTE-TOTAL
FTE_TOTAL		Signed 11.6Contains the employee's total FTE. The total FTE is the sum of the FTEs for all of the employee's (Level 1 through 5) positions or jobs.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PRO-RATE-TOTAL
PRO_RATE_TOTAL		Signed 13.4—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PRO-RATE-A-SAL
PRO_RATE_A_SAL		Signed 13.4—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-NEW-HIRE-DATE
NEW_HIRE_DATE		Numeric 8 (yyyymmdd)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#EMP-COMPA-RATIO
COMPA_RATIO		Derived——
#EMP-PENET-RATIO
PENET_RATIO		Derived——
#EMP-SAL-MTH-RATE
SAL_MTH_RATE		Derived——
#EMP-HOUR-MTH-RATE
HOUR_MTH_RATE		Derived——
#EMP-MONTHLY-RATE
MONTHLY_RATE		Derived——
#EMP-SAL-BIWK-RATE
SAL_BIWK_RATE		Derived——
#EMP-HRY-BIWK-RATE
HRY_BIWK_RATE		Derived——
#EMP-SAL-SEMI-RATE
SAL_SEMI_RATE		Derived——
#EMP-HRY-SEMI-RATE
HRY_SEMI_RATE		Derived——
#EMP-SAL-WKLY-RATE
SAL_WKLY_RATE		Derived——
#EMP-HRY-WKLY-RATE
HRY_WKLY_RATE		Derived——
#EMP-WEEKLY-RATE
WEEKLY_RATE		Derived——
#EMP-BIWEEKLY-RATE
BIWEEKLY_RATE		Derived——
#EMP-SEMIMNTH-RATE
SEMIMNTH_RATE		Derived——
#EMP-EMP-ANN-HRS
EMP_ANN_HRS		Derived——
#EMP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the pay currency.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Contains the country of the employee's home address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-NAME-PREFIX
NAME_PREFIX		Alpha 4 (Lower Case)Contains the prefix (title) of the employee's name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-NAME-SUFFIX
NAME_SUFFIX		Alpha 4 (Lower Case)Contains the suffix of the employee's name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-WORK-COUNTRY
WORK_COUNTRY		Alpha 2Contains the employee's work country.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAST-NAME-PRE
LAST_NAME_PRE		Alpha 30 (Lower Case)Contains the employee's previous last name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EST-REMUN
EST_REMUN		Signed 11.2Used for taxing Canada Commission Payments.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EST-EXPENSE
EST_EXPENSE		Signed 11.2Used for taxing Canada Commission Payments.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-BUS-NBR-GRP
BUS_NBR_GRP		Alpha 4Contains the business number group.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-QC-ENT-NBR-GRP
QC_ENT_NBR_GRP		Alpha 4Contains the Quebec enterprise number group.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAST-PRE
LAST_PRE		Derived——
#EMP-LAST-SUF
LAST_SUF		Derived——
#EMP-LAST-PRE-SUF
LAST_PRE_SUF		Derived——
#EMP-FIRST-MI
FIRST_MI		Derived——
#EMP-LAST-NAME-EXP
LAST_NAME_EXP		Derived——
#EMP-FIRST-MI-EXP
FIRST_MI_EXP		Derived——
#EMP-FULL-NAME
FULL_NAME		Derived——
#EMP-SHORT-NAME
SHORT_NAME		DerivedContains the employee's short name.—
#EMP-LABEL-NAME-1
LABEL_NAME_1		Derived——
#EMP-WC-PROVINCE
WC_PROVINCE		Alpha 2Contains the employees province for Canadian Workers Compensation.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-RAILROAD-CODE
RAILROAD_CODE		Numeric 1—
  • 0 Not Railroad Employee
  • 1 Tier One Employee
  • 2 Tier Two Employee
  • 3 Both Tier 1 and Tier 2
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-FST-DAY-WORKED
FST_DAY_WORKED		Numeric 8 (yyyymmdd)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAST-DAY-PAID
LAST_DAY_PAID		Numeric 8 (yyyymmdd)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-LAB-DIST-FLAG
LAB_DIST_FLAG		Alpha 1" " = Not Applicable
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-ENCUMBER-FLAG
ENCUMBER_FLAG		Alpha 1" " = Not Applicable
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-EFFORT-FLAG
EFFORT_FLAG		Alpha 1Flag to indicate whether this activity is subject to effort reporting, and if it is, whether it prints in the sponsored or non-sponsored section of the report for effort reporting. " " = Not Applicable
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-RPT-CURR
RPT_CURR		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PRMCERT-ID
PRMCERT_ID		Numeric 9Contains 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.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-SNDCERT-ID
SNDCERT_ID		Numeric 9Contains 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.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-FRNG-RATE
FRNG_RATE		Signed 12.6A default fringe rate that can be sued by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-FRNG-ACCT-CAT
FRNG_ACCT_CAT		Alpha 5Account 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 thruBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-FRNG-ACCOUNT
FRNG_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-FRNG-SUB-ACCT
FRNG_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-DEATH-DATE
DEATH_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-TAX-FILTER
TAX_FILTER		Numeric 1—
  • 1 Locate All
  • 2 Locate Federal & State Only
  • 3 Locate Federal Only
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-REMOTE
REMOTE		Numeric 1—
  • 0 Not Remote
  • 1 Remote
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PUB-SEC-RETIRE
PUB_SEC_RETIRE		Numeric 4—
  • 0000 Not a Member
  • 0001 Member; Use Hire Date
  • 0002 Member; Use Adj Hire Date
  • 0003 Member; State Specific
  • 0004 Suppress Soc Sec EE and ER
  • 0005 Suppress Medicare EE and ER
  • 0006 Suppress SS/Med EE and ER
  • 0007 Member; PERA - Tax Def
  • 0008 Member; SS Tax Def
  • 0009 Member; Med Tax Def
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-PRMCERT-COMP
PRMCERT_COMP		Numeric 4—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR708, LT101 +25 more
#EMP-SNDCERT-COMP
SNDCERT_COMP		Numeric 4—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR708, LT101 +25 more
#EMP-ST-STATUS
ST_STATUS		Numeric 1——
#EMP-LAST-NAME-UC SET6
LAST_NAME_UC		Alpha 30Employees last name in upper case for efficiency in select by nameBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR709, LT101 +25 more
#EMP-FIRST-NAME-UC SET6
FIRST_NAME_UC		Alpha 15Employees first name in upper case for efficiency in select by nameBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR709, LT101 +25 more
#EMP-FICA-NBR-LAST4
FICA_NBR_LAST4		Alpha 4This field contains the last four digits of the employee's Fica Nbr. This allows clients to secure the regular Fica Nbr field and leave this field open for inclusion on payroll and other reports.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR711, LT101 +25 more
#EMP-EMAIL-PERSONAL
EMAIL_PERSONAL		Alpha 60 (Lower Case)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#EMP-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—
#EMP-HICN
HICN		Alpha 11—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EMPSET1
  1. COMPANY
  2. EMPLOYEE
PrimaryAC03.3, AC03.7, AC145, AC17.3, AC18.2, AC190, AC191, AC197 +22 more (list truncated in source)
EMPSET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. EMPLOYEE
KeyChangeBN242, BN320, HEP3.1, HR105, HR12.1, HR170, HR228, HR70.1 +18 more
EMPSET3
  1. COMPANY
  2. EMP-STATUS
  3. EMPLOYEE
KeyChangeHR03.1
EMPSET4
  1. COMPANY
  2. FICA-NBR
  3. EMPLOYEE
KeyChangeBN305, HEP4.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
EMPSET6
  1. COMPANY
  2. LAST-NAME-UC
  3. FIRST-NAME-UC
  4. MIDDLE-INIT
  5. EMPLOYEE
KeyChangeHEP2.1, HR212, HR255, HS10.1, HS10.2, PA311, PA370, PR33.3
EMPSET7
  1. COMPANY
  2. PROCESS-LEVEL
  3. EMPLOYEE
KeyChangeBN100, BN101, BN102, BN103, BN150, BN242, BN245, BN260 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYPRTAXAUTHPRSYSTEMCUCODESDEPTCODEEMSTATUSEMPALTNAMEEMPBODGLMASTERHRSUPERJOBCODEPCODESPAEMPLOYEE+4 more belowACASSIGNEMACHDEPSTPAEMPPOSPRRATESATTENDHISTBENEFICRYBENEFITBNBENBNCHANGEBNGRPCHGBONDBENSEQPACOMMENTSCODACOMPHIST+54 more belowEMPLOYEE

One to one (31) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen EMP-ACCT-CATEGORY != Spaces
EMP-ACCT-CATEGORY→AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen EMP-ACTIVITY != Spaces
EMP-ACTIVITY→ACV-ACTIVITY
CityPRTAXAUTHRequiredWhen EMP-TAX-CITY != Spaces
EMP-TAX-CITY→PRX-TAX-ID-CODE
CompanyPRSYSTEMRequired
EMP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountyPRTAXAUTHRequiredWhen EMP-TAX-COUNTY != Spaces
EMP-TAX-COUNTY→PRX-TAX-ID-CODE
CurrencyCUCODESRequiredWhen (EMP-CURRENCY-CODE != Spaces)
EMP-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen EMP-DEPARTMENT != Spaces
EMP-COMPANY→DPT-COMPANY
EMP-PROCESS-LEVEL→DPT-PROCESS-LEVEL
EMP-DEPARTMENT→DPT-DEPARTMENT
Emp StatusEMSTATUSRequiredWhen EMP-EMP-STATUS != Spaces
EMP-COMPANY→EMS-COMPANY
EMP-EMP-STATUS→EMS-EMP-STATUS
EmpaltnameEMPALTNAMENot Required
EMP-COMPANY→EAN-COMPANY
EMP-EMPLOYEE→EAN-EMPLOYEE
EmpbodEMPBODNot Required, Delete Cascades
EMP-COMPANY→EMB-COMPANY
EMP-EMPLOYEE→EMB-EMPLOYEE
Home AccountGLMASTERRequiredWhen 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 SupvHRSUPERRequiredWhen (EMP-SUPERVISOR-IND != Spaces)
EMP-COMPANY→HSU-COMPANY
EMP-SUPERVISOR-IND→HSU-CODE
Job CodeJOBCODERequiredWhen EMP-JOB-CODE != Spaces
EMP-COMPANY→JBC-COMPANY
EMP-JOB-CODE→JBC-JOB-CODE
LocationPCODESRequiredWhen PEM-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
PEM-LOCAT-CODE→PCO-CODE
PaemployeePAEMPLOYEENot Required, Delete Cascades
EMP-COMPANY→PEM-COMPANY
EMP-EMPLOYEE→PEM-EMPLOYEE
Prmcert IdEMPLOYEERequiredWhen (EMP-PRMCERT-COMP != Zeroes) And (EMP-PRMCERT-COMP != Zeroes)
EMP-PRMCERT-COMP→EMP-COMPANY
EMP-PRMCERT-ID→EMP-EMPLOYEE
Process LevelPRSYSTEMRequired
EMP-COMPANY→PRS-COMPANY
EMP-PROCESS-LEVEL→PRS-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPRequired
EMP-COMPANY→PQC-COMPANY
EMP-PROCESS-LEVEL→PQC-PROCESS-LEVEL
EMP-QC-ENT-NBR-GRP→PQC-QC-ENT-NBR-GRP
Resident StatePRSTATERequiredWhen EMP-TAX-STATE != Spaces
EMP-TAX-STATE→PSA-STATE
Sndcert IdEMPLOYEERequiredWhen (EMP-SNDCERT-COMP != Zeroes) And (EMP-SNDCERT-ID != Zeroes)
EMP-SNDCERT-COMP→EMP-COMPANY
EMP-SNDCERT-ID→EMP-EMPLOYEE
SupervisorHRSUPERRequiredWhen EMP-SUPERVISOR != Spaces
EMP-COMPANY→HSU-COMPANY
EMP-SUPERVISOR→HSU-CODE
Tax Rpt StatePREMPSTATENot RequiredValid When (EMP-TAX-STATE != Spaces)
EMP-COMPANY→PES-COMPANY
EMP-EMPLOYEE→PES-EMPLOYEE
EMP-TAX-STATE→PES-STATE
Tax SchoolPRTAXAUTHNot RequiredValid When EMP-TAX-SCHOOL != Spaces
EMP-TAX-SCHOOL→PRX-TAX-ID-CODE
UnionPCODESRequiredWhen EMP-UNION-CODE != Spaces
"UN"→PCO-TYPE
EMP-UNION-CODE→PCO-CODE
User LevelPCODESRequiredWhen EMP-USER-LEVEL != Spaces
"UL"→PCO-TYPE
EMP-USER-LEVEL→PCO-CODE
Wc StatePRSTATERequiredWhen EMP-WC-STATE != Spaces
EMP-WC-STATE→PSA-STATE
Work CityPRTAXAUTHNot RequiredValid When EMP-WORK-CITY != Spaces
EMP-WORK-CITY→PRX-TAX-ID-CODE
Work CountyPRTAXAUTHNot RequiredValid When EMP-WORK-COUNTY != Spaces
EMP-WORK-COUNTY→PRX-TAX-ID-CODE
Work Rpt StatePREMPSTATENot RequiredValid When EMP-WORK-STATE != Spaces
EMP-COMPANY→PES-COMPANY
EMP-EMPLOYEE→PES-EMPLOYEE
EMP-WORK-STATE→PES-STATE
Work SchoolPRTAXAUTHNot RequiredValid When EMP-WORK-SCHOOL != Spaces
EMP-WORK-SCHOOL→PRX-TAX-ID-CODE
Work StatePRSTATERequiredWhen EMP-WORK-STATE != Spaces
EMP-WORK-STATE→PSA-STATE

One to many (79) — child tables

RelationTableRulesConditionField map
AcassignACASSIGN
EMP-COMPANY→AAN-COMPANY
EMP-EMPLOYEE→AAN-EMPLOYEE-ASSET
—→AAN-ACTIVITY-GRP
—→AAN-ACTIVITY
—→AAN-RESOURCE-TYPE
—→AAN-RESOURCE-CODE
Ach DepositsEMACHDEPSTDelete Cascades
EMP-COMPANY→EAD-COMPANY
EMP-EMPLOYEE→EAD-EMPLOYEE
—→EAD-ACH-DIST-NBR
All PosPAEMPPOSDelete Cascades
EMP-COMPANY→PEP-COMPANY
EMP-EMPLOYEE→PEP-EMPLOYEE
—→PEP-POS-LEVEL
—→PEP-EFFECT-DATE
Alt Pay RatesPRRATESDelete Cascades
EMP-COMPANY→PRR-COMPANY
EMP-EMPLOYEE→PRR-EMPLOYEE
—→PRR-SEQ-NBR
Attend HistATTENDHISTDelete Cascades
EMP-COMPANY→ATH-COMPANY
EMP-EMPLOYEE→ATH-EMPLOYEE
—→ATH-DATE
—→ATH-ATTEND-CODE
—→ATH-TIME-SEQ
BeneficiariesBENEFICRY
EMP-COMPANY→BNF-COMPANY
EMP-EMPLOYEE→BNF-EMPLOYEE
—→BNF-PLAN-TYPE
—→BNF-PLAN-CODE
—→BNF-SEQ-NBR
BenefitBENEFITDelete Restricted
EMP-COMPANY→BEN-COMPANY
EMP-EMPLOYEE→BEN-EMPLOYEE
—→BEN-PLAN-TYPE
—→BEN-PLAN-CODE
—→BEN-START-DATE
BnbenBNBENDelete Cascades
EMP-COMPANY→BNB-COMPANY
EMP-EMPLOYEE→BNB-EMPLOYEE
—→BNB-PLAN-TYPE
—→BNB-PLAN-CODE
—→BNB-START-DATE
BnchangeBNCHANGEDelete Cascades
EMP-COMPANY→BNH-COMPANY
EMP-EMPLOYEE→BNH-EMPLOYEE
—→BNH-EFFECT-DATE
—→BNH-SEQ-NBR
BngrpchgBNGRPCHGDelete Cascades
EMP-COMPANY→BNG-COMPANY
EMP-EMPLOYEE→BNG-EMPLOYEE
—→BNG-EFFECT-DATE
—→BNG-SEQ-NBR
BondbenseqBONDBENSEQ
EMP-COMPANY→BBS-COMPANY
EMP-EMPLOYEE→BBS-EMPLOYEE
—→BBS-PLAN-CODE
—→BBS-START-DATE
—→BBS-BOND-SEQ-NBR
Ck CommentsPACOMMENTSDelete 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
—→PAC-DATE
CodaCODA
EMP-COMPANY→COD-COMPANY
EMP-EMPLOYEE→COD-EMPLOYEE
—→COD-PLAN-TYPE
—→COD-PLAN-CODE
—→COD-PLAN-YEAR
—→COD-PROCESS-LEVEL
—→COD-BUS-NBR-GRP
—→COD-QC-ENT-NBR-GRP
ComphistCOMPHIST
EMP-COMPANY→CPH-COMPANY
EMP-EMPLOYEE→CPH-EMPLOYEE
—→CPH-PLAN-TYPE
—→CPH-PLAN-CODE
—→CPH-PLAN-YEAR
CorrespondenceHRCORRESP
EMP-COMPANY→HCP-COMPANY
"1"→HCP-REQ-TYPE
EMP-EMPLOYEE→HCP-ID-NBR
Zeroes→HCP-DEPENDENT
—→HCP-SEQ-NBR
Cur Err Pro TrTIMERECORD
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 PosPAEMPPOS
EMP-COMPANY→PEP-COMPANY
EMP-EMPLOYEE→PEP-EMPLOYEE
—→PEP-POS-LEVEL
—→PEP-EFFECT-DATE
CwchangeCWCHANGEDelete Cascades
EMP-COMPANY→CCH-COMPANY
EMP-EMPLOYEE→CCH-EMPLOYEE
—→CCH-POSITION
—→CCH-WORK-SCHED
—→CCH-EFFECT-DATE
—→CCH-CHANGE-TYPE
DeductionEMDEDMASTRDelete Restricted
EMP-COMPANY→EDM-COMPANY
EMP-EMPLOYEE→EDM-EMPLOYEE
—→EDM-DED-CODE
—→EDM-EFFECT-DATE
—→EDM-SEQ-NBR
DependentEMDEPENDDelete Cascades
EMP-COMPANY→EMD-COMPANY
EMP-EMPLOYEE→EMD-EMPLOYEE
—→EMD-SEQ-NBR
EmdistmastEMDISTMASTDelete Cascades
EMP-COMPANY→DIP-COMPANY
EMP-EMPLOYEE→DIP-EMPLOYEE
—→DIP-POSITION
—→DIP-PAY-CODE
—→DIP-DED-CODE
—→DIP-SEQ-NBR
Emp AssignmentCWASSIGN
EMP-COMPANY→CWA-COMPANY
EMP-EMPLOYEE→CWA-EMPLOYEE
—→CWA-CONTRACT-YEAR
—→CWA-POSITION
—→CWA-ASG-EFFECT-DTE
—→CWA-PCD-SEQ-NBR
Emp CmchangeCMCHANGEDelete Cascades
EMP-COMPANY→CHG-COMPANY
EMP-EMPLOYEE→CHG-EMPLOYEE
—→CHG-POS-LEVEL
—→CHG-EFFECT-DATE
—→CHG-CHANGE-TYPE
—→CHG-WORK-SCHED
—→CHG-CONTRACT-YEAR
—→CHG-CONTRACT-NBR
Emp CmcontractCMCONTRACT
EMP-COMPANY→CNR-COMPANY
EMP-EMPLOYEE→CNR-EMPLOYEE
—→CNR-CONTRACT-NBR
Emp ContractCWCONTRACT
EMP-COMPANY→CCT-COMPANY
EMP-EMPLOYEE→CCT-EMPLOYEE
—→CCT-CONTRACT-YEAR
—→CCT-POSITION
—→CCT-CONT-SEQ-NBR
Emp GarnPREMPGARNDelete Cascades
EMP-COMPANY→PEG-COMPANY
EMP-EMPLOYEE→PEG-EMPLOYEE
—→PEG-CASE-NUMBER
—→PEG-FILE-NUMBER
Emp LeaveLPEMPLEAVE
EMP-COMPANY→LEL-COMPANY
EMP-EMPLOYEE→LEL-EMPLOYEE
—→LEL-BEGIN-DATE
—→LEL-SEQ-NBR
Emp TransEMTATRANS
EMP-COMPANY→ETT-COMPANY
EMP-EMPLOYEE→ETT-EMPLOYEE
—→ETT-PLAN-NAME
—→ETT-DATE
—→ETT-SEQ-NBR
EmtamastrEMTAMASTRDelete Cascades
EMP-COMPANY→ETM-COMPANY
EMP-EMPLOYEE→ETM-EMPLOYEE
—→ETM-PLAN-NAME
Err Time RecsTIMERECORD
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 DollarsEMPFLEXDOL
EMP-COMPANY→EFD-COMPANY
EMP-EMPLOYEE→EFD-EMPLOYEE
—→EFD-START-DATE
Flex PeriodsEMPFLEXREM
EMP-COMPANY→EFR-COMPANY
EMP-EMPLOYEE→EFR-EMPLOYEE
—→EFR-PLAN-START-DT
—→EFR-START-DATE
Fut Time RecsTIMERECORD
EMP-COMPANY→TRD-COMPANY
EMP-EMPLOYEE→TRD-EMPLOYEE
—→TRD-TR-DATE
—→TRD-TIME-SEQ
GmeffortGMEFFORT
EMP-COMPANY→EFH-HR-COMPANY
EMP-EMPLOYEE→EFH-EMPLOYEE
—→EFH-BEGIN-DATE
—→EFH-END-DATE
—→EFH-SEQUENCE-NBR
GmlabdistGMLABDIST
EMP-COMPANY→GML-HR-COMPANY
EMP-EMPLOYEE→GML-EMPLOYEE
—→GML-EFFECT-DATE
—→GML-JOB-CODE
—→GML-POSITION
—→GML-PAY-CODE
GmretdistGMRETDIST
EMP-COMPANY→GMI-HR-COMPANY
EMP-EMPLOYEE→GMI-EMPLOYEE
—→GMI-START-DATE
—→GMI-END-DATE
—→GMI-JOB-CODE
—→GMI-POSITION
—→GMI-PAY-CODE
—→GMI-SEQUENCE-NBR
GmtranefrtGMTRANEFRT
EMP-COMPANY→GEF-HR-COMPANY
EMP-EMPLOYEE→GEF-EMPLOYEE
—→GEF-ACTIVITY
—→GEF-ACCT-CATEGORY
—→GEF-COMPANY
—→GEF-ACCT-UNIT
—→GEF-ACCOUNT
—→GEF-SUB-ACCT
—→GEF-OBJ-ID
Hr Occup CodeHROCCUPCDValid When EMP-JOB-CODE != Spaces
EMP-COMPANY→HOP-COMPANY
EMP-JOB-CODE→HOP-JOB-CODE
EMP-WORK-COUNTRY→HOP-COUNTRY-CODE
—→HOP-OCCUPTN-CODE
HrhistoryHRHISTORY
EMP-COMPANY→HRH-COMPANY
EMP-EMPLOYEE→HRH-EMPLOYEE
Zeroes→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Job HistAPPJOBHIST
EMP-COMPANY→AJH-COMPANY
EMP-EMPLOYEE→AJH-EMPLOYEE
—→AJH-SEQ-NBR
—→AJH-APPLICANT
Lp ServiceTAEMPSERV
EMP-COMPANY→TES-COMPANY
EMP-EMPLOYEE→TES-EMPLOYEE
—→TES-TR-DATE
—→TES-TES-OBJ-ID
—→TES-SERVICE-STATUS
—→TES-EVENT-STATUS
LptransTAEMPTRANS
EMP-COMPANY→TTR-COMPANY
EMP-EMPLOYEE→TTR-EMPLOYEE
—→TTR-PLAN
—→TTR-EMPLOYEE-GROUP
—→TTR-POSITION
—→TTR-DATE
—→TTR-SEQ-NBR
ObjectivesPAEMPGOALDelete Restricted
EMP-COMPANY→PGO-COMPANY
EMP-EMPLOYEE→PGO-EMPLOYEE
—→PGO-END-DATE
—→PGO-PRIORITY
—→PGO-SEQ-NBR
One Time DedONETMDED
EMP-COMPANY→OTD-COMPANY
EMP-EMPLOYEE→OTD-EMPLOYEE
—→OTD-DED-CODE
—→OTD-EDM-SEQ-NBR
—→OTD-SEQ-NBR
Open ManualsPAYMASTR
EMP-COMPANY→PYM-COMPANY
EMP-PROCESS-LEVEL→PYM-PROCESS-LEVEL
EMP-EMPLOYEE→PYM-EMPLOYEE
"M"→PYM-CHECK-TYPE
—→PYM-CHECK-ID
Open PaymentsPAYMASTR
EMP-COMPANY→PYM-COMPANY
EMP-PROCESS-LEVEL→PYM-PROCESS-LEVEL
EMP-EMPLOYEE→PYM-EMPLOYEE
—→PYM-CHECK-TYPE
—→PYM-CHECK-ID
Ot Plan CodePROVERTIMEValid When EMP-OT-PLAN-CODE != Spaces
EMP-COMPANY→PRO-COMPANY
EMP-OT-PLAN-CODE→PRO-PLAN-CODE
—→PRO-EFFECT-DATE
Part BenefitPARTBENDelete Restricted
EMP-COMPANY→PTB-COMPANY
EMP-EMPLOYEE→PTB-EMPLOYEE
—→PTB-PARTICIPNT
—→PTB-PLAN-TYPE
—→PTB-PLAN-CODE
—→PTB-START-DATE
PathfindPATHFINDDelete Cascades
EMP-COMPANY→PTF-COMPANY
EMP-EMPLOYEE→PTF-EMPLOYEE
—→PTF-FLD-NBR
—→PTF-POS-LEVEL
PaymastrPAYMASTRDelete Restricted
EMP-COMPANY→PYM-COMPANY
EMP-EMPLOYEE→PYM-EMPLOYEE
—→PYM-CHECK-ID
PaymentsPAYMASTRDelete Restricted
EMP-COMPANY→PYM-COMPANY
EMP-EMPLOYEE→PYM-EMPLOYEE
—→PYM-CHECK-DATE
—→PYM-CHECK-NBR
—→PYM-CHECK-ID
Payments2PAYMASTR
EMP-COMPANY→PYM-COMPANY
EMP-EMPLOYEE→PYM-EMPLOYEE
—→PYM-CHECK-DATE
—→PYM-CHECK-NBR
—→PYM-CHECK-ID
Pep AuditPAPEPAUDITDelete 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
PersacthstPERSACTHST
EMP-COMPANY→PAH-COMPANY
EMP-EMPLOYEE→PAH-EMPLOYEE
—→PAH-EFFECT-DATE
—→PAH-ACTION-CODE
—→PAH-ACTION-NBR
PgemployeePGEMPLOYEEDelete Cascades
EMP-COMPANY→PGE-COMPANY
EMP-EMPLOYEE→PGE-EMPLOYEE
—→PGE-GROUP-NAME
Plan NameEMTAMASTRDelete Restricted
EMP-COMPANY→ETM-COMPANY
EMP-EMPLOYEE→ETM-EMPLOYEE
—→ETM-PLAN-NAME
Pos Chg ErrorPAPOSERRDelete Cascades
EMP-COMPANY→PPE-COMPANY
EMP-EMPLOYEE→PPE-EMPLOYEE
Zeroes→PPE-REQUISITION
—→PPE-POSITION
—→PPE-EFFECT-DATE
—→PPE-UPDATE-TYPE
PositionPAPOSITIONValid When (EMP-POSITION != Spaces)
EMP-COMPANY→POS-COMPANY
EMP-POSITION→POS-POSITION
—→POS-EFFECT-DATE
Pr DistribsPRDISTRIBDelete Restricted
EMP-COMPANY→PRD-COMPANY
EMP-EMPLOYEE→PRD-EMPLOYEE
—→PRD-GL-DATE
—→PRD-CHECK-ID
—→PRD-OBJ-ID
PrhoursPRHOURSDelete Cascades
EMP-COMPANY→PHS-COMPANY
EMP-EMPLOYEE→PHS-EMPLOYEE
—→PHS-HOURS-TYPE
—→PHS-PAYROLL-YEAR
QuartdedQUARTDED
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 AllQUARTDED
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
QuartwageQUARTWAGE
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 AllQUARTWAGE
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 StatesPREMPSTATEDelete Cascades
EMP-COMPANY→PES-COMPANY
EMP-EMPLOYEE→PES-EMPLOYEE
—→PES-STATE
Salary HistoryPRRATEHIST
EMP-COMPANY→PRH-COMPANY
EMP-EMPLOYEE→PRH-EMPLOYEE
—→PRH-POS-LEVEL
—→PRH-BEG-DATE
—→PRH-SEQ-NBR
SchedulePRSAGHEADValid When EMP-SCHEDULE != Spaces
EMP-COMPANY→SGH-COMPANY
"S"→SGH-INDICATOR
EMP-SCHEDULE→SGH-SCHEDULE
—→SGH-EFFECT-DATE
StandtimeSTANDTIMEDelete Cascades
EMP-COMPANY→STM-COMPANY
EMP-EMPLOYEE→STM-EMPLOYEE
Spaces→STM-TIME-GROUP
—→STM-PAY-CODE
—→STM-SEQ-NBR
Step And GradePRSAGDTLValid 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
—→SGD-EFFECT-DATE
Super CodesHRSUPER
EMP-COMPANY→HSU-COMPANY
EMP-EMPLOYEE→HSU-EMPLOYEE
—→HSU-CODE
Ta EnrollTAENROLLDelete Cascades
EMP-COMPANY→TEN-COMPANY
EMP-EMPLOYEE→TEN-EMPLOYEE
—→TEN-PLAN
—→TEN-EMPLOYEE-GROUP
—→TEN-POSITION
—→TEN-JOB-CODE
—→TEN-PROCESS-LEVEL
—→TEN-DEPARTMENT
Ta GroupTAEEGROUPDelete Cascades
EMP-COMPANY→TGR-COMPANY
EMP-EMPLOYEE→TGR-EMPLOYEE
—→TGR-EMPLOYEE-GROUP
—→TGR-EFFECTIVE-DATE
—→TGR-QUALIFY-FLAG
Ta MasterTAEEMASTERDelete Cascades
EMP-COMPANY→TEM-COMPANY
EMP-EMPLOYEE→TEM-EMPLOYEE
—→TEM-PLAN
—→TEM-EMPLOYEE-GROUP
—→TEM-POSITION
TaloshrsTALOSHRSDelete Cascades
EMP-COMPANY→TLH-COMPANY
EMP-EMPLOYEE→TLH-EMPLOYEE
—→TLH-PLAN
—→TLH-EMPLOYEE-GROUP
—→TLH-POSITION
—→TLH-PLAN-RULE
—→TLH-ACCRUAL-TYPE
—→TLH-YEAR
TimerecordTIMERECORDDelete Restricted
EMP-COMPANY→TRD-COMPANY
EMP-EMPLOYEE→TRD-EMPLOYEE
—→TRD-TIME-SEQ
User FieldsHREMPUSFDelete Cascades
EMP-COMPANY→HEU-COMPANY
Zeroes→HEU-EMP-APP
EMP-EMPLOYEE→HEU-EMPLOYEE
—→HEU-FIELD-KEY
VesthoursVESTHOURS
EMP-COMPANY→VES-COMPANY
EMP-EMPLOYEE→VES-EMPLOYEE
—→VES-PLAN-TYPE
—→VES-PLAN-CODE
—→VES-PLAN-YEAR
WagesPRTIME
EMP-COMPANY→PRT-COMPANY
EMP-EMPLOYEE→PRT-EMPLOYEE
—→PRT-TR-DATE
—→PRT-TIME-SEQ
—→PRT-CHECK-ID
Work SchedHRWRKSCHDValid When (EMP-WORK-SCHED != Spaces)
EMP-COMPANY→WSC-COMPANY
EMP-WORK-SCHED→WSC-WORK-SCHED
—→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (131)

Referenced by (661)