BPMaster

PlanID	Plan Identifier	BigID	12
CompanyID	Company Identifier	SmallID	12
PlanName	Plan Name	Varchar	250
PlanDescrp	Plan Description	Varchar	255
EssEnable	Field is allowed in ESS (Y/N)	Varchar	1
EssReqProvider	[Require | Optional | None] Entry of a provider is required in ESS	Enum	1		ENUM R Require O Optional N None
EssAltName	Alternate name shown in ESS	Varchar	80
EssReqProv	Require provider in ESS	Varchar	1
EssProviderLink	URL for provider. Do we want this in another table, though for eff.	Text	16000
EssProvLnkTitle	Link to providers website	Text	16000
AdminAddr1	Admin Address, Line 1	Varchar	40
AdminAddr2	Admin Address, Line 2	Varchar	40
AdminCity	Admin Address, City	Varchar	40
AdminCmpny	Admin Company Name	Varchar	40
AdminEmail	Admin Email Address	Varchar	80
AdminFax	Admin Fax Number	Varchar	25
AdminName	Admin Name	Varchar	40
AdminState	Admin Address, State	Varchar	40
AdminTitle	Admin Title	Varchar	40
AdminZip	Admin Address, Zip Code	Varchar	10
CarrierID	Carrier Identifier	BigID	12
CobraAdPct	Cobra Add-on Percentage	Number	22
CobraCCAmt	Cobra Covered Child Amt	Number	22
CobraCEAmt	Cobra Covered Employee Amt	Number	22
CobraCSAmt	Cobra Covered Spouse Amt	Number	22
CobraFeeTp	Cobra Fee Type	Enum	1		ENUM P Per Plan C Per COBRA Enrollee E Per Employee
CobraFlg	Covered Under Coba Flag	Varchar	1
CobraFreq	Cobra Fees Frequency	Enum	1		ENUM M Monthly Q Quarterly Y Annually
CobraPEAmt	Cobra Fee Per Employee	Number	22
CobraPPAmt	Cobra Fee Per Plan	Number	22
CobraRates	Cobra Rates Flag	Enum	1		ENUM C Use Current Rates P Add Fixed Percentage N Setup New Plan S Use Separate Rates
CobraTPAFl	Cobra TPA Fee Flag	Varchar	1
CobraTPAID	Cobra TPA Identifier	BigID	12
ConvertFlg	Convertable Plan Flag	Varchar	1
DueDate	Due date	Date	32
GroupNbr	Group Number	Varchar	40
Period	Period	Long	12
PhoneNbr	Phone Number	Varchar	40
PlanAcct	Plan Account Number	Varchar	40
PlanFeeAmt	Plan Wide Fee Amount	Number	22
PlanFeeFlg	Plan Wide Fee Flag	Varchar	1
PlanFeeFrq	Plan Wide Fee Frequency	Enum	1		ENUM M Monthly Q Quarterly Y Annually
PlanNbr	Plan Number	Varchar	40
PlanStatus	Plan Status	Enum	1		ENUM A Active I Inactive P In-Planning
PlanType	Plan Type	Enum	1		ENUM M Med D Den V Vis H Hear P Rx L XL S STD X LTD I Life J SLif C 125 K Ret E Other
PortPFlg	Portable Plan Flag	Varchar	1
PPOFeeFlg	PPO Fee Flag	Varchar	1
PPOID	PPO Identifier	BigID	12
ProRateFlg	Pro Rate Flag	Enum	1		ENUM N Not Pro-Rated D Based on Days in Month H Based on Half Month
SelfFndFlg	Self Funded Flag	Varchar	1
StartDate	Starting Date	SmallDate	32
StopDate	Ending Date	Date	32
TPAID	TPA Identifier	BigID	12
WizSteps	Wizard Steps	Varchar	255
CobraSpAtEERtFlg	Cobra Spouse at Employees Rate	Varchar	1
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12