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
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 HR13.1 HR170
EMPLOYEE HR513 HR70.1
DEPENDENT PA18.1 PA218
SEQ-NBR 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
|
