BN_SNAP_CONFIG (SQL Table)	Index Back
Enrollment Reporting Config BN_SNAP_CONFIG stores the user preferences for an Enrollment Reporting Snapshot run. These preferences include the flags that indicate which plan types should be processed, as well as whether deduction information should be included, and whether Life & Disability coverage should be calculated.

BN_SNAP_CONFIG

(SQL Table)

Enrollment Reporting Config

BN_SNAP_CONFIG stores the user preferences for an Enrollment Reporting Snapshot run. These preferences include the flags that indicate which plan types should be processed, as well as whether deduction information should be included, and whether Life & Disability coverage should be calculated.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INCLUDE_AX Character(1) VARCHAR2(1) NOT NULL This is a configuration flag which indicates that the associated Benefit Plan type category should be inculded for processing.
Y/N Table Edit
Default Value: Y

2 INCLUDE_1X Character(1) VARCHAR2(1) NOT NULL Health
Y/N Table Edit
Default Value: Y

3 INCLUDE_2X Character(1) VARCHAR2(1) NOT NULL Life
Y/N Table Edit
Default Value: Y

4 INCLUDE_3X Character(1) VARCHAR2(1) NOT NULL Disability
Y/N Table Edit
Default Value: Y

5 INCLUDE_4X Character(1) VARCHAR2(1) NOT NULL Savings
Y/N Table Edit
Default Value: Y

6 INCLUDE_6X Character(1) VARCHAR2(1) NOT NULL FSA
Y/N Table Edit
Default Value: Y

7 INCLUDE_7X Character(1) VARCHAR2(1) NOT NULL Retirement
Y/N Table Edit
Default Value: Y

8 INCLUDE_8X Character(1) VARCHAR2(1) NOT NULL Pension
Y/N Table Edit
Default Value: Y

9 INCLUDE_9X Character(1) VARCHAR2(1) NOT NULL Vacation Buy/Sell
Y/N Table Edit
Default Value: Y

10 INCLUDE_CALC Character(1) VARCHAR2(1) NOT NULL Calculate Life/Disability Covg
Y/N Table Edit
Default Value: Y

11 INCLUDE_DED Character(1) VARCHAR2(1) NOT NULL Include Payroll Deduction Info
Y/N Table Edit
Default Value: Y

12 INCLUDE_TERMS Character(1) VARCHAR2(1) NOT NULL Y/N flag - Include implied terminations in Enrollment Reporting Snapshot. Implied terminations are generated from a new Waive or Enrollment replacing a prior active enrollment in a different plan.
Y/N Table Edit
Default Value: Y

13 INCLUDE_TERM_DEP Character(1) VARCHAR2(1) NOT NULL Include Implied Dependent Term
Y/N Table Edit
Default Value: Y

14 INCLUDE_ORIG Character(1) VARCHAR2(1) NOT NULL Y/N: Should original enrollment date be included?
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCLUDE_AX	Character(1)	VARCHAR2(1) NOT NULL	This is a configuration flag which indicates that the associated Benefit Plan type category should be inculded for processing. Y/N Table Edit Default Value: Y
2	INCLUDE_1X	Character(1)	VARCHAR2(1) NOT NULL	Health Y/N Table Edit Default Value: Y
3	INCLUDE_2X	Character(1)	VARCHAR2(1) NOT NULL	Life Y/N Table Edit Default Value: Y
4	INCLUDE_3X	Character(1)	VARCHAR2(1) NOT NULL	Disability Y/N Table Edit Default Value: Y
5	INCLUDE_4X	Character(1)	VARCHAR2(1) NOT NULL	Savings Y/N Table Edit Default Value: Y
6	INCLUDE_6X	Character(1)	VARCHAR2(1) NOT NULL	FSA Y/N Table Edit Default Value: Y
7	INCLUDE_7X	Character(1)	VARCHAR2(1) NOT NULL	Retirement Y/N Table Edit Default Value: Y
8	INCLUDE_8X	Character(1)	VARCHAR2(1) NOT NULL	Pension Y/N Table Edit Default Value: Y
9	INCLUDE_9X	Character(1)	VARCHAR2(1) NOT NULL	Vacation Buy/Sell Y/N Table Edit Default Value: Y
10	INCLUDE_CALC	Character(1)	VARCHAR2(1) NOT NULL	Calculate Life/Disability Covg Y/N Table Edit Default Value: Y
11	INCLUDE_DED	Character(1)	VARCHAR2(1) NOT NULL	Include Payroll Deduction Info Y/N Table Edit Default Value: Y
12	INCLUDE_TERMS	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag - Include implied terminations in Enrollment Reporting Snapshot. Implied terminations are generated from a new Waive or Enrollment replacing a prior active enrollment in a different plan. Y/N Table Edit Default Value: Y
13	INCLUDE_TERM_DEP	Character(1)	VARCHAR2(1) NOT NULL	Include Implied Dependent Term Y/N Table Edit Default Value: Y
14	INCLUDE_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Y/N: Should original enrollment date be included? Y/N Table Edit Default Value: Y