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.

Field / column	Type	Description & values	Updated by
`EMV-COMPANY` PK COMPANY	Numeric 4	Contains the company number represents an established company.	PA18.1
`EMV-EMPLOYEE` PK EMPLOYEE	Numeric 9	Employee number.	PA18.1
`EMV-VISA-NUMBER` VISA_NUMBER	Alpha 30	This field contains the visa number.	PA18.1
`EMV-VISA-CNTRY-CD` VISA_CNTRY_CD	Alpha 2	Contains the visa country code.	PA18.1
`EMV-VISA-TYPE` VISA_TYPE	Alpha 15	This field contains the visa type.	PA18.1
`EMV-EXP-DATE` EXP_DATE	Numeric 8 (yyyymmdd)	This field contains the visa expiration date.	PA18.1
`EMV-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	Contains the starting date for the VISA.	PA18.1
`EMV-DEPENDENT` PK DEPENDENT	Numeric 4	Contains the dependent number. Dependent numbers match those on HR13.	PA18.1
`EMV-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	PA18.1
`EMV-CITIZEN` CITIZEN	Alpha 4	Indicates if employee or dependent is a citizen of the country of the document.	PA18.1
`EMV-TRAV-DOCUMENT` TRAV_DOCUMENT	Alpha 10	Contains the type of travel document (passport, visa, and so on).	PA18.1
`EMV-RENEW-FLAG` RENEW_FLAG	Alpha 1	Indicates if the employee needs to renew this document, or whether the document can be allowed to expire. `N` No `Y` Yes	PA18.1
`EMV-APPLY-DATE` APPLY_DATE	Numeric 8 (yyyymmdd)	Contains the date the document was applied for.	PA18.1
`EMV-APPLY-STATUS` APPLY_STATUS	Alpha 10	Contains the current application status of this document (e.g. In Process; Granted).	PA18.1
`EMV-ISSUE-DATE` ISSUE_DATE	Numeric 8 (yyyymmdd)	Indicates the date the document was issued.	PA18.1
`EMV-ISSUE-BY` ISSUE_BY	Alpha 30 (Lower Case)	Indicates the organization or location which issued this document.	PA18.1
`EMV-REGISTER-DATE` REGISTER_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-COMMENT` COMMENT	Alpha 40 (Lower Case)	This field contains the comment narrative.	PA18.1
`EMV-DATE-STAMP` DATE_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-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	PA18.1
`EMV-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	PA18.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`EMVSET1`	`COMPANY`, `EMPLOYEE`, `DEPENDENT`, `SEQ-NBR`	Primary		HR11.1, HR13.1, HR170, HR513, HR70.1, PA115, PA18.1, PA218 +1 more
`EMVSET2`	`COMPANY`, `EMPLOYEE`, `DEPENDENT`, `VISA-CNTRY-CD`, `BEGIN-DATE*`, `SEQ-NBR`	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	`"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`

Programs

Updated by (3)

HR11.1 Employee
PA115 Employee Purge
PA18.1 Travel Information

Referenced by (6)

HR13.1 Dependent
HR170 Human Resource Writer Report Request
HR513 Dependent Conversion
HR70.1 Human Resource Writer Inquiry
PA218 Travel Listing
PA311 Employee Profile