LOY_ATTRDEFN_B
Holds Loyalty Attribute Definition.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
LOY_ATTRDEFN_B_PK |
LOY_ATTRDEFN_B_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOY_ATTRDEFN_B_ID | NUMBER | 18 | Yes | Who column: Primary Key. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| ACCNT_ACT_CODE | VARCHAR2 | 30 | Account Activity Type (Accrual / Redemption / Both) | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Yes | indicates if the attribute definition is active and to be used. | |
| ATTR_DEFN_ID | NUMBER | 18 | The Point Type to get total of. | ||
| ATTR_TYPE_CODE | VARCHAR2 | 30 | Yes | Field/Encoded/Point/Attribute | |
| BUS_SVC_NAME | VARCHAR2 | 75 | Business Service Name | ||
| CANCEL_ACTN_CODE | VARCHAR2 | 30 | cancel action code. | ||
| COST_PER_PT | NUMBER | The general cost per point a customer can redeem a point for , normally <1. | |||
| CURCY_CODE | NUMBER | 18 | Currency Code | ||
| CURCY_EXCH_DT | DATE | Currency exchange date | |||
| DATA_TYPE_CODE | VARCHAR2 | 30 | Yes | String/Numeric/Date | |
| DEFAULT_VAL | VARCHAR2 | 75 | Default value to assign. | ||
| DESC_TEXT | VARCHAR2 | 1000 | Description | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Yes | Should this be displayed to Member? | |
| DYNAMIC_FLAG | VARCHAR2 | 1 | Yes | indicates if the attribute should only be stored in session in memory and should not be created in the DB. Available only for Attributes defined on Bucket so as to allow for performing complex calculations in memory to apply to points etc. In Memory attributes will not be written to DB but will be stored in memory. Can be viewed as virtual fields on the BC. | |
| EXPIRY_ALIGN_CODE | VARCHAR2 | 30 | Day to which the expiration date should align. E.g. Member Anniversary Date, End of Month, 1st day of quarter, etc | ||
| EXPIRY_BASIS_CODE | VARCHAR2 | 30 | Expiry basis for a point type (Account Activity / Period / Fixed Day) | ||
| EXPIRY_DAY_CODE | VARCHAR2 | 30 | Along with the Expiry Month column determines the fixed day of the year in case the Expiry Basis selected is Fixed Day | ||
| EXPIRY_MONTH_CODE | VARCHAR2 | 30 | Along with the Expiry Day column determines the fixed day of the year in case the Expiry Basis selected is Fixed Day | ||
| EXP_PD_UOM_CODE | VARCHAR2 | 30 | Stores the UOM for Expiry Period | ||
| EXP_PERIOD_LEN | NUMBER | Stores the length of the period till which points are valid. | |||
| INTERNAL_NAME | VARCHAR2 | 75 | Yes | Internal name of the Attribute such as the Field Name. If Object Type is Bucket, then we should show only the Attribute types of fields in the Promotion Bucket and also default the DATA_TYPE below to the appropriate type. | |
| MERGE_ACTION_CODE | VARCHAR2 | 30 | Action to take during the merge. For example, Default, Sum(for numeric values), Latest(for datetime values) etc. | ||
| METHOD_NAME | VARCHAR2 | 75 | Define method name to the custom attribute to calculate value | ||
| MIN_REACTIVATN_QTY | NUMBER | Stores the minimum no. of points required for Reactivation | |||
| MONTHS_LEN | NUMBER | For Point Total attribute - # of Months to get Point Total over. | |||
| OBJECT_CODE | VARCHAR2 | 30 | Yes | Object for which the Attribute is being defined. Possible values: Member, Transaction, Bucket | |
| PICK_APPLET | VARCHAR2 | 75 | Pick Applet to show in the UI when user is selecting values. | ||
| PICK_FIELD | VARCHAR2 | 75 | Field to pick from BC for row id | ||
| PICK_FIELD_NAME | VARCHAR2 | 75 | Field to pick from pick applet | ||
| PICK_LIST | VARCHAR2 | 75 | Pick List to show in the UI when user is selecting values. | ||
| PRG_FORMULA_ID | NUMBER | 18 | Promotion Formula Id | ||
| PROGRAM_ID | NUMBER | 18 | Yes | Program for which this attribute is being defined. | |
| PROMOTION_ID | NUMBER | 18 | Promotion for which this attribute is being defined. | ||
| QUAL_POINT_FLAG | VARCHAR2 | 1 | Yes | Whther a point type is Qualifying Point Type | |
| REACTIVATE_FLAG | VARCHAR2 | 1 | Yes | Flag to allow the point reactivation | |
| READONLY_FLAG | VARCHAR2 | 1 | Yes | Read only flag. | |
| RET_EFF_FLAG | VARCHAR2 | 1 | Yes | Flag at the point type level indicates if the Accrual Items have an Effective Start Date | |
| RPT_EXP_PD_UOM_CODE | VARCHAR2 | 30 | Stores the UOM for Re-activation Points Expiry Period | ||
| RPT_EXP_PERIOD_LEN | NUMBER | Stores the length of the period till which Re-activated points are valid | |||
| TIER_CLASS_ID | NUMBER | 18 | Tier Class for which this attribute is being defined | ||
| WEIGHT_FACTOR | NUMBER | Weight to convert to base dimension | |||
| WEIGHT_FACTOR_NQ | NUMBER | Weight to convert to base dimension (non-qualifying). | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| LOY_ATTRDEFN_B | loy_promo | PROMOTION_ID |
| LOY_ATTRDEFN_B | loy_attrdefn_b | ATTR_DEFN_ID |
| LOY_ATTRDEFN_B | loy_prg_frml | PRG_FORMULA_ID |
| LOY_ATTRDEFN_B | loy_tier_cls | TIER_CLASS_ID |
| LOY_ATTRDEFN_B | loy_program | PROGRAM_ID |
| loy_prog_point_block | loy_attrdefn_b | POINT_TYPE_ID |
| loy_attr_itm | loy_attrdefn_b | ATTRIB_DEFN_ID |
| loy_program | loy_attrdefn_b | POINT_TYPE_ID |
| loy_acrl_itm | loy_attrdefn_b | ATTRIB_DEFN_ID |
| loy_member | loy_attrdefn_b | MAX_POINT_TYPE_ID |
| loy_actcrtr | loy_attrdefn_b | ATTRIB_ID |
| loy_actcrtr | loy_attrdefn_b | OTHER_ATTRIB_ID |
| loy_actcrtr | loy_attrdefn_b | PMT_ATTRIB_ID |
| loy_rdm_prod | loy_attrdefn_b | POINT_TYPE_ID |
| loy_aggr_point | loy_attrdefn_b | ATTRDEFN_B_ID |
| loy_attrdefn_b | loy_attrdefn_b | ATTR_DEFN_ID |
| loy_attrdefn_tl | loy_attrdefn_b | LOY_ATTRDEFN_B_ID |
| loy_prog_neg_point | loy_attrdefn_b | POINT_TYPE_ID |
| loy_txn_stg | loy_attrdefn_b | POINT_TYPE_ID |
| loy_rdm_itm | loy_attrdefn_b | ATTRB_DEFN_ID |
| loy_txn | loy_attrdefn_b | POINT_TYPE_ID |
| loy_tier_cls | loy_attrdefn_b | QUAL_POINT_TYPE_ID |
| loy_attrib | loy_attrdefn_b | ATTRIB_DEFN_ID |
| loy_promo_atr | loy_attrdefn_b | ATTRIB_DEFN_ID |
| loy_prog_partner_pnttype | loy_attrdefn_b | POINT_TYPE_ID |
| loy_mem_blkad | loy_attrdefn_b | POINT_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_ATTRDEFN_B_F1 | Non Unique | Default | PROMOTION_ID |
| LOY_ATTRDEFN_B_F2 | Non Unique | Default | ATTR_DEFN_ID |
| LOY_ATTRDEFN_B_F3 | Non Unique | Default | PRG_FORMULA_ID |
| LOY_ATTRDEFN_B_F4 | Non Unique | Default | TIER_CLASS_ID |
| LOY_ATTRDEFN_B_U1 | Unique | FUSION_TS_TX_DATA | LOY_ATTRDEFN_B_ID |
| LOY_ATTRDEFN_B_U2 | Unique | Default | PROGRAM_ID, OBJECT_CODE, ATTR_TYPE_CODE, INTERNAL_NAME, PROMOTION_ID, CONFLICT_ID |