APR_BLM42100 - Future Effective Payroll Benefit Setup
SQL Query Builder
57 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BENEFIT | char(7) '' | ||||
| DSCRIPTN | char(31) '' | ||||
| INACTIVE | tinyint 0 | ||||
Active Status values (2) 0 = Active1 = Inactive | |||||
| BNFBEGDT | datetime '1/1/1900' | ||||
| BNFENDDT | datetime '1/1/1900' | ||||
| VARBENFT | tinyint 0 | ||||
| BNFTFREQ | smallint 0 | ||||
| TAXABLE | tinyint 0 | ||||
| SBJTFDTX | tinyint 0 | ||||
| SBJTSSEC | tinyint 0 | ||||
| SBJTMCAR | tinyint 0 | ||||
| SBJTSTTX | tinyint 0 | ||||
| SBJTLTAX | tinyint 0 | ||||
| SBJTFUTA | tinyint 0 | ||||
| SBJTSUTA | tinyint 0 | ||||
| FFEDTXRT | smallint 0 | ||||
| FLSTTXRT | smallint 0 | ||||
| BORCDTYP | smallint 0 | ||||
| BSDORCDS | smallint 0 | ||||
| BNFTMTHD | smallint 0 | ||||
| BNFFRMLA | smallint 0 | ||||
| BNFPRCNT_1 | numeric(19,5) 0 | ||||
| BNFPRCNT_2 | numeric(19,5) 0 | ||||
| BNFPRCNT_3 | numeric(19,5) 0 | ||||
| BNFPRCNT_4 | numeric(19,5) 0 | ||||
| BNFPRCNT_5 | numeric(19,5) 0 | ||||
| BNFITAMT_1 | numeric(19,5) 0 | ||||
| BNFITAMT_2 | numeric(19,5) 0 | ||||
| BNFITAMT_3 | numeric(19,5) 0 | ||||
| BNFITAMT_4 | numeric(19,5) 0 | ||||
| BNFITAMT_5 | numeric(19,5) 0 | ||||
| BNFTRMAX_1 | numeric(19,5) 0 | ||||
| BNFTRMAX_2 | numeric(19,5) 0 | ||||
| BNFTRMAX_3 | numeric(19,5) 0 | ||||
| BNFTRMAX_4 | numeric(19,5) 0 | ||||
| BNFTRMAX_5 | numeric(19,5) 0 | ||||
| BNTRMXUN_1 | int 0 | ||||
| BNTRMXUN_2 | int 0 | ||||
| BNTRMXUN_3 | int 0 | ||||
| BNTRMXUN_4 | int 0 | ||||
| BNTRMXUN_5 | int 0 | ||||
| BNPAYPMX | numeric(19,5) 0 | ||||
| BNFYRMAX | numeric(19,5) 0 | ||||
| BNFLFMAX | numeric(19,5) 0 | ||||
| W2BXNMBR | smallint 0 | ||||
| W2BXLABL | char(7) '' | ||||
| NOTEINDX | numeric(19,5) 0 | ||||
| DATAENTDFLT | tinyint 0 | ||||
| EMPLRMAXMAT | numeric(19,5) 0 | ||||
| W2BXNMBR2 | smallint 0 | ||||
| W2BXLABL2 | char(7) '' | ||||
| W2BXNMBR3 | smallint 0 | ||||
| W2BXLABL3 | char(7) '' | ||||
| W2BXNMBR4 | smallint 0 | ||||
| W2BXLABL4 | char(7) '' | ||||
| Benefit_Fiscal_Max | numeric(19,5) 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with APR_BLM42100. Click "Join" to add to your query.
BENEFIT
VARBENFT
BNFTFREQ