Setting Up Setup Master Table

The following table provides details about setting up the setup master table.

Table 31-2 The Setup Master Table

Name Table or Column Name Description
Table Name SETUP_MASTER This table allows you to set certain one-time preferences. These preferences guide the application while performing various functionalities.
Component Codes BASE_LOAD_RUN_ID

This value in this column indicates the preferred Load Run ID (n_load_run_id) selection. LLFP application will load and process the complete dataset for the selected Load Run ID.

Accepted values are 0, 1, etc. The default value is set to 0.

DEFAULT_GAAP

Enter the default GAAP code to be used to filter the accounts for processing.

Accepted Values: Any GAAP Code from DIM_GAAP

LLFP_ACCOUNTS_TO_PROC

The value in this column indicates the number of accounts to be processed in a batch.

Accepted Values: Any number starting from 1, depending on the hardware size.

Default Seeded Value: 200000

LLFP_SLICE_COUNT

The value in this column indicates the number of slices of instrument data that must be chunked.

Default Value: -1

Accepted Values: Any number starting from 1, depending on the hardware size.

DEFAULT_FX_RATE_SRC

Default FX Rate Source

Example of Accepted Values: BLOOMBERG

LLFP_PARALLEL_DOP

The value in this column indicates the Degree of Parallelism for the execution of DT.

Accepted Values: Any numeric value based on the hardware size.

MIN_ECL_COHORT_SIZE

A minimum number of accounts will form part of the ECL cohort.

Example of Accepted Values: 50

LLFP_PREFERRED_RATING_ST_LT_IND

The value in this column indicates the LLFP Default Rating Type Indicator, S, or L.

Accepted Values: S or L

DT_LOG_LEVEL

The value in this column indicates the log level as Debug or Error.

Accepted values: 0 for Debug or 1 for Errors

GL_ACCOUNT_HIER General Ledger Hierarchy applicable for Subledger. The value should correspond to the applicable HIERARCHY_ID in the table DIM_GENERAL_LEDGER_HIER.