LOY_TIER_INT
This is a Member Tier related interface data table for Bulk Import purpose. Mapped to LOY_MEM_TIER.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
LOY_TIER_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOY_TIER_INT_ID | NUMBER | 18 | Unique identifier of the Loyalty Tier line in the interface table. System generated. | ||
| 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_TIER_OVN | NUMBER | 9 | Object Version Number copied from corresponding Loyalty Tier 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_TIER_ID | NUMBER | 18 | Reference Column to the LOY_TIER (Primary Key to LOY_TIER table) | ||
| CARD_DESC_TEXT | VARCHAR2 | 250 | Card description | ||
| CARD_TYPE_CODE | VARCHAR2 | 30 | Membership card type. Can be regular silver, gold... | ||
| DEM_TIER_ID | NUMBER | 18 | Dem Tier Id | ||
| DESC_TEXT | VARCHAR2 | 250 | Descriptive text. | ||
| DWNGRD_APPRV_FLAG | VARCHAR2 | 1 | Downgrade approval required flag used in batch processing. | ||
| EXPIRE_POINTS_FLAG | VARCHAR2 | 1 | Flag if points do not expire while a member belongs to this tier. | ||
| EXP_SNAPTO_CODE | VARCHAR2 | 30 | Indicates the day to which the expiration date should snap to. E.g. End of Month, 1st day of quarter, etc | ||
| EXTENSION_DAYS_NUM | NUMBER | 22 | The point expiration extension in days defined on tier level. It can be 30, 60, 365 etc. E.g. Your Mileage Plus miles dont expire provided you earn or redeem any amount of miles at least once every 365 days. | ||
| GRACE_PERIOD_LEN | NUMBER | 22 | Grace period Length. | ||
| GRACE_PERIOD_UOM | VARCHAR2 | 30 | Grace Period Uom | ||
| LOUNGE_CODE | VARCHAR2 | 30 | Lounge type, can be silver, gold... | ||
| LOUNGE_DESC_TEXT | VARCHAR2 | 250 | Lounge description | ||
| LWST_DEM_TIER_ID | NUMBER | 18 | Lwst Dem Tier Id | ||
| NAME | VARCHAR2 | 30 | Name | ||
| NON_QUAL_EXP_LEN | NUMBER | 22 | Non Qual Exp Len | ||
| NON_QUAL_EXP_UOM | VARCHAR2 | 30 | Non Qual Exp Uom | ||
| ONLY_ACTIVITY_FLAG | VARCHAR2 | 1 | When this flag is checked a statement will only be created and sent if there was activity during the statement period | ||
| POINT_TYPE_A_REQ | NUMBER | 22 | The number of points required to reach this tier from the next lowest tier. This value does not have any effect on how the rules are actually calculated. | ||
| POINT_TYPE_B_REQ | NUMBER | 22 | The number of points required to reach this tier from the next lowest tier. This value does not have any effect on how the rules are actually calculated. | ||
| POINT_TYPE_C_REQ | NUMBER | 22 | The number of points required to reach this tier from the next lowest tier. This value does not have any effect on how the rules are actually calculated. | ||
| POINT_TYPE_D_REQ | NUMBER | 22 | The number of points required to reach this tier from the next lowest tier. This value does not have any effect on how the rules are actually calculated. | ||
| QUAL_EXP_LEN | NUMBER | 22 | Qual Exp Len | ||
| QUAL_EXP_UOM | VARCHAR2 | 30 | Qual Exp Uom | ||
| QUAL_PERIOD_LEN | NUMBER | 22 | Qual Period Len | ||
| QUAL_PERIOD_UOM | VARCHAR2 | 30 | Qual Period Uom | ||
| REQUAL_PERIOD_LEN | NUMBER | 22 | Length of requalifying period | ||
| REQUAL_PERIOD_UOM | VARCHAR2 | 30 | Requalifying period unit of measure | ||
| SEQ_NUM | NUMBER | 22 | Sequence number to track tier order | ||
| SHOW_FLAG | VARCHAR2 | 1 | Flag indicating whether to show the tier record to member. | ||
| STMT_FREQ_CODE | VARCHAR2 | 30 | The frequency of when a statement is send e.g.(Quarterly, Annually, etc.) | ||
| TIER_CLASS_ID | NUMBER | 18 | Tier Class Id |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_TIER_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |