|
PAEMERGCNT FILE
Employee Emergency Contact
The Employee Emergency Contact file contains emergency contact information
for employees.
REFERENCED BY
HPAE.1 HR170 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 Hr
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: Seq Nbr Contains a sequence number that keeps
records unique. It is automatically
assigned.
PAE-LAST-NAME Alpha 30 (Lower Case) PA12.1 PA512
Element: Last 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 Init Contains the middle initial of the
emergency contact person.
PAE-ADDR1 Alpha 30 (Lower Case) PA12.1 PA512
Element: Addr1 Contains the first line of address.
PAE-ADDR2 Alpha 30 (Lower Case) PA12.1 PA512
Element: Addr1 Contains the second line of the address.
PAE-ADDR3 Alpha 30 (Lower Case) PA12.1 PA512
Element: Addr1 Contains the third line of address.
PAE-ADDR4 Alpha 30 (Lower Case) PA12.1 PA512
Element: Addr1 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 Contains the state of the emergency
contact's address.
PAE-ZIP Alpha 10 PA12.1 PA512
Element: Zip 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
Element: Wk Phone CntryContains the prefix of the emergency
contact's work telephone number.
PAE-WK-PHONE-NBR Alpha 15 PA12.1 PA512
Element: Wk Phone Nbr Contains the emergency contact's work
telephone number.
PAE-WK-PHONE-EXT Alpha 5 PA12.1 PA512
Element: Wk Phone Ext Contains the extension of the emergency
contact's telephone number.
PAE-CL-PHONE-CNTRY Alpha 6 PA12.1 PA512
Element: Phone Country This field contains the prefix of the
telephone number. For example, the
country or city code.
PAE-CL-PHONE-NBR Alpha 15 PA12.1 PA512
Element: Phone Phone 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 HR70.1
SEQ-NBR 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
|