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 |
PA18.1 | HR11.1 | PA115 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
EMV-COMPANY Element: Company Hr | Numeric 4 Contains the company number represents an established company. |
|
||
EMV-EMPLOYEE Element: Employee | Numeric 9 Employee number. |
|
||
EMV-VISA-NUMBER Element: Visa Number | Alpha 30 This field contains the visa number. |
|
||
EMV-VISA-CNTRY-CD Element: Visa Cntry Cd | Alpha 2 Contains the visa country code. |
|
||
EMV-VISA-TYPE Element: Visa Type | Alpha 15 This field contains the visa type. |
|
||
EMV-EXP-DATE Element: Exp Date | Numeric 8 (yyyymmdd) This field contains the visa expiration date. |
|
||
EMV-BEGIN-DATE Element: Begin Date | Numeric 8 (yyyymmdd) Contains the starting date for the VISA. |
|
||
EMV-DEPENDENT Element: Dependent | Numeric 4 Contains the dependent number. Dependent numbers match those on HR13. |
|
||
EMV-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
EMV-CITIZEN Element: Citizen | Alpha 4 Indicates if employee or dependent is a citizen of the country of the document. |
|
||
EMV-TRAV-DOCUMENT Element: Trav Document | Alpha 10 Contains the type of travel document (passport, visa, and so on). |
|
||
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 |
|
||
EMV-APPLY-DATE Element: Apply Date | Numeric 8 (yyyymmdd) Contains the date the document was applied for. |
|
||
EMV-APPLY-STATUS Element: Apply Status | Alpha 10 Contains the current application status of this document (e.g. In Process; Granted). |
|
||
EMV-ISSUE-DATE Element: Issue Date | Numeric 8 (yyyymmdd) Indicates the date the document was issued. |
|
||
EMV-ISSUE-BY Element: Issue By | Alpha 30 (Lower Case) Indicates the organization or location which issued this document. |
|
||
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). |
|
||
EMV-COMMENT Element: Comment | Alpha 40 (Lower Case) This field contains the comment narrative. |
|
||
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. |
|
||
EMV-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
EMV-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EMVSET1 |
COMPANY EMPLOYEE DEPENDENT SEQ-NBR |
|
| ||||||||||||||||
EMVSET2 |
COMPANY EMPLOYEE DEPENDENT VISA-CNTRY-CD BEGIN-DATE* SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apply Status | PCODES |
Required
| |||||||||||||||
Citizen | HRCTRYCODE |
Required
| |||||||||||||||
Company | PRSYSTEM |
Required
| |||||||||||||||
Dependent | EMDEPEND |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Pa Employee | PAEMPLOYEE |
Required
| |||||||||||||||
Travel Doc | PCODES |
Required
| |||||||||||||||
Visa Country | INSTCTRYCD |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.