Creating Social Insurance Report Data Files

This section provides an overview of social insurance report data files.

Page Name

Definition Name

Usage

SI Create Remun Rpt File JPN Page

GPJP_RC_SC_RPT1

Create the report files for the Monthly Standard Remuneration Report (Revised) and the Monthly Standard Remuneration Report (Regular).

SI Create Bonus Rpt File JPN Page

GPJP_RC_SC_BNS2

Create the bonus report file.

SI Create Other Rpt File JPN Page

GPJP_RC_SC_RPT2

Create the enrollment, termination, and address change report files.

In addition to the printed reports listed previously, you can also submit some social insurance reports electronically. You can create the following files for the following reports:

  • Monthly Standard Remuneration Revised report.

  • Monthly Standard Remuneration Regular report.

  • Bonus Payment report.

  • Enrollment report.

  • Termination report.

  • Address change report.

Three processes, and therefore three run control pages, are used to create these files:

  • Remuneration report file creation.

  • Bonus report file creation.

  • Other report file creation.

Each of these processes has the same basic structure. First, they select the report data from the appropriate tables. Next, the system validates the content and the format of the report files. Last, the system places the data to a file.

If errors are found during the validation step, the system creates a detailed log file for each error that is detected. The error file includes the record row number, employee ID, health insurance card number, name, report type, field name containing the error, and an error description. The error file name follows the format gpjp_sc_det_log_process instance number. csv.

When the data is placed in the file, commas are replaced with spaces.

Remuneration Report Files

The process that is used to create both the Monthly Standard Remuneration Report (Regular) and the Monthly Standard Remuneration Calculation Report (Revised) selects rows from the Monthly Remuneration Results Record (GPJP_MTHRMN_TBL), whose object date (GPJP_OBJECT_DATE) and social insurance establishment (GPJP_TAX_ESTAB) match the values on the SI Create Remun Rpt File JPN page. The selected rows are extracted and used to create the report file.

Additionally, for the Monthly Standard Remun Calc Report (Revised), the process selects rows where the subject indicator (GPJP_SUBJECT_IND) is occasional revision. For the Monthly Standard Remun Calc Report (Regular), the process selects rows where GPJP_SUBJECT_IND is regular decision.

Note: Prior to creating the remuneration report files, you must run the load social insurance monthly remuneration process.

Bonus Report Files

The process used to create the bonus report file selects data from the Global Payroll result table (GPJP_WA_PIN) for the payees who are insured as of the end of the bonus payment month. The selected rows are extracted and used to create the report file.

Other Report Files

The process that is used to create the enrollment report, termination report, and address change report files selects data from the employee social insurance payee table (GPJP_SC_PYE_DTA) where the effective date is within the period and the SI establishment is equal to the value that is selected on the SI Create Other Rpt File JPN page.

In addition, the change reason should match the following criteria for each file:

Data File

Change Reason

Enrollment Report

New enrollment.

Re-enrollment.

Termination Report

Loss by Death.

Loss by Age.

Loss by Other Reason.

To create the Address Change report data file, the system looks for the following conditions:

  • An active row is on the Address table (ADDRESSES) whose effective date is between the period that is specified on the SI Create Other Rpt File JPN page and the address type is Home.

  • For the effective date of the active row used above, an effective row is on the social insurance payee table whose change reason is not Excluded.

  • No row is on the social insurance payee table whose effective date is equal to the address row listed previously whose change reason is New Enrollment or Re-enrollment.

Use SI Create Remun Rpt File JPN page to create the report files for the Monthly Standard Remuneration Report (Revised) and the Monthly Standard Remuneration Report (Regular).

Navigation:

Global Payroll & Absence Mgmt > Social Security/Insurance > SI Create Remun Rpt File JPN > SI Create Remun Rpt File JPN

This example illustrates the fields and controls on the SI Create Remun Rpt File JPN page. You can find definitions for the fields and controls later on this page.

 SI Create Remun Rpt File JPN page

Report Selection

Select which report data to use when creating the file.

Payee ID Type

Select the appropriate option.

Note: This option only allows you to switch insurance numbers. The generated report format complies with the social insurance agency format. It does not, however, comply with either the health insurance society and pension insurance society formats.

File Output Location

Field or Control

Description

File Handle

Select a predefined file handle.

Use the SI Create Bonus Rpt File JPN (social insurance create bonus report file Japan) page (GPJP_RC_SC_BNS2) to create the bonus report file.

Navigation:

Global Payroll & Absence Mgmt > Social Security/Insurance > SI Create Bonus Report JPN > SI Create Bonus Rpt File JPN

This example illustrates the fields and controls on the SI Create Bonus Rpt File JPN page. You can find definitions for the fields and controls later on this page.

 SI Create Bonus Rpt File JPN page

Payee ID Type

Select the appropriate option.

Note: This option only allows you to switch insurance numbers. The generated report format complies with the social insurance agency format. It does not, however, comply with either the health insurance society and pension insurance society formats.

File Output Location

Field or Control

Description

File Handle

Select a predefined file handle.

Use the SI Create Other Rpt File JPN (social insurance create other report file Japan) page (GPJP_RC_SC_RPT2) to create the enrollment, termination, and address change report files.

Navigation:

Global Payroll & Absence Mgmt > Social Security/Insurance > SI Create Other Report File JPN > SI Create Other Rpt File JPN

This example illustrates the fields and controls on the SI Create Other Rpt File JPN page. You can find definitions for the fields and controls later on this page.

 SI Create Other Rpt File JPN page

Report Selection

Select which report data to use when creating the file.

Payee ID Type

Select the appropriate option.

Note: This option only allows you to switch insurance numbers. The generated report format complies with the social insurance agency format. It does not, however, comply with either the health insurance society and pension insurance society formats.

File Output Location

Field or Control

Description

File Handle

Select a predefined file handle.