EMPVISA – Employee Travel and Visa
- System
- Personnel (PA)
- Prefix
EMV- Primary key
COMPANY,EMPLOYEE,DEPENDENT,SEQ-NBR- Fields
- 21
- Updated by
- 3 programs
- Referenced by
- 6 programs
EMPVISA is the Employee Travel and Visa table in Lawson Personnel (prefix EMV). It is indexed by COMPANY, EMPLOYEE, DEPENDENT, SEQ-NBR (EMVSET1); alternate indexes: EMVSET2. It is related 1:1 to PCODES, HRCTRYCODE, PRSYSTEM, EMDEPEND, EMPLOYEE, PAEMPLOYEE and INSTCTRYCD. It is updated by HR11.1, PA115 and PA18.1 and referenced by HR13.1, HR170, HR513, HR70.1, PA218 and PA311. The table has 21 fields, 2 indexes and 8 documented relations.
About EMPVISA
The Employee Travel and Visa file contains information about countries for which an employee holds a visa and the expiration date of each visa.
Fields (21)
Column = COBOL field name without the EMV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#EMV-COMPANY PKCOMPANY | Numeric 4 | Contains the company number represents an established company. | PA18.1 |
#EMV-EMPLOYEE PKEMPLOYEE | Numeric 9 | Employee number. | PA18.1 |
#EMV-VISA-NUMBERVISA_NUMBER | Alpha 30 | This field contains the visa number. | PA18.1 |
#EMV-VISA-CNTRY-CD SET2VISA_CNTRY_CD | Alpha 2 | Contains the visa country code. | PA18.1 |
#EMV-VISA-TYPEVISA_TYPE | Alpha 15 | This field contains the visa type. | PA18.1 |
#EMV-EXP-DATEEXP_DATE | Numeric 8 (yyyymmdd) | This field contains the visa expiration date. | PA18.1 |
#EMV-BEGIN-DATE SET2BEGIN_DATE | Numeric 8 (yyyymmdd) | Contains the starting date for the VISA. | PA18.1 |
#EMV-DEPENDENT PKDEPENDENT | Numeric 4 | Contains the dependent number. Dependent numbers match those on HR13. | PA18.1 |
#EMV-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | PA18.1 |
#EMV-CITIZENCITIZEN | Alpha 4 | Indicates if employee or dependent is a citizen of the country of the document. | PA18.1 |
#EMV-TRAV-DOCUMENTTRAV_DOCUMENT | Alpha 10 | Contains the type of travel document (passport, visa, and so on). | PA18.1 |
#EMV-RENEW-FLAGRENEW_FLAG | Alpha 1 | Indicates if the employee needs to renew this document, or whether the document can be allowed to expire.
| PA18.1 |
#EMV-APPLY-DATEAPPLY_DATE | Numeric 8 (yyyymmdd) | Contains the date the document was applied for. | PA18.1 |
#EMV-APPLY-STATUSAPPLY_STATUS | Alpha 10 | Contains the current application status of this document (e.g. In Process; Granted). | PA18.1 |
#EMV-ISSUE-DATEISSUE_DATE | Numeric 8 (yyyymmdd) | Indicates the date the document was issued. | PA18.1 |
#EMV-ISSUE-BYISSUE_BY | Alpha 30 (Lower Case) | Indicates the organization or location which issued this document. | PA18.1 |
#EMV-REGISTER-DATEREGISTER_DATE | Numeric 8 (yyyymmdd) | Indicates the date the person registered with the host country embassy in the country (associated with the document). | PA18.1 |
#EMV-COMMENTCOMMENT | Alpha 40 (Lower Case) | This field contains the comment narrative. | PA18.1 |
#EMV-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | PA18.1 |
#EMV-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | PA18.1 |
#EMV-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA18.1 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EMVSET1 |
| Primary | HR11.1, HR13.1, HR170, HR513, HR70.1, PA115, PA18.1, PA218 +1 more | |
EMVSET2 |
| KeyChange | PA18.1, PA218 |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apply Status | PCODES | Required | When EMV-APPLY-STATUS != Spaces |
| |||||||||
| Citizen | HRCTRYCODE | Required | When EMV-CITIZEN != Spaces |
| |||||||||
| Company | PRSYSTEM | Required |
| ||||||||||
| Dependent | EMDEPEND | Required | When EMV-DEPENDENT > Zeroes |
| |||||||||
| Employee | EMPLOYEE | Required |
| ||||||||||
| Pa Employee | PAEMPLOYEE | Required |
| ||||||||||
| Travel Doc | PCODES | Required | When EMV-TRAV-DOCUMENT != Spaces |
| |||||||||
| Visa Country | INSTCTRYCD | Required | When (EMV-VISA-CNTRY-CD != Spaces) |
|