BPMaster

PlanID	Plan Identifier	BigID	12
CompanyID	Company Identifier	SmallID	12
PlanName	Plan Name	Varchar	80
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
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
CobraFlg	Covered Under Coba Flag	Varchar	1
CobraFreq	Cobra Fees Frequency	Enum	1		Enum
CobraPEAmt	Cobra Fee Per Employee	Number	22
CobraPPAmt	Cobra Fee Per Plan	Number	22
CobraRates	Cobra Rates Flag	Enum	1		Enum
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
PlanNbr	Plan Number	Varchar	40
PlanStatus	Plan Status	Enum	1		Enum
PlanType	Plan Type	Enum	1		Enum
PortPFlg	Portable Plan Flag	Varchar	1
PPOFeeFlg	PPO Fee Flag	Varchar	1
PPOID	PPO Identifier	BigID	12
ProRateFlg	Pro Rate Flag	Enum	1		Enum
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