Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPVISA


                              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
Element: Company Hr    Contains the company number represents
                       an  established company.

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

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

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

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

EMV-EXP-DATE           Numeric 8  (yyyymmdd)                     PA18.1
Element: Expiration DatThis field contains the visa expiration
                       date.

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

EMV-DEPENDENT          Numeric 4                                 PA18.1
Element: Dependent NumbContains the dependent number. Dependent
                       numbers match those on HR13.

EMV-SEQ-NBR            Numeric 4                                 PA18.1
Element: Sequence NumbeAn automatically assigned sequence
                       number.

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

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

EMV-RENEW-FLAG         Alpha 1                                   PA18.1
Element: 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
Element: Apply Date    Contains the date the document was
                       applied for.

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

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

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

EMV-REGISTER-DATE      Numeric 8  (yyyymmdd)                     PA18.1
Element: 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
Element: Comment Line  This field contains the comment
                       narrative.

EMV-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA18.1
Element: 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
Element: 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
Element: User          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