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.

Field / column	Type	Description & values	Updated by
`PAE-COMPANY` PK COMPANY	Numeric 4	—	PA12.1, PA512
`PAE-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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 4	Contains 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 1	Contains 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 2	Contains the state of the emergency contact's address.	PA12.1, PA512
`PAE-ZIP` ZIP	Alpha 10	Contains 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 6	Contains the prefix of the emergency contact's home telephone number.	PA12.1, PA512
`PAE-HM-PHONE-NBR` HM_PHONE_NBR	Alpha 15	Contains the emergency contact's home telephone number.	PA12.1, PA512
`PAE-WK-PHONE-CNTRY` WK_PHONE_CNTRY	Alpha 6	Contains the prefix of the emergency contact's work telephone number.	PA12.1, PA512
`PAE-WK-PHONE-NBR` WK_PHONE_NBR	Alpha 15	Contains the emergency contact's work telephone number.	PA12.1, PA512
`PAE-WK-PHONE-EXT` WK_PHONE_EXT	Alpha 5	Contains the extension of the emergency contact's telephone number.	PA12.1, PA512
`PAE-CL-PHONE-CNTRY` CL_PHONE_CNTRY	Alpha 6	This 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 15	Phone number.	PA12.1, PA512
`PAE-FULL-NAME` FULL_NAME	Derived	—	—
`PAE-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	Contains 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PAESET1`	`COMPANY`, `EMPLOYEE`, `SEQ-NBR`	Primary		HPAE.1, HR11.1, HR170, HR70.1, HR90.1, HS705, ZH500, PA115 +4 more

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PAE-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Country	INSTCTRYCD	Required	When (PAE-COUNTRY-CODE != Spaces)	`PAE-COUNTRY-CODE` → `INT-COUNTRY-CODE`
Employee	EMPLOYEE	Required		`PAE-COMPANY` → `EMP-COMPANY`, `PAE-EMPLOYEE` → `EMP-EMPLOYEE`
Pa Employee	PAEMPLOYEE	Required		`PAE-COMPANY` → `PEM-COMPANY`, `PAE-EMPLOYEE` → `PEM-EMPLOYEE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Comments	PACOMMENTS	Delete 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)

HR11.1 Employee
PA115 Employee Purge
PA12.1 Emergency Contact
PA512 Emergency Contact Conversion

Referenced by (8)

HPAE.1 Contact Selection Invoke
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
HR90.1 Comments
HS705 Emp Work Force Mgmt Extract
PA212 Emergency Contact Listing
PA311 Employee Profile
ZH500 Employee Data Extract