Loyalty Member Tier

Member Tier Data Object for Loyalty Member Service

QName: {http://xmlns.oracle.com/apps/sales/loyalty/member/service/memberService/}MemberTier

Logical Business Objects

• CRM : Loyalty : Loyalty Member

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Contained by	Loyalty Member
Handled by	Loyalty Member Service

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
ActiveFlg	string	Active flag
Comments	string	Member tier Comments
CreatedBy	string	Tier created by reference
EndDt	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Member tier end date
LastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Last update date
LookupCode	string	Reason lookup code
LookupType	string	Reason lookup type
LoyTierClsId	long	Loyalty tier class Id
LoyTierId	long	Loyalty tier Id
MemTierId	long	Primary key Primary Key
MemberId	long	Tier associated member identifier
MemberTierNumber	string	Member tier number
NextTierName	string	Next tier name
ObjectVersionNumber	int	It is used to implement optimistic lock
PresentQualPoints	decimal	Present qualifying points
QualPointsToUpgrade	decimal	Required qualifying points to upgrade to next tier
ReasonValue	string	Reason for change the tier
StartDt	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Start date
StartQualPd	string	LOV Meaning of the LOV Code 'StaryQualPdCode'
StartQualPdCode	string	Start qualifying period code
TierClassId	long	Member tier identifier
TierClassName	string	Tier class name
TierId	long	Tier identifier
TierName	string	Tier name
TierQualPoints	decimal	Tier qualifying points
TillDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Till date for upgrade to next tier