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
# = File Number
|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 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)||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.
|Ranking Member Descriptor Expiration Date||String||If assigned to the configured descriptor, this is the date that the descriptor will expire.
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 | firstname.lastname@example.org | 1(333) 555-1234 | Rank_A | 4 |2010-12-25 10:33:15 | 2020-12-31