EIM: Resolving Foreign Key Columns for POINT_TYPE_ID in EIM_LOY_TXN table,

 Hi Team,

We are building a batch process to import Loyalty Transaction from feed file.

While importing the sample transaction records in Dev environment, the record is imported and is visible in UI.  However, the list column, Point Type (field Point Name) in Loyalty  Transaction record is null.

The following are foreign key mapping columns for column: POINT_TYPE_ID

            POINT_ATTR_TYPE_CD,

          POINT_INTERNALNAME,

          POINT_OBJECT_CD,

          POINT_PROG_BU,

            POINT_PROG_NAME,

            POINT_PROMO_BU,

            POINT_PROMO_NAME,

            POINT_PROMOPROG_BU,

            POINTPROMOPROGNAME 

One record, "Points" is  created as Point Type record for active Loyalty Program, 'Program A'  The Loyalty Program 'Program A" has six promotions: 3 for tier promotions and  remaining 3 for Admin- Accrual, Redemption, Enrollment. 'PROMOTION_ID' column in S_LOY_ATTRDEFN table is null for this Loyalty Point Type record.