This is a table that corresponds to the "all_sports" permission for the included license sample data; containing 1 row per customer per year a license was held.

Format

A data frame with 9 variables

cust_id

Customer ID (numeric) (composite key)

year

License Year (numeric) (yyyy) (composite key)

duration_run

Running Duration in years (numeric)

month

Earliest Transaction Month (numeric) (1=Jan, 2=Feb, ...)

res

Residency (numeric) (1=Res, 0=Nonres)

sex

Gender (numeric) (1=Male, 2=Female)

birth_year

Year of Birth (numeric) (yyyy)

R3

R3 Group this Year (numeric) (1=carry, 2=renew, 3=reactivate, 4=recruit)

lapse

Lapsed next Year? (numeric) (1=lapse, 0=renew)

See also

Salic Function Reference: salic

Building License History: make_history

Other Sample Data: cust, dashboard, data_salic, lic, metrics, sale