SAP Program RPLSHOJ0 - Acquisition of Qualification Form Data File for SI Office

Purpose
This report creates date file (CSV format) for Health Insurance andEmployees Pension Insurance Acquisition of Qualification Form that isfor Social Insurance (SI) Office. Data file can be for magnetic media(Floppy Disk, 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

  • 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
        • pension or pension only) acquisition of qualification formdata file is to be created.
        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 "Acquired" or "Office change"in the specified time period.
        When you select Pension only, employees who meet the followingcriteria are included in the output:
        Employees whose Acquired/Lost status of Employee's Pension iseither "Acquired" or "Office change" in the specified timeperiod.
        • It is possible to specify more than one target branch office to which
          • Acquisition of Qualification Form data is 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 create data file for floppy disk, magnet optical disk
              • and electronic filing via Internet.
              • 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:SHFD0006.CSV001, SHFD0006.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 in the pop-up screen.
                        • A Business Add In (BAdI) is available to set (or edit) remarks column
                          • field (Bikou-ran Kanji 37 characters / Alpha-numeric 75characters) in Acquisition of Qualification Form data file. Data fieldsexcept remarks column field (Bikou-ran) in Acquisition ofQualification Form data file are all set by the report. To set data tothis remarks column field (Bikou-ran), please implement BAdIprovided. For detailed information of how to implement BAdI, pleaserefer to the implementation guide listed below.
                          Personnel Management
                          -> Personnel Administration
                          -> Payroll Data
                          -> Social Insurance
                          -> Insured
                          -> Submission with Data Media/Electronic Filing toSocial Insurance Office
                          -> BAdI: Maintain Acquisition of Qualification FormData File Editing Module
                          Note
                          It is technically possible to edit (change) data in the fields otherthan remarks column field (Bikou-ran) that are defined forinternal table to creating data file via BAdI provided. If you intend tochange data set by the standard, please pay special caution not tocreate wrong application record. For details about BAdI, please refer tothe interface documents of above BAdI.

                          Activities
                          First, you need to specify for which Period Acquisition ofQualification Form data to be created.
                          For employee selection, 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 Acquisition 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 fortarget branch office, then all branch offices defined by parametersetting will be processed. Thus, you will be requested to make an entryfor social insurance consultant's information in Output conditiontab.
                          As selection conditions, change default Create date andSubtype of address infotype if necessary.
                          As output condition, you need to specify which insurance type (
                          Health insurance & Pension or Pension only) Acquisition ofQualification Form data file is to be created based on the actualscenario of your company.
                          If you create Acquisition of Qualification Form data file for more thanone social 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_LSHOJ1_(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 SHFD0006.CSV as a default. Youdo not need to change this file name if you save output data filedirectly into 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).