Setting Up Setup the Master Table

The following table provides details on setting up the SETUP_MASTER table.

Table 25: The Setup Master Table

Name

Table or Column Name

Description

Table Name

SETUP_MASTER

This table allows the user to set certain one-time preferences. These preferences guide the application while performing various functionalities.

Component Code

DEFAULT_GAAP

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

Accepted Values: Any GAAP Code from DIM_GAAP

Component Code

LLFP_ACCOUNTS_TO_PROC

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

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

Default Seeded Value: 200000

Component Code

LLFP_SLICE_COUNT

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

Default Value: -1

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

Component Code

DEFAULT_FX_RATE_SRC

Default FX Rate Source

Example of Accepted Values: BLOOMBERG

Component Code

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.

Component Code

MIN_ECL_COHORT_SIZE

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

Example of Accepted Values: 50

Component Code

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

Component Code

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