|
|
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
Element: Company The company number represents an
established company and is entered on
all function codes.
PAE-EMPLOYEE Numeric 9 PA12.1 PA512
Element: 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
Element: Sequence NumbeContains a sequence number that keeps
records unique. It is automatically
assigned.
PAE-LAST-NAME Alpha 30 (Lower Case) PA12.1 PA512
Element: Name Contains the last name of the emergency
contact person.
PAE-FIRST-NAME Alpha 15 (Lower Case) PA12.1 PA512
Element: First Name Contains the first name of the
emergency contact person.
PAE-MIDDLE-INIT Alpha 1 PA12.1 PA512
Element: Middle InitialContains the middle initial of the
emergency contact person.
PAE-ADDR1 Alpha 30 (Lower Case) PA12.1 PA512
Element: Address 1 Contains the first line of address.
PAE-ADDR2 Alpha 30 (Lower Case) PA12.1 PA512
Element: Address 1 Contains the second line of the address.
PAE-ADDR3 Alpha 30 (Lower Case) PA12.1 PA512
Element: Address 1 Contains the third line of address.
PAE-ADDR4 Alpha 30 (Lower Case) PA12.1 PA512
Element: Address 1 Contains the fourth line of address.
PAE-CITY Alpha 18 (Lower Case) PA12.1 PA512
Element: City Contains the city of the address.
PAE-STATE Alpha 2 PA12.1 PA512
Element: State or ProviContains the state of the emergency
contact's address.
PAE-ZIP Alpha 10 PA12.1 PA512
Element: Postal Code Contains the postal code of the address.
PAE-RELATIONSHIP Alpha 30 (Lower Case) PA12.1 PA512
Element: Relationship Contains the relationship of the
emergency contact person to the
employee.
PAE-HM-PHONE-CNTRY Alpha 6 PA12.1 PA512
Element: Hm Phone CntryContains the prefix of the emergency
contact's home telephone number.
PAE-HM-PHONE-NBR Alpha 15 PA12.1 PA512
Element: 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
Element: Work TelephoneContains 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
Element: Full Name
PAE-COUNTRY-CODE Alpha 2 PA12.1 PA512
Element: Country Code Contains the country of the address.
PAE-DATE-STAMP Numeric 8 (yyyymmdd) PA12.1 PA512
Element: 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
Element: 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
Element: User
PAE-LABEL-NAME Derived
Element: Label Name
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
|
