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
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
EMP-COMPANY Element: Company | Numeric 4 Contains the company number. |
||
EMP-EMPLOYEE Element: Employee | Numeric 9 Contains 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. |
||
EMP-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) Contains the employee's last name. |
||
EMP-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) Contains the employee's first name. |
||
EMP-MIDDLE-INIT Element: Middle Initial | Alpha 1 Contains the employee's middle initial. |
||
EMP-MIDDLE-NAME Element: Middle Name | Alpha 15 (Lower Case) Contains the employee's middle name. |
||
EMP-NICK-NAME Element: Nick Name | Alpha 30 (Lower Case) Contains the employee's nick name. |
||
EMP-ADDR1 Element: Hr Addr1 | Alpha 57 (Lower Case) Contains the first line of the employee's address. |
||
EMP-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) Contains the second line of the employee's address. |
||
EMP-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) Contains the third line of the employee's address. |
||
EMP-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) Contains the fourth line of the employee's address. |
||
EMP-CITY Element: Hr City | Alpha 58 (Lower Case) Contains the city of the employee's address. |
||
EMP-STATE Element: State | Alpha 2 Contains the state of the employee's address. |
||
EMP-ZIP Element: Zip | Alpha 10 Contains the postal code of the employee's address. |
||
EMP-EMP-STATUS Element: Status | Alpha 2 Contains the employee's status, which can be used to determine if this employee is paid. |
||
EMP-FICA-NBR Element: Social Number | Alpha 20 Contains the employee's Social Security number. |
||
EMP-EIC-STATUS Element: EIC Status | Numeric 1 Indicates if the employee's EIC status is Single or Joint. 0 = Not Applicable 1 = Single 2 = Joint |
||
EMP-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the employee's process level. |
||
EMP-DEPARTMENT Element: Department | Alpha 5 Contains the employee's department. |
||
EMP-USER-LEVEL Element: User Level | Alpha 10 Contains the employee's user level. |
||
EMP-HM-DIST-CO Element: Company | Numeric 4 Contains the employee's home general ledger distribution company for expense. |
||
EMP-HM-ACCT-UNIT Element: Acct Unit | Alpha 15 Contains the employee's home general ledger accounting unit for expense. |
||
EMP-HM-ACCOUNT Element: Account | Numeric 6 Contains the employee's home general ledger account for expense. |
||
EMP-HM-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the employee's home general ledger subaccount for expense. |
||
EMP-JOB-CODE Element: Job Code | Alpha 9 Contains the employee's job code. |
||
EMP-UNION-CODE Element: Union | Alpha 10 Contains the employee's union code. |
||
EMP-SUPERVISOR Element: Supervisor | Alpha 10 Contains the supervisor code that identifies the supervisor to whom the employee reports. |
||
EMP-DATE-HIRED Element: Hire Date | Numeric 8 (yyyymmdd) Contains the employee's hire date. |
||
EMP-PAY-FREQUENCY Element: Pay Frequency | Numeric 1 Identifies the employee's pay frequency. 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = UK Four-Weekly |
||
EMP-SHIFT Element: Shift | Numeric 1 Identifies 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 |
||
EMP-SALARY-CLASS Element: Salary Class | Alpha 1 Select whether the rate of pay is hourly or salaried. H = Hourly S = Salaried |
||
EMP-EXEMPT-EMP Element: Exempt | Alpha 1 Indicates if the employee is exempt from overtime pay. N = No Y = Yes |
||
EMP-PAY-RATE Element: Pay Rate | Signed 13.4 Contains 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. |
||
EMP-STAND-HOURS Element: Stand Hours | Signed 7.2 Contains 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. |
||
EMP-STAND-AMT Element: Stand Amt | Signed 11.3 Contains 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. |
||
EMP-WARN-FLAG Element: Warn Flag | Alpha 1 Indicates if a warning displays when the employee exceeds the standard hours or amount for a pay period. N = No Y = Yes |
||
EMP-ADD-ALLOW-PER Element: Add Allow Per | Signed 7.3 Contains the additional percent (hours or amount) allowed before a warning message displays. |
||
EMP-ADD-ALLOW-HRS Element: Add Allow Hrs | Signed 7.2 Contains the additional hours allowed before the warning message displays. |
||
EMP-ADD-ALLOW-AMT Element: Add Allow Amt | Numeric 9 Contains the additional amount of pay allowed before the warning message displays. |
||
EMP-RPT-INS-COST Element: Reportable Insurance | Signed 11.2 Contains 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. |
||
EMP-AUTO-TIME-REC Element: Auto Time Rec | Alpha 1 Indicates if an employee is allowed to have generated standard time records. N = No S = Standard T = Time Group Y = Yes |
||
EMP-LAST-DED-SEQ Element: Last Ded Seq | Numeric 4 Contains 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. |
||
EMP-AUTO-DEPOSIT Element: Auto Deposit | Alpha 1 Indicates if the employee is set up for automatic payroll deposit. N = No P = Partial Y = Yes |
||
EMP-ADJ-HIRE-DATE Element: Adjusted Hire Date | Numeric 8 (yyyymmdd) Contains the employee's adjusted hire date. |
||
EMP-ANNIVERS-DATE Element: Annivers Date | Numeric 8 (yyyymmdd) Contains the employee's anniversary date of employment. |
||
EMP-TERM-DATE Element: Term Date | Numeric 8 (yyyymmdd) Contains the date of employment termination. |
||
EMP-LAST-CMT-SEQ Element: Last Cmt Seq | Numeric 4 Contains the last sequence number used when the last employee comment was created. |
|
|
EMP-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) Contains the date the employee record was added to the database. |
||
EMP-NBR-FTE Element: Full Time Equivalent | Signed 7.6 Contains 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. |
||
EMP-PENSION-PLAN Element: Pension Plan | Alpha 1 Indicates if the employee is a participant in a retirement plan maintained by the company. N = No Y = Yes |
||
EMP-PAY-STEP Element: Step | Numeric 2 Contains the appropriate step if the employee's pay is based on a step and grade schedule. |
||
EMP-PAY-GRADE Element: Grade | Alpha 3 Contains the appropriate grade if the employee is paid based on a step and grade schedule or is assigned to a grade range schedule. |
||
EMP-SCHEDULE Element: Schedule | Alpha 9 Contains 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. |
||
EMP-EBE-AMOUNT Element: Business Expense | Signed 9.2 Contains the employee business expense amount for W-2 purposes. |
||
EMP-SICK-PAY Element: Sick Pay | Signed 11.2 Contains the employee's non-taxable sick pay reportable on the W-2 form. |
||
EMP-OT-PLAN-CODE Element: Ot Plan Code | Alpha 4 Contains the pay plan with which the employee is associated. |
||
EMP-DECEASED Element: Deceased | Alpha 1 Indicates if the employee is deceased. Y = Yes N = No |
||
EMP-BSI-GROUP Element: Bsi Group | Alpha 11 Contains 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. |
||
EMP-WORK-STATE Element: Work State | Alpha 2 Contains the employee's work state abbreviation. |
||
EMP-TAX-STATE Element: Tax State | Alpha 2 Contains the employee's state taxing authority for income tax purposes. |
||
EMP-TAX-PROVINCE Element: Province | Alpha 2 Contains the tax province of the employee that is used for Canada Payroll. |
||
EMP-WC-STATE Element: Wc State | Alpha 2 Contains the employee's work state abbreviation that is used for computing workers' compensation premiums. |
||
EMP-TAX-COUNTY Element: Tax County | Alpha 10 Contains the county taxing authority for income tax purposes. |
||
EMP-TAX-CITY Element: Tax City | Alpha 10 Contains the city taxing authority for income tax purposes. |
||
EMP-MOVING-EXP Element: Moving Exp | Signed 11.2 Contains the employee's qualified moving expenses that are reportable on the W-2 form. |
||
EMP-ALT-RATE-EXIST Element: Alt Rate Exist | Alpha 1 Indicates whether the employee has alternates pay rates defined for different job codes. Y = Yes Blank = No |
||
EMP-PEND-ACT-DATE Element: Pend Act Date | Numeric 8 (yyyymmdd) Contains the date an action will take effect. |
||
EMP-PIN Element: Pin | Alpha 10 (Lower Case) Contains the employee Personal Identification Number. |
|
|
EMP-TIPPED Element: Tipped | Alpha 1 Contains 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 |
||
EMP-EMAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) Contains the employee's E-mail address. |
||
EMP-ACTIVITY Element: Activity | Alpha 15 Contains 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. |
||
EMP-ACCT-CATEGORY Element: Acct Category | Alpha 5 Contains 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. |
||
EMP-MAX-LIMIT-OVRD Element: Max Limit Ovrd | Alpha 1 Indicates the default for the maximum compensation limit from Benefit Plan file has been overriden for this employee. Y = Yes N = No |
||
EMP-SEC-LVL Element: Sec Lvl | Numeric 1 Contains the employee's security level. |
||
EMP-SEC-LOCATION Element: Sec Location | Alpha 10 Contains the employee's security location. |
||
EMP-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
||
EMP-WORK-SCHED Element: Work Sched | Alpha 10 Contains the employee's work schedule. |
||
EMP-SUPERVISOR-IND Element: Supervisor Ind | Alpha 10 Contains the employee's indirect supervisor. |
||
EMP-ANNUAL-HOURS Element: Annual Hours | Signed 8.4 Contains the employee's annual hours. |
||
EMP-WORK-COUNTY Element: Work County | Alpha 10 Contains the employee's work county. |
||
EMP-WORK-CITY Element: Work City | Alpha 10 Contains the employee's work city. |
||
EMP-WORK-SCHOOL Element: Work School | Alpha 10 Contains the employee's work school. |
||
EMP-WORK-TRANSPORT Element: Work Transport | Alpha 10 Contains the employees work transportation. |
|
|
EMP-TAX-SCHOOL Element: Tax School | Alpha 10 Contains the employee's school tax authority. |
||
EMP-TAX-TRANSPORT Element: Tax Transport | Alpha 10 Contains the employee's tax transportation authority. |
|
|
EMP-FTE-TOTAL Element: Fte Total | Signed 11.6 Contains 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. |
||
EMP-PRO-RATE-TOTAL Element: Pay Rate | Signed 13.4 |
||
EMP-PRO-RATE-A-SAL Element: Pay Rate | Signed 13.4 |
||
EMP-NEW-HIRE-DATE Element: New Hire Date | Numeric 8 (yyyymmdd) |
||
EMP-COMPA-RATIO Element: Compa Ratio | Derived |
|
|
EMP-PENET-RATIO Element: Penet Ratio | Derived |
|
|
EMP-SAL-MTH-RATE Element: Sal Mth Rate | Derived |
|
|
EMP-HOUR-MTH-RATE Element: Hour Mth Rate | Derived |
|
|
EMP-MONTHLY-RATE Element: Monthly Rate | Derived |
|
|
EMP-SAL-BIWK-RATE Element: Sal Biwk Rate | Derived |
|
|
EMP-HRY-BIWK-RATE Element: Hry Biwk Rate | Derived |
|
|
EMP-SAL-SEMI-RATE Element: Sal Semi Rate | Derived |
|
|
EMP-HRY-SEMI-RATE Element: Hry Semi Rate | Derived |
|
|
EMP-SAL-WKLY-RATE Element: Sal Wkly Rate | Derived |
|
|
EMP-HRY-WKLY-RATE Element: Hry Wkly Rate | Derived |
|
|
EMP-WEEKLY-RATE Element: Weekly Rate | Derived |
|
|
EMP-BIWEEKLY-RATE Element: Biweekly Rate | Derived |
|
|
EMP-SEMIMNTH-RATE Element: Semimnth Rate | Derived |
|
|
EMP-EMP-ANN-HRS Element: Emp Annual Hrs | Derived |
|
|
EMP-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the pay currency. |
||
EMP-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
||
EMP-COUNTRY-CODE Element: Country Code | Alpha 2 Contains the country of the employee's home address. |
||
EMP-NAME-PREFIX Element: Name Prefix | Alpha 4 (Lower Case) Contains the prefix (title) of the employee's name. |
||
EMP-NAME-SUFFIX Element: Name Suffix | Alpha 4 (Lower Case) Contains the suffix of the employee's name. |
||
EMP-WORK-COUNTRY Element: Country Code | Alpha 2 Contains the employee's work country. |
||
EMP-LAST-NAME-PRE Element: Last Name Pre | Alpha 30 (Lower Case) Contains the employee's previous last name. |
||
EMP-EST-REMUN Element: Est Remun | Signed 11.2 Used for taxing Canada Commission Payments. |
||
EMP-EST-EXPENSE Element: Est Expense | Signed 11.2 Used for taxing Canada Commission Payments. |
||
EMP-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group. |
||
EMP-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec enterprise number group. |
||
EMP-LAST-PRE Element: Last Pre | Derived |
|
|
EMP-LAST-SUF Element: Last Suf | Derived |
|
|
EMP-LAST-PRE-SUF Element: Last Pre Suf | Derived |
|
|
EMP-FIRST-MI Element: First Mi | Derived |
|
|
EMP-LAST-NAME-EXP Element: Last Name Exp | Derived |
|
|
EMP-FIRST-MI-EXP Element: First Mi Exp | Derived |
|
|
EMP-FULL-NAME Element: Full Name | Derived |
|
|
EMP-SHORT-NAME Element: Short Name | Derived Contains the employee's short name. |
|
|
EMP-LABEL-NAME-1 Element: Label Name 1 | Derived |
|
|
EMP-WC-PROVINCE Element: Wc Province | Alpha 2 Contains the employees province for Canadian Workers Compensation. |
||
EMP-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
||
EMP-RAILROAD-CODE Element: Railroad Code | Numeric 1 0 = Not Railroad Employee 1 = Tier One Employee 2 = Tier Two Employee 3 = Both Tier 1 and Tier 2 |
||
EMP-FST-DAY-WORKED Element: Fst Day Worked | Numeric 8 (yyyymmdd) |
||
EMP-LAST-DAY-PAID Element: Last Day Paid | Numeric 8 (yyyymmdd) |
||
EMP-LAB-DIST-FLAG Element: Lab Dist Flag | Alpha 1 " " = Not Applicable Y = Yes N = No |
||
EMP-ENCUMBER-FLAG Element: Encumber Flag | Alpha 1 " " = Not Applicable Y = Yes N = No |
||
EMP-EFFORT-FLAG Element: Effort Flag | Alpha 1 Flag 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 |
||
EMP-RPT-CURR Element: Rpt Curr | Alpha 5 |
||
EMP-PRMCERT-ID 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. |
||
EMP-SNDCERT-ID 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. |
||
EMP-FRNG-RATE Element: Frng Rate | Signed 12.6 A 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. |
||
EMP-FRNG-ACCT-CAT 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 |
||
EMP-FRNG-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
||
EMP-FRNG-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
||
EMP-DEATH-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
||
EMP-TAX-FILTER Element: Tax Filter | Numeric 1 1 = Locate All 2 = Locate Federal & State Only 3 = Locate Federal Only |
||
EMP-REMOTE Element: Remote | Numeric 1 0 = Not Remote 1 = Remote |
||
EMP-PUB-SEC-RETIRE Element: 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 |
||
EMP-PRMCERT-COMP Element: Company Hr | Numeric 4 |
||
EMP-SNDCERT-COMP Element: Company Hr | Numeric 4 |
||
EMP-ST-STATUS Element: St Status | Numeric 1 |
|
|
EMP-LAST-NAME-UC Element: Last Name Uc | Alpha 30 Employees last name in upper case for efficiency in select by name |
||
EMP-FIRST-NAME-UC Element: First Name Uc | Alpha 15 Employees first name in upper case for efficiency in select by name |
||
EMP-FICA-NBR-LAST4 Element: Fica Nbr Last4 | Alpha 4 This 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. |
||
EMP-EMAIL-PERSONAL Element: Email Address | Alpha 60 (Lower Case) |
||
EMP-UPDATED-BY-LTM Element: Updated By Ltm | Alpha 1 Y = Yes N = No |
|
|
EMP-HICN Element: Hl Claim Nbr | Alpha 11 |
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acct Category | ACACCTCAT |
Required
| ||||||||||||||||||||||||||||||
Activity | ACACTIVITY |
Required
| ||||||||||||||||||||||||||||||
City | PRTAXAUTH |
Required
| ||||||||||||||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
County | PRTAXAUTH |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Department | DEPTCODE |
Required
| ||||||||||||||||||||||||||||||
Emp Status | EMSTATUS |
Required
| ||||||||||||||||||||||||||||||
Empaltname | EMPALTNAME |
Not Required
| ||||||||||||||||||||||||||||||
Empbod | EMPBOD |
Not Required, Delete Cascades
| ||||||||||||||||||||||||||||||
Home Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Indir Supv | HRSUPER |
Required
| ||||||||||||||||||||||||||||||
Job Code | JOBCODE |
Required
| ||||||||||||||||||||||||||||||
Location | PCODES |
Required
| ||||||||||||||||||||||||||||||
Paemployee | PAEMPLOYEE |
Not Required, Delete Cascades
| ||||||||||||||||||||||||||||||
Prmcert Id | EMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Process Level | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Prqcentgrp | PRQCENTGRP |
Required
| ||||||||||||||||||||||||||||||
Resident State | PRSTATE |
Required
| ||||||||||||||||||||||||||||||
Sndcert Id | EMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Supervisor | HRSUPER |
Required
| ||||||||||||||||||||||||||||||
Tax Rpt State | PREMPSTATE |
Not Required
| ||||||||||||||||||||||||||||||
Tax School | PRTAXAUTH |
Not Required
| ||||||||||||||||||||||||||||||
Union | PCODES |
Required
| ||||||||||||||||||||||||||||||
User Level | PCODES |
Required
| ||||||||||||||||||||||||||||||
Wc State | PRSTATE |
Required
| ||||||||||||||||||||||||||||||
Work City | PRTAXAUTH |
Not Required
| ||||||||||||||||||||||||||||||
Work County | PRTAXAUTH |
Not Required
| ||||||||||||||||||||||||||||||
Work Rpt State | PREMPSTATE |
Not Required
| ||||||||||||||||||||||||||||||
Work School | PRTAXAUTH |
Not Required
| ||||||||||||||||||||||||||||||
Work State | PRSTATE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acassign | ACASSIGN |
| ||||||||||||||||||||||||||||||||||||
Ach Deposits | EMACHDEPST |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
All Pos | PAEMPPOS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Alt Pay Rates | PRRATES |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Attend Hist | ATTENDHIST |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Beneficiaries | BENEFICRY |
| ||||||||||||||||||||||||||||||||||||
Benefit | BENEFIT |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Bnben | BNBEN |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Bnchange | BNCHANGE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Bngrpchg | BNGRPCHG |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Bondbenseq | BONDBENSEQ |
| ||||||||||||||||||||||||||||||||||||
Ck Comments | PACOMMENTS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Coda | CODA |
| ||||||||||||||||||||||||||||||||||||
Comphist | COMPHIST |
| ||||||||||||||||||||||||||||||||||||
Correspondence | HRCORRESP |
| ||||||||||||||||||||||||||||||||||||
Cur Err Pro Tr | TIMERECORD |
| ||||||||||||||||||||||||||||||||||||
Current Pos | PAEMPPOS |
| ||||||||||||||||||||||||||||||||||||
Cwchange | CWCHANGE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Deduction | EMDEDMASTR |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Dependent | EMDEPEND |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Emdistmast | EMDISTMAST |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Emp Assignment | CWASSIGN |
| ||||||||||||||||||||||||||||||||||||
Emp Cmchange | CMCHANGE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Emp Cmcontract | CMCONTRACT |
| ||||||||||||||||||||||||||||||||||||
Emp Contract | CWCONTRACT |
| ||||||||||||||||||||||||||||||||||||
Emp Garn | PREMPGARN |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Emp Leave | LPEMPLEAVE |
| ||||||||||||||||||||||||||||||||||||
Emp Trans | EMTATRANS |
| ||||||||||||||||||||||||||||||||||||
Emtamastr | EMTAMASTR |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Err Time Recs | TIMERECORD |
| ||||||||||||||||||||||||||||||||||||
Flex Dollars | EMPFLEXDOL |
| ||||||||||||||||||||||||||||||||||||
Flex Periods | EMPFLEXREM |
| ||||||||||||||||||||||||||||||||||||
Fut Time Recs | TIMERECORD |
| ||||||||||||||||||||||||||||||||||||
Gmeffort | GMEFFORT |
| ||||||||||||||||||||||||||||||||||||
Gmlabdist | GMLABDIST |
| ||||||||||||||||||||||||||||||||||||
Gmretdist | GMRETDIST |
| ||||||||||||||||||||||||||||||||||||
Gmtranefrt | GMTRANEFRT |
| ||||||||||||||||||||||||||||||||||||
Hr Occup Code | HROCCUPCD |
| ||||||||||||||||||||||||||||||||||||
Hrhistory | HRHISTORY |
| ||||||||||||||||||||||||||||||||||||
Job Hist | APPJOBHIST |
| ||||||||||||||||||||||||||||||||||||
Lp Service | TAEMPSERV |
| ||||||||||||||||||||||||||||||||||||
Lptrans | TAEMPTRANS |
| ||||||||||||||||||||||||||||||||||||
Objectives | PAEMPGOAL |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
One Time Ded | ONETMDED |
| ||||||||||||||||||||||||||||||||||||
Open Manuals | PAYMASTR |
| ||||||||||||||||||||||||||||||||||||
Open Payments | PAYMASTR |
| ||||||||||||||||||||||||||||||||||||
Ot Plan Code | PROVERTIME |
| ||||||||||||||||||||||||||||||||||||
Part Benefit | PARTBEN |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Pathfind | PATHFIND |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Paymastr | PAYMASTR |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Payments | PAYMASTR |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Payments2 | PAYMASTR |
| ||||||||||||||||||||||||||||||||||||
Pep Audit | PAPEPAUDIT |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Persacthst | PERSACTHST |
| ||||||||||||||||||||||||||||||||||||
Pgemployee | PGEMPLOYEE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Plan Name | EMTAMASTR |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Pos Chg Error | PAPOSERR |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Position | PAPOSITION |
| ||||||||||||||||||||||||||||||||||||
Pr Distribs | PRDISTRIB |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
Prhours | PRHOURS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Quartded | QUARTDED |
| ||||||||||||||||||||||||||||||||||||
Quartded All | QUARTDED |
| ||||||||||||||||||||||||||||||||||||
Quartwage | QUARTWAGE |
| ||||||||||||||||||||||||||||||||||||
Quartwage All | QUARTWAGE |
| ||||||||||||||||||||||||||||||||||||
Report States | PREMPSTATE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Salary History | PRRATEHIST |
| ||||||||||||||||||||||||||||||||||||
Schedule | PRSAGHEAD |
| ||||||||||||||||||||||||||||||||||||
Standtime | STANDTIME |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Step And Grade | PRSAGDTL |
| ||||||||||||||||||||||||||||||||||||
Super Codes | HRSUPER |
| ||||||||||||||||||||||||||||||||||||
Ta Enroll | TAENROLL |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Ta Group | TAEEGROUP |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Ta Master | TAEEMASTER |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Taloshrs | TALOSHRS |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Timerecord | TIMERECORD |
Delete Restricted
| ||||||||||||||||||||||||||||||||||||
User Fields | HREMPUSF |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
Vesthours | VESTHOURS |
| ||||||||||||||||||||||||||||||||||||
Wages | PRTIME |
| ||||||||||||||||||||||||||||||||||||
Work Sched | HRWRKSCHD |
|
All trademarks and registered trademarks are the property of their
respective owners.