VRS Life Insurance - Data Definitions
The following tables are used to calculate VRS Life Insurance:
Table | Description |
---|---|
Stores the information on the Deduction Codes tab. | |
Stores the information on the Rates tab. | |
Stores the information on the Plans tab. | |
Stores the information on the Coverage tab. | |
Stores the information on the VA VRS Life Insurance - Participants page. | |
Stores the information on the Dependents tab on the VA VRS Life Insurance - Participants page. | |
Stores the information on the VA VRS Life Insurance - Exceptions page. | |
Stores the information on the VA VRS Life Insurance - Setup page. |
vavrscode
The information on the Deduction Codes tab is stored in the vavrscode table.
The following table lists the fields, database fields, data types, and descriptions for the vavrscode table.
Field | Database Field | Data Type | Description |
---|---|---|---|
Deduction Code | vrs_cd | char(4) | The deduction code. |
Employee Type | emp_type | smallint | The employee’s deduction rate type. Valid values:
|
Spouse Type | sp_type | smallint | The spouse’s deduction rate type. Valid values:
|
Dependent Type | dep_type | smallint | The dependent’s deduction rate type. Valid values:
|
Frequency | dedfreq | char(1) | The deduction frequency. Valid values:
|
Amount | salary_ded | decimal(16,2) | The salary exemption amount. |
Insurance Type | rate_type | char(1) | The type of insurance. Valid values:
|
vavrsrate
The information on the Rates tab is stored in the vavrsrate table.
The following table lists the fields, database fields, data types, and descriptions for the vavrsrate table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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:
|
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:
|
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:
|
vavrsplan
The information on the Plans tab is stored in the vavrsplan table.
The following table lists the fields, database fields, data types, and descriptions for the vavrsplan table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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. |
vavrscover
The information on the Coverage tab is stored in the vavrscover table.
The following table lists the fields, database fields, data types, and descriptions for the vavrscover table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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. |
vavrspart
The information on the VA VRS Life Insurance - Participants page is stored in the vavrspart table.
The following table lists the fields, database fields, data types, and descriptions for the vavrspart table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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. |
vavrschild
The information on the Dependents tab on the VA VRS Life Insurance - Participants page is stored in the vavrschild table.
The following table lists the fields, database fields, data types, and descriptions for the vavrschild table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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. |
vavrshour
The information on the VA VRS Life Insurance - Exceptions page is stored in the vavrshour table.
The following table lists the fields, database fields, data types, and descriptions for the vavrshour table.
Field | Database Field | Data Type | Description |
---|---|---|---|
Pay Method | pay_method | char(1) | The pay method to override. Valid values:
|
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. |
vavrsprofile
The information on the VA VRS Life Insurance - Setup page is stored in the vavrsprofile table.
The following table lists the fields, database fields, data types, and descriptions for the vavrsprofile table.
Field | Database Field | Data Type | Description |
---|---|---|---|
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. |