EMPVISA FILE

                        Employee Travel and Visa

The Employee Travel and Visa file contains information about countries for
which an employee holds a visa and the expiration date of each visa.

REFERENCED BY

HR170     HR70.1    PA218     PA311

UPDATED BY

HR704     PA115     PA18.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

EMV-COMPANY          Numeric 4                                   PA18.1
Company              Contains the company number represents
                     an  established company.

EMV-EMPLOYEE         Numeric 9                                   PA18.1
Employee             Employee number.

EMV-VISA-NUMBER      Alpha 15                                    PA18.1
Visa Number          This field contains the visa number.

EMV-VISA-COUNTRY     Alpha 30  (Lower Case)
Visa Country         This field contains the visa country.

EMV-VISA-CNTRY-CD    Alpha 2                                     HR704   PA18.1
Visa Cntry Cd        Contains the visa country code.

EMV-VISA-TYPE        Alpha 15                                    PA18.1
Type of Visa         This field contains the visa type.

EMV-EXP-DATE         Numeric 8  (yyyymmdd)                       PA18.1
Expiration Date      This field contains the visa expiration
                     date.

EMV-BEGIN-DATE       Numeric 8  (yyyymmdd)                       PA18.1
Begin Date           Contains the starting date for the VISA.

                         EMPVISA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMVSET1   COMPANY                                                HR170   HR70.1
          EMPLOYEE                                               HR704   PA115
          VISA-NUMBER                                            PA18.1  PA218
                                                                 PA311

                         EMPVISA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            EMV-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            EMV-COMPANY          -> EMP-COMPANY
                            EMV-EMPLOYEE         -> EMP-EMPLOYEE

Pa Employee    PAEMPLOYEE   Required

                            EMV-COMPANY          -> PEM-COMPANY
                            EMV-EMPLOYEE         -> PEM-EMPLOYEE

Visa Country   INSTCTRYCD   Required
                            When (EMV-VISA-CNTRY-CD != Spaces )

                            EMV-VISA-CNTRY-CD    -> INT-COUNTRY-CODE