PAEMERGCNT – Employee Emergency Contact

System
Personnel (PA)
Prefix
PAE
Primary key
COMPANY, EMPLOYEE, SEQ-NBR
Fields
27
Updated by
4 programs
Referenced by
8 programs

PAEMERGCNT is the Employee Emergency Contact table in Lawson Personnel (prefix PAE). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (PAESET1). It is related 1:1 to PRSYSTEM, INSTCTRYCD, EMPLOYEE and PAEMPLOYEE and 1:M to PACOMMENTS. It is updated by HR11.1, PA115, PA12.1 and PA512 and referenced by HPAE.1, HR170, HR70.1, HR90.1, HS705, PA212, PA311 and ZH500. The table has 27 fields, 1 index and 5 documented relations.

About PAEMERGCNT

The Employee Emergency Contact file contains emergency contact information for employees.

Fields (27)

Column = COBOL field name without the PAE- 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
#PAE-COMPANY PK
COMPANY		Numeric 4—PA12.1, PA512
#PAE-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number. It is use to correlate all information related to the employee.PA12.1, PA512
#PAE-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains a sequence number that keeps records unique. It is automatically assigned.PA12.1, PA512
#PAE-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the last name of the emergency contact person.PA12.1, PA512
#PAE-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the first name of the emergency contact person.PA12.1, PA512
#PAE-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the middle initial of the emergency contact person.PA12.1, PA512
#PAE-ADDR1
ADDR1		Alpha 30 (Lower Case)Contains the first line of address.PA12.1, PA512
#PAE-ADDR2
ADDR2		Alpha 30 (Lower Case)Contains the second line of the address.PA12.1, PA512
#PAE-ADDR3
ADDR3		Alpha 30 (Lower Case)Contains the third line of address.PA12.1, PA512
#PAE-ADDR4
ADDR4		Alpha 30 (Lower Case)Contains the fourth line of address.PA12.1, PA512
#PAE-CITY
CITY		Alpha 58 (Lower Case)Contains the city of the address.PA12.1, PA512
#PAE-STATE
STATE		Alpha 2Contains the state of the emergency contact's address.PA12.1, PA512
#PAE-ZIP
ZIP		Alpha 10Contains the postal code of the address.PA12.1, PA512
#PAE-RELATIONSHIP
RELATIONSHIP		Alpha 30 (Lower Case)Contains the relationship of the emergency contact person to the employee.PA12.1, PA512
#PAE-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6Contains the prefix of the emergency contact's home telephone number.PA12.1, PA512
#PAE-HM-PHONE-NBR
HM_PHONE_NBR		Alpha 15Contains the emergency contact's home telephone number.PA12.1, PA512
#PAE-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains the prefix of the emergency contact's work telephone number.PA12.1, PA512
#PAE-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the emergency contact's work telephone number.PA12.1, PA512
#PAE-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension of the emergency contact's telephone number.PA12.1, PA512
#PAE-CL-PHONE-CNTRY
CL_PHONE_CNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.PA12.1, PA512
#PAE-CL-PHONE-NBR
CL_PHONE_NBR		Alpha 15Phone number.PA12.1, PA512
#PAE-FULL-NAME
FULL_NAME		Derived——
#PAE-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Contains the country of the address.PA12.1, PA512
#PAE-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA12.1, PA512
#PAE-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA12.1, PA512
#PAE-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA12.1, PA512
#PAE-LABEL-NAME
LABEL_NAME		Derived——

Indexes (1)

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
PAESET1
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NBR
PrimaryHPAE.1, HR11.1, HR170, HR70.1, HR90.1, HS705, ZH500, PA115 +4 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMINSTCTRYCDEMPLOYEEPAEMPLOYEEPACOMMENTSPAEMERGCNT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PAE-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (PAE-COUNTRY-CODE != Spaces)
PAE-COUNTRY-CODE→INT-COUNTRY-CODE
EmployeeEMPLOYEERequired
PAE-COMPANY→EMP-COMPANY
PAE-EMPLOYEE→EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequired
PAE-COMPANY→PEM-COMPANY
PAE-EMPLOYEE→PEM-EMPLOYEE

One to many (1) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTSDelete Cascades
PAE-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"EC"→PAC-CMT-TYPE
PAE-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
PAE-SEQ-NBR→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE

Programs

Updated by (4)

Referenced by (8)