PeopleSoft Global Payroll for China 9.1 PeopleBook

Reporting CNAO Standard Accounting Data

This chapter provides an overview of CNAO (National Audit Office of China) standard accounting data, and discusses how to:

Set up CNAO accounting data interface options.
Set up CNAO Shared Information data.
Set up CNAO Payroll Information data.
Create the CNAO XML file.

Understanding CNAO Standard Accounting Data

The National Audit Office of China (CNAO) publishes the accounting auditing filing standard, GB/T 24589-[Year] Financial Information Technology - Data Interface of Accounting Software. This standard mandates the filing format of accounting data, expands the scope of filing required information, and requires additional organizations to file their accounting information including payroll data. State-owned enterprises, joint ventures, public sector, and the government ministry in China are required to report information to CNAO using the CNAO standard. The standard requires that organizations generate and submit compliant XML documents.

Oracle enables you to export PeopleSoft HCM data to XML files to comply with the CNAO standard for Shared Information and Payroll Information reports.

Note. As of the date of this PeopleBook publication, the most recent CNAO standard was GB/T 24589-2010, referred to as CNAO Version 2 standard. This chapter describes compliance with the Version 2 standard.

PeopleSoft HCM Data Available for Export

PeopleSoft Global Payroll for China generates separate Shared Information and Payroll Information XML report files for these certifications:

State-owned Enterprise and Joint Venture (SOE)
Public Sector and Government Ministry (PSGM)

This table lists the PeopleSoft HCM data that is available for export to the XML files for CNAO.

CNAO Report Type	Data Item	SOE	PSGM
Shared Information	Electronic Accounting Book	Yes	Yes
	Accounting Period	Yes	Yes
	Journal Category (displays tag without values)*	Yes	NA
	Banking Account Information (displays tag without values)*	NA	Yes
	Exchange Rate Type (displays tag without values)*	Yes	Yes
	Currency	Yes	Yes
	Settlement Method (displays tag without values)*	Yes	Yes
	Department Records	Yes	Yes
	Employee Records	Yes	Yes
	Employee Category	NA	Yes
	Supplier Records (displays tag without values)*	Yes	NA
	Project (displays tag without values)*	NA	Yes
	Customer Records (displays tag without values)*	Yes	NA
Payroll Information	Payroll Periods	Yes	Yes
	Payroll Element	Yes	Yes
	Individual Payroll Records	Yes	Yes
	Individual Payroll Detailed Records	Yes	Yes

*Items marked with an asterisk are not required by CNAO, however PeopleSoft HCM makes their tags without values available for export to meet XML schema format requirements. (NA = not applicable)

Note. The pages and actions described in this chapter apply to both SOE and PSMG unless otherwise specified.

Setting Up CNAO Accounting Data Interface Options

This sections discusses how to:

Define the CNAO enterprise name.
Define accounting software default settings.
Define the parent department.

Pages Used to Set Up CNAO Accounting Data Interface Options

Page Name	Definition Name	Navigation	Usage
Company Location	COMPANY_TABLE1	Set Up HRMS, Foundation Tables, Organization, Company, Company Location	Enter the description to use as the Enterprise Name on the CNAO Shared Information report for SOE and PSGM.
Default Settings	COMPANY_TABLE2_GBL	Set Up HRMS, Foundation Tables, Organization, Company, Default Settings	Enter the currency code, translation type template, accounting period mapping, and other default settings to use for CNAO reporting.
Department Profile	DEPARTMENT_TBL_GBL	Set Up HRMS, Foundation Tables, Organization, Departments, Department Table	Identify the parent department responsible for CNAO reporting.

Defining the CNAO Enterprise Name

Access the Company Location page (Set Up HRMS, Foundation Tables, Organization, Company, Company Location).

Description

Enter or verify the company description.

Data from this field appears as the Enterprise Name on the CNAO Shared Information reports for SOE and PSGM.

Legal Entity

Enter or verify the legal entity.

Data from this field appears as the Enterprise Type on the CNAO Shared Information reports for SOE and PSGM.

Defining Accounting Software Default Settings

Access the Default Settings page (Set Up HRMS, Foundation Tables, Organization, Company, Default Settings).

Default Settings

Currency Code

Enter or verify the currency code.

Data from this field appears as Functional Currency in the CNAO Shared Information reports for SOE and PSGM.

Shared Information

Expand the China section of the Default Settings page, and enter data in the Accounting Software DI Options group box, beginning with the Shared Information sub group box.

Organization Number and Enterprise Industry

Enter or verify data in these fields.

Data from these fields appear as items of the same names in the CNAO Shared Information reports for SOE and PSGM.

Translation Type

Enter the translation type template to use for CNAO reporting.

Enter State Owned Enterprise to use the SOE template.

Enter Public Sector and Ministries to use the PSGM template.

Accounting Data Information

Electronic Book Number and Electronic Book Name

Enter or verify data in these fields.

Data from these fields appear as items of the same names in the CNAO Shared Information report for SOE and PSGM.

Accounting Period Mapping

Select the accounting period to use. The default option is Pay Date for PSGM.

If the State Owned Enterprise (SOE) translation type is used, select the Pay Date accounting period option. The Pay Date accounting period is based on the payment date in the selected calendars.

If the Public Sector and Ministries (PSGM) translation type is used, select the Earn Date accounting period option. The Earn Date accounting period is based on the period end date in the selected calendars.

For example, if the Payment Date accounting period option is selected, then the following payroll periods and payment dates are used (for an assumed 2011 reporting year):

Payroll Period Start Date	Payroll Period End Date	Payment Date
2010–Dec–01	2010–Dec–31	2011–Jan–01
2011–Jan–01	2011–Jan–31	2011–Feb–01
2011–Feb–01	2011–Feb–31	2011–Mar–01
...	...	...
2011–Nov–01	2011–Nov–20	2011–Dec–01

Or, if the Earned Date accounting period option is selected, then the following payroll periods and payment dates are used (for an assumed 2011 reporting year):

Payroll Period Start Date	Payroll Period End Date	Payment Date
2011–Jan–01	2011–Jan–31	2011–Feb–01
2011–Feb–01	2011–Feb–31	2011–Mar–01
2011–Mar–01	2011–Mar–31	2011–Apr–01
...	...	...
2011–Nov–01	2011–Nov–30	2011–Dec-01
2011–Dec–01	2011–Dec–31	2012–Jan-01

Public Sector Specific Info

Administrative Division Code, Budget Management Level and Fund Source

Enter or verify data in these fields.

Data from these fields appear as items of the same names in the CNAO Shared Information report for PSGM only.

Translation Type

Enter the translation type template to use for CNAO reporting.

Enter State Owned Enterprise to use the SOE template.

Enter Public Sector and Ministries to use the PSGM template.

Vendor/Software Information

CNAO Standard Version

Enter the CNAO standard version to apply to this reporting.

Data from this field appear as CNAO Standard Version on the CNAO Shared Information reports for SOE and PSGM.

Defining the Parent Department

Access the Department Profile page (Set Up HRMS, Foundation Tables, Organization, Departments, Department Profile).

Expand the China section of the Department Profile page.

Parent Department	Enter the parent department responsible for CNAO reporting for SOE and PSGM.
Not Display on Fin Data Rpt (not display on financial data report	When this check box is selected, the parent company information does not appear on the CNAO XML file. If you want the parent company information to appear, you must deselect this check box.

Setting Up CNAO Shared Information Data

This section discusses how to:

Define the employee category.
Assign the person profile (PSGM)

Pages Use to Set Up CNAO Shared Information Data

Page Name	Definition Name	Navigation	Usage
Employee Categorization	EMPL_CTG_L1	Set Up HRMS, Product Related, Workforce Administration, Labor Administration, Labor Agreement, Employee Categorization	Define the employee category to use within the Labor Agreement for your reporting region.
Person Profile	JPM_PROFILE_PERS	Workforce Development, Profile Management, Profiles, Person Profiles, Person Profile).	Assign the PERSON-CHN profile type to an employee and identify the employee's job class and education information to use in the CNAO Shared Information report for PSGM.

Defining the Employee Category

Access the Employee Categorization page (Set Up HRMS, Product Related, Workforce Administration, Labor Administration, Labor Agreement, Employee Categorization).

Employee category data appears on the CNAO Shared Information reports for SOE and PSGM.

Enter data on the Employee Categorization page to define employee categories within the Labor Agreement for your reporting region. The Labor Agreement is set up on the Labor Agreement page (Set Up HRMS, Product Related, Workforce Administration, Labor Administration, Labor Agreement, Labor Agreement).

Assigning the Person Profile (PSGM)

Access the Person Profile page (Workforce Development, Profile Management, Profiles, Person Profiles, Person Profile).

Data from the Person Profile page appears in employee records on the CNAO Shared Information report for PSGM only.

Profile Type

To include an employee in CNAO reporting, the employee must have a profile type of PERSON-CHN with an Active status.

China Specific Fields

Enter or verify data in the China Specific Fields group box to identify the employee's current job class and education and degree levels. The system uses the most recently added row for CNAO reporting.

Cadre Jobs, Professional & Technical Jobs, School Education, and Degrees are Content Catalog items that are defined on the Item Details page (Set Up HRMS, Product Related, Profile Management, Content Catalog, Content Items, Item Details).

Setting Up CNAO Payroll Information Data

This section discusses how to:

Define CNAO payroll element data.
Defining the CNAO payroll element group attributes.

Pages Used to Set Up CNAO Payroll Information Data

Page Name	Definition Name	Navigation	Usage
Define List Set	GP_ELN_SET	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Define List Set	Define the list set to use as payroll elements on the CNAO Payroll Information reports for SOE and PSGM.
Element Group Members page	GP_ELEMENT_GROUP	Click the Description link for an element group name on the Define List Set page.	View the definition of an element group name and change the element application default sort sequences.
Element Group Attributes	GP_ELN_SET_SEC	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Define List Set, Define List Set, and then click the Element Group Details button in the row for the desired Element Group Name.	Define the CNAO payroll element group attributes to use on the PSGM Payroll Information reports for SOE and PSGM.

Defining CNAO Payroll Element Data

Access the Define List Set page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Define List Set).

Data on the Define List Set page appears as payroll elements on the CNAO Payroll Information reports for SOE and PSGM.

Application

Enter PAY_ELEM_CHN (China Payroll Elements) for CNAO reporting.

List set applications are set up on the Define Application page (Set Up HRMS, Product Related, Global payroll & Absence Mgmt, Elements Define Application).

Warning! Do not modify the delivered PAY_ELEM_CHN list set application. Changing it can cause significant issues. Application Engine modification is required if you want to use other list set applications.

List Set Attributes

This group box appears when you enter PAY_ELEM_CHN in the Application field and exit the field.

Data in the List Set Attributes group box appears as Payroll Categoryon the CNAO Payroll Information reports for SOE and PSGM.

Pay Group and Sort Order

Enter the pay group to use.

If multiple pay groups (and therefore multiple list sets) exist for the application, you must select each pay group to use and assign the sort order in which to use them. The default sort order is 0.

Element Groups

Description

Click the Description link for an element group name to display the Element Group Members page where you can view or change element group member data, including the Application Default Sort Sequence.

Defining the CNAO Payroll Element Group Attributes

Access the Element Group Attributes page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Define List Set, Define List Set, and then click the Element Group Details button in the row for the desired Element Group Name).

Application Default Sort Seq

The default sort sequence is set on the Element Group Members page.

To change the sort sequence, return to the Define List Set page (click either OK to save attribute changes or Cancel to ignore attribute changes). Then click the Description link for the element group name whose application default sort sequence you want to change. The Element Group Members page appears in a separate window. Make the changes, save the page, and close the window. Click the Element Group Details button to return to the Element Group Attributes page.

Include/Exclude

Select the Include/Exclude check box to include the element on the CNAO XML file. Deselect the check box to exclude it.

Expenditure Category Code

(PSGM only) Enter the expenditure category code to use for each element name in the CNAO Payroll Information report for PSGM.

Expenditure category codes are ChartField1 numbers defined on the ChartField Values page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values).

See PeopleSoft HCM Application Fundamentals PeopleBook: Setting Up and Working with ChartFields and ChartField Combinations.

Creating the CNAO XML File

This section discusses how to create the CNAO XML file for SOE or PSGM. Specifically, it discusses how to:

Define the CNAO CHN file handle.
Generate the CNAO Shared Information or Payroll Information Report.
Review the CNAO XML file.

Pages Used to Generate the CNAO XML File

Page Name	Definition Name	Navigation	Usage
File Handles CHN	GPCN_FILE_HANDL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, File Handles CHN, File Handles CHN	Enter the file name and character set to use for CNAO SOE or PSGM reporting.
Create Accounting DI CHN	GPCN_CNAO_RPT	Global Payroll & Absence Mgmt, Authority Correspondence, Create Accounting DI CHN	Identify parameters for running either the CNAO Shared Information or Payroll Information report for CNAO SOE or PSGM reporting.
Business Unit List	GPCN_BUNIT_LIST	Click the Business Unit List link on the Create Accounting DI CHN page.	Select the business unit of the company whose CNAO accounting data you want to report.
Pay Entity List	GPCN_PYENT_LIST	Click the Pay Entity link on the Create Accounting DI CHN page.	(Payroll Information) Select the pay entity of the company whose CNAO payroll information you want to report.

Defining the CHN XML File Handle

Access the File Handles CHN page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, File Handles CHN, File Handles CHN).

File Name

Enter the XML file name to use for CNAO reporting.

Character Set

Enter the UTF-8 (Unicode UTF-8) character set for CNAO reporting.

Generate the CNAO Shared Information or Payroll Information Report

Access the Create Accounting DI CHN page (Global Payroll & Absence Mgmt, Authority Correspondence, Create Accounting DI CHN).

Parameters

Report Type	Select the CNAO report type to create, either Payroll Information or Shared Information. Fields appear on the page based on the report type that is selected.
Company	Enter the company whose accounting data you want to report, and enter the reporting year.
Year,	Enter the reporting year for which you want to report CNAO accounting data.
Accounting Month From, Accounting Month To and Display Periods	The Accounting Month From and Accounting Month To fields and Display Periods button appear only when the Payroll Information report type is selected. Enter the months of the reporting year to use. Click the Display Periods button to view which pay group, calendars and payment dates are included in the range of months that you selected. Note. Only finalized calendars and payrolls are can be included.
Business Unit List	Click this link to display the Business Unit List page. Enter each business unit for which you want to report accounting data to CNAO. If no business units are specified, the system reports on all departments and employees within the selected company.
Pay Entity	This link appears only when the Payroll Information report type is selected. Click the link to display the Pay Entity List page where you can identify each pay entity for which you want to report CNAO payroll information.
File Handle	Enter the file handle for the SOE or PSGM XML file template to use.

Applicable Periods for Payroll Results

This group box appears only when the Payroll Information report type is selected.

Reviewing the CNAO XML File

After you have generated the XML file, you can review it on the Process Scheduler View Log/Trace page. You can also refer to the log file Accounting DI Log.csv to review data before submitting the files.

If you are unable to save the CSV log file in CSV format, you can save it manually (from Internet Explorer) as follows:

Right click on the log file.
Select Save Target As. A popup menu appears.
In the File Name drop-down menu, type the name that you want to use with the .csv extension (for example, CNAO_XML_report.csv).
Click Save.

File Name	Enter the XML file name to use for CNAO reporting.
Character Set	Enter the UTF-8 (Unicode UTF-8) character set for CNAO reporting.