Benefits – Lawson BN tables and programs

Benefits (BN) in Lawson S3 v10 MSP6 has 68 tables, 126 online screens and 79 batch programs.

Tables (68)

TablePrefixDescriptionPrimary keyFields
BENEFICRYBNFBeneficiaryCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, SEQ-NBR43
BENEFITBENEmployee BenefitCOMPANY, PLAN-TYPE, EMPLOYEE, START-DATE, PLAN-CODE100
BNACCOUNTSBNABenefit AccountsCOMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, DED-CODE21
BNANNENRBAENo description in the Lawson data dictionaryCOMPANY, PROCESS-LEVEL, RULE-TYPE, GROUP-NAME22
BNBENBNBNo description in the Lawson data dictionaryCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE45
BNBROKERBRKNo description in the Lawson data dictionaryBROKER24
BNCARRIERBCRInsurance CarrierINS-CARRIER25
BNCATEGORYBCTBenefit CategoriesPLAN-TYPE, PLAN-OPTION3
BNCHANGEBNHBenefit ChangesCOMPANY, EMPLOYEE, EFFECT-DATE, SEQ-NBR15
BNCOMMENTSBCMBenefit CommentsCOMPANY, CMT-TYPE, EMPLOYEE, PARTICIPNT, PLAN-TYPE, PLAN-CODE, GROUP-NAME, START-DATE, SEQ-NBR11
BNCOMPANYBNCBenefit Company ParametersCOMPANY43
BNCOVDFTBCDBenefit Coverage DefaultsCOMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME, COVERAGE-OPT18
BNCOVERAGECVRBenefit CoverageCOMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME52
BNCOVOPTCOPBenefit Coverage OptionsCOMPANY, PLAN-TYPE, PLAN-CODE, COVERAGE-OPT20
BNCYCDTLBCCThis table is used by Web Benefit Enrollment Task to display and create the server costs for mid year enrollments into…COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-END-DATE13
BNCYCLEBCYThis database table is used for the Web Benefit Enrollment processing.COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ12
BNEMPEXERBXREmp Stock Option TransactionsCOMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBR47
BNEMPGRNTBEGEmp Stock Option GrantCOMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF31
BNESSPLNRRUPEmployee Self-Service Plan Rule.COMPANY, GROUP-NAME, PLAN-TYPE, PLAN-CODE5
BNESSPRGRRUGNo description in the Lawson data dictionaryCOMPANY, GROUP-NAME2
BNFAMSTSBFSNo description in the Lawson data dictionaryCOMPANY, PROCESS-LEVEL, FAMILY-STATUS, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE30
BNGRPCHGBNGBenefit Group ChangeCOMPANY, EMPLOYEE, EFFECT-DATE, SEQ-NBR14
BNINVDETLBIDBenefit Invoice DetailCOMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, EMPLOYEE, PARTICIPNT, INV-NUMBER22
BNINVESTBIVInvestment DistributionCOMPANY, PLAN-CODE, SEQ-NBR6
BNNEWHIREBNNNo description in the Lawson data dictionaryCOMPANY, PROCESS-LEVEL, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE23
BNPAYDETLBPDBenefit Payment DetailCOMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATE14
BNPAYMENTBNPBenefit PaymentCOMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR29
BNPLNENRBPENo description in the Lawson data dictionaryCOMPANY, PROCESS-LEVEL, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE30
BNPLNGROUPBPGNo description in the Lawson data dictionaryCOMPANY, PLAN-GROUP5
BNPOSTCODEBPCBenefit Postal CodePOST-CODE-TBL, POSTAL-CODE2
BNPRMOPTPCVBenefit Premium OptionsCOMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME, COVERAGE-OPT27
BNSIMDTLBSDBenefit Simulation DetailCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE11
BNSIMHDRBSHBenefit SimulationCOMPANY, EMPLOYEE12
BNSTKGNTBSGNo description in the Lawson data dictionaryCOMPANY, OPT-GRANT-NBR33
BNSTKSPLTBSPNo description in the Lawson data dictionarySTOCK-SYMBOL, SPLIT-DATE12
BNSTOCKBSKNo description in the Lawson data dictionarySTOCK-SYMBOL9
BNTRANSBNTNo description in the Lawson data dictionaryCOMPANY, PLAN-TYPE, PLAN-CODE, EMPLOYEE, PARTICIPNT, DEPENDENT, START-DATE, TRAN-SEQ-NBR22
BNWAITBWTBenefit Waiting PeriodCOMPANY, RULE-TYPE, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, ACTION-CODE38
BONDBENIFBONSavings Bond BeneficiaryCOMPANY, EMPLOYEE, PLAN-CODE, START-DATE, BOND-NBR9
BONDBENSEQBBSSavings Bond SequenceCOMPANY, EMPLOYEE, PLAN-CODE, START-DATE, BOND-SEQ-NBR8
CODACODCash/Deferred Account HistoryCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR, PROCESS-LEVEL, BUS-NBR-GRP, QC-ENT-NBR-GRP23
COMPHISTCPHEmployee Compensation HistoryCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR13
CONTRDETLCNDContribution Schedule DetailCOMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, BEGIN-YEAR-PCT18
DEPBENDEPNo description in the Lawson data dictionaryCOMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE20
EMPFLEXDOLEFDEmployee Flex DollarsCOMPANY, START-DATE, EMPLOYEE76
EMPFLEXREMEFREmployee Flex Period DollarsCOMPANY, EMPLOYEE, PLAN-START-DT, START-DATE42
EMPINVESTEMIEmp Benefit Investment DistCOMPANY, EMPLOYEE, PLAN-CODE, START-DATE, SEQ-NBR, DIST-ST-DATE12
FLEXDOLLARFLDFlex DollarsCOMPANY, FLEX-PLAN, START-DATE, GROUP-NAME67
FLEXPLANFLPFlex PlanCOMPANY, FLEX-PLAN30
LETTERCODELTCBenefit Letter CodeCOMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE10
LETTERTEXTLTTBenefit Letter TextCOMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE, SEQ-NBR8
NAVIGATENAVBenefit Process OrderCOMPANY, PROCESS-LEVEL, EMPLOYEE4
OCCURTYPEOCCCOBRA Occurrence TypeCOMPANY, OCCUR-TYPE6
PARTBENPTBCOBRA Participant BenefitCOMPANY, PLAN-TYPE, PARTICIPNT, EMPLOYEE, START-DATE, PLAN-CODE33
PARTICIPNTPARCOBRA ParticipantCOMPANY, PARTICIPNT50
PLANPLNPL Group DetailCOMPANY, PLAN-TYPE, PLAN-CODE91
PREMIUMPREBenefit Plan PremiumCOMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME64
RATETBLDTLRTDRate Table DetailCOMPANY, TABLE-CODE, START-DATE, BEG-AGE-YR-SAL, SMOKER16
RATETBLHDRRTHRate Table HeaderCOMPANY, TABLE-CODE, START-DATE14
RESTRANSRTRSpending Account TransactionsCOMPANY, START-DATE, EMPLOYEE, PLAN-CODE, DATE, CHECK-NBR8
SBBENSBBSavings Bond BeneficiaryCOMPANY, EMPLOYEE, BNFC-NBR17
SPHISTSPHStock Purchase Plan HistoryCOMPANY, EMPLOYEE, PLAN-CODE, START-DATE, DATE-PURCH7
VESTHOURSVESEmployee Vesting HoursCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR12
VESTSCHDDTVSDVesting Schedule DetailCOMPANY, VEST-SCHED, SERV-YEARS4
VESTSCHDHDVSHVesting Schedule HeaderCOMPANY, VEST-SCHED3
ZBNUXCTLZBCNo description in the Lawson data dictionaryCOMPANY12
ZBNUXLOGZBLNo description in the Lawson data dictionaryCOMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE-457, START-DATE-457, PLAN-CODE-MAT, START-DATE-MAT, SEQ-NBR26
ZMULTCOVJTCNo description in the Lawson data dictionaryCOMPANY, PLAN-TYPE, PLAN-CODE, COVER-TYPE, START-DATE, GROUP-NAME9

Online screens (126)

ScreenDescriptionUpdatesReferences
BN00.1Benefits Company2310
BN00.2COBRA Parameters27
BN00.3COBRA Occurrence Types22
BN00.4Group Life W-2 Table11
BN01.1Insurance Entity11
BN01.2Broker12
BN02.1Age Rate Table46
BN02.2Salary Rate Table46
BN02.3Service Rate Table46
BN02.4Credits Rate Table46
BN02.5Coverage Reduction Table47
BN03.1Vesting Schedule23
BN04.1Frequency Table34
BN05.1Standard Letter23
BN06.1Flex Plan27
BN07.1Stock Definition13
BN08.1Flex Credits17
BN11.1Eligibility Postal Codes11
BN12.1Benefits Annual Limits10
BN12.2Benefits Ded Annual Limits10
BN13.1Benefit Plan Categories12
BN15.1Benefit Plan1628
BN15.2Plan Details12
BN16.1Benefit Entry Rules18
BN16.2Add Rules110
BN16.3Change Rules110
BN16.4Termination Rules110
BN16.5Plan Entry Points01
BN16.6Plan Entry Points01
BN17.1Coverage Options by Plan36
BN17.2Coverage Option Defaults16
BN17.3Coverage Amounts18
BN18.1Options Amount38
BN18.2Options Amount Range38
BN18.3Flat Contributions38
BN18.4Salary or Coverage Rate Table38
BN18.5Contribution Limits38
BN18.6Match Limit Schedule38
BN18.7Match Percent Schedule38
BN19.1Options Rates29
BN19.2Options Rate Tables29
BN19.3Match Limits26
BN19.4Match Percents26
BN20.1General Ledger Overrides210
BN23.1Stock Option Grant16
BN30.1Benefit Process Order13
BN31.1Speed Benefit Entry1763
BN31.2Employee Benefit Entry1763
BN31.4Benefits Added Automatically02
BN31.5Benefits Added Automatically02
BN32.1Employee Benefit Changes1763
BN32.2Employee Benefit Detail Changes1763
BN32.3Benefit Add1763
BN33.1Employee Stock Option Grant Mass Entry110
BN33.2Employee Stock Option Grant111
BN33.3Employee Stock Option Vesting Detail18
BN33.4Employee Stock Option Transaction08
BN35.1Benefit Change Audit26
BN36.1Investment19
BN45.1Employee Flex Credits1145
BN46.1Flex Benefit Periods05
BN46.2Flex Benefits Inquiry06
BN47.1Beneficiaries29
BN48.1Savings Bond Beneficiaries19
BN48.2Savings Bond Purchase Sequence18
BN50.1Current Plan Participants06
BN51.1Employee Benefit Summary07
BN51.2Employee Benefit Detail010
BN52.1Plan Inquiry03
BN53.1Benefit Transactions112
BN55.1Defined Contribution or Defined Benefit Acct Balance010
BN55.2Vested Amounts111
BN56.1Compensation History18
BN57.1Vesting Hours17
BN59.1Spending Account Transactions17
BN59.2Enrollment Period Totals02
BN59.3Plan Year Spending Account Totals03
BN60.1Savings Bond History08
BN60.2Savings Bond Balance02
BN61.1Stock Purchase History07
BN61.2Stock Balance02
BN65.1Election Simulation1146
BN65.2Flex Credits04
BN66.1Estimated Pay Calculation4073
BN70.1COBRA Participant413
BN70.2Participant Dates14
BN71.1COBRA Benefit Entry1357
BN72.1Retiree Benefit Entry1357
BN77.1COBRA and Retiree Benefit Inquiry08
BN80.1Manual Invoice Entry511
BN81.1Cash Entry410
BN81.2Cash Entry and Application411
BN82.1Transaction Inquiry08
BN85.1Free Form Letter25
BN90.1Comments56
BS01.1Benefits Enrollment Rules23
BS02.1Benefits Plan Groups42
BS03.1Benefits Annual Enrollment Plan Rules16
BS03.2Benefits Life Event Plan Rules16
BS03.3Benefits New Hire Plan Rules16
BS03.4Current Benefits Display Rules24
BS04.1Benefits Number Of Dependents12
BS05.1Benefits New Hire Rules12
BS06.1Benefits Cycle Rules23
BS07.1Benefits Plan Type Rules11
BS09.1Employee Annual Enrollment Rules017
BS10.1Web Enrollment Current Benefit Inquiry950
BS11.1Web Enrollment Employee Flex Dollar Inquiry018
BS12.1Web Enrollment Eligible New Plans952
BS13.1Web Enrollment Coverage Options949
BS14.1Web Enrollment Coverage Amounts950
BS15.1Web Enrollment Contribution Limits952
BS30.1Web Pending Dependent Benefits14
BS31.1Web Pending Employee Benefits23
BS32.1Web Enrollment Stop Benefits Update1763
ZB01.1Years Of Service Calculation317
ZB10.1Coverage Options Calculator1764
ZB10.2Get Benefit Eligibility Dates322
ZB10.3Delete Web Pending Benefit Elections21
ZB31.1Speed Benefit Entry1763
ZB31.2Employee Benefit Entry1763
ZB31.4Benefits Added Automatically02
ZB31.5Benefits Added Automatically02
ZB32.1Employee Benefit Changes1763
ZB32.2Employee Benefit Detail Changes1763
ZB32.3Benefit Add1763

Batch programs (79)

ProgramDescriptionUpdatesReferences
BN100Employee Change Benefit Update2368
BN101Mass Benefit Add1866
BN102Plan Employee Update1866
BN103Mass Benefit Termination1866
BN104Frequency Table Update1122
BN105Plan Update2360
BN106Benefit Transaction Export218
BN107Stock Splits Update52
BN134Current Flex Time Record Delete34
BN137Stock Option Purge44
BN138This program has been retired.10
BN140Savings Bond Update39
BN141Stock Purchase Update26
BN145Flex Dollars Calculation1249
BN150Life Insurance Reportable Income4187
BN170COBRA Notification Report23
BN171COBRA Letter Print27
BN175Outstanding Invoice Listing35
BN180Invoice Edit65
BN181Invoice Print35
BN190General Ledger Update510
BN200Company Parameter Listing15
BN201Insurance Entity Listing12
BN202Rate Table Listing14
BN203Vesting Schedule Listing14
BN204Frequency Table Listing13
BN205Broker Listing11
BN206Flex Plan Listing110
BN207Stock Listing13
BN215Plan Parameter Listing123
BN216Benefit Entry Rules Listing18
BN220Benefit Plan Status Report17
BN223Stock Option Grant Listing17
BN230Plan Participant Report119
BN231Employee Benefit Report118
BN232Benefits Statement443
BN233COBRA and Retiree Benefit Report110
BN234Employee Stock Option Listing214
BN236Participation Report19
BN237Vesting Report19
BN238Vacation Hours History115
BN240Savings Bond Balance Report112
BN242One Page Benefits Statement119
BN245Benefit Election Form1063
BN246Flex Missing Benefits Report115
BN247Beneficiary Listing18
BN248Savings Bond Sequence Listing110
BN252Benefit Plans Listing13
BN258Spending Account Balance112
BN259Spending Account Payment Report18
BN260Employee Benefit Extract429
BN270COBRA Participant Listing15
BN281Cash Application Edit16
BN285Standard Letter Print210
BN300Key Employees17
BN305Highly Compensated Employees5371
BN310Top Heavy Report17
BN320Premium Report437
BN321Dependent Benefit Listing111
BN325Benefit Exception Report110
BN330Defined Contribution Plan Contributions112
BN331HIPAA Certification Report429
BN335Employee Deferral Report114
BN340ADP and ACP Tests434
BN345Percentage Test113
BN350Coverage Test - Classification113
BN430Benefit Purge1811
BN480Invoice and Payment Purge44
BN531Batch Benefit Enrollment1864
BN532Batch Dependent Benefit Enrollment312
BN533Employee Stock Option Grant Conversion28
BN534Employee Stock Option Transaction Conversion25
BN547Beneficiaries Conversion39
BN555Defined Benefit or Defined Contribution Balance Conv29
BN556Compensation History Upload26
BS531Web Pending Employee Benefit Extract36
ZB570Benefit Eligibility Extract11
ZB599Update Enrollment Data Structu19
ZS531Web Pending Employee Benefit Extract36

Other tables used by Benefits programs (205)

ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ADDRDATA, APPJOBHIST, APPLICANT, ATTENDCODE, BANKACCT, BANKFILE, BNATXLIMIT, BNLIMITS, BNTAEMPBAL, BNTAGROUP, C6BANKM, C6EMDDMSTR, C6EMPADDRT, C6EMPINV, C6EXEMPT, C6HOUSERNT, C6INPF, C6INVEST, C6NETWAGE, C6PRDDEF, C6PRDDTL, C6PREVEMP, C6PROJECTN, C6STATE, C6TAXGRP, CMASSIGN, CMCHANGE, CMCONTRACT, CMCONTRULE, CMEMPTRANS, CMPAYCYC, CUCODES, CUCONV, CURELAT, CWASSIGN, CWCHANGE, CWCONTRACT, CWCONTRULE, CWDISTRIB, CWEMPTRANS, DEDCODE, DEDFREQTBL, DEPTCODE, DEPTSEGBLK, EMACHDEPST, EMDEDMASTR, EMDEPEND, EMDISTMAST, EMPACHDIST, EMPCODES, EMPLOYEE, EMSTATUS, EMTAMASTR, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, GLADDRESS, GLCHART, GLCHARTDTL, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLNAMES, GLSYSTEM, GMAUDIT, GMEFFORT, GMLABDIST, GMRETDIST, GMTRANEFRT, HISTERR, HRCTRYCODE, HRDEPBEN, HREMPRCVR, HREMPUSF, HRHISTORY, HRLTMRULE, HRSECLEV, HRSUPER, HRUSERFLDS, HRUTILITY, HRWRKSCHD, INEMPLOYEE, INSTCTRYCD, JOBCODE, LPLINK, LPPENDREQ, MILITARY, ONETMDED, PAASSIGNED, PABUDGET, PACOMMENTS, PADICT, PADICT2, PAEEEORACE, PAEMPAPP, PAEMPAPTST, PAEMPLOYEE, PAEMPPOS, PAENCUMBER, PAERECRUIT, PAINSTRUCT, PAMEDICAL, PAPEPAUDIT, PAPOSCHG, PAPOSITION, PAPOSRULE, PASCRTY, PATHFIND, PATSTSETUP, PAYCLASS, PAYDEDUCTN, PAYMASTR, PAYSUMGRP, PCODES, PCODESDTL, PERSACTHST, PERSACTION, PERSACTYPE, PERSGROUP, PGEMPLOYEE, PGSELECT, PLANMASTER, PRBATCH, PRBUSGRP, PRCHECK, PRDEDDTL, PREMDEDHST, PREMPBANK, PREMPGARN, PRGARNHIST, PRGARNRULE, PRGARNRULX, PRGARNTYPE, PRMINWAGE, PRMONITOR, PRONWAGES, PROTPAYPRD, PROTWRKPRD, PROVERTIME, PRPAYCODE, PRPENFSRC, PRPENFSRCH, PRPENHIST, PRPENPAY, PRPROCGRP, PRPROVINCE, PRQCENTGRP, PRRATEHIST, PRRATES, PRREGPARM, PRSAGDTL, PRSAGHEAD, PRSHIFTHDR, PRSHIFTTBL, PRSTATE, PRSYSTEM, PRTAXAUTH, PRTAXLEVY, PRTAXLOC, PRTIME, PRTRDADJ, PSGRELATE, PSGTAXES, PWEMPLY, PWSUPER, QUARTDED, QUARTWAGE, REVIEW, STANDTIME, SUBCKPOINT, SYSRULES, SYSTEMCODE, TAEEGROUP, TAEEMASTER, TAEMPSERV, TAENROLL, TAPAYROLL, TAPLAN, TAREASCODE, TASERVCODE, TASERVICE, TASTRUCTUR, TAXGROUP, TAXIDEXMP, TIMERECORD, TIPPAY, TRSGBLCK, WCCLASS, WCCLASSHDR, WCCLASSOVR, WCPOLICY, WFSETUP