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.
Members with updates to their Ranking Set Level and/or updates for associated member descriptor assignments, since the previous execution of the sync will be included in the sync file.
Upon each execution, all current member information is extracted and the completed file is then FTPed 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 ranking set with rank level/descriptor updates since the last sync execution. |
| 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 | [email protected] | 1(333) 555-1234 | Rank_A | 4 |2010-12-25 10:33:15 | 2020-12-31
