JP2019008504A - Information processing system - Google Patents

Abstract

To enable easy comprehension of whether or not it is possible to acquire visa before the departure date in a case of traveling abroad.SOLUTION: An information processing system has a travel expense adjustment system, an overseas information provision system and a mail transmission device. Upon receiving first personal information number and business trip information of a first employee, the travel expense adjustment system specifies the passport issuing country of the first employee on the basis of first personal information and a basic information table, and transmits the passport issuing country information, the first personal number, and the business trip information to the overseas information providing system. The business trip information includes a scheduled business trip departure date, a scheduled business trip return date, and a destination country. The overseas information providing system specifies the minimum visa acquisition date on the basis of the passport issuing country information, the first personal number, the business trip information personal number, and the visa application information history table of the first employee received from the travel expense adjustment system, and if the minimum visa acquisition date is after the scheduled business trip departure date included in the business trip information, the information processing system transmits an error message to the first employee.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a system technology that provides visa information and the like to employees when an overseas business trip occurs.

  As background art of this technical field, there is JP-A-2006-139453 (Patent Document 1). Patent document 1 teaches language, customs, technology, etc. while working in the foreign country of the dispatch destination, thereby fostering human resources that are required in internationalization. In the staffing system to be supplied, a technique is described in which the system creates a visa application document based on personal information registered from overseas applicants. Japanese Patent Laid-Open No. 2006-155546 (Patent Document 2) provides necessary advice as information in a major base city of a travel destination in response to a request from a traveler during a free trip abroad. The system is described.

JP 2006-139453 A JP 2006-155546 A

  Visa acquisition differs depending on the country of passport issue and the destination combination, and the procedure is complicated. On the other hand, it is often necessary to suddenly travel abroad depending on the work of employees. In the prior art, although documents necessary for travel are prepared, it is necessary to rely on experience to determine whether a visa can be obtained in consideration of the number of days until travel.

  In view of the above problems, in the present invention, the travel expense settlement system, the overseas information provision system connected to the travel expense settlement system via a network, and the mail transmission connected to the overseas information provision system via the network. The travel expense settlement system includes an input unit, an output unit, a control unit, and a basic information table for managing correspondence between employee personal identifiers and passport issuance locations. The overseas information providing system includes a receiving unit, an output unit, a control unit, a visa application information table for managing a passport issuing country, a destination country, and the number of days required for obtaining a visa, and the travel expense adjustment The control unit of the system, via the input unit, provides the first personal information number of the first employee, the business trip departure date, the business trip end date, the travel destination information including the destination country. , Based on the first personal information and the basic information table, the passport issuing country of the first employee is specified, the information on the passport issuing country, the first personal number, and the The business trip information is transmitted to the overseas information providing system via the output unit, and the control unit of the overseas information providing system receives the information on the first employee's sport issuing country received from the travel expense settlement system, and Based on the first personal number, the business trip information personal number, and the visa application information history table, the shortest visa acquisition date is specified, and the shortest visa acquisition date is included in the business trip information after the planned departure date of the business trip In this case, an information processing system is provided that controls the output unit and the mail transmission device to transmit an error message to the first employee.

  According to the information processing system of the present invention, it is possible to easily determine whether it is possible to obtain a visa in consideration of the number of days until travel, without depending on experience.

It is a system configuration figure of one embodiment of the present invention. It is a figure which shows the visa exemption country table used by one Embodiment of this invention. It is a figure which shows the visa acquisition log | history table used by one Embodiment of this invention. It is a figure which shows the visa application information table used by one Embodiment of this invention. It is a figure which shows the destination information table used by one Embodiment of this invention. It is a figure which shows the vaccination information table used by one Embodiment of this invention. It is a flowchart which shows the process sequence on the travel expense adjustment system in one Embodiment of this invention. It is a flowchart which shows the processing flow of judgment of visa exemption in one Embodiment of this invention. It is a flowchart which shows the processing flow of visa application information provision in one Embodiment of this invention. It is a flowchart which shows the processing flow of destination and route information provision in one Embodiment of this invention. It is a flowchart which shows the processing flow of vaccination information provision in one Embodiment of this invention. It is a figure which shows the structure content of the cooperation file used by one Embodiment of this invention.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 shows the configuration of an information processing system including an overseas information providing system 1 according to the present invention, a travel expense settlement system 2 as a data linkage destination system, and a mail transmission device 4. The overseas information providing system 1, the travel expense settlement system 2, which is a data linkage destination system, and the mail transmission device 4 are connected to each other via a network 3. The travel expense settlement system includes an input unit that receives information input from an employee, an output unit that transmits data to the extracurricular information providing system, a storage unit, and a control unit that controls these. A basic information table is stored in the storage unit. In the basic information table, for each personal identifier (LDAP number) for identifying an employee, the passport information (passport issuance place, passport expiration date), address of the employee concerned Etc. are managed. In addition, when an overseas business trip schedule is entered, the overseas travel information is entered into the travel expense settlement system via the input unit 21 (registration of overseas business trip schedule), and travel expenses are applied and settled. The overseas business trip information includes information on a planned business trip date, a planned end date, a travel destination (region), a travel destination (country), a travel destination (city), and an accommodation destination (city).

  When the travel expense settlement system receives registration of an overseas business trip schedule from an employee (receives overseas business trip information via the input section), the employee's personal information registered in the basic information table of the travel expense settlement system (LDAP Number, employee address) and passport information (passport issuance location, passport expiration date), and sent to the overseas information provision system as a linked file.

FIG. 12 shows an example of a cooperation file. The linkage file is used to link the contents input by the employee into the travel expense settlement system and the overseas information provision system. When the employee inputs the following contents on the travel expense settlement system, the entered contents and the related contents are written in the linkage file and sent to the overseas information providing system. Specifically, there are (1) information input by the employee to the travel expense settlement system and (2) information acquired from a table of the travel expense settlement system. (1) The information entered by the employee into the travel expense settlement system includes, for example, the employee's personal identifier (LDAP) 31a, the planned business trip date (31b), that is, the planned start date of the business trip, and the planned end date (31c), that is, the business trip. Scheduled destination date, destination (region) (31d), that is, the name of the region arriving using the means of transportation, destination (country) (31e), ie, the name of the country arriving using the means of transportation, destination (City) (31f) In other words, the name of the city arriving by means of transportation, accommodation (city) (31g), that is, the city where the reserved hotel is located. The names of cities that can be registered include "accommodation (country / region)" on the travel expense settlement system.
After inputting the above contents into the travel expense settlement system, the control unit transmits it as a linkage file to the overseas information providing system. (2) Information acquired from the table of the travel expense settlement system is a basic information table of the travel expense settlement system registered in advance by the employee. For example, employee address information (31j), employee passport issue location (31h), and employee passport expiration date (31i) are included.

  The control unit writes the information (1) and (2) in the linkage file, and then automatically transmits it to the overseas information providing system.

  Returning to FIG. 1, the overseas information providing system 1 will be described. The overseas information providing system 1 includes a data receiving unit 11, a storage unit 13, a data output unit 14, and a control unit 14 for controlling them. The data receiving unit 11, the control unit 12, the storage unit 13, and the data output unit 14 are configured. The storage unit 13 includes a visa exemption country table 131, a visa acquisition history table 132, a visa application information table 133, a travel destination information table 134, and a vaccination information table 135 to be subsequently operated.

  FIG. 2 shows an example of a visa exempt country table in the present embodiment. The visa exemption country table includes the passport issuing place 131a, the visa exemption when the passport is issued at the passport issuing place and the exempt country 131b that is the target country, the stay period 131c that is the exempted condition, and the notes 131d This shows the correspondence relationship. According to Figure 2, if a passport is issued in Japan, the visa is exempted if you travel to the United States within 30 days.

  FIG. 3 shows an example of a visa acquisition history table in the present embodiment. The visa acquisition history table is a table for managing visa history acquired by each employee in the past. The visa acquisition history table shows a correspondence relationship between an employee's personal number (LDAP) 132a and a visa acquisition destination 132c, visa type 132d, and visa expiration date 132e acquired by the employee in the past. According to FIG. 3, the employee identified by LDAP00001 has obtained an American work visa in the past, and the expiration date of the visa is 2017/1/1.

  FIG. 4 shows an example of a visa application information table in the present embodiment. The visa application information table is a table for managing procedures and the like necessary for visa application (acquisition). The visa application information table includes the combination of the passport issuance location 133a and the destination 133b, the embassy address 133d required for visa application, the acquisition procedure 133e, and the required documents 133f. ), The correspondence between 133g days to acquisition and remarks 133h (other surrounding matters).

FIG. 5 shows an example of a visa application information table in the present embodiment. Destination information table
This shows the correspondence between the travel destination 134a and the immigration information 134b for that country.

  In FIG. 6, the example of the vaccination information table in a present Example is shown. The vaccination information table is for managing vaccinations required for each destination. More specifically, the vaccination management information table indicates a correspondence relationship between the travel destination 135a, the period 135b, the vaccination type 135d required in that case, and the importance 135e.

  Hereinafter, a processing flow for providing various information using the above system will be described with reference to flowcharts.

  A processing flow on the travel expense settlement system will be described with reference to FIG.

  In S100, the employee logs in to the travel expense settlement system.

  In S101, the employee registers an advance application for an overseas business trip in the travel expense settlement system. The contents of the registration are as described in (1) Information input by the employee to the travel expense settlement system.

  In S102, the control part of the travel expense settlement system acquires visa information from the basic information table of the travel expense settlement system. The visa information to be acquired is as described in (2) Information acquired from the table of the travel expense settlement system described above.

    In S103, the control part of the travel expense settlement system writes the information acquired in S102 and S103 into the cooperation file, and passes the cooperation file to the output part of the travel expense settlement system.

  In S104, in order to link information necessary for the overseas information provision system from the travel expense settlement system, the output unit 14 of the travel expense settlement system sends data (cooperation file) to the overseas information provision system.

  With reference to FIG. 8, a processing flow for determining processing on the overseas information providing system: visa exemption will be described. The processing in FIG. 8 is performed by the control unit of the stem that provides overseas information. In the process of FIG. 8, the control unit 12 applies a visa application when the employee travels based on the information received from the travel expense settlement system (information on the collaborative doctor file), the visa exemption country table, and the visa acquisition history table. This is a process for determining whether or not (acquisition) is necessary.

  In S200, a visa exemption determination process is started.

  In S201, it is determined whether there is visa information in the information linked from the travel expense settlement system to the overseas information providing system. This step is necessary because visa information is not a required entry when employees register personal information on an overseas information provision system. Even if one item among the items 31k, 31l, 31m, 31n, 31o, 31p, and 31q in the R linkage file is not input, it is determined that the visa information is not registered, and the process proceeds to S202. If the visa information is registered, the process proceeds to S204.

  In S202, from the “visa exemption table” of the overseas information provision system, the stay period (131c) and precautions (with the employee's passport issuance (nationality) (131a) and destination (country) (31e) as the primary key 131d) is extracted. The process proceeds to S203.

  In S203, it is checked whether the extraction process in S202 is successful. If unsuccessful, the employee can travel without obtaining a visa for the country in which he / she intends to travel, so the process proceeds to S208 (the flag “need visa application required” is set to “OFF”). If the extraction process in S202 fails, the process proceeds to S204.

  In S204, from the “visa acquisition history table” 132 of the overseas information providing system, using the employee's LDAP (31a) and branch number (132b) as primary keys, the visa acquisition destination (132c), visa type (132d), Extract the visa expiration date (132e). The process proceeds to S205.

  In S205, it is checked whether or not the travel destination (country) (31e) is included in the visa country (132c) that the employee has already acquired. If the travel destination (country) (31e) is not included in the country of the visa that the employee has already acquired, a new visa must be acquired, so S209 (flag “Visa application required” set to “On”) Go to (). If the travel destination (country) (31e) is included in the country (132c) of the visa that the employee has already acquired, it is necessary to check the expiration date (132e) of the visa, and the process proceeds to S206.

  In S206, it is checked whether the expiry date (132e) of the acquired business trip destination (country) visa is before the end date (31c) of the business trip. If the visa expiration date (132e) is before the end date (31c) of the business trip, it is necessary to re-apply for the visa, so S209 (set the flag “Visa application required” to “On”) Proceed to If the visa expiration date (132e) is not before the end date (31c) of the business trip, it is determined whether the visa type is for business use.

  In S207, it is determined whether the acquired visa type (132d) is for business. If it can be used for business, visa application is not required, so the process proceeds to S208 (set flag “Visa application required” to “OFF”). If the acquired visa cannot be used for business, it is necessary to re-apply for the visa, and the process proceeds to S209 (flag “Visa application required” is set to “On”).

  In S208, the flag “Visa application required” is set to “OFF”. By setting this flag to “OFF”, processing on the overseas information provision system: visa application information provision processing is not performed.

  In S209, the flag “Visa application required” is set to “ON”. When this flag is set to “ON”, processing on the overseas information provision system: processing of visa application information provision is performed.

  In S210, the visa exemption determination process is terminated.

  With reference to FIG. 9, the processing flow of overseas information providing system processing: visa application information provision will be described. The processing of FIG. 9 is based on the determination result of the processing of FIG. 8, the information received from the travel expense settlement system (information of the linked medical doctor file), and the visa application information table. This is a process for determining whether or not.

  In S300, the visa application information providing process is started.

  In S301, it is checked whether the flag “Visa application required” is “ON”. If it is not “ON”, it is not necessary to execute the visa application information provision process, and the process proceeds to S310 (the process continuation flag is set to “ON”). If it is “ON”, processing for providing visa application information is required, and the process proceeds to S302.

  In S302, from the visa application information table 133 of the overseas information providing system, the passport issuance location (31h), travel destination (country) (31e), branch number (133c) are used as primary keys, and the embassy address (133d). , Visa acquisition procedure (133e) and necessary documents (133f), number of days until visa acquisition (133g), remarks (133h) information.

  In step S303, it is checked whether the information acquisition is successful in step S302. If successful, the process proceeds to S304. When it fails, it progresses to S307.

  In S304, in order to check whether the visa can be obtained in time for the business trip start date (31b), the shortest date for obtaining the visa is calculated by, for example, "shortest date = today's date + days until obtaining the visa (133g) "

  Next, the process proceeds to S305.

  In S305, it is checked whether the shortest date for obtaining the visa calculated in S304 is before the business trip start date (31b). If the shortest date is not before the business trip start date (31b), the process proceeds to S309. If the shortest date is before the business trip start date (31b), the process proceeds to S306.

  In S306, in order to output information from the overseas information providing system, the information acquired from the “visa application information table” 133 of the overseas information providing system is passed to the output unit 14 of the travel expense settlement system. The process proceeds to S310.

  In S307, the process is performed when the acquisition of information from the “visa application information table” 133 of the overseas information providing system fails in S303. If it fails, the error information (A) is passed to the output unit 14 of the overseas information providing system. The error information (A) is, for example, “Visa application information cannot be obtained from the overseas information providing system. Please contact the master administrator of the overseas information providing system.”

  Next, it progresses to S308.

  In S308, the processing continuation flag is set to “ON”. By setting the processing continuation flag to “ON”, subsequent processing on the overseas information provision system can be performed. The reason for this is that even if acquisition of visa application information fails from the “visa application information table” 133 of the overseas information provision system, the subsequent destination, route information provision processing, and vaccination information provision processing are not This is because it can be implemented. The process proceeds to S311.

  In S309, the processing in S305, “Check whether the shortest date for obtaining a visa is before the business trip start date (31b)” is “NO”. When the result of the check is “NO”, the error information (B) is passed to the output unit 14 of the overseas information providing system. The error information (B) is, for example, “You cannot get a visa until the start date of the business trip. Change the start date of the business trip or consult the embassy directly about obtaining a visa. I can't travel on business. "

  Next, it progresses to S310.

  In S310, the processing continuation flag is set to “OFF”. By setting the processing continuation flag to “OFF”, subsequent processing on the overseas information provision system is not performed. The reason is that a visa cannot be obtained in time for the start of a business trip, so that the business trip cannot be performed, and therefore no subsequent processing is required on the overseas information providing system.

  Next, it progresses to S311.

  In step S311, the visa application information providing process is terminated.

  The processing on the overseas information providing system: destination and route information providing processing flow will be described with reference to FIG. The processing in FIG. 10 is performed by the control unit of the stem that provides overseas information.

  In S400, the destination and route information provision processing is started.

  In S401, it is checked whether the processing continuation flag is “ON”. [0004] As described in [0004], if a visa cannot be obtained by the start date (31b) of the business trip, the business trip cannot be made, so that it is not necessary to perform subsequent processing on the overseas information providing system. At that time, the processing continuation flag is set to “OFF”, and control is performed so that the processing on the overseas information providing system is not performed.

  When the processing continuation flag is “OFF”, the process proceeds to S411. If it is “ON”, the process proceeds to S402.

  In S402, information on entry procedure (country) (134b) is acquired from the "destination information table" 134 of the overseas information providing system using the destination (country) (31e) as a primary key. The process proceeds to S403.

  In step S403, it is checked whether the information acquisition is successful in step S402. If successful, the process proceeds to S404. When it fails, it progresses to S405.

  In S404, in order to output information from the overseas information providing system, the information acquired from the “travel destination information table” 134 is passed to the output unit 14 of the overseas information providing system. The process proceeds to S406.

In S405, the process is performed when information acquisition fails in S402. When the information acquisition fails, the error information (C) is passed to the output unit 14 of the overseas information providing system.
The error information (C) is, for example, “Procedure information for entering the country on a business trip cannot be obtained from the overseas information providing system. Please contact the master administrator of the overseas information providing system.”

  Further, even if the acquisition of procedure information for entering the country of business trip from the overseas information providing system fails, the subsequent process can be performed, so the process proceeds to S406.

  In S406, it is checked whether the travel destination (city) (31f) and the accommodation destination (city) (31g) are the same. In the case of being together, since it is not necessary to provide route information from the destination (city) (31f) to the accommodation (city) (31g), the process proceeds to S412. If the travel destination (city) (31f) and accommodation (city) (31g) are different, the route information from the destination (city) (31f) to the accommodation (city) (31g) is provided. Since it becomes necessary, the process proceeds to S407.

  In S407, the route history is extracted from the settlement data history table of the travel expense settlement system using the travel destination (city) (31f) and the accommodation destination (city) (31g) as keys (up to 5). This process extracts payment data (route information) after a business trip registered at the same destination (city) (31f) and accommodation (city) (31g) on the travel expense adjustment system, and provides it to employees as reference information. To do. The number of route information data to be provided is up to five.

  In S408, it is checked whether the extraction process in S407 is successful. If successful, the process proceeds to S409. When it fails, it progresses to S410.

  In S409, when the process of S407 is successful, the history information of the acquired route is passed to the output unit 14 of the overseas information providing system in order to output information from the travel expense settlement system. The process proceeds to S412.

In S410, when the extraction process in S407 fails, the error information (D) is passed to the output unit 14 of the overseas information providing system. The error information (D) is, for example, “Failed to extract history data of the route information between the travel destination (XX city) and the accommodation (XX city) from the travel expense settlement system. To the system administrator of the travel expense settlement system Please contact us. "

  In S411, the processing is performed when the processing continuation flag is "OFF". When the processing continuation flag is “OFF”, the subsequent processing on the overseas information providing system is not performed, so the process directly moves to the output unit 14 of the overseas information providing system to perform the output processing.

  In S412, the travel destination and route information provision processing is terminated.

  With reference to FIG. 11, the processing flow of the overseas information provision system: the provision of vaccination information will be described. The processing in FIG. 10 is performed by the control unit of the stem that provides overseas information.

  In step S501, a process for providing vaccination information is started.

  In S502, from the "immunization information table" 135 of the overseas information provision system, the type of vaccination (135d), important with the destination (region) (31d), period (135b), branch number (135c) as the primary key Get the degree (135e). The process proceeds to S503.

  In step S503, it is checked whether the extraction process in step S502 is successful. If successful, the process proceeds to S504. When it fails, it progresses to S505.

  In step S504, in order to output information from the overseas information provision system, the information acquired from the “vaccination information table” 135 of the overseas information provision system is passed to the output unit 14 of the travel expense settlement system.

  In S505, the process when the extraction process in S503 fails. When it fails, the error information (E) is passed to the output unit 14 of the overseas information providing system. The error information (E) is, for example, “The information relating to immunization has failed to be extracted from the overseas information providing system. Please contact the master administrator of the overseas information providing system.”

  Through the above processing (FIGS. 9, 10, and 11), the output unit 14 of the overseas information providing system acquires various types of information from the control unit 12.

  Based on the acquired information, the output unit 14 creates a mail text for the employee to be traveled, and transmits information about the mail text to the mail transmission device 4.

DESCRIPTION OF SYMBOLS 1 Overseas information provision system 11 Data receiving part 12 Control part 13 Storage part 131 Visa exemption country table 132 Visa acquisition history table 133 Visa application information table 134 Travel destination information table 134 Vaccination information table 14 Data output part 2 Travel expense adjustment system 21 Business trip Schedule information input unit 22 control unit 23 storage unit 231 passport, visa information table 232 basic information table 3 linkage file 4 mail transmission device

Claims (4)

An information processing system comprising: a travel expense settlement system; an overseas information provision system connected to the travel expense settlement system via a network; and a mail transmission device connected to the overseas information provision system via the network,
The travel expense settlement system includes an input unit, an output unit, a control unit, and a basic information table for managing correspondence between employee personal identifiers and passport issuance locations,
The overseas information providing system includes a receiving unit, an output unit, a control unit, a visa application information table for managing a passport issuing country, a destination country, and the number of days required for obtaining a visa,
The control unit of the travel expense settlement system receives the first personal information number of the first employee, the business trip departure date, the business trip end date, and the travel destination country information via the input unit. Then, based on the first personal information and the basic information table, the passport issuing country of the first employee is specified, the information on the passport issuing country, the first personal number, and the business trip information To the overseas information providing system via the output unit,
The control unit of the overseas information providing system includes the first employee's sport issuing country information received from the travel expense settlement system, the first personal number, the business trip information personal number, and the visa application information history. Based on the table, the shortest date for obtaining a visa is specified, and when the shortest date for obtaining a visa is after the planned departure date for the business trip included in the business trip information, the output unit sends an error message to the first employee. And an information processing system for controlling the mail transmitting device. The information processing system according to claim 1,
The overseas information providing system
It further includes a destination information table that associates the country of destination with the contents of the immigration procedures,
When the specified visa acquisition shortest date is before the planned business trip departure date included in the business trip information, the control unit of the overseas information providing system,
Based on the travel destination country of the first employee included in the business trip information and the travel destination information table, the contents of the entry procedure corresponding to the travel destination country of the first employee An information processing system that controls the output unit and the mail transmission device to transmit to one employee. The information processing system according to claim 1,
The overseas information providing system further includes a vaccination information table that associates the country of destination, the stay period, and information on necessary vaccination,
When the specified visa acquisition shortest date is before the planned business trip departure date included in the business trip information, the control unit of the overseas information providing system,
Based on the travel destination country of the first employee included in the business trip information, the scheduled business trip departure date, the business trip end scheduled date, and the vaccination information table, the first employee needs the necessary information. An information processing system for controlling the output unit and the mail transmitting device so as to transmit information relating to vaccination to the first employee. The information processing system according to claim 1,
The overseas information providing system includes a visa exemption country table for managing correspondence between a passport issuing country, a destination country, and visa exemption conditions, and a visa acquisition history table for managing correspondence between the individual identifier of the employee and a visa acquisition history. And further comprising
When the control unit of the overseas information providing system receives the first personal information number and the business trip information from the travel expense settlement system,
Based on the first personal information number, the visa exemption country table of the business trip information, and the visa acquisition history table, it is determined whether or not a visa is required,
An information processing system characterized by identifying a shortest visa acquisition date when a visa acquisition is required.

Images