VRS Life Insurance - Data Definitions

vavrscode

Stores the information on the Deduction Codes tab.

vavrsrate

Stores the information on the Rates tab.

vavrsplan

Stores the information on the Plans tab.

vavrscover

Stores the information on the Coverage tab.

vavrspart

Stores the information on the VA VRS Life Insurance - Participants page.

vavrschild

Stores the information on the Dependents tab on the VA VRS Life Insurance - Participants page.

vavrshour

Stores the information on the VA VRS Life Insurance - Exceptions page.

vavrsprofile

Stores the information on the VA VRS Life Insurance - Setup page.

Deduction Code

vrs_cd

char(4)

The deduction code.

Employee Type

emp_type

smallint

The employee’s deduction rate type.

Valid values:

• 0 - None

• 1 - Rate Per Thousand

• 2 - Flat Rate

• 3 - Per Unit

Spouse Type

sp_type

smallint

The spouse’s deduction rate type.

Valid values:

• 0 - None

• 1 - Rate Per Thousand

• 2 - Flat Rate

• 3 - Per Unit

Dependent Type

dep_type

smallint

The dependent’s deduction rate type.

Valid values:

• 0 - None

• 1 - Rate Per Thousand

• 2 - Flat Rate

• 3 - Per Unit

Frequency

dedfreq

char(1)

The deduction frequency.

Valid values:

• D - Daily

• W - Weekly

• B - BiWeekly

• S - Semi-Monthly

• M - Monthly

• Q - Quarterly

Amount

salary_ded

decimal(16,2)

The salary exemption amount.

Insurance Type

rate_type

char(1)

The type of insurance.

Valid values:

• M - Mandatory

• V - Voluntary

• I - Imputed Life

Deduction Code

vrs_cd

char(4)

The deduction code that the rate schedule applies to.

Minimum Age

min_yr

integer

The minimum age applicable to this rate schedule.

Maximum Age

max_yr

integer

The maximum age applicable to this rate schedule.

Employee Rate

emp_rate

decimal(9,5)

The employee’s deduction rate.

Depending on the value selected in the Employee Type field on the Deduction Codes tab, enter the deduction rate with the matching format:

• Rate Per Thousand

• Flat Rate

Spouse Rate

sp_rate

decimal(9,5)

The spouse’s deduction rate.

Depending on the value selected in the Spouse Type field on the Deduction Codes tab, enter the deduction rate with the matching format:

• Rate Per Thousand

• Flat Rate

Dependent Rate

dep_rate

decimal(9,5)

The dependent’s deduction rate.

Depending on the value selected in the Dependent Type field on the Deduction Codes tab, enter the deduction rate with the matching format:

• Rate Per Thousand

• Flat Rate

Deduction Code

vrs_cd

char(4)

The deduction code that the insurance plan applies to.

Plan Number

plan_no

integer

The number assigned to this plan.

Employee Factor

emp_factor

decimal(5,4)

The multiplier used to calculate the employee’s coverage against the employee’s salary.

Spouse Factor

sp_factor

decimal(5,4)

The multiplier used to calculate the spouse’s coverage against the employee’s salary.

Dependent Factor

dep_factor

decimal(5,4)

The multiplier used to calculate the dependent’s coverage against the employee’s salary.

Deduction Code

vrs_cd

char(4)

The deduction code that the coverage amount applies to.

Plan Number

plan_no

integer

The corresponding plan number assigned in the Plan Number field on the Plans tab.

Minimum Age

min_yr

integer

The minimum age applicable to this coverage.

Maximum Age

max_yr

integer

The maximum age applicable to this coverage.

Employee Coverage

emp_coverage

decimal(16,2)

The employee’s flat coverage amount.

Spouse Coverage

sp_coverage

decimal(16,2)

The spouse’s flat coverage amount.

Dependent Coverage

dep_coverage

decimal(16,2)

The dependent’s flat coverage amount.

Employee Number

empl_no

integer

The employee number.

Deduction Code

vrs_cd

char(4)

The deduction code assigned to the employee.

Employee Plan

emp_plan

smallint

The employee plan chosen.

Spouse Plan

sp_plan

smallint

The spouse plan chosen.

Dependent Plan

dep_plan

smallint

The dependent plan chosen.

Employee Number

empl_no

integer

The employee number.

Dependent Name

c_name

char(30)

The dependent’s name.

Birth Date

birth date

date

The dependent’s date of birth.

Spouse

sp_ind

char(1)

Indicates whether the dependent is a spouse.

Pay Method

pay_method

char(1)

The pay method to override.

Valid values:

• H - Hourly

• P - Percent

• S - Salary

• D - Daily

Job Class

classify

char(4)

The job class to override.

Employee Number

empl_no

integer

The employee number.

Multiplier

hours

integer

The pay rate multiplier to use while overriding salary calculations.

Round to Nearest Cent

round_off

char(1)

Indicates whether to round values to the nearest cent.

Optional Life Common Date

common

date

The common date for Optional Life.

Optional Life Start Date

effdate

date

The effective start date for Optional Life.