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 incremental. 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_YYYYMMDDHHMMSS_#.txt
# = File Number  
Format  Pipe delimited
Frequency  Daily 
Source  Kognitiv Loyalty 
Contents  All members in the specified member ranking set with their ranking level.   

 

     
SB 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 Email  String(256)   
Member Mobile Phone  String(30) See Article for Phone Number Formatting 
Ranking Set String(20) Kognitiv Loyalty Ranking Set External Reference
Ranking Set Level  String(20) Kognitiv Loyalty Ranking 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

InternalMemberId | MemberAccountId | MemberFirstName | MemberLastName | MemberAddress | MemberCity | MemberRegionAbbreviation | MemberPostalCode | MemberCountryAbbreviation | MemberEmail | MemberMobilePhone | Ranking Set | RankingSetLevel | RankingSetLevelJoinDate | RankingMemberDescriptorExpirationDate

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

Kognitiv Logo

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

Tags:
Home: Kognitiv Loyalty © 2021 Kognitiv Corporation. All Rights Reserved.