BENEFIT | char(6) | Yes | Benefit - | IN |
DSCRIPTN | char(30) | Yes | Deduction Description - | 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 Social Security 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 | smallint | IN |
FLSTTXRT | numeric(19,5) | No | smallint | 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 - | 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 Maximum Match - | 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 |