Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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

HR13.1    HR170     HR513     HR70.1    PA218     PA311

UPDATED BY

PA18.1    HR11.1    PA115

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 30                                    PA18.1
Visa Number          This field contains the visa number.

EMV-VISA-CNTRY-CD    Alpha 2                                     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.

EMV-DEPENDENT        Numeric 4                                   PA18.1
Dependent Number     Contains the dependent number. Dependent
                     numbers match those on HR13.

EMV-SEQ-NBR          Numeric 4                                   PA18.1
Sequence Number      An automatically assigned sequence
                     number.

EMV-CITIZEN          Alpha 4                                     PA18.1
Citizen              Indicates if employee or dependent is a
                     citizen of the country  of the document.

EMV-TRAV-DOCUMENT    Alpha 10                                    PA18.1
Trav Document        Contains the type of travel document
                     (passport, visa, and so on).

EMV-RENEW-FLAG       Alpha 1                                     PA18.1
Renew Flag           Indicates if the employee needs to renew
                     this document, or whether the document
                     can be allowed to expire.
                     N = No
                     Y = Yes

EMV-APPLY-DATE       Numeric 8  (yyyymmdd)                       PA18.1
Apply Date           Contains the date the document was
                     applied for.

EMV-APPLY-STATUS     Alpha 10                                    PA18.1
Apply Status         Contains the current application status
                     of this document (e.g. In Process;
                     Granted).

EMV-ISSUE-DATE       Numeric 8  (yyyymmdd)                       PA18.1
Issued Date          Indicates the date the document was
                     issued.

EMV-ISSUE-BY         Alpha 30  (Lower Case)                      PA18.1
Issue By             Indicates the organization or location
                     which issued this document.

EMV-REGISTER-DATE    Numeric 8  (yyyymmdd)                       PA18.1
Register Date        Indicates the date the person registered
                     with the host country embassy in the
                     country (associated with the document).

EMV-COMMENT          Alpha 40  (Lower Case)                      PA18.1
Comment Line         This field contains the comment
                     narrative.


EMV-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA18.1
Date Stamp           This field contains the server date
                     (month, date, and year) of the last
                     change to this record.


EMV-TIME-STAMP       Numeric 6  (hhmmss)                         PA18.1
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

EMV-USER-ID          Alpha 10  (Lower Case)                      PA18.1
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         EMPVISA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMVSET1   COMPANY                                                HR11.1  HR13.1
          EMPLOYEE                                               HR170   HR513
          DEPENDENT                                              HR70.1  PA115
          SEQ-NBR                                                PA18.1  PA218
                                                                 PA311

EMVSET2   COMPANY       KeyChange                                PA18.1  PA218
          EMPLOYEE
          DEPENDENT
          VISA-CNTRY-CD
          BEGIN-DATE*
          SEQ-NBR

                         EMPVISA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apply Status   PCODES       Required
                            When EMV-APPLY-STATUS != Spaces

                            "AP"                 -> PCO-TYPE
                            EMV-APPLY-STATUS     -> PCO-CODE

Citizen        HRCTRYCODE   Required
                            When EMV-CITIZEN != Spaces

                            "CI"                 -> CTC-TYPE
                            EMV-VISA-CNTRY-CD    -> CTC-COUNTRY-CODE
                            EMV-CITIZEN          -> CTC-HRCTRY-CODE

Company        PRSYSTEM     Required

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

Dependent      EMDEPEND     Required
                            When EMV-DEPENDENT > Zeroes

                            EMV-COMPANY          -> EMD-COMPANY
                            EMV-EMPLOYEE         -> EMD-EMPLOYEE
                            EMV-DEPENDENT        -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required

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

Pa Employee    PAEMPLOYEE   Required

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

Travel Doc     PCODES       Required
                            When EMV-TRAV-DOCUMENT != Spaces

                            "TD"                 -> PCO-TYPE
                            EMV-TRAV-DOCUMENT    -> PCO-CODE

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

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