2. CORE
2.99. CFTM_RATE_CODE_DEFN
Description - This Table stores the Rate Code Data Primary Key and Foreign Keys -
Column Descriptions -
PRODUCT_CODE VARCHAR2(4) Product Type
PARTY_TYPE VARCHAR2(10) Party Type (from CSTM_PARTY_TYPE_DEFN) REPEATING VARCHAR2(1) Y - Yes / N - No
MANDATORY VARCHAR2(1) Y - Yes / N - No
Primary Key BRANCH_CODE,RATE_CODE,CCY_CODE
Foreign Key FK_CFTM_RATE_CCY (BRANCH_CODE,RATE_CODE) REFERS CFTM_RATE_CODE(BRANCH_CODE,RATE_CODE)
COLUMN DATA TYPE DESCRIPTION
RATE_CODE VARCHAR2(10) Rate Code
CCY_CODE VARCHAR2(3) Rate Code Currency BRANCH_CODE VARCHAR2(3) Rate Code Branch
Primary Key BRANCH_CODE,RATE_CODE
COLUMN DATA TYPE DESCRIPTION
RATE_CODE VARCHAR2(10) Rate Code
RATE_DESCR VARCHAR2(105) Rate Code Description
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor MOD_NO NUMBER(4) Gives the latest modification number
BRANCH_CODE VARCHAR2(3) Branch Code
LOWEST_RATE_INDICAT OR
VARCHAR2(1) Column not in use
Primary Key RATE_CODE
COLUMN DATA TYPE DESCRIPTION
RATE_CODE VARCHAR2(10) Rate Code for Floating rate Maintenance RATE_CODE_DESCRIPTI
ON
VARCHAR2(105) Description of the Floating Rate Code
HOLIDAY_CCY VARCHAR2(3) Currency Of the Rate Code for which Holidays should be checked
2.100. CFTM_RATE_DETAIL
Description - This table stores the interest rates for different rate codes Primary Key and Foreign Keys -
Column Descriptions -
2.101. CFTM_RATE_MASTER
Description - This table stores the interest rates for different rate codes Primary Key and Foreign Keys -
Column Descriptions -
2.102. CFTM_RATE_SOURCE_DEFN
PROPAGATION_ACROSS _BRANCHES
CHAR(1) Rate code defined needs to be propagated to other branches or not (Y/N)
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor
Primary Key BRANCH,RATE_CODE,TENOR_CODE,CCY_CODE,EFFECTIVE_DATE,RATE_TYPE
COLUMN DATA TYPE DESCRIPTION
BRANCH VARCHAR2(3) Flexcube Branch Code
RATE_CODE VARCHAR2(10) Rate code like LIBOR, HIBOR , EURIBOR etc
TENOR_CODE VARCHAR2(12) Tenor Code
CCY_CODE VARCHAR2(3) Currency Code
EFFECTIVE_DATE DATE Effective Date
RATE_TYPE VARCHAR2(12) Rate Type
INTEREST_RATE NUMBER(13,8) Interest Rate RATE_SOURCE VARCHAR2(10) Rate Source RATE_TYPE_DESCRIPTI
ON
VARCHAR2(105) Rate Type Description
Primary Key BRANCH,RATE_CODE,TENOR_CODE,CCY_CODE,EFFECTIVE_DATE
COLUMN DATA TYPE DESCRIPTION
BRANCH VARCHAR2(3) Flexcube Branch Code
RATE_CODE VARCHAR2(10) Rate code like LIBOR, HIBOR , EURIBOR etc
TENOR_CODE VARCHAR2(12) Tenor Code
CCY_CODE VARCHAR2(3) Currency Code
EFFECTIVE_DATE DATE Effective Date
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor RATE_SOURCE VARCHAR2(10) Source of the rate
Description - This table stores the Sources of interest rates Primary Key and Foreign Keys -
Column Descriptions -
2.103. CFTM_RATE_TYPE_DEFN
Description - This table stores the Sources of interest rates Primary Key and Foreign Keys -
Column Descriptions -
2.104. CFTM_TENOR_CODE_DEFN
Description - This table stores the Tenor Code Primary Key and Foreign Keys -
Column Descriptions -
2.105. COTB_CUST_AVLD_SCHEME_DTLS
Primary Key RATE_SOURCE
COLUMN DATA TYPE DESCRIPTION
RATE_SOURCE VARCHAR2(10) Rate Source RATE_SOURCE_DESCRI
PTION
VARCHAR2(105) Rate Source Description
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT VARCHAR2(1) Authorisation status of the record
ONCE_AUTH VARCHAR2(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor
Primary Key RATE_TYPE
COLUMN DATA TYPE DESCRIPTION
RATE_TYPE VARCHAR2(12) Rate Type
RATE_TYPE_DESCRIPTI ON
VARCHAR2(105) Rate Type Description
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor
Primary Key RATE_CODE,TENOR_CODE
COLUMN DATA TYPE DESCRIPTION
RATE_CODE VARCHAR2(10) Rate Code
TENOR_CODE VARCHAR2(10) Tenor Code
TENOR_CODE_DESCRIP TION
VARCHAR2(105) Tenor Code Description
Description - This is the table for Customer Availed Scheme details Primary Key and Foreign Keys -
Column Descriptions -
2.106. COTB_CUST_SCHEME_DETAILS
Description - This is the table for Customer Scheme Details Primary Key and Foreign Keys -
Column Descriptions -
2.107. COTM_BENEFIT_DETAILS
Description - This is the table for Customer Benefit Details
Primary Key RP_REF_NO
COLUMN DATA TYPE DESCRIPTION
CUSTOMER_NO VARCHAR2(9) Customer No
CUST_AC_NO VARCHAR2(20) Customer Account No TRN_REF_NO VARCHAR2(16) Transaction Reference Number
BEN_PROC_DATE DATE Benefit Process Date
SCHEME_ID VARCHAR2(35) Scheme ID
BEN_PLAN_ID VARCHAR2(35) Benefit Plan ID EL_PLAN_ID VARCHAR2(35) Eligibility Plan ID PRICE_COMP VARCHAR2(35) Price Components
BEN_TYPE VARCHAR2(1) Benefit Type
VAR_TYPE VARCHAR2(1) Variance Type
VAR_CCY VARCHAR2(3) Variance Currency
VAR_VALUE NUMBER(22,3) Variance Value ORIGINAL_COMPUTED_P
RICE
NUMBER(22,3) Computed Price
FINAL_PRICE NUMBER(22,3) Final Price
PRICE_CCY VARCHAR2(3) Price Currency
RP_REF_NO VARCHAR2(16) Reference Number
Primary Key CUSTOMER_NO,SCHEME_ID,EL_PLAN_ID,BEN_START_DT
COLUMN DATA TYPE DESCRIPTION
CUSTOMER_NO VARCHAR2(9) Customer Number
SCHEME_ID VARCHAR2(35) Scheme ID
EL_PLAN_ID VARCHAR2(35) Eligibility Plan ID
BEN_START_DT DATE Benefit Start Date
BEN_END_DT DATE Benefit End Date
LINKAGE_STAT VARCHAR2(1) Linkage Status
LINKAGE_DATE DATE Linkage Date
PREV_LINKAGE_STAT VARCHAR2(1) Previous Linkage Status LAST_STAT_CHNG_DT DATE Last Status Change Date STAT_REASON VARCHAR2(255) Status Reason
MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO VARCHAR2(4) Gives the latest modification number
Primary Key and Foreign Keys -
Column Descriptions -
2.108. COTM_BENEFIT_MASTER
Description - This is the primary table for the FLEXCUBE Customer Benefit Plans Primary Key and Foreign Keys -
Column Descriptions -
2.109. COTM_COMMON_FUNCTIONS
Description - This is the table for the Charge Component for Function Id Primary Key and Foreign Keys -
Column Descriptions -
Primary Key BEN_PLAN_ID,MODULE,PRODUCT,PRICE_COMP
Foreign Key FK_COTM_BENEFIT_DETAILS (BEN_PLAN_ID,MODULE) REFERS COTM_BENEFIT_MASTER(BEN_PLAN_ID,MODULE)
COLUMN DATA TYPE DESCRIPTION
BEN_PLAN_ID VARCHAR2(35) Benefit Plan ID
PRODUCT VARCHAR2(4) Product
PRICE_COMP_TYPE VARCHAR2(1) Price Component Type PRICE_COMP VARCHAR2(35) Price Components
BEN_TYPE VARCHAR2(1) Benefit Type
VAR_TYPE VARCHAR2(1) Variance Type
VAR_CCY VARCHAR2(3) Variance Currency
VAR_VALUE NUMBER Variance Value
VAR_RULE VARCHAR2(35) Variance Rule
VAR_CCY2 VARCHAR2(3) Variance Currency
BUY_SPREAD NUMBER Buy Spread
SALE_SPREAD NUMBER Sale Spread
MODULE VARCHAR2(2) Module
MAX_VALUE NUMBER Maximum Value
MIN_VALUE NUMBER Minimum Value
Primary Key BEN_PLAN_ID,MODULE
COLUMN DATA TYPE DESCRIPTION
BEN_PLAN_ID VARCHAR2(35) Benefit Plan ID BEN_PLAN_DESC VARCHAR2(105) Benefit Plan Description
MODULE VARCHAR2(2) Module Code
PRIORITY_NO VARCHAR2(5) Priority Number
MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO VARCHAR2(4) Gives the latest modification number
Primary Key FUNCTION_ID,FUN_NAME
COLUMN DATA TYPE DESCRIPTION
FUNCTION_ID VARCHAR2(35) Function Id
2.110. COTM_CUSTOMER_RVT
Description - This is the primary table for the FLEXCUBE Customer Relationship Value Tag Details Primary Key and Foreign Keys -
Column Descriptions -
2.111. COTM_CUST_SCHEME_LINK
Description - This is the primary table for the FLEXCUBE Customer Scheme Linkage Primary Key and Foreign Keys -
Column Descriptions -
2.112. COTM_CUST_SCHEME_LINK_DTLS
Description - This is the table for the FLEXCUBE Customer Scheme Linkage Details Primary Key and Foreign Keys -
FUN_NAME VARCHAR2(200)
FUNCTION_DESC VARCHAR2(105) Function Description
Primary Key CUSTOMER_NO,RVT_CODE
Foreign Key FK_COTM_CUSTOMER_RVT (CUSTOMER_NO) REFERS STTM_CUSTOMER(CUSTOMER_NO)
COLUMN DATA TYPE DESCRIPTION
CUSTOMER_NO VARCHAR2(9) Customer Number
RVT_CODE VARCHAR2(35) Relationship Value Tag Code RVT_CODE_VALUE VARCHAR2(20) Relationship Value Tag Value SOURCE_CODE VARCHAR2(15) Source Code
MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO NUMBER(4) Gives the latest modification number
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
Primary Key CUSTOMER_NO
Foreign Key FK_COTM_CUST_SCHEME_LINK (CUSTOMER_NO) REFERS STTM_CUSTOMER(CUSTOMER_NO)
COLUMN DATA TYPE DESCRIPTION
CHECKER_ID VARCHAR2(12) Authorizer CUSTOMER_NO VARCHAR2(9) Customer Number
MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO NUMBER(4) Gives the latest modification number
Primary Key CUSTOMER_NO,SCHEME_ID
Column Descriptions -
2.113. COTM_ELPLAN_MASTER
Description - This is the primary table for the FLEXCUBE Customer Eligibility Plans Primary Key and Foreign Keys -
Column Descriptions -
2.114. COTM_ELPLAN_RDE
Description - This is the table for the Relationship Data Element for Eligibility Plans Primary Key and Foreign Keys -
Column Descriptions -
2.115. COTM_FUNCTION_PARAMS
Description - This is the primary table for the FLEXCUBE Function Parameters Primary Key and Foreign Keys -
Column Descriptions -
Foreign Key FK_COTM_CUST_SCHEME_LINK_DTLS (CUSTOMER_NO) REFERS COTM_CUST_SCHEME_LINK(CUSTOMER_NO)
COLUMN DATA TYPE DESCRIPTION
CUSTOMER_NO VARCHAR2(9) Customer Number
SCHEME_ID VARCHAR2(35) Scheme ID
BEN_START_DT DATE Benefit Start Date
BEN_END_DT DATE Benefit End Date
Primary Key EL_PLAN_CODE
COLUMN DATA TYPE DESCRIPTION
EL_PLAN_CODE VARCHAR2(35) Eligibility Plan ID EL_PLAN_DESC VARCHAR2(105) Eligibility Plan Description EL_CONDITION VARCHAR2(4000) Eligibility Condition
MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO VARCHAR2(4) Gives the latest modification number
Primary Key EL_PLAN_CODE,RDE_CODE,RDE_TYPE
Foreign Key FK_COTM_ELPLAN_RDE (EL_PLAN_CODE) REFERS COTM_ELPLAN_MASTER(EL_PLAN_CODE)
COLUMN DATA TYPE DESCRIPTION
EL_PLAN_CODE VARCHAR2(35) Eligibility Plan ID
RDE_CODE VARCHAR2(35) Relationship Data Element Code RDE_TYPE VARCHAR2(1) Relationship Data Element Type
RDE_PARAM_VAL VARCHAR2(35) Relationship Data Element Parameter Value
Primary Key FUNCTION_ID,PARAM_NAME,RETURN_TYPE
2.116. COTM_RP_CHARGE
Description - This is the table for the FLEXCUBE Relationship Pricing Charges Primary Key and Foreign Keys -
Column Descriptions -
2.117. COTM_RP_MODULE
Description - This is the table for the Relationship Pricing Modules Primary Key and Foreign Keys -
Column Descriptions -
2.118. COTM_RVT
Description - This is the primary table for the FLEXCUBE Relationship Value Tag Primary Key and Foreign Keys -
Column Descriptions -
COLUMN DATA TYPE DESCRIPTION
FUNCTION_ID VARCHAR2(35) Function Id PARAM_NAME VARCHAR2(20) Parameter Name RETURN_TYPE VARCHAR2(20) Return Type
Primary Key MODULE,CHARGE_COMP
Foreign Key FK_COTM_RP_CHARGE (MODULE) REFERS SMTB_MODULES(MODULE_ID)
COLUMN DATA TYPE DESCRIPTION
MODULE VARCHAR2(2) Module Code
CHARGE_COMP VARCHAR2(10) Charge Component COMP_DESC VARCHAR2(105) Component Description
Primary Key MODULE
Foreign Key FK_COTM_RP_MODULE (MODULE) REFERS SMTB_MODULES(MODULE_ID)
COLUMN DATA TYPE DESCRIPTION
MODULE VARCHAR2(2) Module Code
MODULE_DESC VARCHAR2(105) Module Description
INTEREST VARCHAR2(1) Interest
CHARGE VARCHAR2(1) Charge
COMMISION VARCHAR2(1) Commision
FEES VARCHAR2(1) Fees
Primary Key RVT_CODE
COLUMN DATA TYPE DESCRIPTION
RVT_CODE VARCHAR2(35) Relationship Value Tag Code RVT_DESC VARCHAR2(105) Relationship Value Tag Descritpion MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO NUMBER(4) Gives the latest modification number
2.119. COTM_SCHEME_DETAIL
Description - This is the table for the FLEXCUBE Customer Scheme Details Primary Key and Foreign Keys -
Column Descriptions -
2.120. COTM_SCHEME_MASTER
Description - This is the primary table for the FLEXCUBE Customer Scheme Details Primary Key and Foreign Keys -
Column Descriptions -
2.121. COTM_SDE_MASTER
Description - This table has information of System Data elements Primary Key and Foreign Keys -
Primary Key SCHEME_ID,BEN_PLAN_ID
Foreign Key FK_COTM_SCHEME_DETAIL (SCHEME_ID) REFERS COTM_SCHEME_MASTER(SCHEME_ID)
COLUMN DATA TYPE DESCRIPTION
SCHEME_ID VARCHAR2(35) Scheme Id
BEN_PLAN_ID VARCHAR2(35) Benefit Plan ID
MODULE VARCHAR2(2) Module Code
Primary Key SCHEME_ID
COLUMN DATA TYPE DESCRIPTION
SCHEME_ID VARCHAR2(35) Pricing Scheme ID
SCHEME_DESC VARCHAR2(105) Pricing Scheme ID Description
SC_START_DT DATE Scheme Start Date
SC_END_DT DATE Scheme End Date
BEN_VALID_PERIOD NUMBER Benefit Validity Period BEN_VALID_BASIS VARCHAR2(1) Benefit Validity Basis VALID_TYPE VARCHAR2(1) Validity Type
APPLY_FOR VARCHAR2(1) Apply For
EXEC_TYPE VARCHAR2(1) Execution Type
RENEW_TYPE VARCHAR2(1) Eligibility Type EL_PLAN_CODE VARCHAR2(35) Eligibility Plan ID
EL_REV_FREQ VARCHAR2(1) Eligibility Revision Frequency
FIRST_REV_DT DATE First Revision Date
LAST_REV_DT DATE Last Revision Date
NEXT_REV_DT DATE Next Revision Date
SCHEME_RP_DESC VARCHAR2(1000) Scheme Advice Description BEN_EXPIRY VARCHAR2(1) Benefit End on Scheme Expiry MAKER_ID VARCHAR2(12) Id of the person who created the record CHECKER_ID VARCHAR2(12) Authorizer
MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_DT_STAMP DATE Authorization date by supervisor
ONCE_AUTH VARCHAR2(1) Authorised once
AUTH_STAT VARCHAR2(1) Authorisation status of the record
RECORD_STAT VARCHAR2(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
MOD_NO VARCHAR2(4) Gives the latest modification number SCHEME_STATUS VARCHAR2(1) Scheme Status
Column Descriptions -
2.122. COTM_SOURCE
Description - This table contains information of Upload Source Maintenance Primary Key and Foreign Keys -
Column Descriptions -
2.123. COTM_SOURCE_PREF
Description - This table contains information about Upload Source Preferences Maintenance Primary Key and Foreign Keys -
Column Descriptions -
Primary Key MODULE,SDE_ID
COLUMN DATA TYPE DESCRIPTION
SDE_TYPE VARCHAR2(1) System Data Element Type
MODULE VARCHAR2(2) Module Code
SDE_ID VARCHAR2(35) System Data Element ID
TABLE_NAME VARCHAR2(35) Table Name
COLUMN_NAME VARCHAR2(200) Column Name FUNCTION_NAME VARCHAR2(500) Function Name PARAM_REQ VARCHAR2(1) Parameter Required PARAM_NAME VARCHAR2(200) Parameter Name
SDE_DESC VARCHAR2(105) System Data Element Description
Primary Key SOURCE_CODE
COLUMN DATA TYPE DESCRIPTION
SOURCE_CODE VARCHAR2(15) Source Code
SOURCE_DESC VARCHAR2(105) Source Code Description
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor BASE_DATA_FROM_FC VARCHAR2(1) Base Data From Flexcube
Primary Key SOURCE_CODE,MODULE_CODE
Foreign Key FK_COTM_SOURCE_PREF (SOURCE_CODE) REFERS COTM_SOURCE(SOURCE_CODE)
COLUMN DATA TYPE DESCRIPTION
SOURCE_CODE VARCHAR2(15) Source Code
MODULE_CODE VARCHAR2(2) Module Code
UPLOADED_STATUS CHAR(1) Post Upload Status
ON_ERROR CHAR(1) On Exception
ON_OVERRIDE CHAR(1) On Override
PROCEED_WITH_EOD CHAR(1) Proceed with EOD DELETE_ALLOWED CHAR(1) Deleted Allowed REVERSE_ALLOWED CHAR(1) Reversal Allowed
AMEND_ALLOWED CHAR(1) Amend Allowed
RECORD_STAT CHAR(1) THIS REFERST TO THE RECORD STATUS, OPEN OR CLOSED
2.124. COTM_UDE_FUNCTION
Description - This table contains information about Relationship Pricing - User Data Elements Maintenance Primary Key and Foreign Keys -
Column Descriptions -
2.125. COTM_UDE_FUNCTIONS
Description - This table contains information about Relationship Pricing - User Data Elements Maintenance Primary Key and Foreign Keys -
Column Descriptions -
2.126. COTM_UDE_MASTER
Description - This is the primarytable for the Relationship Pricing - User Data Elements Primary Key and Foreign Keys -
Column Descriptions -
AUTH_STAT CHAR(1) Authorisation status of the record
ONCE_AUTH CHAR(1) Authorised once
MOD_NO NUMBER(4) Gives the latest modification number MAKER_ID VARCHAR2(12) Id of the person who created the record MAKER_DT_STAMP DATE Gives the date when the record was created by CHECKER_ID VARCHAR2(12) Authorizer
CHECKER_DT_STAMP DATE Authorization date by supervisor PURGE_DAYS NUMBER(4) Purge Days(Calender)
ALLOW_DEFERRED_PRO CESSING
VARCHAR2(1) Allow Deferred Processing
ALLOW_EOD_WITH_DEF ERRED
VARCHAR2(1) Allow EOD with Deferred
ALLOW_DELETE VARCHAR2(1) Allow Delete
Primary Key UDE_CODE,PARAM_NAME
Foreign Key FK_COTM_UDE_FUNCTION (UDE_CODE) REFERS COTM_UDE_MASTER(UDE_CODE)
COLUMN DATA TYPE DESCRIPTION
UDE_CODE VARCHAR2(35) User Data Element Code PARAM_NAME VARCHAR2(20) Parameter Name
UDE VARCHAR2(35) User Data Element
SDE VARCHAR2(35) System Data Element
CONSTANT VARCHAR2(20) Constant
Foreign Key FK_COTM_UDE_FUNCTIONS (UDE_CODE) REFERS COTM_UDE_MASTER(UDE_CODE)
COLUMN DATA TYPE DESCRIPTION
UDE_CODE VARCHAR2(35) User data element code PARAM_NAME VARCHAR2(20) Parameter name
UDE VARCHAR2(35) User data element
SDE VARCHAR2(35) System data element
CONSTANT VARCHAR2(20) Constant
Primary Key UDE_CODE
COLUMN DATA TYPE DESCRIPTION
UDE_BASIS VARCHAR2(1) User Data Element Basis UDE_DATA_TYPE VARCHAR2(1) User Data Element Datatype