The Data Space

Input data shared by every by-policy projection.

The eight input CSVs are read here, once per model, and referenced from Projection as data. Projection is parameterized by point_id, so each Projection[N] is a separate ItemSpace with its own cells cache; if the readers lived there, every model point would re-read every file. Holding them in an unparameterized Space reads each file once no matter how many policies are projected.

Inputs are external files: plain CSVs in the model folder’s parent directory, products/universal_life/, rather than data stored inside the model. The model folder therefore holds nothing but formulas – no _data/, no IOSpec, no embedded values – so a diff of the model shows logic changes only. This follows annuallife.TradLife_A; contrast basiclife.BasicTerm_S, which keeps its inputs inside the model through modelx’s IOSpec machinery.

The consequence worth knowing: the model is not portable on its own. Copying the UL_US_S folder without its parent’s CSVs produces a model that reads and then fails on first evaluation.

input_dir() resolves the directory from _model.path.parent at run time, so the model works wherever the repository is checked out. Each table has a filename Reference and a reader Cells:

Reference	Cells	File
model_point_file	model_point_table()	model_point_table.csv
coi_rates_file	coi_rates()	coi_rates.csv
corridor_file	corridor_factors()	corridor_factors.csv
mort_table_file	mort_table()	mort_table.csv
class_factor_file	class_factor_table()	class_factor_table.csv
lapse_table_file	lapse_table()	lapse_table.csv
prem_persistency_file	prem_persistency_table()	prem_persistency.csv
surr_charge_file	surr_charge_table()	surr_charge_table.csv

coi_rates.csv carries the guaranteed maximum monthly rate per $1,000 of net amount at risk; the current scale is the guaranteed scale times Projection.coi_curr_factor, because current COI scales are not published [std]. mort_table.csv is a small illustrative best-estimate table [std], not a published one – the notes forbid hard-coding the licensed 2015 VBT and 2017 CSO families. To swap in a licensed basis, replace the file with a same-schema one, or point mort_table_file at a different name, then clear the cache. No formula changes.

Cells Descriptions

input_dir()

The directory holding the input CSVs: the model folder’s parent.

Inputs are external files, not data stored inside the model, so the model folder is pure formulas. The path is resolved at run time from where the model was read, following annuallife.TradLife_A.

model_point_table()

The model point table, read from model_point_table.csv.

coi_rates()

Guaranteed maximum monthly COI rates, read from coi_rates.csv.

Per $1,000 of net amount at risk, keyed by issue-age cell and policy year.

corridor_factors()

The GPT corridor factor table by attained age, read from corridor_factors.csv.

mort_table()

The best-estimate annual mortality table by age, read from mort_table.csv.

class_factor_table()

The underwriting-class factors, read from class_factor_table.csv.

lapse_table()

The base annual lapse rates by policy year, read from lapse_table.csv.

prem_persistency_table()

Premium persistency (paid/planned) by policy year, read from prem_persistency.csv.

surr_charge_table()

The surrender charge schedules, read from surr_charge_table.csv.

One row per surr_charge_id, giving the initial charge per $1,000 of initial face and the number of years over which it runs off linearly.