| EMPLOYID | char(15) | Yes | Employee ID - | IN |
| BENEFIT | char(6) | Yes | Benefit - | IN |
| INACTIVE | tinyint | No | Inactive - - 0 = False & 1 = True | IN |
| BNFBEGDT | datetime | Yes | Benefit Begin Date - | IN |
| BNFENDDT | datetime | No | Benefit End Date - | IN |
| VARBENFT | tinyint | Yes | Variable Benefit/Transaction Required - - 0 = False & 1 = True | IN |
| BNFTFREQ | smallint | No | Benefit Frequency - - 1 = Weekly, 2 = Biweekly | IN |
| SBJTFDTX | tinyint | No | Subject to Federal Tax - - 0 = False & 1 = True | IN |
| SBJTSSEC | tinyint | No | Subject to FICA Soc Sec Tax - - 0=False & 1=True | IN |
| SBJTMCAR | tinyint | No | Subject to FICA Medicare Tax - - 0=False & 1=True | IN |
| SBJTSTTX | tinyint | No | Subject to State Tax - - 0 = False & 1 = True | IN |
| SBJTLTAX | tinyint | No | Subject to Local Tax - - 0 = False & 1 = True | IN |
| SBJTFUTA | tinyint | No | Subject to FUTA Tax - - 0 = False & 1 = True | IN |
| SBJTSUTA | tinyint | No | Subject to SUTA Tax - - 0 = False & 1 = True | IN |
| FFEDTXRT | numeric(19,5) | No | Flat Federal Tax Rate - | IN |
| FLSTTXRT | numeric(19,5) | No | Flat State Tax Rate - | IN |
| BORCDTYP | smallint | No | Based on Record Type - - 1=Pay Codes & 2=Deductions | IN |
| BSDORCDS | smallint | No | Based on Records - - 0 = False & 1 = True | IN |
| BNFTMTHD | smallint | No | Benefit Method - - 1 = % of Gross Wages, | IN |
| BNFFRMLA | smallint | No | Benefit Formula - - 0=Single & 1=Multiple | IN |
| BNFPRCNT_1 | numeric(19,5) | No | Benefit Percent 1 - | IN |
| BNFPRCNT_2 | numeric(19,5) | No | Benefit Percent 2 - | IN |
| BNFPRCNT_3 | numeric(19,5) | No | Benefit Percent 3 - | IN |
| BNFPRCNT_4 | numeric(19,5) | No | Benefit Percent 4 - | IN |
| BNFPRCNT_5 | numeric(19,5) | No | Benefit Percent 5 - | IN |
| BNFITAMT_1 | numeric(19,5) | No | Benefit Ammount 1 - | IN |
| BNFITAMT_2 | numeric(19,5) | No | Benefit Ammount 2 - | IN |
| BNFITAMT_3 | numeric(19,5) | No | Benefit Ammount 3 - | IN |
| BNFITAMT_4 | numeric(19,5) | No | Benefit Ammount 4 - | IN |
| BNFITAMT_5 | numeric(19,5) | No | Benefit Ammount 5 - | IN |
| BNFTRMAX_1 | numeric(19,5) | No | Benefit Tier Max 1 - | IN |
| BNFTRMAX_2 | numeric(19,5) | No | Benefit Tier Max 2 - | IN |
| BNFTRMAX_3 | numeric(19,5) | No | Benefit Tier Max 3 - | IN |
| BNFTRMAX_4 | numeric(19,5) | No | Benefit Tier Max 4 - | IN |
| BNFTRMAX_5 | numeric(19,5) | No | Benefit Tier Max 5 - | IN |
| BNTRMXUN_1 | numeric(19,5) | No | Benefit Tier Max Units 1 - | IN |
| BNTRMXUN_2 | numeric(19,5) | No | Benefit Tier Max Units 2 - | IN |
| BNTRMXUN_3 | numeric(19,5) | No | Benefit Tier Max Units 3 - | IN |
| BNTRMXUN_4 | numeric(19,5) | No | Benefit Tier Max Units 4 - | IN |
| BNTRMXUN_5 | numeric(19,5) | No | Benefit Tier Max Units 5 - | IN |
| BNPAYPMX | numeric(19,5) | No | Benefit Pay Period Maximum - | IN |
| BNFYRMAX | numeric(19,5) | No | Benefit Year Maximum - | IN |
| Benefit_Fiscal_Max | numeric(19,5) | No | Benefit Fiscal Year Maximum - | IN |
| BNFLFMAX | numeric(19,5) | No | Benefit Lifetime Maximum - | IN |
| W2BXNMBR | smallint | No | W-2 Box Number - | IN |
| W2BXLABL | char(6) | No | W-2 Box Label - | IN |
| W2BXNMBR2 | smallint | No | W-2 Box Number 2 - | IN |
| W2BXLABL2 | char(6) | No | W-2 Box Label 2 - | IN |
| W2BXNMBR3 | smallint | No | W-2 Box Number 3 - | IN |
| W2BXLABL3 | char(6) | No | W-2 Box Label 3 - | IN |
| W2BXNMBR4 | smallint | No | W-2 Box Number 4 - | IN |
| W2BXLABL4 | char(6) | No | W-2 Box Label 4 - | IN |
| DATAENTDFLT | tinyint | No | Data Entry Default - - 0 = False & 1 = True | IN |
| EMPLRMAXMAT | numeric(19,5) | No | Employer Match Maximum - | IN |
| UseDefaultCoBenefit | smallint | No | Optional if @I_vUseDefaultCoBenefit = 1 | IN |
| UpdateIfExists | tinyint | No | Flag to allow customer data to be updated if it exists. 0=no, 1=yes | IN |
| RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
| USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
| USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
| ErrorState | int | No | Return value: 0=No Errors, 1=Error Occurred | INOUT |
| oErrString | varchar(255) | No | Return Error Code List | INOUT |