Data Dictionary  - Formula Builder

 

 

 
Table Name Fb_FbCnTkn_Content_Tokens

 

 
Table Comment This table contains the list of participating tokens for a given formula

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 
FbTkn_fb_ouinstance NUMBER(10) NOT NULL OU Instance Yes Yes

 
FbTkn_formula_id VARCHAR2(20) NOT NULL Formula id Yes Yes

 
FbTkn_component_ou NUMBER(10) NOT NULL This is the OU of the ’other’ component from where the formula is defined. If Formula is created thru ’BasFb’, then this OUInstance is nothing but the BasFb component’s Login OU. Yes Yes

 
FbTkn_component VARCHAR2(20) NOT NULL The Component which owns the formula. If the formula is defined thru BASFB component, then the componentname will be ’BasFb’ itself. Yes Yes

 
FbTkn_token_code VARCHAR2(40) NOT NULL The participating Token code of the formula. Yes No

 
FbTkn_created_by VARCHAR2(30) NULL Created By No No

 
FbTkn_created_date DATE NULL Created Date No No

 
FbTkn_modified_by VARCHAR2(30) NULL Modified By No No

 
FbTkn_modified_date DATE NULL Modified Date No No

 

 
Table Name Fb_FbMst_Formula_Master

 

 
Table Comment This table contains the list of all formula defined in the system either thru BASFB component or thru any other component

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 
FbMst_fb_ouinstance NUMBER(10) NOT NULL OUInstance of BasFb Component Yes No

 
FbMst_formula_id VARCHAR2(20) NOT NULL Formula ID Yes No

 
FbMst_component_ouinstance NUMBER(10) NOT NULL This is the OU of the ’other’ component from where the formula is defined. If Formula is created thru ’BasFb’, then this OUInstance is nothing but the BasFb component’s Login OU. Yes No

 
FbMst_component VARCHAR2(20) NOT NULL The Component which owns the formula. If the formula is defined thru BASFB component, then the componentname will be ’BasFb’ itself. Yes No

 
FbMst_formula_status VARCHAR2(5) NULL Status can be ’Active’ [’A’] or ’InActive’ [I]. No No

 
FbMst_formula_desc VARCHAR2(80) NULL Description of the formula No No

 
FBMST_FORMULA_DESC_UP VARCHAR2(80) NULL Formula id description in upper case. No No

 
FbMst_formula_content VARCHAR2(150) NULL Formula content is nothing but a mathematical expression with numbers and tokens where tokens starts with an alphabet. Tokens should be purely alpha-numeric. Only one special character ’_" is allowed No No

 
FbMst_usage_flag VARCHAR2(5) NULL This flag will have the value ’Y’ if the formula is used by Entity-Parameter screens else ’N’ No No

 
FbMst_created_by VARCHAR2(30) NULL Created By No No

 
FbMst_created_date DATE NULL Created Date No No

 
FbMst_modified_by VARCHAR2(30) NULL Modified By No No

 
FbMst_modified_date DATE NULL Modified Date No No

 
FbMst_timeStamp NUMBER(10) NULL Time Stamp No No

 

 
Table Name Fb_FbPrm_parameter_details

 

 
Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 
ComponentName VARCHAR2(80) NOT NULL Component Name. Here it is BASFB Yes No

 
ParamCategory VARCHAR2(25) NOT NULL Parameter category Yes No

 
ParamType VARCHAR2(25) NOT NULL Parameter type Yes No

 
ParamCode VARCHAR2(5) NOT NULL Parameter code Yes No

 
Langid NUMBER(10) NOT NULL Language id Yes No

 
ParamDesc VARCHAR2(80) NULL Parameter description No No

 
CreationDate DATE NULL Created Date No No

 

 
Table Name Fb_TknLst_Valid_Token_List

 

 
Table Comment This table contains the list of valid set of Tokens that can participate in a formula defined for a component. Data gets inserted into this table from components which needs to avail the formula builder service.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 
TknLst_fb_ouinstance NUMBER(10) NOT NULL BasFb’s OU Yes No

 
TknLst_component_ouinstance NUMBER(10) NOT NULL This the OU of the component which populates the list of permissible tokens for a formula Yes No

 
TknLst_component VARCHAR2(20) NOT NULL This is the Code of the Component which populates is availing the Formula Builder service Yes No

 
TknLst_token_code VARCHAR2(40) NOT NULL This column contains the valid token list permissible for formulae defined for a component. Yes No

 
TknLst_created_by VARCHAR2(30) NULL Created by No No

 
TknLst_created_date DATE NULL Created Date No No

 
TknLst_modified_by VARCHAR2(30) NULL Modified By No No

 
TknLst_modified_date DATE NULL Modified Date No No