The entity for holding the foreign country information for an employee. The data
originates from the Employee Data Base (EDB) and one record may exist per employee.
There should be a record in this table for any employee with the EDBPAY.FOREIGN_ADDR_IND
equal to 'F'.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (foreign key) |
| FAD_COUNTRY | FOREIGN COUNTRY CODE | VARCHAR2(2) | The abbreviation for the name of the country in which the individuals permanent address is located when the address is outside the United States. (translation in CTLFCT) |
| FAD_POSTAL_CODE | FOREIGN POSTAL CODE | VARCHAR2(10) | The postal code assigned to the area in which the individuals permanent address is located when the address is outside the United States. |
| FAD_PROVINCE | FOREIGN PROVINCE CODE | VARCHAR2(15) | The name of the province in which the individuals permanent address is located when the address is outside the United States. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 5, 1999