|
|
FLEXPLAN FILE
Flex Plan
The Flex Plan file contains information about flex plans.
REFERENCED BY
BN08.1 BN100 BN101 BN102 BN103 BN105
BN138 BN145 BN16.1 BN16.2 BN16.3 BN16.4
BN206 BN215 BN216 BN220 BN230 BN232
BN238 BN245 BN246 BN258 BN259 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN325 BN340
BN350 BN430 BN45.1 BN531 BN59.1 BN59.3
BN65.1 BN65.2 BN71.1 BN72.1 BS10.1 BS12.1
BS32.1 HFLP.1 HR55.1 PR20.4 PRBN.1
UPDATED BY
BN00.1 BN04.1 BN06.1 BN104 BN15.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLP-COMPANY Numeric 4 BN06.1
Element: Company Contains the company number, which
represents an established company.
FLP-FLEX-PLAN Alpha 4 BN06.1
Element: Flex Plan Contains the code that represents the
flex plan.
FLP-DESC Alpha 30 (Lower Case) BN06.1
Element: Description Contains the description of the flex
plan.
FLP-GROUP-NAME Alpha 10 BN06.1
Element: Group Name Contains the employee group for
eligibility.
FLP-ENTRY-MMDD Numeric 4 BN06.1 BN430
Element: Entry Month DaContains the date the flex plan year
begins.
The flex plan year is the twelve month
period beginning on this month and day.
FLP-SPEND-ONLY Alpha 1 BN06.1
Spending Account Indicates whether the flex plan is a
Only spending account only.
N = No
Y = Yes
FLP-DED-TABLE Alpha 2 BN06.1
Element: Deduction TablContains the frequency table assigned
to the flex plan.
FLP-FLEX-PAY-CODE Alpha 4 BN06.1
Element: Flex Credit PaContains the code that represents the
flex credit pay code assigned to the
flex plan.
FLP-PIK-PAY-CODE Alpha 4
Element: Pik Pay Code This field is not used.
FLP-PRE-TAX-DED Alpha 4
Element: Pre Tax Ded This field is not used.
FLP-ATN-DED Alpha 4
Element: Atn Ded This field is not used.
FLP-CORE-HEALTH Alpha 4 BN15.1
Element: Core Health PlIf a health benefit plan under the flex
plan is defined as a core plan, this
field is updated as Yes or Spouse.
FLP-CORE-DENTAL Alpha 4 BN15.1
Element: Core Dental PlIf a dental benefit plan under the flex
plan is defined as a core plan, this
field is updated as Yes or Spouse.
FLP-CORE-DISAB Alpha 4 BN15.1
Element: Core DisabilitIf a disability benefit plan under the
flex plan is defined as a core plan,
this field is updated with Yes.
FLP-CORE-LIFE Alpha 4 BN15.1
Element: Core Life PlanIf an employee life benefit plan under
the flex plan is defined as a core plan,
this field is updated as Yes.
FLP-CORE-DEP-LIFE Alpha 4 BN15.1
Element: Core Dep Life If a dependent life benefit plan under
the flex plan is defined as a core plan,
this field is updated with Yes or
Spouse.
FLP-HEALTH-FLAG Alpha 1 BN15.1
Core Benefit Health
Flag
FLP-DENTAL-FLAG Alpha 1 BN15.1
Core Benefit Dental
Flag
FLP-DISAB-FLAG Alpha 1 BN15.1
Core Benefit
Disability Flag
FLP-LIFE-FLAG Alpha 1 BN15.1
Core Benefit Life
Flag
FLP-DEP-LIFE-FLAG Alpha 1 BN15.1
Element: Dep Life Flag
FLP-DED-FREQ-FLAG Numeric 1 BN04.1 BN06.1
Update Deduct Freq 0 = Not Updated BN104
Table Flag 1 = Updated
FLP-CURRENCY-CODE Alpha 5 BN06.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
FLP-CURR-ND Numeric 1 BN06.1
Account Currency
Code
FLEXPLAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLPSET1 COMPANY BN00.1 BN04.1
FLEX-PLAN BN06.1 BN08.1
BN100 BN101
BN102 BN103
BN104 BN105
BN138 BN145
BN15.1 BN16.1
BN16.2 BN16.3
BN16.4 BN206
BN215 BN216
BN220 BN230
BN232 BN238
BN245 BN246
BN258 BN259
BN31.1 BN31.2
...
FLPSET2 COMPANY KeyChange BN04.1
DED-TABLE
FLEX-PLAN
FLEXPLAN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Atn Ded DEDCODE Required
FLP-COMPANY -> DDC-COMPANY
FLP-ATN-DED -> DDC-DED-CODE
Company BNCOMPANY Required
FLP-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
FLP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When FLP-CURRENCY-CODE != Spaces
FLP-CURRENCY-CODE -> CUC-CURRENCY-CODE
Deduct Table DEDFREQTBL Required
FLP-COMPANY -> DFT-COMPANY
FLP-DED-TABLE -> DFT-TABLE-CODE
Di Core Plan PLAN Not Required
FLP-COMPANY -> PLN-COMPANY
"DI" -> PLN-PLAN-TYPE
FLP-CORE-DISAB -> PLN-PLAN-CODE
Dl Core Plan PLAN Not Required
FLP-COMPANY -> PLN-COMPANY
"DL" -> PLN-PLAN-TYPE
FLP-CORE-DEP-LIFE -> PLN-PLAN-CODE
Dn Core Plan PLAN Not Required
FLP-COMPANY -> PLN-COMPANY
"DN" -> PLN-PLAN-TYPE
FLP-CORE-DENTAL -> PLN-PLAN-CODE
El Core Plan PLAN Not Required
FLP-COMPANY -> PLN-COMPANY
"EL" -> PLN-PLAN-TYPE
FLP-CORE-LIFE -> PLN-PLAN-CODE
Flex Pay Code PRPAYCODE Required
When FLP-FLEX-PAY-CODE != Spaces
FLP-COMPANY -> PCD-COMPANY
FLP-FLEX-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
Group Name PERSGROUP Not Required
FLP-COMPANY -> PRG-COMPANY
FLP-GROUP-NAME -> PRG-GROUP-NAME
Hl Core Plan PLAN Not Required
FLP-COMPANY -> PLN-COMPANY
"HL" -> PLN-PLAN-TYPE
FLP-CORE-HEALTH -> PLN-PLAN-CODE
Pik Pay Code PRPAYCODE Required
FLP-COMPANY -> PCD-COMPANY
FLP-PIK-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
Pre Tax Ded DEDCODE Required
FLP-COMPANY -> DDC-COMPANY
FLP-PRE-TAX-DED -> DDC-DED-CODE
FLEXPLAN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Flex Dollars FLEXDOLLAR
FLP-COMPANY -> FLD-COMPANY
FLP-FLEX-PLAN -> FLD-FLEX-PLAN
FLD-START-DATE
FLD-GROUP-NAME
|
