My Advisories

View My Advisories by using Millennium Explorer, My Millennium>Advisories.

If you create Assignments, and if the conditions of the Assignment are met, the Millennium Assignment Service will generate Advisories for you. Your Advisories are available for review on the My Advisories page. All of your Advisories, regardless of Status or Date Created, will display.

Tip: You can add the My Advisories page to your Home Page. See the My Millennium, Home Page topic for more information about adding My Advisories to your Home Page.

The My Advisories page will show the following information for each Advisory:

• Assignment Name - shows the name of the Assignment that triggered the Advisory.
• Category - shows the name of the category for the Assignment that triggered the Advisory.
• Status - indicates if this Advisory has been read or unread. The system will automatically assign a status, based on the action you take when you are notified that a new Advisory has been posted. You can manually edit the status of an Advisory from this display.
• Date Created - shows the date that the Millennium Assignment Service created the Advisory.
• Constituent - This shows the name of the constituent whose data triggered the creation of the Advisory.
• Hyperlink - This shows the name of the data table whose data row triggered the created of the Advisory. The table name is shown as a hyperlink. When you click the link, you will leave the My Advisories page and go to the display of the specified data row.

Change Advisory Status

Once you have read an Advisory, you may want to change its Status from Unread to Read.

1. On the My Advisories page, locate the individual Advisory and point to the Edit Button located to its left.
2. Click Mark as Read.

There may be times that you want to change an Advisory Status from Read, back to Unread.

1. On the My Advisories page, locate the individual Advisory and point to the Edit Button located to its left.
2. Click Mark as Unread.

Delete Advisories

To delete one Advisory:

1. On the My Advisories page, locate the individual Advisory and point to the Edit Button located to its left.
2. Click Delete.

Important! The System will automatically delete the Advisory. You will not have the opportunity to confirm your intention to delete.

To delete all of your Advisories:

1. On the My Advisories page, point to the Edit Button located to the left of any Advisory.
2. Click Delete All Advisories.

Important! The System will automatically delete every Advisory. You will not have the opportunity to confirm your intention to delete all Advisories.

Email Notification

When you create an Assignment, you can opt to have the Millennium Assignment Service generate an email message to notify you that an Advisory has been created. Activate this option by selecting the Send an Email to check box on Insert Assignment or Update Assignment forms. Manually enter an email address for a recipient. Enter a message in the Email Message box. This will be the body of the email message that serves as notification that an Advisory was posted.

Advisories Field Descriptions

The advisories table is located in the primary data database (for Oracle sites, the milldata tabl espace). For each Advisory that an Assignment generates, a row is inserted into this table.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
advkey		numeric/number 13, 0	This system-generated field holds the unique, primary key for the row.
advname		char 50	This system-generated field holds the name of the Assignment that is responsible for the generation of this Advisories row.
advuser		char 30	This system-generated field holds the User ID who 'owns' this Advisory and who will be notified.
advcat		char 6	This system-generated field holds the category of the Assignment that generated this Advisory.
advstat		char 30	This field holds status of the Advisory. It may be Read or Unread.
advaflag		char 1   ['N']	This field is a flag indicating whether a notification should (Y) or should not (N) be generated for this Advisory.This field is not used at this time.
adveflag		char 1   ['N']	This field is a flag indicating whether an email message should (Y) or should not (N) be generated for this Advisory.
advlflag		char 1   ['N']	This field is a flag indicating whether a letter should (Y) or should not (N) be generated for this Advisory.This field is not used at this time.
advrflag		char 1   ['N']	This field is a flag indicating whether a report should (Y) or should not (N) be generated for this Advisory.This field is not used at this time.
advtflag		char 1   ['N']	This field is a flag indicating whether a table should (Y) or should not (N) be generated for this Advisory.This field is not used at this time.
advemail		char 255	If an email is to be generated for this Advisory, this field will hold the email address.
advfile		char 3	This system-generated field will hold the file number of the primary table that is referenced in this Advisory.
advtype		char 6	This system-generated field holds the type of selection specified in the Assignment that generated this Advisory. This may be all constituents' information (' '), the user's Prospects (P), the user's Bookmarked constituents (B), a single constituent (S), or a worktable (W). If you have chosen any combination of the last four options, this field will contain the code for each that is chosen.
advdoc		char 255	If this Advisory is to generate a letter, this field holds the name of that letter.This field is not used at this time.
advrept		char 100	If the Advisory is to generate a report, this field holds the name of that report.This field is not used at this time.
advresp		char 30	This field is not used at this time.
advdkey		char 9	If the Advisory is the result of a single data row, this field will hold a copy of the primary key for that row.
advid		char 10	If the Advisory is the result of a single data row, this field will hold a copy of the id number for the constituent who owns that row.
advncname		char 200	If the Advisory is the result of a single data row, this field will hold a copy of the formatted name of the constituent who owns that row.
advsmash		char 30	If the Advisory is the result of a single data row, this field will hold a copy of the smashed name of the constituent who owns that row.
advamount		money/number 19,4	If the Assignment involved an amount, this field holds that amount.
advmsg		char 255	If the Advisory is to create an email message, this field holds the text for that message.
advtime		datetime/date 8   [getdate()]	This field holds the date and time of the creation of the Advisory.
advsnzint		datetime/date 8	This field is not used at this time.
advcheck		numeric/number 13, 0	This field is not used at this time.
advdecode		char 300	This system-generated field is for system-use only.

Indices - Advisories

Index	Primary	Foreign	Unique	Fields	Sort
pk_advisories	Y			advkey	ASC
adv01				advdkey, advfile	ASC
adv02				advstat	ASC
adv03				advtime	ASC
adv04				advuser	ASC

Top of Page