Employee Emergency Contact
The Employee Emergency Contact file contains emergency contact information for employees.
REFERENCED BY
HPAE.1 | HR170 | HR70.1 | HR90.1 | HS705 | ZH500 |
PA212 | PA311 |
PA12.1 | PA512 | HR11.1 | PA115 |
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: Hr City | Alpha 58 (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.