PAEMERGCNT

Employee Emergency Contact

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

REFERENCED BY
HR90.1 HS705 ZH500


UPDATED BY
HPAE.1 HR11.1 HR170 HR70.1 PA115 PA12.1
PA212 PA311 PA512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAE-COMPANY
Element: Company Hr
Numeric 4
PA12.1 PA512
PAE-EMPLOYEE
Element: 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
Element: Seq Nbr
Numeric 4
Contains a sequence number that keeps records unique. It is automatically assigned.
PA12.1 PA512
PAE-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the last name of the emergency contact person.
PA12.1 PA512
PAE-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the first name of the emergency contact person.
PA12.1 PA512
PAE-MIDDLE-INIT
Element: Middle Init
Alpha 1
Contains the middle initial of the emergency contact person.
PA12.1 PA512
PAE-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
Contains the first line of address.
PA12.1 PA512
PAE-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
Contains the second line of the address.
PA12.1 PA512
PAE-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Contains the third line of address.
PA12.1 PA512
PAE-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Contains the fourth line of address.
PA12.1 PA512
PAE-CITY
Element: City
Alpha 18 (Lower Case)
Contains the city of the address.
PA12.1 PA512
PAE-STATE
Element: State
Alpha 2
Contains the state of the emergency contact's address.
PA12.1 PA512
PAE-ZIP
Element: Zip
Alpha 10
Contains the postal code of the address.
PA12.1 PA512
PAE-RELATIONSHIP
Element: Relationship
Alpha 30 (Lower Case)
Contains the relationship of the emergency contact person to the employee.
PA12.1 PA512
PAE-HM-PHONE-CNTRY
Element: Hm Phone Cntry
Alpha 6
Contains the prefix of the emergency contact's home telephone number.
PA12.1 PA512
PAE-HM-PHONE-NBR
Element: Hm Phone Nbr
Alpha 15
Contains the emergency contact's home telephone number.
PA12.1 PA512
PAE-WK-PHONE-CNTRY
Element: Wk Phone Cntry
Alpha 6
Contains the prefix of the emergency contact's work telephone number.
PA12.1 PA512
PAE-WK-PHONE-NBR
Element: Wk Phone Nbr
Alpha 15
Contains the emergency contact's work telephone number.
PA12.1 PA512
PAE-WK-PHONE-EXT
Element: Wk Phone Ext
Alpha 5
Contains the extension of the emergency contact's telephone number.
PA12.1 PA512
PAE-CL-PHONE-CNTRY
Element: Phone Country
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
Element: Phone
Alpha 15
Phone number.
PA12.1 PA512
PAE-FULL-NAME
Element: Full Name
Derived
PAE-COUNTRY-CODE
Element: Country Code
Alpha 2
Contains the country of the address.
PA12.1 PA512
PAE-DATE-STAMP
Element: 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
Element: 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
Element: User
Alpha 10 (Lower Case)
PA12.1 PA512
PAE-LABEL-NAME
Element: Label Name
Derived


PAEMERGCNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAESET1 COMPANY
EMPLOYEE
SEQ-NBR
HPAE.1 HR11.1
HR170 HR70.1
HR90.1 HS705
ZH500 PA115
PA12.1 PA212
PA311 PA512


PAEMERGCNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:22:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.