The Member Future Point Expiration Sync is used to export batches of member-level information related to future point expiration. This point expiration data is pre-calculated and is subject to change. Using an associated sync setting, either all members are returned in the sync data, or only those members who have points due to expire in the next expiration period. Only monthly and yearly point expiration cycles are supported.
Due to potential performance impact, ALP SaaS support must enable a global database setting before utilizing this sync. Furthermore, the “Enable Member Calculated Next Point Expiration” setting must be enabled on the point expiration batch level.
Upon each execution, all member changes since the last execution will be included in the sync file with current information. Files are then FTP’d to the predetermined location.
Note: This information is offered as a PDF for portability. MemberFuturePointExpiration.pdf
YYYYMMDDHHMMSS = Execution time (24hr clock – Corporate Timezone)
## = File Number
No header record
|Contents||Member-level future point expiration data|
|Member Id||Numeric(10)||ALP SaaS Internal Member Id|
|Member Account Id||String(60)||Member Primary Account Id|
|Future Expiration Process Date||Date/Time||(UTC) YYYY-MM-DD HH:MM:SS [24 hr clock]
The date/time this data was last calculated.
|Points1ExpireYYYYMMDD||Decimal||Points to expire in cycle 1 (date populated in column name)|
|Points2ExpireYYYYMMDD||Decimal||Points to expire in cycle 2 (date populated in column name)|
|Points3ExpireYYYYMMDD*||Decimal||Points to expire in cycle 3 (date populated in column name)|
|Points4ExpireYYYYMMDD*||Decimal||Points to expire in cycle 4 (date populated in column name)|
|Points5ExpireYYYYMMDD*||Decimal||Points to expire in cycle 5 (date populated in column name)|
|Points6ExpireYYYYMMDD*||Decimal||Points to expire in cycle 6 (date populated in column name)|
* Columns only present if monthly cycles are used.