What are Tables in AXIS used for?
Tables define assumptions, parameters, and values used in calculations at the Cell level and higher levels (projection tables).
Where can Tables be found in AXIS?
Tables appear at many levels in AXIS and can be created, edited, and stored in the Dataset from assumption screens or the View Menu.
What is a Dataset Table in AXIS?
A user-owned table stored within a specific dataset and only available to that dataset. It can be copied to other datasets if needed.
What are Vendor-defined or Common Tables in AXIS?
Common Tables are vendor-provided, available to all datasets, and cannot be deleted or altered by users. They can be used as templates for new Dataset Tables.
Can both Dataset and Common Tables be viewed in selection lists?
Yes. Both appear in Table lists or assumption field selections, based on user-selected checkboxes for each type.
What is a Table ID in AXIS?
Each table has a unique permanent ID number assigned at creation. It never changes and can be shown in Table Selection fields.
What are Cell Tables used for?
Used by Cells or their sub-objects for policy-level calculations, often structured by policy duration and entry age.
What are Projection Tables used for?
Used by Subfunds, Funds, and Offices for higher-level projections. Columns have defined purposes, and rows represent financial years.
What is the difference between Cell and Projection Tables?
Cell Tables support policy-level calculations, while Projection Tables handle higher-level projections for Subfunds, Funds, and Offices.
Can Projection Tables be Common Tables?
No. Projection Tables are always Dataset Tables.
What are Common Tables in AXIS?
Vendor-defined tables provided with each version of AXIS. Available to all datasets, locked from editing, and form the basis for new Dataset Tables. Often include industry-standard mortality tables.
What are Large Tables in AXIS?
User-defined tables with 100 columns, each representing an entry age (e.g., product age, issue age, risk charge age). Support Full, Partial, and Extract views within a cell.
What are Single Column Tables in AXIS?
Tables where rows can represent policy year, attained age, or entry age.
What are Column Specific Tables in AXIS?
Tables with a fixed number of columns, each having a defined purpose. Rows can represent calendar year, policy year, attained age, product age, or outstanding term. May include 1200-row monthly tables and expandable columns.
What are Row Specific Tables in AXIS?
Tables divided into subsections where each row has a specific title indicating its purpose.
What are Row and Column Specific Tables in AXIS?
Tables where both rows and columns have specific meanings. Example: an Age Distribution Table with columns for product age and rows for age-specific data.
What are Composite Tables in AXIS?
Combinations of tables with titled rows and multiple columns that may include modifiers and links to other tables. Compound Tables are special composites that allow up to 10 adjustment tables.
What are Formula Tables in AXIS?
User-designed formulas written in AXIS Script that dynamically calculate values by age, duration, or year based on defined algorithms.
What are Table Sections in AXIS?
Sections categorize tables by use (e.g., premiums, interest, expenses). Names must be unique within a section but can repeat in others. Sections control where a table can be used.
Can tables from one module be used in another AXIS module?
Yes. For example, a lapse rate table created in the Regular Life module can be used in other modules without recreating it.
