System Parameters

ALLOWMULTICURRENCYREPORT

YES

YES allows sub-consolidated reports to display in Local Currency, when the Unit designated Currency does not agree.

ALTCALC2_ADJ

YES

Define Where 2nd Scenario Calculation Posts

BRIDGE_ALLOW_ALL_UNITS

Y or N

Y  by default (if there is no parameter), which allows all users to bridge data into all units in the system regardless of whether or not they have access rights to the units. N removes the consolidation option for the bridge.

BRIDGE_ALLOW_SUBCON_SELECT

Y or N

Y  by default (if there is no parameter), which allows all users to bridge data into Sub Consolidations to which they have access rights. N, no longer displays the Sub Consolidation drop-down menu for the bridge.

BRIDGE_ALLOW_UNIT_SELECT

Y or N

Y  by default (if there is no parameter), which allows all users to bridge data into Units to which they have access rights. N no longer displays. The Unit drop-down list for the bridge.

BRIDGE_DEFAULT_TAG

Tag Letter

Creates a default Tag Letter to be used when data is brought in via the bridge.

BSOS_XXXX

Tag Letter_Tag Letter

Activates the Balance Sheet Offset Summary report. Balance Sheet Only amounts entered with the tags established in the system parameter are included. These amounts are rate effected and display in the appropriate column based on the tag.

CC_DISABLE_STATES

0 or 1

1 removes pre-defined states from the Data Entry > Jurisdiction drop-down list.

CLIENTDISPLAYNAME

Text

**Enter the name of the client to display on report pages in the system, as well as in the header of printed reports.

DefEndBalDefault

Tag letter and type of event

Designates where the difference is posted when Ending Balances are entered vs Activity for Book/Tax Basis Temporary Differences.Examples:

•O, A uses tag O and posts as Activity

•X, D uses tag X and posts as Deferred Only

DEF_RF_SUMMATION_COLUMN

1 through 26

Selects the column in the Deferred Balances Report to display a sub-total balance for the Adjusted Beginning Balance or any other purpose.

DEF_RF_SUMMATION_NAME

Text

Column Heading for the column created with DEF_RF_SUMMATION_COLUMN parameter.

DISABLE_DEFERREDPROVONLY

1 or 2

1 displays the Deferred Provision Only entry field. However, no entry is permitted. 2 removes the Deferred Provision Only entry field.
 
Note: This parameter does not work for the State Details page.

DISABLE_RDS_CONSTRAINTS

0 or 1

1 removes the check when joining datasets in a sequential dataset.

EffectRatesDiffStat_PermNet

0 or 1

1 The Tax Effect of Rates Different than Statutory for permanent differences is included in the respective permanent difference line.

EFFRATEBRKOUT

0 or 1

1 enables the Unit Tax Rate view in Unit and Filing Group reports. It also enables on-page breakout, as well as the Use Blended Rate view in Sub-Consolidated and Consolidated reports.

ENABLE_APICPOOL

0 or 1

1 enables the APIC Pool functionality and report.

Enable_GS_Scrunch

0 or 1

1 enables you to select a Current GAAP, Current STAT, Non-Current GAAP, and Non-Current STAT class or tag for the scrunch functionality.

ENABLE_TSDEBUG

1

Information for the support team.

EXTENDED_USER_RESTRICTION

Activate in Manage Configuration

0 or 1

**1 enables assignments made for a user in the Admin area under System/Administer Users to restrict Import of data and Batch Print reports to only assigned datasets, units and sub-consolidations.

FILTER#_NAME

Text

Names the filtered Deferred Balances Report created with the FILTER#_SQL parameter.

FILTER#_SQL

SQL query

Filters deferred balances based on a SQL query to show a subset of deferred balances.

FISCAL_MONTHS_OFFSET

0-11

0 designates a calendar year for the payable auto posting. For fiscal years, enter the fiscal month minus 12 (e.g., -1 = November; -2 = October, etc.).

Ending balances roll over to create beginning balances with the code BBAL and a date of fiscal year end plus 1 day. For example: If the paramvalue is -3, CPROV posts with a date of 9/30/CY and BBAL posts with a date of 10/1/CY.

FLOWTHROUGHFACTORS_USE_FX

0 or 1

1 displays the FX  fields (Use Fx Rates During Calculations, Beg Fx Rate, and Wgt Avg Fx Rate) on the Flow-Through Factor page.

FLOWTHROUGHFACTORS_AUTOCALC

0 or 1

1 automatically calculates flow-through factors in reports.

FLOWTHROUGHFACTORS_MANUALCALC

0 or 1

1 displays the Calculate Flow-Through Factor Results menu item in the Provision and Estimated Payments datasets.

FORMAT_FOR_EXCEL

0 or 1

1 configures the Excel output to treat Leading Zeros or Scientific Notation as text, not numbers.

GLOBAL_XSL

0 or 1

**1 activates the Global Attachments page in the Administration area. This page allow the JE style sheet to be uploaded.

GLOBAL_XSL_BROWSEUPDATE

0 or 1

**1 displays the Browse and Update Attachment button on the Global Attachments Page.

GLOBAL_XSL_SAVEAS

0 or 1

**1 displays the Attachment Save As button on the Global Attachments page.

GlobalRegion

US or EUROPE or CANADA

**Select US, EUROPE, or CANADA to determine presentation of certain terminology in the user interface and reports.

gstags#

Tag Letter

Tag Letter isolates GAAP to STAT entries on the Tax Provision report. This parameter works in conjunction with the SHOW_GAAPTOSTAT.

JE_AUTOCREATE_OUTPUTJE

0 or 1

1 Configurable Journal Entry

itstagpermsgaap-yeprovgs-1

G:Manual

Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features.

itstagpermsstat-yeprovgs-1

S:Manual

Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features.

itstagtempsgaap-yeprovgs-1

G:Manual

Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features.

itstagtempsstat-yeprovgs-1

S:Manual

Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features.

JE_AUTOREGEN_TAXCALCS

0 or 1

1 Configurable Journal Entry

JE_COMPONENT_FILTER_FEDERAL_XXX

Component ID

**Filters the Federal Component list for detail JE configurations.

JE_COMPONENT_FILTER_STATE_XXX

Component ID

**Filters the State Component list for detail JE configurations.

JE_COMPONENT_ROLLUP_SET_CODE

Alphanumeric

**The component rollup set code of the rollup group. Example: R99. (Use the Manage Rollups page to create rollup sets and groups.) Rollup groups add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_DATASET_DELETE_ALL

0 or 1

1 displays the Delete all Journal Entries menu option in the Provision  dataset under Data Review > Dataset > Administration.

JE_FILTER#

Text

**A Temporary Difference Code. # can be any number from 1-9. Filters add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_FILTER_NAME#

Text

**The name of the filter group, such as Depreciation. # can be any number from 1-9. Filters add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_ROUNDING_DECIMAL_PLACES

Any integer from -6 to 6.

Number of places to which calculated journal entries are rounded. The default value in the calculation procedure is 2 (no rounding).

JE_SHOW_ZERO_BOOKCALCS

0 or 1

1 indicates that zero dollar Book calculations display on Output Journal Entries reports.

JE_SHOW_ZERO_TAXCALCS

0 or 1

1 indicates that zero dollar Tax calculations display on Output Journal Entries reports.

JE_STATE_GROUP_NAME_#

Text

The state group name. # can be any number from 1-9. State groups add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_STATE_GROUP_%_STATE##

Text

A state code. % can be any number from 1-9 and ## can be any number form 00 - 99. State groups add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_Supplemental_Label#

Text

The header text for Output Journal Entries reports.

JE_TAG_GROUP_#_NAME

Text

The tag group name. # can be any number from 1-9. Tag groups add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_TAG_GROUP_#_TAGS

Text

A group of  tags separated by commas. Example: F, M, Q
# can be any number from 1-9. Tag groups add items to the Tax Calculation drop-down list on the Journal Entries page.

JE_TYPE_LOCKED

0 or 1

1 prevents the JE Type field on the Journal Entries page from being editable after a journal entry configuration is saved.

JE_UNIT_DELETE_ALL

0 or 1

**1 activates the Delete All button on the Journal Entries page.

LIMIT_PAYABLE_DATES

Y or N

Y allows only dates within the dataset to be used when making entries in the payable. N lifts the restriction and allows any date to be entered.

LockoutMinutes

Numeral

Number of minutes a user should be locked out of the system once they have exceeded the specified number of login attempts.

MaxFailLogins

Numeral

Number of login attempts before a user is locked out of the system.

PassHistNum

Numeral

Number of unique passwords that must be used before a user's password can be repeated.

POST_AMORTIZED

0, 1 or 2

1 posts Deferred Only adjustments to Book/Tax Basis. lines.

2 adjustments with deferred only amounts will post the RTP to the respective Tax Basis and Book/Tax Basis lines.

•Adjustments (Deferred Only amounts) posted to Temp Diff – Book/Tax Basis posts the RTP to Temp Diff – Book/Tax Basis.

•Adjustments (Deferred Only amounts) posted to Temp Diff – Tax Basis posts the RTP to Temp Diff –Tax Basis.

•Adjustments (Deferred Only amounts) posted to AT Temp Diff – Book/Tax Basis posts the RTP to AT Temp Diff – Book/Tax Basis.

•Adjustments (Deferred Only amounts) posted to AT Temp Diff – Tax Basis posts the RTP to AT Temp Diff – Tax Basis.

POST_DO

0 or 1

1 enables the calculation of Deferred Only Return to Provision (RTP) true-ups.

POST_BSO

0 or 1

1 enables the calculation of Balance Sheet Only Return to Provision (RTP) true-ups. Your adjustments with balance sheet only amounts will post the RTP to the respective Tax Basis and Book/Tax Basis lines.

POST_GAAP

1 enables the GAAP to STAT RTP posting

POST_STATE

0 or 1

1 enables the calculation of State Return to Provision (RTP) true-ups.

PRINTFORMAT_PAGESWIDE

Numeral

Number of pages reports should print to override the default of shrink to fit 1 page.

PROVISION_HIDE_STATES

0 or 1

1 adjusts the Stored Procedure Tax Provision report, so that the detailed view does not display state-by-state detail.

PROVSCBRKOUT

0 or 1

1 displays the CSC Tax Provision Report under sub-consolidation.

REPORT_FOOTER

Text

Text entered displays as a page footer on reports when printed.

REPORT_HEADER

Text

Text entered displays as a page header on reports when printed.

ReportingCurrencySymbol

Text

By adding this parameter, you can change the default three-letter reporting currency symbol (USD) that appears in the header of reports when viewed in Reporting Currency.

SEPARATESTATE#

State Code

Enter the State code to configure how the State Tax Prov Rpt Breakout displays works with the STATE_BREAKOUT_UNIT parameter. Activate in Manage Configuration

SHOW_ADVANCEDLIABILITY

0 or 1

1 allows Payable functionality and allows it to work properly. SHOW_SIMPLELIABILITY and SHOW_LIABILITY should be 0. SHOW_LIABILITY

SHOW_ALTPROVCALC

0 or 1

1 Alternative Provision Calculations

SHOW_ALTPROVCALC

0 or 1

1 Define Where 1st Scenario Calculation Posts

SHOW_BRIDGEUNITMAP

0 or 1

**1 activates the Unit Mapping page in the Manage Bridge section.

SHOW_CASHPYMTS

0 or 1

**1 activates the Cash Payments report, which displays the Return Basis Provision (formerly known as the Cash Provision) and subtracts the payments.

SHOW_CTA

0 or 1

1 enables you to manually enter Currency Translation Adjustment (CTA) calculations for all temporary differences via the Additional CTA option. The entry is in the Reporting Currency and After Tax Rate format. Depending on which fields are populated, amounts could impact both Current and Deferred Tax Expense, Deferred Only Tax Expense, or Equity. Amounts are tracked and shown on reports with a system-defined After Tax Temporary Difference.

SHOW_DEFBALCSCBRKOUT

0 or 1

1 displays the CSC Deferred Balances Report under sub-consolidation.

SHOW_EFFRATECONSOLPTBIPCT

0 or 1

1 displays an additional line in the effective tax rates that further analyzes the components in the CSC ETR Report under sub-consolidation.

SHOW_EFFRATECSCBRKOUT

0 or 1

1 displays the CSC Effective Tax Rate Report under sub-consolidation.

SHOW_EXPECTEDDEFERRED

0 or 1

1 displays the Expected Deferred Report.

SHOW_GAAPTOSTAT

0 or 1

1 allows GAAP to STAT functionality. This parameter works in conjunction with the GAAPTOSTAT and gstags parameters.

SHOW_JE

0 or 1

1 allows the Journal Entry functionality.

SHOW_LIABILITY

0 or 1

1 enables the Liability tab, if using. SHOW_ADVANCEDLIABILITY should be set to 0.

SHOW_OUTPUTJE

0 or 1

1 activates the configurable journal entry.

SHOW_PAYABLERECLASS

0 or 1

1 activates the reclass functionality to allow unit-to-unit reclass of the payable liability.

SHOW_PLUGINDEV

0 or 1

***1 to display the plug-in report settings page.

SHOW_SIMPLELIABILITY

0 or 1

1 enables Simple Liability if using. SHOW_ADVACEDLIABILITY should be set to 0.

SHOW_WORKPAPER

0 or 1

1 displays the Workpaper Report.

STATE_BREAKOUT_UNIT

Unit Code

1 Enter the Unit code to configure how the State Tax Prov Rpt Breakout display works with the SEPARATESTATE# parameter.

TBIS_ADJ

0 or 1

1 Define where BBC Calculation Posts

TSPasswordExpireDays

Numeral

1 The number determines how many days a password can be active.

TSPasswordMinDigits

Numeral

The number determines the minimum number of digits that must be in a user's password.

TSPasswordMinLength

Numeral

The number determines the minimum amount of keystrokes that must be in a user's password.

USE_OLD_AMTESTIMATOR_Default

0 or 1

**0 uses the Reporting Currency Alternative Minimum Tax (AMT) calculation method  for any new dataset that is created. 1 creates new datasets with the Local  Currency AMT methodology.

USE_SPDEFBALREPORTS

0 or 1

1 allows additional view options on the Deferred Balances report and the expanded views display on page vs. exporting to Excel.

USE_SPPROVISIONREPORTS

0 or 1

1 allows additional view options on the Tax Provision report and the expanded views display on page vs. exporting to Excel.

USE_SPPROVSUMMARYREPORTS

0 or 1

1 allows additional view options on the State Provision Summary report. The expanded views display on page vs. exporting to Excel.

UserExtended

0 or 1

1 adds more information fields about a user (email, phone, number, etc.) in the Administer User section under the Administration area under System.

CASE_INSENSITIVE_LOGIN

0 or 1

** 0 specifies that all user logins are case-sensitive.

      1 specifies that all user logins are not case-sensitive

SHOW_CASHPYMTS

0 or 1

**1 activates the Cash Payments report, which displays the Return Basis Provision (formerly known as the Cash Provision) and subtracts the payments.

SHOW_DATABASEANALYZER

0 or 1

**1 activates the TS Database Analyzer, which allows Administrators to run SQL queries on database data.

SHOW_DATABASEANALYZER

0 or 1

**1 activates the TS Database Analyzer, which allows Administrators to run SQL queries on database data.