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. |