PAEMERGCNT FILE
Employee Emergency Contact
The Employee Emergency Contact file contains emergency contact information
for employees.
REFERENCED BY
HPAE.1 HR170 HR650 HR70.1 HR90.1 PA212
PA311
UPDATED BY
PA12.1 PA512 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAE-COMPANY Numeric 4 PA12.1 PA512
Company The company number represents an
established company and is entered on
all function codes.
PAE-EMPLOYEE Numeric 9 PA12.1 PA512
Employee Contains the employee's number. It is
use to correlate all information related
to the employee.
PAE-SEQ-NBR Numeric 4 PA12.1 PA512
Sequence Number Contains a sequence number that keeps
records unique. It is automatically
assigned.
PAE-LAST-NAME Alpha 30 (Lower Case) PA12.1 PA512
Last Name Contains the last name of the emergency
contact person.
PAE-FIRST-NAME Alpha 15 (Lower Case) PA12.1 PA512
First Name Contains the first name of the
emergency contact person.
PAE-MIDDLE-INIT Alpha 1 PA12.1 PA512
Middle Initial Contains the middle initial of the
emergency contact person.
PAE-ADDR1 Alpha 30 (Lower Case) PA12.1 PA512
Address 1 Contains the first line of address.
PAE-ADDR2 Alpha 30 (Lower Case) PA12.1 PA512
Address 2 Contains the second line of the address.
PAE-ADDR3 Alpha 30 (Lower Case) PA12.1 PA512
Address 3 Contains the third line of address.
PAE-ADDR4 Alpha 30 (Lower Case) PA12.1 PA512
Address 4 Contains the fourth line of address.
PAE-CITY Alpha 18 (Lower Case) PA12.1 PA512
City Contains the city of the address.
PAE-STATE Alpha 2 PA12.1 PA512
State or Province Contains the state of the emergency
contact's address.
PAE-ZIP Alpha 10 PA12.1 PA512
Postal Code Contains the postal code of the address.
PAE-RELATIONSHIP Alpha 30 (Lower Case) PA12.1 PA512
Relationship Contains the relationship of the
emergency contact person to the
employee.
PAE-HM-PHONE-CNTRY Alpha 6 PA12.1 PA512
Hm Phone Cntry Contains the prefix of the emergency
contact's home telephone number.
PAE-HM-PHONE-NBR Alpha 15 PA12.1 PA512
Hm Phone Nbr Contains the emergency contact's home
telephone number.
PAE-WK-PHONE-CNTRY Alpha 6 PA12.1 PA512
Work Telephone Contains the prefix of the emergency
Country contact's work telephone number.
PAE-WK-PHONE-NBR Alpha 15 PA12.1 PA512
Work Telephone Contains the emergency contact's work
telephone number.
PAE-WK-PHONE-EXT Alpha 5 PA12.1 PA512
Work Telephone Contains the extension of the emergency
Extension contact's telephone number.
PAE-FULL-NAME Derived
Full Name
PAE-COUNTRY-CODE Alpha 2 PA12.1 PA512
Country Code Contains the country of the address.
PAE-DATE-STAMP Numeric 8 (yyyymmdd) PA12.1 PA512
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAE-TIME-STAMP Numeric 6 (hhmmss) PA12.1 PA512
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAE-USER-ID Alpha 10 (Lower Case) PA12.1 PA512
User ID Name Contains the user ID of the person who
last changed this record.
PAEMERGCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAESET1 COMPANY HPAE.1 HR11.1
EMPLOYEE HR170 HR650
SEQ-NBR HR70.1 HR90.1
PA115 PA12.1
PA212 PA311
PA512
PAEMERGCNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
PAEMERGCNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
