FLEXPLAN

Flex Plan

The Flex Plan file contains information about flex plans.

REFERENCED BY
BN08.1 BN100 BN101 BN102 BN103 BN105
BN145 BN16.1 BN16.2 BN16.3 BN16.4 BN206
BN215 BN216 BN220 BN230 BN232 BN238
BN245 BN246 BN258 BN259 BN260 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 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HFLP.1 HR55.1 LP138 PR20.4 PRBN.1


UPDATED BY
BN00.1 BN04.1 BN06.1 BN104 BN15.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLP-COMPANY
Element: Company Hr		Numeric 4
Contains the company number, which represents an established company.
BN06.1
FLP-FLEX-PLAN
Element: Flex Plan		Alpha 4
Contains the code that represents the flex plan.
BN06.1
FLP-DESC
Element: Description		Alpha 30 (Lower Case)
Contains the description of the flex plan.
BN06.1
FLP-GROUP-NAME
Element: Group Name		Alpha 10
Contains the employee group for eligibility.
BN06.1
FLP-ENTRY-MMDD
Element: Entry Mmdd		Numeric 4
Contains the date the flex plan year begins. The flex plan year is the twelve month period beginning on this month and day.
BN06.1 BN430
FLP-SPEND-ONLY
Element: Spend Only		Alpha 1
Indicates whether the flex plan is a spending account only.
N = No
Y = Yes
BN06.1
FLP-DED-TABLE
Element: Ded Table		Alpha 2
Contains the frequency table assigned to the flex plan.
BN06.1
FLP-FLEX-PAY-CODE
Element: Flex Pay Code		Alpha 4
Contains the code that represents the flex credit pay code assigned to the flex plan.
BN06.1 BN145
FLP-PIK-PAY-CODE
Element: Pik Pay Code		Alpha 4
This field is not used.
FLP-PRE-TAX-DED
Element: Pre Tax Ded		Alpha 4
This field is not used.
FLP-ATN-DED
Element: Atn Ded		Alpha 4
This field is not used.
FLP-CORE-HEALTH
Element: Core Health		Alpha 4
If a health benefit plan under the flex plan is defined as a core plan, this field is updated as Yes or Spouse.
BN15.1
FLP-CORE-DENTAL
Element: Core Dental		Alpha 4
If a dental benefit plan under the flex plan is defined as a core plan, this field is updated as Yes or Spouse.
BN15.1
FLP-CORE-DISAB
Element: Core Disab		Alpha 4
If a disability benefit plan under the flex plan is defined as a core plan, this field is updated with Yes.
BN15.1
FLP-CORE-LIFE
Element: Core Life		Alpha 4
If an employee life benefit plan under the flex plan is defined as a core plan, this field is updated as Yes.
BN15.1
FLP-CORE-DEP-LIFE
Element: Core Dep Life		Alpha 4
If a dependent life benefit plan under the flex plan is defined as a core plan, this field is updated with Yes or Spouse.
BN15.1
FLP-HEALTH-FLAG
Element: Health Flag		Alpha 1
BN15.1
FLP-DENTAL-FLAG
Element: Dental Flag		Alpha 1
BN15.1
FLP-DISAB-FLAG
Element: Disab Flag		Alpha 1
BN15.1
FLP-LIFE-FLAG
Element: Life Flag		Alpha 1
BN15.1
FLP-DEP-LIFE-FLAG
Element: Dep Life Flag		Alpha 1
BN15.1
FLP-DED-FREQ-FLAG
Element: Ded Freq Flag		Numeric 1

0 = Not Updated
1 = Updated
BN04.1 BN06.1
BN104
FLP-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN06.1
FLP-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN06.1
FLP-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN06.1
FLP-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN06.1
FLP-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN06.1
FLP-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN06.1
FLP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN06.1
FLP-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN06.1


FLEXPLAN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLPSET1 COMPANY
FLEX-PLAN
...
BN00.1 BN04.1
BN06.1 BN08.1
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN15.1
BN16.1 BN16.2
BN16.3 BN16.4
BN206 BN215
BN216 BN220
BN230 BN232
BN238 BN245
BN246 BN258
BN259 BN260
BN31.1 BN31.2
FLPSET2 COMPANY
DED-TABLE
FLEX-PLAN
KeyChange
BN04.1


FLEXPLAN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Flex Dollars FLEXDOLLAR
FLP-COMPANY->FLD-COMPANY
FLP-FLEX-PLAN->FLD-FLEX-PLAN
  FLD-START-DATE
  FLD-GROUP-NAME

File created: Thu Jun 09 02:10:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.