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 30 (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 18 (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 18 (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 18 (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 |
|
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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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 |
|
