LOY_MEM_VCHR_STATUS_INT
Interface table for Loyalty member voucher status history.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
LOY_MEM_VCHR_STATUS_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Unique Identifier for a Batch | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier of the interface record. Internal use only. | |
| IMPORT_STATUS_CODE | VARCHAR2 | 1 | Status for the data in the interface table | ||
| 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. | ||
| FILE_RECORD_NUM | NUMBER | 18 | This column is required by import wizard to relate record in the interface table to the file row, and used for reporting purposes. Import framework would populate this value. | ||
| INTERNAL_VCHR_STATUS_OVN | NUMBER | 9 | Object Version Number copied from corresponding Member Voucher 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. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | This is an optional column for multi-csv uptake, but recommended. The column saves the individual sys task id for each input csv file, corresponding to value in the mkt_cm_systask table. This value will be populated by the import framework. | ||
| LOY_MEM_VCHR_STATUS_ID | NUMBER | 18 | Who Column: Primary Key. | ||
| MEMBER_ID | NUMBER | 18 | Refers member id. | ||
| MEM_NUM | VARCHAR2 | 30 | Member number, alternate key for MEMBER_ID | ||
| MEM_VCHR_ID | NUMBER | 18 | Refers member voucher id. | ||
| VOUCHER_NUM | VARCHAR2 | 30 | Voucher Number, alternate key for MEM_VCHR_ID | ||
| START_DATE | TIMESTAMP | When the status start taking effect. | |||
| END_DATE | TIMESTAMP | End date of the status. | |||
| FROM_STATUS_CODE | VARCHAR2 | 30 | Voucher status code before change. | ||
| TO_STATUS_CODE | VARCHAR2 | 30 | Voucher status code after change | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_MEM_VCHR_STATUS_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |