EMPFLEXREM – Employee Flex Period Dollars
- System
- Benefits (BN)
- Prefix
EFR- Primary key
COMPANY,EMPLOYEE,PLAN-START-DT,START-DATE- Fields
- 42
- Updated by
- 21 programs
- Referenced by
- 9 programs
EMPFLEXREM is the Employee Flex Period Dollars table in Lawson Benefits (prefix EFR). It is indexed by COMPANY, EMPLOYEE, PLAN-START-DT, START-DATE (EFRSET1); alternate indexes: EFRSET2 and EFRSET3. It is related 1:1 to PRSYSTEM, CUCODES, EMPFLEXDOL, EMPLOYEE, FLEXPLAN and STANDTIME. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 and 13 more and referenced by BN104, BN232, BN242, BN46.1, BN46.2, BN51.2, BS12.1, HR170 and 1 more. The table has 42 fields, 3 indexes and 6 documented relations.
About EMPFLEXREM
The Employee Flex Period Dollars file contains information about an employee's flex benefit periods.
Fields (42)
Column = COBOL field name without the EFR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EFR-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN100, BN102, BN145, BN45.1 |
EFR-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee's number. The number correlates all information about the employee. | BN100, BN102, BN145, BN45.1 |
EFR-PLAN-START-DT PKPLAN_START_DT | Numeric 8 (yyyymmdd) | Contains the start date of the flex plan year. | BN100, BN102, BN145, BN45.1 |
EFR-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | Contains the start date of the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-STOP-DATESTOP_DATE | Numeric 8 (yyyymmdd) | Contains the stop date of the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CREDITS-AVAILCREDITS_AVAIL | Signed 11.2 | Contains the amount of flex dollars the employee received before electing benefits for the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CREDITS-SPENTCREDITS_SPENT | Signed 11.2 | Contains the flex dollars that were spent for benefits during the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more |
EFR-PRE-TAX-AVAILPRE_TAX_AVAIL | Signed 11.2 | Contains the employee's available pre-tax dollars for the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-PRE-TAX-SPENTPRE_TAX_SPENT | Signed 11.2 | Contains the pre-tax dollars that were spent for benefits during the flex benefit period. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more |
EFR-STM-SEQ-NBRSTM_SEQ_NBR | Numeric 4 | Contains the sequence number that associates this file to the employee's standard time record in PR30.1 (Standard Time Record). | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CRDT-AVL-SHORTCRDT_AVL_SHORT | Derived | — | — |
EFR-CRDT-SPT-SHORTCRDT_SPT_SHORT | Derived | — | — |
EFR-PT-AVL-SHORTPT_AVL_SHORT | Derived | — | — |
EFR-PT-SPT-SHORTPT_SPT_SHORT | Derived | — | — |
EFR-WK-CRDTS-AVAILWK_CRDTS_AVAIL | Derived | — | — |
EFR-BI-CRDTS-AVAILBI_CRDTS_AVAIL | Derived | — | — |
EFR-SM-CRDTS-AVAILSM_CRDTS_AVAIL | Derived | — | — |
EFR-MO-CRDTS-AVAILMO_CRDTS_AVAIL | Derived | — | — |
EFR-PP-CRDTS-AVAILPP_CRDTS_AVAIL | Derived | — | — |
EFR-WK-CRDTS-SPENTWK_CRDTS_SPENT | Derived | — | — |
EFR-BI-CRDTS-SPENTBI_CRDTS_SPENT | Derived | — | — |
EFR-SM-CRDTS-SPENTSM_CRDTS_SPENT | Derived | — | — |
EFR-MO-CRDTS-SPENTMO_CRDTS_SPENT | Derived | — | — |
EFR-PP-CRDTS-SPENTPP_CRDTS_SPENT | Derived | — | — |
EFR-WK-PT-AVAILWK_PT_AVAIL | Derived | — | — |
EFR-BI-PT-AVAILBI_PT_AVAIL | Derived | — | — |
EFR-SM-PT-AVAILSM_PT_AVAIL | Derived | — | — |
EFR-MO-PT-AVAILMO_PT_AVAIL | Derived | — | — |
EFR-PP-PT-AVAILPP_PT_AVAIL | Derived | — | — |
EFR-WK-PT-SPENTWK_PT_SPENT | Derived | — | — |
EFR-BI-PT-SPENTBI_PT_SPENT | Derived | — | — |
EFR-SM-PT-SPENTSM_PT_SPENT | Derived | — | — |
EFR-MO-PT-SPENTMO_PT_SPENT | Derived | — | — |
EFR-PP-PT-SPENTPP_PT_SPENT | Derived | — | — |
EFR-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CREATION-DATECREATION_DATE | Numeric 8 (yyyymmdd) | This is the date that this line was added to the requisition. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-UPD-DATEUPD_DATE | Numeric 8 (yyyymmdd) | — | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
EFR-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EFRSET1 | COMPANY, EMPLOYEE, PLAN-START-DT, START-DATE | Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN31.1 +15 more | |
EFRSET2 | COMPANY, EMPLOYEE, PLAN-START-DT, START-DATE* | BN100, BN101, BN102, BN103, BN105, BN232, BN242, BN31.1 +13 more | ||
EFRSET3 | COMPANY, EMPLOYEE, START-DATE | BN46.1, BN46.2, BS12.1, HR170, HR70.1 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | EFR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Currency | CUCODES | Required | EFR-CURRENCY-CODE → CUC-CURRENCY-CODE | |
| Empflexdol | EMPFLEXDOL | Required | EFR-COMPANY → EFD-COMPANY, EFR-PLAN-START-DT → EFD-START-DATE, EFR-EMPLOYEE → EFD-EMPLOYEE | |
| Employee | EMPLOYEE | Required | EFR-COMPANY → EMP-COMPANY, EFR-EMPLOYEE → EMP-EMPLOYEE | |
| Flexplan | FLEXPLAN | Required | EFR-COMPANY → FLP-COMPANY, EFD-FLEX-PLAN → FLP-FLEX-PLAN | |
| Flpstandtime | STANDTIME | Not Required | EFR-COMPANY → STM-COMPANY, EFR-EMPLOYEE → STM-EMPLOYEE, Spaces → STM-TIME-GROUP, FLP-FLEX-PAY-CODE → STM-PAY-CODE, EFR-STM-SEQ-NBR → STM-SEQ-NBR |
Programs
Updated by (21)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN430 Benefit Purge
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BS32.1 Web Enrollment Stop Benefits Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add