SAP Program RPLHULJ0 - Loss of Qualification Form Data File for HI Union

Purpose
This report creates date file (CSV format) for Health Insurance andEmployees Pension Insurance Loss of Qualification Form that is forHealth Insurance (HI) Union. Data file can be for magnetic media (FloppyDisk, Magneto Optical disk) and electronic filing via Internet.
This report checks employees Social Insurance Basic Data infotype (0140)and takes necessary data from the employee's master data infotypes.

Prerequisites

  • This report create data file according to the specification "Magnetic
    • Medium Notification Specification (Health Insurance Union / PensionFund)" stated by Social Insurance Agency. Depending on Health InsuranceUnion to which data file is to be submitted, specification of recordlayout may differ from that of Social Insurance Agency.
    • Employee's Social Insurance Basic Data infotype (0140) must be
      • maintained with correct status and validity date.
      • Employee's personnel area and personnel subarea in Organizational
        • Assignment infotype must be maintained (in the case of new hire andtransfer).

        Features

        • It is possible to specify for which insurance type (Health insurance
          • only or Health insurance & Pension) Lost of QualificationForm data file is to be created.
          When you select Health insurance only, employees who meet thefollowing criteria are included in the output:
          Employees whose Acquired/Lost status of Health Insurance iseither "Lost" or "Office change" in the specified timeperiod.
          When you select Health insurance & Pension, employees who meetthe following criteria are included in the output:
          Employees whose Acquired/Lost status of Health Insurance orEmployee's Pension is either "Lost" or "Office change" inthe specified time period.
          • It is possible to specify more than one target branch office to which
            • Loss of Qualifcation Form data to be created.
            • It is possible to specify which employee's address information is to be
              • used. Official tax address (subtype J1) is proposed as default.
              • It is possible to specify the size (volume) of disk media to be used.
                • 1.44Mb and 1.25Mb are supported for floppy disk (FD) and 230Mb and 640Mbare supported for magneto optical disk (MO).
                Note
                For magneto optical disk, number of data record saved in a disk islimited to 99999 records. For electronic filing, number of data recordsaved in a file is limited to 20000 record and the size of a file isalso limited to 4.5Mb.
                • If the volume of output data is larger than specified disk media size,
                  • the report automatically divides output data into multiple files withspecified volume and attaches sequential numbers to file names. (EX:KPFD0006.CSV001, KPFD0006.CSV002)
                  Note
                  Note that when a data file is saved to a disk media, you need to editfile name (extension) to take out sequential number. Sequential numberis to be used as a label of disk media.
                  • It is possible to save the output file to TemSe, to an application
                    • server and directly to a local PC.
                    • It is possible to display detailed data of employee records and office
                      • record that are stored in the data file. By pushing "Employee detail
                      " or "Office detail" on the application tool bar of resultscreen, respective data will is shown with SAP List Viewer format.
                      • When there is an error record(s) caused by insufficient employee data
                        • and/or branch office data, it is possible to check such record(s). Incase an error record(s) is detected, buttons labeled "Employee"and/or "Office" with error icon are displayed on the applicationtool bar of result screen. By pushing these buttons, corresponding errorrecord(s) will be shown.
                        • Name of Health Insurance Union specific item can be set in the selection
                          • screen.
                          • A Business Add In (BAdI) is available to set (or edit) customer specific
                            • data to Health Insurance Union specific item field (Kanji 40 characters/ Alpha-numeric 80 characters) and remarks column field (Bikou-ran
                            Kanji 37 characters / Alpha-numeric 75 characters) in Loss ofQualification Form data file. Data fields except Health InsuranceUnion specific item and remarks column field (Bikou-ran) inLoss of Qualification Form data file are all set by the report. To setdata to this Health Insurance Union specific item field andremarks column field (Bikou-ran), please implement BAdI provided.For detailed information of how to implement BAdI, please refer to theimplementation guide listed below.
                            • Personnel Management

                              • -> Personnel Administration
                              -> Payroll Data
                              -> Social Insurance
                              -> Insured
                              -> Submission with Data Media/Electronic Filing toHealth Insurance Union
                              -> BAdI: Maintain Loss of Qualification Data FileEditing Module
                              Note
                              It is technically possible to edit (change) data in the fields otherthan Health Insurance Union specific item and remarks columnfield (Bikou-ran) that are defined for internal table to creatingdata file via BAdI provided. If you intend to change data set by thestandard, please pay special caution not to create wrong applicationrecord. For details about BAdI, please refer to the interface documentsof above BAdI.

                              Activities
                              First, you need to specify for which Period loss ofqualificationdata to be created.
                              For employee section, you can specify employee number(s) or range ofnumbers.
                              You can also add further selections such as Company code. Thiscan be done by pushing Further selections button on the reportssection screen and select criteria you would like to use.
                              As selection conditions, you can specify social insurance modifier fortarget branch office (SI Mod. of Target Br. Office).
                              Note
                              Specifying social insurance modifier for target branch office has effecton selecting Loss of Qualification Form data of employees who areselected by employee selection condition in the specified period.
                              Note
                              Note that if you leave blank entry for social insurance modifier for target branch office, then all branch offices defined by parameter settingwill be processed. Thus, you will be requested to make an entry forsocial insurance consultant's information in Output conditiontab.
                              As selection conditions, change Create date if necessary.
                              As output condition, you need to specify which insurance type (
                              Health insurance only or Health insurance & Pension) Lossof Qualification Form data file is to be created based on the actualscenario of your company.
                              If you create Loss of Qualification Form data file for more than onesocial insurance modifier for target branch office (SI Mod. ofTarget Br. Office), you need to specify the code and name (kanji) ofcertified social insurance consultant.
                              As output file attributes, you need to specify FD serial number(starting number) and target media type.
                              As file output destination, you need to specify output destinationoption. If you choose application server as output destination, you alsoneed to specify File output path (on server). If you want to saveoutput data file directly into a local PC or TemSe, then you do not needto specify File output path (on server).
                              Note
                              When you output a file to TemSe, the TemSe object has a following name.
                              HR_LHULJ1_(FD serial number)
                              Note
                              The report stores data file(s) in the directory on an application serverspecified by File output path (on server). Thus, proper authorizationmust be set for the directory in an application server beforehand.
                              Execute the report.
                              Note
                              If there is no selection condition specified for employee selection,execution time of this report may become long since this report checksall employees.
                              It is recommended to create report variants for combination of socialinsurance modifier for target branch office and Personnel Area /Subarea in Further selections to group employees to beprocessed. Such combination(s) are defined in the Implementation Guide.Please refer to parameter settings done in the following ImplementationGuide node.
                              Personnel Management
                              -> Personnel Administration
                              -> Payroll Data
                              -> Social Insurance
                              -> Branch Office
                              -> Assign Branch Office Modifier to Personnel Area /Subarea
                              -> Modifier for social insurance and labor insurance
                              At the result screen, a list of output file(s) is displayed.
                              Note
                              When there is an error record(s) caused by insufficient employee dataand/or branch office data, buttons labeled "Employee" and/or "
                              Office" with error icon are displayed on the application tool barof result screen. Push these buttons, to check error record(s) and makenecessary corrections. Then, re-execute the report to obtain correctdata file.
                              Save data to appropriate media.
                              If you select application server as output destination and specifiedFile output path (on server), then output file(s) were alreadysaved in the directory in the application server you specified. Useappropriate software tool to retrieve and save output data file(s) toappropriate media.
                              If you want to save output file(s) into a local PC, then select a line(a file) and push Download button on the application tool bar.The reports only propose the file name KPFD0006.CSV as a default. You donot need to change this file name if you save output data file directlyinto a magnetic media of a local PC.
                              If you select TemSe as output destination then you can download the filewith utility report List of HR TemSe Objects (RPUTSV00) orDownload HR TemSe Object (RPUTSVJ0).