Menu Close

PH_PLANS

Table with one row for each plan in Atlas

ColumnComments
PROSPECTPLANDIMID
CONSTITUENTDIMID
HOUSEHOLDDIMIMD
PLANOWNERNAME
PLANOWNERSORTNAME
PLANNAME
PLANTYPE
PLANSTARTDATE
PLANNARRATIVE
PLANISACTIVE
OPPORTUNITYCOUNT
PLANPRIMARYMANAGERDIMID
PLANPRIMARYMANGERSORTNAME
PLANSECONDARYMANAGERDIMID
PLANSECONDARYMANAGERSORTNAME
PLANPARTICIPANTLIST
PLANBUSINESSUNITFrom Prospect Plan attribute "Business Unit"
PLANOPPORTUNITYCOUNT
PLANSECONDARYSOLICITORLIST
NEXTPLANSTEPDIMID
NEXTPLANSTEPSTATUS
NEXTPLANSTEPOBJECTIVE
NEXTPLANSTEPEXPECTEDDATE
NEXTPLANSTEPOWNER
NEXTPLANSTEPSTAGE
NEXTPLANSTEPCATEGORY
NEXTPLANSTEPSUBCATEGORY
NEXTPLANSTEPCONTACTMETHOD
NEXTPLANSTEPPARTICIPANTS
NEXTPLANSTEPADDITIONALSOLICITORS
LASTCOMPLETEDPLANSTEPDIMID
LASTCOMPLETEDPLANSTEPSTATUS
LASTCOMPLETEDPLANSTEPOBJECTIVE
LASTCOMPLETEDPLANSTEPEXPECTEDDATE
LASTCOMPLETEDPLANSTEPOWNER
LASTCOMPLETEDPLANSTEPSTAGE
LASTCOMPLETEDPLANSTEPCATEGORY
LASTCOMPLETEDPLANSTEPSUBCATEGORY
LASTCOMPLETEDPLANSTEPCONTACTMETHOD
LASTCOMPLETEDPLANSTEPPARTICIPANTS
LASTCOMPLETEDPLANSTEPADDITIONALSOLICITORS

Leave a Reply