Uploading and Maintaining XBRL Facts and Taxonomy Elements

Pages Used to Upload Facts and Taxonomy Elements

Page Name	Definition Name	Navigation	Usage
Define File Layout	XBRL_FILE_DFN	select EPM Foundation, then select XBRL Reporting, then select Import Data, then select Define File Layout	Review the delivered file definitions and file layouts.
Load Data	XBRL_DATA_LD	select EPM Foundation, then select XBRL Reporting, then select Import Data, then select Load Data	Upload taxonomy elements or instance facts.
Maintain Taxonomy Elements	XBRL_ELEMENTS	select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Taxonomy Elements	Review or update taxonomy elements that you have uploaded.
Maintain Footnotes	XBRL_FOOTNOTES	select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Footnotes	Review or update footnotes.
Maintain Footnotes – Fact References	XBRL_FNOTES_REF	select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Footnotes, then select Fact References	Review or update footnote fact references.
Maintain Instance Facts	XBRL_INST_FACT	select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Instance Facts	Review or update instance facts that you have uploaded.

Understanding Data Upload Requirements

We provide a generic data upload utility, the Load Data Application Engine process, to import your mapped taxonomy elements, financial instance facts, and disclosure facts into the system. File layouts are delivered for comma separated value (CSV) and tab separated value (TSV) text files. Typically, you will prepare the data using a spreadsheet program and save it as a CSV or TSV file. The following sections describe the required file layouts.

File Layout for Taxonomy Elements

The following table lists the required format for the file that contains the mapped taxonomy elements.

Field Nbr	Field Name	Long Name	Field Type	Format	Length
1	PS_ELEMENT	Element Id in PSFT	CHAR		30
2	EFFDT	Effective Date	DATE	YYYY/MM/DD	10
3	TAXONOMY_ID	Taxonomy ID	CHAR		10
4	NAMESPACE_ALIAS	Namespace Alias	CHAR		10
5	XBRL_ELEMENT_NAME	Element Name	CHAR		254
6	EFF_STATUS	Status as of Effective Date	CHAR		1
7	XBRL_ELEMENT_LBL	XBRL Element Label	CHAR		254
8	DRCR	XBRL Balance	CHAR		15
9	XBRL_DATATYPE	Data Type	CHAR	NUM/TXT	3

The following example shows a spreadsheet that contains taxonomy elements using the required format. PS Element is the user-defined ID you will use in PeopleSoft EPM for the element.

Image: Taxonomy Elements

This example illustrates the Taxonomy Elements.

Note: The date field format is YYYY/MM/DD. For example, the date Jul 01, 2009 should be formatted as 2009/07/01.

File Layout for Financial Report Facts

The following table lists the required format for the file that contains the element facts for financial reports.

Field Nbr	Field Name	Edit Table	Long Name	Field Type	Length
1	TAXONOMY_ID	XBRL_TAXONOMY	Taxonomy ID	CHAR	10
2	ENTITY_NAME	XBRL_ENTITY	Entity Name	CHAR	50
3	REPORT_ID	XBRL_RPT_DEFN	Report ID	CHAR	8
4	XBRL_CONTEXT_ID	XBRL_CONTEXT	XBRL Context Identifier	CHAR	30
5	LINE_NBR		Line Number	NUM	5
6	PS_ELEMENT	XBRL_ELEMENTS	Element ID in PSFT	CHAR	30
7	XBRL_UOM_ID	XBRL_UOM	XBRL Unit of Measure ID	CHAR	30
8	XBRL_DECIMALS		Rounded to Decimals	CHAR	20
9	XBRL_AMOUNT		Amount	CHAR	30
10	XBRL_FOOTNOTE_ID	XBRL_FOOTNOTES	Foot Note Id	CHAR	30

The following example shows a spreadsheet that contains element facts for financial reports using the required format. PS Element is the user-defined ID you will use in PeopleSoft EPM for the element.

Image: Element Facts for Financial Reports

This example illustrates the Element Facts for Financial Reports.

The decimal column specifies rounding. If the amount is rounded to thousands, the decimal value is "-3". If the amount is rounded to millions, the decimal value is "-6". The Amount field should be populated as per the XBRL guidance.

You should ensure that these are not comma formatted. For Example, 2 million USD rounded to millions should be represented as:

Decimal = -6 and Amount = 2000000

File Layout for Disclosure Schedule

The disclosure schedule (table) has two additional columns for Dimension and Segment (dimension member). The following table lists the required format for the file that contains the disclosure facts.

Field Nbr	Field Name	Edit Table	Long Name	Field Type	Length
1	TAXONOMY_ID	XBRL_TAXONOMY	Taxonomy ID	CHAR	10
2	ENTITY_NAME	XBRL_ENTITY	Entity Name	CHAR	50
3	REPORT_ID	XBRL_RPT_DEFN	Report ID	CHAR	8
4	XBRL_CONTEXT_ID	XBRL_CONTEXT	XBRL Context Identifier	CHAR	30
5	LINE_NBR		Line Number	NUM	5
6	PS_ELEMENT	XBRL_ELEMENTS	Element ID in PSFT	CHAR	30
7	XBRL_DIMENSION	XBRL_ELEMENTS	Dimension	CHAR	30
8	XBRL_SEGMENT	XBRL_ELEMENTS	XBRL Segment	CHAR	100
9	XBRL_UOM_ID	XBRL_UOM	XBRL Unit of Measure ID	CHAR	30
10	XBRL_DECIMALS		Rounded to Decimals	CHAR	20
11	XBRL_AMOUNT		Amount	CHAR	30
12	XBRL_FOOTNOTE_ID	XBRL_FOOTNOTES	Foot Note ID	CHAR	30

The following example shows a spreadsheet that contains disclosure facts using the required format.

Image: Disclosure Facts Formatting

This example illustrates the Disclosure Facts Formatting.

Define File Layout Page

Use the Define File Layout page (XBRL_FILE_DFN) to review the delivered file definitions and file layouts.

Navigation

select EPM Foundation, then select XBRL Reporting, then select Import Data, then select Define File Layout

Image: Define File Layout page

This example illustrates the fields and controls on the Define File Layout page. You can find definitions for the fields and controls later on this page.

The following table lists the delivered file definitions. You should not modify these.

File Definition	File Layout	Format	Description
DISCL_CSV	XBRL_DISCL_FACTS_CSV	CSV	Use this file layout to upload disclosure schedule data in CSV format.
DISCL_TSV	XBRL_DISCL_FACTS_TSV	TSV	Use this file layout to upload disclosure schedule data in TSV format.
ELMTS_CSV	XBRL_ELEMENTS_CSV	CSV	Use this file layout to upload taxonomy elements in CSV format.
ELMTS_TSV	XBRL_ELEMENTS_TSV	TSV	Use this file layout to upload taxonomy elements in TSV format.
FACTS_CSV	XBRL_INST_FACT_CSV	CSV	Use this file layout to upload financial instance facts in CSV format.
FACTS_TSV	XBRL_INST_FACT_TSV	TSV	Use this file layout to upload financial instance facts in TSV format.

Load Data Page

Use the Load Data page (XBRL_DATA_LD) to upload taxonomy elements or instance facts.

Navigation

select EPM Foundation, then select XBRL Reporting, then select Import Data, then select Load Data

Image: Load Data run control page

This example illustrates the fields and controls on the Load Data run control page. You can find definitions for the fields and controls later on this page.

Attach

Click this button to browse to and attach the file to import.

View

Click this button to view an attached file.

Delete

Click this button to delete an attached file.

First Data Line

Enter the line number where the actual data begins. For example, if the first row of your file contains headings, then you should enter 2, if not, enter 1.

File Definition

Specify the file definition to use for the import. The delivered file definitions that you use are:

DISCL_CSV: Select to import disclosure facts in CSV format.
DISCL_TSV: Select to import disclosure facts in TSV format.
ELMTS_CSV: Select to import taxonomy elements in CSV format.
ELMTS_TSV: Select to import taxonomy elements in TSV format.
FACTS_CSV: Select to import financial element facts in CSV format.
FACTS_TSV: Select to import financial element facts in TSV format.

Load Option

Specify how to handle duplicate rows. Values are:

Insert and/or Update: Select to load all rows. If duplicate rows exist, they are replaced with the new data in the source file.
Ignore rows that already exist: Select to only load new rows. If duplicate rows exist they are rejected. In other words, the existing data is retained, while new data is loaded.

File Errors Option

Specify how to handle errors during the import process. Value are:

Abort run without loading data: Select to reject the file without loading any data. Error rows are written to the error log.
Skip errors rows and continue: Select to load only valid rows. Rejected rows are written to the error log.

Run

Click to start the data upload process.

After running the process, review errors logs (if any) and take the necessary corrective actions.

The Load Data process does not use EPM job streams. Instead, the process uses online temporary table instances, and Peopletools manages the assignment of temporary tables. The instance count for the Load Data process has been set to 3. Make sure that the "Online Temp Table Instances" parameter in PeopleTools Options is configured to at least 3.

Maintain Taxonomy Elements Page

Use the Maintain Taxonomy Elements page (XBRL_ELEMENTS) to review or update taxonomy elements that you have uploaded.

Navigation

select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Taxonomy Elements

Image: Maintain Taxonomy Elements page

This example illustrates the fields and controls on the Maintain Taxonomy Elements page . You can find definitions for the fields and controls later on this page.

Use this page to maintain the taxonomy elements that you upload.

Element ID

Each element ID represents a combination of taxonomy element name and the namespace it belongs to. The element ID is referenced in the instance facts, and also when you create an XBRL instance. This is a user-defined field, in other words, you decide what ID to use.

Taxonomy ID

The taxonomy this element is associated with. You set up taxonomy IDs using the Define Taxonomy page.

Prefix

The namespace prefix (alias) for the element.

Name

The taxonomy element name, as defined in the taxonomy schema.

Label

The taxonomy element label, as defined in the taxonomy schema.

Balance

Balance type can be Debit or Credit. This field is blank for some elements that are used for footnotes and cash flow line items.

Data Type

Values are Numeric or Text.

Maintain Footnotes Page

Use the Maintain Footnotes page (XBRL_FOOTNOTES) to review or update footnotes.

Navigation

select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Footnotes

Image: Maintain Footnotes page

This example illustrates the fields and controls on the Maintain Footnotes page. You can find definitions for the fields and controls later on this page.

You can create or update footnotes using this page, and use the Fact References tab to review the instance facts they are associated with. The footnotes may be associated to an element representing a report line or it may have its own element. In the later case, the amount and UOM fields will be blank.

Copy

Click this button to copy the current footnote to a new Footnote ID.

Language ISO Locale

Enter the ISO language code for the footnote.

Type

Specify the type of footnote. Values are:

General Footnote: Select for a footnote that does not reference a report line item.
Reference to Report Line Item: Select for a footnote that references a line item on the report, and enter the report line number it is associated with in the Footnote# field.

Maintain Instance Facts Page

Use the Maintain Instance Facts page (XBRL_INST_FACT) to review or update instance facts that you have uploaded.

Navigation

select EPM Foundation, then select XBRL Reporting, then select Maintain Data, then select Maintain Instance Facts

Image: Maintain Instance Facts page

This example illustrates the fields and controls on the Maintain Instance Facts page . You can find definitions for the fields and controls later on this page.

Use this page to review and maintain the instance facts that you upload. You can associate footnotes with a fact by selecting a Footnote ID.