| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | BAPLAN | Plan ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | BAEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | BADC | Description - Compressed | String | Generic Edit | 40 | 0 | Allow NULL? |
| 4 | BAANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | BAEFT | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 6 | BAEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 7 | BASTUS | Status Code | Character | UDC (08 ST) | 1 | 0 | Allow NULL? |
| 8 | BAPLTY | Plan Type | String | UDC (08 PT) | 2 | 0 | Allow NULL? |
| 9 | BABENF | Trans. Code - Beneficiary Flag | Character | UDC (08 DC) | 1 | 0 | Allow NULL? |
| 10 | BACERN | Policy/Reference Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | BACOVA | Amount - Coverage | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | BAPREP | Amount - Premium Payment | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | BAVTAB | Vesting Table | String | UDC (06 VT) | 5 | 0 | Allow NULL? |
| 14 | BAEDBA | Percentage - Employee | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 15 | BAFDBA | Employee DBA ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | BARDBA | Percentage - Employer | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | BASDBA | Employer DBA ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 18 | BAMANP | Mandatory Participation | Character | UDC (08 YN) | 1 | 0 | Allow NULL? |
| 19 | BAPCDO | Per Coverage Dollars | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 20 | BASALF | Salary Factor | Numeric | Generic Edit | 5 | 1 | Allow NULL? |
| 21 | BADTAB | Table Code | String | Generic Edit | 5 | 0 | Allow NULL? |
| 22 | BAPDDP | Payroll DBA For Deduction Points | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 23 | BAPDCP | Payroll DBA For Credit Points | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 24 | BADPYN | Flex or Spending Account Type | Character | UDC (08 DQ) | 1 | 0 | Allow NULL? |
| 25 | BAVCRL | Vesting Calculation Rule | String | UDC (08 CR) | 2 | 0 | Allow NULL? |
| 26 | BAPTVH | Pay Type Table | String | UDC (08 TT) | 4 | 0 | Allow NULL? |
| 27 | BAVSMH | Vesting Minimum Hours | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 28 | BAVCPE | Vesting Computation Period | Character | UDC | 1 | 0 | Allow NULL? |
| 29 | BAPH01 | Category Code - Plan Master 01 | String | UDC (08 B1) | 3 | 0 | Allow NULL? |
| 30 | BAPH02 | Category Code - Plan Master 02 | String | UDC (08 B2) | 3 | 0 | Allow NULL? |
| 31 | BAPH03 | Category Code - Plan Master 03 | String | UDC (08 B3) | 3 | 0 | Allow NULL? |
| 32 | BAPH04 | Category Code - Plan Master 04 | String | UDC (08 B4) | 3 | 0 | Allow NULL? |
| 33 | BAPH05 | Category Code - Plan Master 05 | String | UDC (08 B5) | 3 | 0 | Allow NULL? |
| 34 | BAPH06 | Category Code - Plan Master 06 | String | UDC (08 B6) | 3 | 0 | Allow NULL? |
| 35 | BAPH07 | Category Code - Plan Master 07 | String | UDC (08 B7) | 3 | 0 | Allow NULL? |
| 36 | BAPH08 | Category Code - Plan Master 08 | String | UDC (08 B8) | 3 | 0 | Allow NULL? |
| 37 | BAPH09 | Category Code - Plan Master 09 | String | UDC (08 B9) | 3 | 0 | Allow NULL? |
| 38 | BAPH10 | Category Code - Plan Master 10 | String | UDC (08 B0) | 3 | 0 | Allow NULL? |
| 39 | BAUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 40 | BAPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | BAUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 42 | BAJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | BAXET1 | Eligibility Table 1 | String | Generic Edit | 4 | 0 | Allow NULL? |
| 44 | BAXET2 | Eligibility Table 2 | String | Generic Edit | 4 | 0 | Allow NULL? |
| 45 | BAEAOR | Amount or Rate | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | BAARFL | Age Rate Flag For Enrollment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | BAPPLN | Plan - Prerequisite | String | Generic Edit | 8 | 0 | Allow NULL? |
| 48 | BAMXPR | Amount - Maximum Premium | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 49 | BARNDA | Amount - Rounding | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 50 | BACBRA | Transfer to COBRA | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 51 | BAPLN2 | Secondary 401(k) Plan | String | Generic Edit | 8 | 0 | Allow NULL? |
| 52 | BAFSAF | Flex or Spending Account Type | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 53 | BAPAYF | Pay Type for Flexible Spending Accts | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 54 | BAFLXA | EE Points Allowance for Flex Benefits | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 55 | BAPLTZ | Prerequisite Plan Type | String | UDC (08 PT) | 2 | 0 | Allow NULL? |
| 56 | BAEFL1 | Flag - Employee/Employer | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 57 | BAEFL2 | Flag - Employee/Employer | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 58 | BAEFL3 | Flag - Employee/Employer | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 59 | BAEFL4 | Flag - Employee/Employer | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 60 | BAEFP1 | Flag - Points/Money | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 61 | BAEFP2 | Flag - Points/Money | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 62 | BAEFP3 | Flag - Points/Money | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 63 | BAEFP4 | Flag - Points/Money | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | BAEFR1 | Flag - Rate Entry | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 65 | BAEFR2 | Flag - Rate Entry | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 66 | BAEFR3 | Flag - Rate Entry | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 67 | BAEFR4 | Flag - Rate Entry | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |