EMPVISA

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.
UPDATED BY
PA18.1 HR11.1 HR13.1 HR170 HR513 HR70.1
PA115 PA218 PA311

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMV-COMPANY
Element: Company Hr		Numeric 4
Contains the company number represents an established company.
PA18.1
EMV-EMPLOYEE
Element: Employee		Numeric 9
Employee number.
PA18.1
EMV-VISA-NUMBER
Element: Visa Number		Alpha 30
This field contains the visa number.
PA18.1
EMV-VISA-CNTRY-CD
Element: Visa Cntry Cd		Alpha 2
Contains the visa country code.
PA18.1
EMV-VISA-TYPE
Element: Visa Type		Alpha 15
This field contains the visa type.
PA18.1
EMV-EXP-DATE
Element: Exp Date		Numeric 8 (yyyymmdd)
This field contains the visa expiration date.
PA18.1
EMV-BEGIN-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
Contains the starting date for the VISA.
PA18.1
EMV-DEPENDENT
Element: Dependent		Numeric 4
Contains the dependent number. Dependent numbers match those on HR13.
PA18.1
EMV-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
PA18.1
EMV-CITIZEN
Element: Citizen		Alpha 4
Indicates if employee or dependent is a citizen of the country of the document.
PA18.1
EMV-TRAV-DOCUMENT
Element: Trav Document		Alpha 10
Contains the type of travel document (passport, visa, and so on).
PA18.1
EMV-RENEW-FLAG
Element: 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
Element: Apply Date		Numeric 8 (yyyymmdd)
Contains the date the document was applied for.
PA18.1
EMV-APPLY-STATUS
Element: Apply Status		Alpha 10
Contains the current application status of this document (e.g. In Process; Granted).
PA18.1
EMV-ISSUE-DATE
Element: Issue Date		Numeric 8 (yyyymmdd)
Indicates the date the document was issued.
PA18.1
EMV-ISSUE-BY
Element: Issue By		Alpha 30 (Lower Case)
Indicates the organization or location which issued this document.
PA18.1
EMV-REGISTER-DATE
Element: 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
Element: Comment		Alpha 40 (Lower Case)
This field contains the comment narrative.
PA18.1
EMV-DATE-STAMP
Element: 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
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA18.1
EMV-USER-ID
Element: User		Alpha 10 (Lower Case)
PA18.1


EMPVISA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMVSET1 COMPANY
EMPLOYEE
DEPENDENT
SEQ-NBR
HR11.1 HR13.1
HR170 HR513
HR70.1 PA115
PA18.1 PA218
PA311
EMVSET2 COMPANY
EMPLOYEE
DEPENDENT
VISA-CNTRY-CD
BEGIN-DATE*
SEQ-NBR
KeyChange
PA18.1 PA218


EMPVISA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:50:21 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.