LOY_ATTRDEFN_INT
It Holds Loyalty Attribute Definitions for Base and Translation Tables. This interface table is for Bulk Import purpose that denormalizes both base and translation tables together in a single interface table. Mapped to LOY_ATTRDEFN_B and LOY_ATTRDEFN_TL.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
LOY_ATTRDEFN_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOY_ATTRDEFN_INT_ID | NUMBER | 18 | Unique identifier of the Attribute Definition Base line in the interface table. System generated. | ||
| PROGRAM_NAME | VARCHAR2 | 50 | Program Name refers to Program Interface table as an alternate key. | ||
| BATCH_ID | NUMBER | 18 | Yes | Unique Identifier for a Batch | |
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status for the data in the interface table | ||
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier of the interface record. Internal use only. | |
| ACTION_CODE | VARCHAR2 | 30 | Indicates delete action entered by user | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | This column is created for internal use and will be populated and used by bulk import logic. | ||
| INTERNAL_ATTRDEFN_OVN | NUMBER | 9 | Object Version Number copied from corresponding Attribute Definition Base record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | 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 | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| 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. | |
| LOY_ATTRDEFN_ID | NUMBER | 18 | Reference Column to the LOY_ATTRDEFN (Primary Key to LOY_ATTRDEFN table) | ||
| ACCNT_ACT_CODE | VARCHAR2 | 30 | Account Activity Type (Accrual / Redemption / Both) | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | 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 | 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 | String/Numeric/Date | ||
| DEFAULT_VAL | VARCHAR2 | 75 | Default value to assign. | ||
| DESC_TEXT | VARCHAR2 | 1000 | Description | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Should this be displayed to Member? | ||
| DISPLAY_NAME | VARCHAR2 | 30 | Name of the Attribute to be displayed to the user. This column need translation. | ||
| DYNAMIC_FLAG | VARCHAR2 | 1 | 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 | 22 | Stores the length of the period till which points are valid. | ||
| INTERNAL_NAME | VARCHAR2 | 75 | 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 | 22 | For Point Total attribute - # of Months to get Point Total over. | ||
| OBJECT_CODE | VARCHAR2 | 30 | 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 | 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 | Whther a point type is Qualifying Point Type | ||
| REACTIVATE_FLAG | VARCHAR2 | 1 | Flag to allow the point reactivation | ||
| READONLY_FLAG | VARCHAR2 | 1 | Read only flag. | ||
| RET_EFF_FLAG | VARCHAR2 | 1 | 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 | 22 | 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 | 22 | Weight to convert to base dimension | ||
| WEIGHT_FACTOR_NQ | NUMBER | 22 | Weight to convert to base dimension (non-qualifying). | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| LANGUAGE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable columns are translated. | ||
| SOURCE_LANG_FLAG | VARCHAR2 | 4 | This flag is needed here to support MLS attributes. If the values is 'Y' then it is used to identify the row that will be responsible to perform update/insert on the _B table and create rows in _TL table for languages that are enabled in fusion but have no data in the interface table. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_ATTRDEFN_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |