1. Tables and Views for Loyalty
  2. LOY_AGGR_POINT

LOY_AGGR_POINT

This is the Loyalty point aggregation table, stores weekly and monthly point aggregation results

Details

  • Schema: FUSION

  • Object owner: LOY

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

LOY_AGGR_POINT_PK

LOY_AGGR_POINT_ID

Columns

Name Datatype Length Precision Not-null Comments
LOY_AGGR_POINT_ID NUMBER 18 Yes Who column. Primary key
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes 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.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who 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.
PERIOD_TYPE CHAR 1 Yes Period type, value could be W/M - Weekly/Monthly
PERIOD_CODE NUMBER 8 Yes Refers to FND_CAL_WEEK.CAL_WEEK or FND_CAL_MONTH.CAL_MONTH based on period type
ATTRDEFN_B_ID NUMBER 18 Yes Refers point type id
MEMBER_ID NUMBER 18 Yes Refers member Id
PROMO_ID NUMBER 18 Refers promotion Id
PARTNER_ID NUMBER 18 Refers partner id
PROD_ID NUMBER 18 Refers item number
POINTS_ACCRUED NUMBER Points accrued as of PERIOD_END_DATE of CAL_WEEK or CAL_MONTH
POINTS_REDEEMED NUMBER Points redeemed as of PERIOD_END_DATE of CAL_WEEK or CAL_MONTH
POINTS_EXPIRED NUMBER Points expired as of PERIOD_END_DATE of CAL_WEEK or CAL_MONTH
POINTS_AVAILABLE NUMBER Point balance as of PERIOD_END_DATE of CAL_WEEK or CAL_MONTH

Foreign Keys

Table Foreign Table Foreign Key Column
LOY_AGGR_POINT loy_attrdefn_b ATTRDEFN_B_ID
LOY_AGGR_POINT loy_member MEMBER_ID
LOY_AGGR_POINT loy_promo PROMO_ID
LOY_AGGR_POINT zpm_partner_profiles PARTNER_ID

Indexes

Index Uniqueness Tablespace Columns
LOY_AGGR_POINT_F1 Non Unique Default ATTRDEFN_B_ID
LOY_AGGR_POINT_F2 Non Unique Default MEMBER_ID
LOY_AGGR_POINT_F3 Non Unique Default PROMO_ID
LOY_AGGR_POINT_F4 Non Unique Default PARTNER_ID
LOY_AGGR_POINT_N1 Non Unique Default PERIOD_TYPE, PERIOD_CODE, MEMBER_ID, ATTRDEFN_B_ID, PROMO_ID, PARTNER_ID, PROD_ID
LOY_AGGR_POINT_U1 Unique Default LOY_AGGR_POINT_ID