Application File Imports Release Notes Sync Web Services FAQ

Member Ranking Extended Sync

The Member Ranking Sync Extended is used to export extended member information for members in a predetermined member ranking. Compared to the Member Ranking Sync, this file includes more member-related details. This is a cumulative file, not an incremental file. Members with no change to their Ranking Set Level since the previous execution of the sync will not be included in the sync file. 

Upon each execution, all current member information is extracted and the completed file is then FTP’d to the predetermined location.

Note: This information is also offered as a PDF for portability. Member Ranking Extended Sync.pdf

Member Ranking Extended Sync

Name  SBMemberRankingSync_MMDDYYYYHHMMSS.txt (single file)  
SBMemberRankingSync_####.txt (multiple files)    

xxxxx = Member Ranking Set External Reference
#### = File Number  
Format  Pipe delimited
Frequency  Daily 
Source  ALP SaaS 
Contents  All members in the specified member ranking set with their ranking level.   

 

Field Name  Type  Description 
Ranking Set External Reference  String(20)   
Ranking Level External Reference  String(20)  
Internal Member Id Integer  
Member Account Id String(60) The most recent active Account Id of the highest rank 
Member First Name  String(60)  
Member Last Name String(60)  
Member Address  String(120)   
Member City  String(120)   
Member Region Abbreviation  String(8)   
Member Postal Code  String(14)   
Member Country Abbreviation  String(2)   
Member Mobile Phone  String(30) See Article for Phone Number Formatting 
Ranking Set String(20) ALP SaaS Ranking Set External Reference
Ranking Set Level  String(20) ALP SaaS Ranking Set Level External Reference
Ranking Set Level Join Date String The date when the member entered the current ranking set level.
YYYY-MM-DD HH:MM:SS 
Ranking Member Descriptor Expiration Date  String If assigned to the configured descriptor, this is the date that the descriptor will expire.
YYYY-MM-DD 

Example Data

RankingSetExternalReference | RankingLevelExternalReference | InternalMemberId | MemberAccountId | MemberFirstName | MemberLastName | MemberAddress | MemberCity | MemberRegionAbbreviation | MemberPostalCode | MemberCountryAbbreviation | MemberEmail | MemberMobilePhone | RankingSet | RankingSetLevel | RankingSetLevelJoinDate | RankingMemberDescriptorExpirationDate

RS | SILVER | 56075 | 600010023 | John | Smith | 123 Main Street | City | RN | 12345-6789 | US | jsmith@email.com | 1(333) 555-1234 | Gold | 2010-12-25 10:33:15 | 2020-12-31

Please note: All external ALP SaaS links and references are directed to US datacenter unless specifically noted.


Tags:
Home: Aimia Loyalty Platform SaaS Wiki
Copyright © 2019 Aimia Inc. All Rights Reserved.
What's new: Recently changed articles