Employee Emergency Contact
The Employee Emergency Contact file contains emergency contact information for employees.
REFERENCED BY
| HR90.1 | HS705 | ZH500 |
| 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 |
|
||
| PAE-EMPLOYEE Element: Employee | Numeric 9 Contains the employee's number. It is use to correlate all information related to the employee. |
|
||
| PAE-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains a sequence number that keeps records unique. It is automatically assigned. |
|
||
| PAE-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) Contains the last name of the emergency contact person. |
|
||
| PAE-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) Contains the first name of the emergency contact person. |
|
||
| PAE-MIDDLE-INIT Element: Middle Init | Alpha 1 Contains the middle initial of the emergency contact person. |
|
||
| PAE-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) Contains the first line of address. |
|
||
| PAE-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) Contains the second line of the address. |
|
||
| PAE-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) Contains the third line of address. |
|
||
| PAE-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) Contains the fourth line of address. |
|
||
| PAE-CITY Element: City | Alpha 18 (Lower Case) Contains the city of the address. |
|
||
| PAE-STATE Element: State | Alpha 2 Contains the state of the emergency contact's address. |
|
||
| PAE-ZIP Element: Zip | Alpha 10 Contains the postal code of the address. |
|
||
| PAE-RELATIONSHIP Element: Relationship | Alpha 30 (Lower Case) Contains the relationship of the emergency contact person to the employee. |
|
||
| PAE-HM-PHONE-CNTRY Element: Hm Phone Cntry | Alpha 6 Contains the prefix of the emergency contact's home telephone number. |
|
||
| PAE-HM-PHONE-NBR Element: Hm Phone Nbr | Alpha 15 Contains the emergency contact's home telephone number. |
|
||
| PAE-WK-PHONE-CNTRY Element: Wk Phone Cntry | Alpha 6 Contains the prefix of the emergency contact's work telephone number. |
|
||
| PAE-WK-PHONE-NBR Element: Wk Phone Nbr | Alpha 15 Contains the emergency contact's work telephone number. |
|
||
| PAE-WK-PHONE-EXT Element: Wk Phone Ext | Alpha 5 Contains the extension of the emergency contact's telephone number. |
|
||
| 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. |
|
||
| PAE-CL-PHONE-NBR Element: Phone | Alpha 15 Phone number. |
|
||
| PAE-FULL-NAME Element: Full Name | Derived |
|
||
| PAE-COUNTRY-CODE Element: Country Code | Alpha 2 Contains the country of the address. |
|
||
| 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. |
|
||
| PAE-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
| PAE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||
| PAE-LABEL-NAME Element: Label Name | Derived |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PAESET1 |
COMPANY EMPLOYEE SEQ-NBR |
|
| ||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM |
Required
| |||||||||
| Country | INSTCTRYCD |
Required
| |||||||||
| Employee | EMPLOYEE |
Required
| |||||||||
| Pa Employee | PAEMPLOYEE |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Comments | PACOMMENTS |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.