D_CONFIG_COMFORT_VARS

Version: 1.0

Attribute details

Attribute ID Datatype Data length Nullabe ? Label Description
INSTIT_CODE VARCHAR2 15 N Institution code
LAST_UPDATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date of last update of report data
T_PERFORMANCE_ID NUMBER 22 Y Technical identifier of performance
T_PRODUCT_ID NUMBER 22 Y Product technical identifier
T_VARIABLE_ID NUMBER 22 Y Technical identifier of the variable
T_VARIABLE_VAL_ID NUMBER 22 N Technical identifier of the variable value
VARIABLE_CODE VARCHAR2 32 Y Code of custom variable
VARIABLE_EXT_NAME VARCHAR2 240 Y External name of custom variable
VARIABLE_NAME VARCHAR2 240 Y Internal name of custom variable
VARIABLE_VALUE_L1 VARCHAR2 4000 Y Value of custom variable
VARIABLE_VALUE_L2 VARCHAR2 4000 Y Second value assigned to the custom variable (for instance: translation in foreign language)
VARIABLE_VALUE_L3 VARCHAR2 4000 Y Third value assigned to the custom variable (for instance: translation in foreign language)
VARIABLE_VALUE_L4 VARCHAR2 4000 Y Fourth value assigned to the custom variable (for instance: translation in foreign language)
VARIABLE_VALUE_L5 VARCHAR2 4000 Y Fifth value assigned to the custom variable (for instance: translation in foreign language)