Contains all the employee information needed in the Lawson Payroll system.
The Personnel Employee file stores additional employee information used by the
Lawson Human Resources, Personnel, and Benefits systems. HR11 (Employee) is
the main program that updates this file.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PEM-COMPANY Element: Company Hr | Numeric 4 Contains the number that represents an
established company and is entered on
all functions.
|
|
PEM-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. An
employee number is assigned to each
person employed by the company. The
system uses the employee number to
correlate all information related to the
employee. This number must be valid in
the Employee file.
|
|
PEM-SUPP-ADDR1 Element: Supplemental Address | Alpha 57 (Lower Case) Contains the first line of the
supplemental address.
|
|
PEM-SUPP-ADDR2 Supplemental Address 2 | Alpha 30 (Lower Case) Contains the second line of the
supplemental address.
|
|
PEM-SUPP-ADDR3 Element: Supp Addr3 | Alpha 30 (Lower Case) Contains the third line of the
supplemental address.
|
|
PEM-SUPP-ADDR4 Element: Supp Addr4 | Alpha 30 (Lower Case) Contains the fourth line of the
supplemental address.
|
|
PEM-SUPP-CITY Supplemental Address City | Alpha 58 (Lower Case) Contains the city of the supplemental
address.
|
|
PEM-SUPP-STATE Suppl. Address State/Province | Alpha 2 Contains the state of the supplemental
address.
|
|
PEM-SUPP-ZIP Suppl. Address Postal Code | Alpha 10 Contains the postal code of the
supplemental address.
|
|
PEM-SUPP-CNTRY-CD Element: Supp Cntry Cd | Alpha 2 Contains the country of the
supplemental address.
|
|
PEM-HM-PHONE-CNTRY Element: Hm Phone Cntry | Alpha 6 Contains the country code of the
employee's home telephone number.
|
|
PEM-HM-PHONE-NBR Element: Hm Phone Nbr | Alpha 15 Contains the employee's home telephone
number.
|
|
PEM-WK-PHONE-CNTRY Element: Wk Phone Cntry | Alpha 6 Contains the country code of the
employee's work telephone number.
|
|
PEM-WK-PHONE-NBR Element: Wk Phone Nbr | Alpha 15 Contains the employee's work telephone
number.
|
|
PEM-WK-PHONE-EXT Element: Wk Phone Ext | Alpha 5 Contains the extension of the
employee's work telephone number.
|
|
PEM-EEO-CLASS Element: Eeo Class | Alpha 4 (Lower Case) Contains the employee's ethnic origin.
|
|
PEM-SEX Element: Sex | Alpha 1 Contains the employee's gender.
F = Female M = Male |
|
PEM-HANDICAP-ID Element: Handicap Id | Alpha 1 Indicates if the employee is disabled.
Y = Yes N = No |
|
PEM-COMP-CODE Element: Comp Code | Alpha 4 Contains miscellaneous data.
|
|
PEM-COMP-NBR Element: Comp Nbr | Alpha 10 Contains miscellaneous data.
|
|
PEM-VETERAN Element: Veteran | Alpha 4 Indicates the individual is a veteran.
|
|
PEM-BIRTHDATE Element: Birthdate | Numeric 8 (yyyymmdd) Contains the employee's birth date.
|
|
PEM-BIRTH-CITY Element: Birth Place: City | Alpha 58 (Lower Case) Contains the city where the employee
was born.
|
|
PEM-BIRTH-STATE Birth Place: State/Province | Alpha 2 Contains the two-character abbreviation
of the state where the employee was
born.
|
|
PEM-BIRTH-CNTRY-CD Element: Birth Cntry Cd | Alpha 2 Indicates country where employee was
born.
|
|
PEM-SENIOR-DATE Element: Senior Date | Numeric 8 (yyyymmdd) Contains the employee's seniority date.
|
|
PEM-MAIDEN-LST-NM Element: Maiden Lst Nm | Alpha 30 (Lower Case) Contains the employee's maiden last
name.
|
|
PEM-MAIDEN-FST-NM Element: Maiden Fst Nm | Alpha 15 (Lower Case) Contains the employee's maiden first
name.
|
|
PEM-MAIDEN-MI Maiden Name Middle Initial | Alpha 1 Contains the employee's maiden middle
initial.
|
|
PEM-FORMER-LST-NM Element: Former Lst Nm | Alpha 30 (Lower Case) Contains the employee's former last
name.
|
|
PEM-FORMER-FST-NM Element: Former Fst Nm | Alpha 15 (Lower Case) Contains the employee's former first
name.
|
|
PEM-FORMER-MI Former Name Middle Initial | Alpha 1 Contains the employee's former middle
initial.
|
|
PEM-LOCAT-CODE Element: Locat Code | Alpha 10 Contains a user-defined location code
that identifies where the employee
works. The Human Resource Code file
validates this field.
|
|
PEM-HIRE-SOURCE Element: Hire Source | Alpha 10 Contains a user-defined hire source
code that identifies the source from
which the employee was acquired. This
field is validated in the Human Resource
Code file.
|
|
PEM-SECURITY-CODE Element: Security Code | Alpha 10 Contains a user-defined badge code
assigned to the employee. This field is
not associated with Lawson user
security.
|
|
PEM-SECURITY-NBR Element: Security Nbr | Alpha 10 Contains an internal security number
that is assigned to the employee. This
field is not associated with Lawson user
security.
|
|
PEM-BARGAIN-UNIT Element: Bargain Unit | Alpha 10 Contains a user-defined code that
represents the employee's union
bargaining unit.
|
|
PEM-CLOCK-NBR Element: Clock Nbr | Alpha 10 Contains the employee's clock number.
|
|
PEM-MAIL-GROUP Element: Mail Group | Alpha 10 Contains a user-defined code that
identifies the mail group to which an
employee belongs.
|
|
PEM-MB-NBR Element: Mb Nbr | Alpha 10 Contains the employee's mail box number.
|
|
PEM-DRAFT-STATUS Element: Draft Status | Alpha 3 Contains a user-defined code that
identifies the employee's draft status.
|
|
PEM-FINAL-RANK Element: Final Rank | Alpha 3 Identifies the highest military rank
attained by the employee.
|
|
PEM-CUR-STATUS Element: Cur Status | Alpha 2 Indicates if the employee is currently
in the Reserves or National Guard.
NG = National Guard RE = Reserves |
|
PEM-LAST-PHYSICAL Element: Last Physical | Numeric 8 (yyyymmdd) Contains the date of the employee's
last physical exam.
|
|
PEM-PHY-SCHD Element: Phy Schd | Alpha 2 Contains the frequency of the
employee's physical examinations.
2Y = 2 years 3Y = 3 years 4Y = 4 years 5Y = 5 years 6Y = 6 years 7Y = 7 years 8Y = 8 years 9Y = 9 years AN = Annual MO = Monthly QT = Quarterly SA = Semi-annual |
|
PEM-NEXT-PHYSICAL Element: Next Physical | Numeric 8 (yyyymmdd) Contains the date of the employee's
next scheduled physical exam.
|
|
PEM-HEIGHT-FT Element: Height Ft | Numeric 2 Contains the employee's height in feet.
|
|
PEM-HEIGHT-IN Element: Height In | Numeric 2 Contains the employee's height in
inches.
01 11 |
|
PEM-WGHT Element: Wght | Signed 5.2 Contains the employee's weight.
|
|
PEM-BLOOD-TYPE Element: Blood Type | Alpha 3 Contains the employee's blood type.
A+ A- AB+ AB- B+ B- O+ O- |
|
PEM-PARKING-LOT Element: Parking Lot | Alpha 10 Contains a user-defined code that
represents the employee's assigned
parking lot.
|
|
PEM-PARKING-SPACE Element: Parking Space | Alpha 10 Identifies the parking space assigned
to the employee.
|
|
PEM-DR-LICENSE Element: Dr License | Alpha 20 Contains the employee's driver's
license number.
|
|
PEM-DR-LIC-ST Element: Dr Lic St | Alpha 2 Contains the abbreviation of the state
that issued the employee's driver's
license.
|
|
PEM-EXP-DATE Element: Expiration | Numeric 8 (yyyymmdd) Contains the expiration date of the
employee's driver's license.
|
|
PEM-DR-LIC-CLASS Element: Dr Lic Class | Alpha 3 Contains the class of the employee's
driver's license.
|
|
PEM-REV-SCHEDULE Element: Rev Schedule | Alpha 2 Identifies the frequency of performance
reviews for the employee.
AN = Annual MO = Monthly QT = Quarterly SA = Semi-annual |
|
PEM-NEXT-REVIEW Element: Next Review | Numeric 8 (yyyymmdd) Contains the next scheduled performance
review date for the employee.
|
|
PEM-NEXT-REV-CODE Element: Next Rev Code | Alpha 10 Identifies the review type for the next
scheduled review date (for example,
salary review).
|
|
PEM-LAST-REVIEW Element: Last Review | Numeric 8 (yyyymmdd) Contains the date of the employee's
last review.
|
|
PEM-LAST-MIL-SEQ Element: Last Mil Seq | Numeric 4 Contains the last sequence number used
to store a military record.
|
|
PEM-LAST-REV-SEQ Element: Last Rev Seq | Numeric 4 Contains the last sequence number used
to store a review record.
|
|
PEM-LAST-COM-SEQ Element: Last Com Seq | Numeric 4 Contains the last sequence number used
to store a comment record.
|
|
PEM-LAST-INT-SEQ Element: Last Int Seq | Numeric 4 Contains the last sequence number used
to store an interview record.
|
|
PEM-LAST-BNF-SEQ Element: Last Bnf Seq | Numeric 4 Contains the last sequence number used
to store a beneficiary record.
|
|
PEM-LAST-INV-NBR Element: Last Inv Nbr | Numeric 4 Contains the last sequence number used
to store an invoice record.
|
|
PEM-LAST-EPC-SEQ Element: Last Epc Seq | Numeric 4 Contains the last sequence number used
to store HR codes for an employee.
|
|
PEM-FNCTN-GROUP Element: Fnctn Group | Numeric 2 Identifies for the EEO-4 report, the
type of work the employee does.
01 15 |
|
PEM-EXCLUDE-FLAG Element: Exclude Flag | Alpha 1 Determines if an employee is included
in the EEO-4 report.
N = Include on EEO-4 Report Y = Exclude from EEO-4 Report |
|
PEM-NBR-HL-DEP Element: Health Dependents | Numeric 3 Contains the number of dependents
covered by the employee's health
insurance.
|
|
PEM-NBR-DN-DEP Element: Dental Dependents | Numeric 3 Contains the number of dependents
covered by the employee's dental
insurance.
|
|
PEM-LIFE-STYLE-CR Element: Life Style Cr | Numeric 2 Contains the number of credits given
for a healthy lifestyle. This is used to
calculate flex credits.
|
|
PEM-HL-COV-PROOF Element: Spouse Health Plan | Alpha 1 Indicates if there is proof that the
employee is covered by health insurance
outside the company.
N = No Y = Yes |
|
PEM-DN-COV-PROOF Element: Spouse Dental Plan | Alpha 1 Indicates if there is proof that the
employee is covered by dental insurance
outside the company.
N = No Y = Yes |
|
PEM-HL-VERIFY-DT Spouse Health Plan Verify Date | Numeric 8 (yyyymmdd) Contains the date outside health
coverage was verified.
|
|
PEM-DN-VERIFY-DT Spouse Dental Plan Verify Date | Numeric 8 (yyyymmdd) Contains the date outside dental
coverage was verified.
|
|
PEM-SPOUSE-EMP Element: Spouse Emp | Alpha 30 (Lower Case) Contains the name of the employee's
spouse's employer.
|
|
PEM-SP-EMP-ADDR1 Spouse Employer Address 1 | Alpha 30 (Lower Case) Contains the first line of the spouse's
employer's address.
|
|
PEM-SP-EMP-ADDR2 Spouse Employer Address 2 | Alpha 30 (Lower Case) Contains the second line of the
spouse's employer's address.
|
|
PEM-SP-EMP-ADDR3 Element: Sp Emp Addr3 | Alpha 30 (Lower Case) Contains the third line of the spouse's
employer's address.
|
|
PEM-SP-EMP-ADDR4 Element: Sp Emp Addr4 | Alpha 30 (Lower Case) Contains the fourth line of the
spouse's employer's address.
|
|
PEM-SP-EMP-CITY Element: Spouse Employer City | Alpha 58 (Lower Case) Contains the city of the spouse's
employer's address.
|
|
PEM-SP-EMP-STATE Spouse Employer State/Province | Alpha 2 Contains the state of the spouse's
employer's address.
|
|
PEM-SP-EMP-ZIP Spouse Employer Postal Code | Alpha 10 Contains the postal code of the
spouse's employer's address.
|
|
PEM-SP-EMP-COUNTRY Element: Sp Emp Country | Alpha 2 Contains country of spouse's employer's
address.
|
|
PEM-SP-EMP-PH-CNTR Element: Sp Emp Ph Cntr | Alpha 6 Contains the country code of the
spouse's employer's telephone number.
|
|
PEM-SP-EMP-PH-NBR Element: Sp Emp Ph Nbr | Alpha 15 Contains the spouse's employer's
telephone number.
|
|
PEM-OWNER-FLAG Element: Owner | Alpha 1 Identifies owners of the company.
N = No Y = Yes |
|
PEM-KEY-EMP-FLAG Element: Key Employee | Alpha 1 Identifies key employees of the
company.
N = No Y = Yes |
|
PEM-OFFICER Element: Officer | Alpha 1 Identifies officers of the company.
N = No Y = Yes |
|
PEM-HIGH-COMP Element: Highly Compensated | Alpha 1 Identifies highly compensated employees
for non-discrimination testing in the
Lawson Benefits System.
N = No Y = Yes |
|
PEM-SMOKER Element: Smoker | Alpha 1 Indicates if an employee is a smoker.
The Lawson Benefits system uses this
information when calculating employee
life and disability insurance premiums.
N = No Y = Yes |
|
PEM-I9-STATUS Element: I9 Status | Alpha 10 Identifies the employee's immigration
status.
|
|
PEM-I9-ALIEN-NBR Element: I9 Alien Nbr | Alpha 11 Contains the employee's alien number.
|
|
PEM-I9-ADMIT-NBR Element: I9 Admit Nbr | Alpha 13 Contains the employee's admission
number.
|
|
PEM-I9-STA-EXP-DT Element: I9 Sta Exp Dt | Numeric 8 (yyyymmdd) Contains the expiration date of the
employee's work authorization status.
|
|
PEM-I9-DOC-NBR Element: I9 Doc Nbr | Alpha 20 Occurs 2 Times Contains the document identification
number.
|
|
PEM-I9-DOC-TYPE Element: I9 Doc Type | Alpha 10 Occurs 2 Times Identifies the type of document entered.
|
|
PEM-I9-DOC-EXP-DT Element: I9 Doc Exp Dt | Numeric 8 (yyyymmdd) Occurs 2 Times Contains the expiration date of the
document.
|
|
PEM-I9-AUTHORIZE Element: I9 Authorize | Alpha 30 (Lower Case) Identifies the person who examined the
evidence or documents establishing the
employee's identity and employment
eligibility.
|
|
PEM-TRUE-MAR-STAT Element: True Mar Stat | Alpha 1 Contains the employee's true marital
status.
D = Divorced M = Married S = Single W = Widowed L = Legally Separated O = Significant Other P = Domestic Partner C = Common Law R = Separated U = Unmarried |
|
PEM-LAST-PAE-SEQ Element: Last Pae Seq | Numeric 4 Contains the last number used to store
an emergency contact record for the
employee.
|
|
PEM-PRIMARY-CARE Element: Primary Care | Alpha 10 Contains the code that represents the
employee's primary care physician.
|
|
PEM-FAMILY-AGG Element: Family Agg | Numeric 9 Contains the number of the employee
defined as the family aggregate
employee.
|
|
PEM-BEN-SALARY-1 Element: Benefit Salary | Signed 11.2 Contains optional user-defined benefit
salary information.
|
|
PEM-BEN-SALARY-2 Element: Benefit Salary | Signed 11.2 Contains optional user-defined benefit
salary information.
|
|
PEM-BEN-SALARY-3 Element: Benefit Salary | Signed 11.2 Contains optional user-defined benefit
salary information.
|
|
PEM-BEN-SALARY-4 Element: Benefit Salary | Signed 11.2 Contains optional user-defined benefit
salary information.
|
|
PEM-BEN-SALARY-5 Element: Benefit Salary | Signed 11.2 Contains optional user-defined benefit
salary information.
|
|
PEM-BEN-DATE-1 Element: Ben Date 1 | Numeric 8 (yyyymmdd) Contains an optional user-defined
benefit date.
|
|
PEM-BEN-DATE-2 Element: Ben Date 2 | Numeric 8 (yyyymmdd) Contains an optional user-defined
benefit date.
|
|
PEM-BEN-DATE-3 Element: Ben Date 3 | Numeric 8 (yyyymmdd) Contains an optional user-defined
benefit date.
|
|
PEM-BEN-DATE-4 Element: Ben Date 4 | Numeric 8 (yyyymmdd) Contains an optional user-defined
benefit date.
|
|
PEM-BEN-DATE-5 Element: Ben Date 5 | Numeric 8 (yyyymmdd) Contains an optional user-defined
benefit date.
|
|
PEM-SEC-LVL Element: Sec Lvl | Numeric 1 Contains the employee's security level.
|
|
PEM-SEC-LOCATION Element: Sec Location | Alpha 10 Contains the employee's security
location.
|
|
PEM-CUR-AGE Element: Cur Age | Derived
|
|
PEM-SEX-1 Element: Sex 1 | Derived
|
|
PEM-EEO-CLASS-1 Element: Eeo Class 1 | Derived
|
|
PEM-WORK-ZIP Element: Work Zip | Alpha 10 Contains the employee's work postal
code.
|
|
PEM-HEIGHT-UNIT Element: Height Unit | Alpha 1 Contains unit in which height is
recorded.
1 = Feet 2 = Meters |
|
PEM-WGHT-UNIT Element: Wght Unit | Alpha 1 Contains unit in which the employee's
weight is recorded.
1 = Pounds 2 = Stones 3 = Kilograms |
|
PEM-LANGUAGE-CODE Element: Language Code | Alpha 10 Contains employee's language if other
than company's primary language.
|
|
PEM-RELIGION Element: Religion | Alpha 10 Contains employee's religion.
|
|
PEM-DISABILITY Element: Disability | Alpha 10 Contains type of disability.
|
|
PEM-SUPP-PHONE-CNT Element: Supp Phone Cnt | Alpha 6 Contains phone country of supplemental
phone number.
|
|
PEM-SUPP-PHONE-NBR Element: Supp Phone Nbr | Alpha 15 Contains supplemental phone number.
|
|
PEM-CONSENT Element: Consent | Alpha 1
N = No Y = Yes " " = No |
|
PEM-ABORIGINAL Element: Aboriginal | Alpha 1 Designates if an employee is Aboriginal.
N = No Y = Yes |
|
PEM-VISIBLE-MIN Element: Visible Min | Alpha 1 Designates if an employee is a visible
minority.
N = No Y = Yes |
|
PEM-RELATED-EMP Element: Related Emp | Alpha 1 Determines whether or not an employee is
related to the employer.
N = No Y = Yes |
|
PEM-I9-DOC-DESCR Element: I9 Doc Descr | Alpha 10 Occurs 2 Times
|
|
PEM-BILINGUAL Element: Bilingual | Alpha 1
N = No Y = Yes |
|
PEM-SUPP-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address.
|
|
PEM-STOCK-TRADE Element: Stock Trade | Alpha 1
" " = Not applicable 1 = Insider 2 = SEC Restricted 3 = Insider & SEC Restricted |
|
PEM-DATE-ASSIGN Element: Date Assign | Numeric 8 (yyyymmdd)
|
|
PEM-USER-AMOUNT Element: User Amount | Signed 13.4
|
|
PEM-ESTAB-PATIENT Element: Estab Patient | Numeric 1
1 = No 2 = Yes 3 = Unknown |
|
PEM-PRIOR-COV-MO Element: Prior Cov Mo | Numeric 2
|
|
PEM-MEDICARE-IND Element: Medicare Ind | Alpha 1
A = Medicare Part A B = Medicare Part B C = Medicare Part A and B D = Medicare Part Unknown E = No Medicare |
|
PEM-TAX-FREQUENCY Element: Tax Freq Over | Numeric 3
|
|
PEM-EMPLOYEE-TYPE Element: Employee Type | Numeric 4
|
|
PEM-SURVEY-DATE Element: Date Stamp | Numeric 8 (yyyymmdd)
|
|
PEM-UPDATED-BY-LTM Element: Updated By Ltm | Alpha 1
Y = Yes N = No |
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Accomodation |
PAMEDICAL |
Delete Restricted
PEM-COMPANY | -> | PMD-COMPANY |
PEM-EMPLOYEE | -> | PMD-EMPLOYEE |
"AC" | -> | PMD-TYPE |
| | PMD-CODE |
| | PMD-SEQ-NBR |
|
Applicant |
APPLICANT |
PEM-COMPANY | -> | APL-COMPANY |
PEM-EMPLOYEE | -> | APL-EMPLOYEE |
| | APL-APPLICANT |
|
Automobiles |
EMPAUTO |
Delete Cascades
PEM-COMPANY | -> | EAT-COMPANY |
PEM-EMPLOYEE | -> | EAT-EMPLOYEE |
| | EAT-AUTO-NBR |
|
Bn Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"BN" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Bnempexer |
BNEMPEXER |
PEM-COMPANY | -> | BXR-COMPANY |
PEM-EMPLOYEE | -> | BXR-EMPLOYEE |
| | BXR-OPT-GRANT-NBR |
| | BXR-STOCK-CTF |
| | BXR-EXERCISE-DATE |
| | BXR-SEQ-NBR |
|
Ce Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"CE" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Certifications |
EMPCODES |
Delete Cascades
PEM-COMPANY | -> | EPC-COMPANY |
"CE" | -> | EPC-TYPE |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Co Property |
EMPCODES |
PEM-COMPANY | -> | EPC-COMPANY |
"CP" | -> | EPC-TYPE |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Competency |
EMPCODES |
Delete Cascades
PEM-COMPANY | -> | EPC-COMPANY |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-TYPE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Contract |
EMPCODES |
Delete Cascades
PEM-COMPANY | -> | EPC-COMPANY |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
"CN" | -> | EPC-TYPE |
| | EPC-CODE |
| | EPC-DATE-ACQUIRED |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Correspondence |
HRCORRESP |
PEM-COMPANY | -> | HCP-COMPANY |
"1" | -> | HCP-REQ-TYPE |
PEM-EMPLOYEE | -> | HCP-ID-NBR |
| | HCP-DEPENDENT |
| | HCP-SEQ-NBR |
|
Cp Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"CP" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Dependents |
EMDEPEND |
Delete Restricted
PEM-COMPANY | -> | EMD-COMPANY |
PEM-EMPLOYEE | -> | EMD-EMPLOYEE |
| | EMD-SEQ-NBR |
|
Dis Action Stp |
PAGRDISTEP |
PEM-COMPANY | -> | PGI-COMPANY |
PEM-EMPLOYEE | -> | PGI-EMPLOYEE |
"2" | -> | PGI-TYPE |
| | PGI-GRIEV-DIS-NBR |
| | PGI-EFFECT-DATE |
| | PGI-SEQ-NBR |
|
Discpl Actions |
PAGRDI |
PEM-COMPANY | -> | PAG-COMPANY |
PEM-EMPLOYEE | -> | PAG-EMPLOYEE |
"2" | -> | PAG-TYPE |
| | PAG-DATE |
| | PAG-GRIEV-DIS-NBR |
|
Dp Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"DP" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Ec Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"EC" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Ed Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"ED" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Education |
EMPCODES |
Delete Cascades
PEM-COMPANY | -> | EPC-COMPANY |
"ED" | -> | EPC-TYPE |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Emerg Contact |
PAEMERGCNT |
Delete Restricted
PEM-COMPANY | -> | PAE-COMPANY |
PEM-EMPLOYEE | -> | PAE-EMPLOYEE |
| | PAE-SEQ-NBR |
|
Ge Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"GE" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Gri Dis Act St |
PAGRDISTEP |
PEM-COMPANY | -> | PGI-COMPANY |
PEM-EMPLOYEE | -> | PGI-EMPLOYEE |
"2" | -> | PGI-TYPE |
| | PGI-GRIEV-DIS-NBR |
| | PGI-EFFECT-DATE |
| | PGI-SEQ-NBR |
|
Griev Dis Act |
PAGRDI |
PEM-COMPANY | -> | PAG-COMPANY |
PEM-EMPLOYEE | -> | PAG-EMPLOYEE |
| | PAG-TYPE |
| | PAG-DATE |
| | PAG-GRIEV-DIS-NBR |
|
Griev Steps |
PAGRDISTEP |
PEM-COMPANY | -> | PGI-COMPANY |
PEM-EMPLOYEE | -> | PGI-EMPLOYEE |
"1" | -> | PGI-TYPE |
| | PGI-GRIEV-DIS-NBR |
| | PGI-EFFECT-DATE |
| | PGI-SEQ-NBR |
|
Grievances |
PAGRDI |
PEM-COMPANY | -> | PAG-COMPANY |
PEM-EMPLOYEE | -> | PAG-EMPLOYEE |
"1" | -> | PAG-TYPE |
| | PAG-DATE |
| | PAG-GRIEV-DIS-NBR |
|
Hist Err |
HISTERR |
Delete Cascades
PEM-COMPANY | -> | HER-COMPANY |
PEM-EMPLOYEE | -> | HER-EMPLOYEE |
| | HER-OBJ-ID |
| | HER-EFFECT-DATE |
| | HER-ACTION-CODE |
| | HER-ACTION-NBR |
| | HER-FLD-NBR |
| | HER-SEQ-NBR |
|
Hr Cont Nbr |
HRCONTNBR |
PEM-COMPANY | -> | HCN-COMPANY |
"1" | -> | HCN-REQ-TYPE |
PEM-EMPLOYEE | -> | HCN-ID-NBR |
Zeroes | -> | HCN-DEPENDENT |
| | HCN-SEQ-NBR |
|
Incid Followup |
PAFOLLOWUP |
Delete Cascades
PEM-COMPANY | -> | PAF-COMPANY |
PEM-EMPLOYEE | -> | PAF-EMPLOYEE |
| | PAF-ESTABLISHMENT |
| | PAF-INCIDENT-NBR |
| | PAF-EFFECT-DATE |
| | PAF-SEQ-NBR |
|
Incident Costs |
PAINCICOST |
Delete Cascades
PEM-COMPANY | -> | PAI-COMPANY |
PEM-EMPLOYEE | -> | PAI-EMPLOYEE |
| | PAI-ESTABLISHMENT |
| | PAI-INCIDENT-NBR |
| | PAI-EFFECT-DATE |
| | PAI-SEQ-NBR |
|
Interviews |
INTERVIEW |
Delete Cascades
PEM-COMPANY | -> | ITV-COMPANY |
Zeroes | -> | ITV-EMP-APP |
PEM-EMPLOYEE | -> | ITV-APPLICANT |
| | ITV-SEQ-NBR |
|
Iv Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"IV" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Job Hist |
APPJOBHIST |
PEM-COMPANY | -> | AJH-COMPANY |
PEM-EMPLOYEE | -> | AJH-EMPLOYEE |
| | AJH-SEQ-NBR |
| | AJH-APPLICANT |
|
Job Interest |
PAJOBINTRS |
Delete Cascades
PEM-COMPANY | -> | PJI-COMPANY |
Zeroes | -> | PJI-EMP-APP |
PEM-EMPLOYEE | -> | PJI-EMPLOYEE |
| | PJI-JOB-CODE |
| | PJI-POSITION |
|
Jobauth |
JOBAUTH |
Delete Cascades
PEM-COMPANY | -> | JBA-COMPANY |
Zeroes | -> | JBA-EMP-APP |
PEM-EMPLOYEE | -> | JBA-EMPLOYEE |
| | JBA-JOB-CODE |
| | JBA-POSITION |
|
Md Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"MD" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Medical Codes |
PAMEDICAL |
Delete Restricted
PEM-COMPANY | -> | PMD-COMPANY |
PEM-EMPLOYEE | -> | PMD-EMPLOYEE |
"EM" | -> | PMD-TYPE |
| | PMD-CODE |
| | PMD-SEQ-NBR |
|
Mi Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"MI" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Military |
MILITARY |
Delete Cascades
PEM-COMPANY | -> | MIL-COMPANY |
Zeroes | -> | MIL-EMP-APP |
PEM-EMPLOYEE | -> | MIL-EMPLOYEE |
| | MIL-BR-SERVICE |
| | MIL-SEQ-NBR |
|
Off Lang |
PAOFFLANG |
PEM-COMPANY | -> | PLA-COMPANY |
PEM-EMPLOYEE | -> | PLA-EMPLOYEE |
Spaces | -> | PLA-POSITION |
| | PLA-REPORT-TYPE |
| | PLA-SEQ-NBR |
|
Os Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"OS" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Osha |
OSHA |
Delete Cascades
PEM-COMPANY | -> | OSH-COMPANY |
PEM-EMPLOYEE | -> | OSH-EMPLOYEE |
| | OSH-ESTABLISHMENT |
| | OSH-SEQ-NBR |
|
Pa Benefits |
EMPCODES |
Delete Cascades
PEM-COMPANY | -> | EPC-COMPANY |
"BN" | -> | EPC-TYPE |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Pa Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"PA" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
| | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Paencumber |
PAENCUMBER |
Delete Restricted
PEM-COMPANY | -> | PEN-COMPANY |
PEM-EMPLOYEE | -> | PEN-EMPLOYEE |
| | PEN-POSITION |
| | PEN-PROCESS-LEVEL |
| | PEN-DEPARTMENT |
| | PEN-JOB-CODE |
| | PEN-GLT-OBJ-ID |
| | PEN-ATN-OBJ-ID |
|
Painstruct |
PAINSTRUCT |
PEM-COMPANY | -> | INS-COMPANY |
PEM-EMPLOYEE | -> | INS-EMPLOYEE |
| | INS-LAST-NAME |
| | INS-FIRST-NAME |
| | INS-MIDDLE-INIT |
| | INS-INSTRUCT |
|
Pending Action |
PERSACTION |
PEM-COMPANY | -> | PCT-COMPANY |
PEM-EMPLOYEE | -> | PCT-EMPLOYEE |
| | PCT-ACTION-TYPE |
| | PCT-ACTION-CODE |
| | PCT-EFFECT-DATE |
| | PCT-ACTION-NBR |
|
Race |
PAEEEORACE |
PEM-COMPANY | -> | EER-COMPANY |
PEM-EMPLOYEE | -> | EER-EMPLOYEE |
| | EER-RACE |
|
Registrations |
PAREGISTER |
PEM-COMPANY | -> | REG-COMPANY |
PEM-EMPLOYEE | -> | REG-EMPLOYEE |
| | REG-COURSE |
| | REG-SESSION |
| | REG-START-DATE |
|
Relocation |
EMPCODES |
PEM-COMPANY | -> | EPC-COMPANY |
"RL" | -> | EPC-TYPE |
Zeroes | -> | EPC-EMP-APP |
PEM-EMPLOYEE | -> | EPC-EMPLOYEE |
| | EPC-CODE |
| | EPC-SUBJECT |
| | EPC-SEQ-NBR |
|
Requisitions |
PAREQAPP |
Delete Cascades
PEM-COMPANY | -> | PRA-COMPANY |
Zeroes | -> | PRA-EMP-APP |
PEM-EMPLOYEE | -> | PRA-APPLICANT |
| | PRA-REQUISITION |
|
Reviews |
REVIEW |
Delete Cascades
PEM-COMPANY | -> | REV-COMPANY |
PEM-EMPLOYEE | -> | REV-EMPLOYEE |
| | REV-SCHED-DATE |
| | REV-CODE |
| | REV-SEQ-NBR |
|
Rl Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"RL" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Rv Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"RV" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
| | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Sk Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"SK" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Stockgrnt |
BNEMPGRNT |
PEM-COMPANY | -> | BEG-COMPANY |
PEM-EMPLOYEE | -> | BEG-EMPLOYEE |
| | BEG-OPT-GRANT-NBR |
| | BEG-STOCK-CTF |
|
Test Exception |
PATESTOVER |
PEM-COMPANY | -> | PAV-COMPANY |
PEM-EMPLOYEE | -> | PAV-EMPLOYEE |
| | PAV-TEST |
|
Tracks |
PAEMPTRACK |
Delete Cascades
PEM-COMPANY | -> | ETR-COMPANY |
PEM-EMPLOYEE | -> | ETR-EMPLOYEE |
| | ETR-TYPE |
| | ETR-TRACK |
|
Train Costs |
PAEMPCOSTS |
Delete Cascades
PEM-COMPANY | -> | EMC-COMPANY |
PEM-EMPLOYEE | -> | EMC-EMPLOYEE |
| | EMC-COURSE |
| | EMC-DATE |
| | EMC-COST-TYPE |
| | EMC-COST-CAT |
|
Training |
PATRNHIST |
Delete Cascades
PEM-COMPANY | -> | TRH-COMPANY |
PEM-EMPLOYEE | -> | TRH-EMPLOYEE |
| | TRH-COURSE |
| | TRH-DATE-COMPLETED |
|
Training Dates |
PATRNHIST |
PEM-COMPANY | -> | TRH-COMPANY |
PEM-EMPLOYEE | -> | TRH-EMPLOYEE |
| | TRH-DATE-COMPLETED |
| | TRH-COURSE |
|
Tv Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"TV" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|
Visas |
EMPVISA |
Delete Cascades
PEM-COMPANY | -> | EMV-COMPANY |
PEM-EMPLOYEE | -> | EMV-EMPLOYEE |
| | EMV-DEPENDENT |
| | EMV-SEQ-NBR |
|
Work Restrict |
PAMEDICAL |
Delete Restricted
PEM-COMPANY | -> | PMD-COMPANY |
PEM-EMPLOYEE | -> | PMD-EMPLOYEE |
"WR" | -> | PMD-TYPE |
| | PMD-CODE |
| | PMD-SEQ-NBR |
|
Wr Comments |
PACOMMENTS |
Delete Cascades
PEM-COMPANY | -> | PAC-COMPANY |
Zeroes | -> | PAC-EMP-APP |
"WR" | -> | PAC-CMT-TYPE |
PEM-EMPLOYEE | -> | PAC-EMPLOYEE |
Spaces | -> | PAC-JOB-CODE |
Spaces | -> | PAC-ACTION-CODE |
Zeroes | -> | PAC-LN-NBR |
| | PAC-SEQ-NBR |
| | PAC-DATE |
|