More information

Field Descriptions

Indices

Profiles World

Site Specific Notes

Comments

Comments are designed to hold free text information about a constituent that is brief and general. Millennium provides three techniques for maintaining textual information within Millennium.

Comments can be edited at any time. The system will record the date of the last change of the comment as well as the User ID of the person who made the change.

Your institution should establish a protocol for recording free text comments as to when each of these techniques will be used. This will avoid duplication and avoid complications for those who view data and report on it! You should also avoid entering information about a constituent in a Comments row that would more appropriately be entered in another row and field.

Notes:

The Millennium system administrator or the database administrator can configure audit logging for the Comments data table. For more information, see Audit Log.

An Administrator can remove the Comments table from the Millennium Explorer if not used. See Table Options for more information.

The number of rows displayed per page can be changed at anytime by using the Paging selections at the bottom of the table. Users may also navigate to various pages by using this feature (see Paging Data for more information).

Linked Comments

When a Comment row exists for a constituent, you may create a one-to-one linked Comment row belonging to the spouse or another constituent. This type of linked row will be a copy of the first constituent's row. You may also link an existing Comment row to a Comment row that also already exists for the spouse or another constituent; when you do so, the Comment row for the second constituent will be overwritten with the first constituent's Comment row information.

Because they are linked, any edits that are made via one constituent's row will automatically be applied to the second constituent's row as well. This is true whether subsequent edits are made via the original constituent or the second constituent's data row. Likewise, if either of the rows is deleted, the linked row will also be deleted. Linked rows may be unlinked. This preserves both data rows and allows you to perform edits or deletions to one without affecting the other.

The following topics discuss the creation and maintenance of linked Comment rows in complete detail.

Data Maintenance, Link New to Existing

Data Maintenance, Link to Existing to Existing

Data Maintenance, How to Link New to Existing

Data Maintenance, How to Link Existing to Existing

Comment Formatting

The characters that are entered in a comment text field (in this, the Comments data table, as well as in any other table which maintains a comment field) are stored in Millennium, as entered, unless the system administrator elects to not store formatting characters such as tabs, line feeds, and new lines in the comment fields. If so elected, the Remove Comment Formatting System Option is set to No, and applies to all users of Millennium.

Comments Field Descriptions

Comments data is stored in the comments data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition. The Comments data table also includes five fields that are used only for Alerts and are noted.

Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.

Field Name

Field Label

 Lookup Table

Type SQL/Oracle

Length

[Default]

{Check}

 Description

commkey

non-displaying

 none

numeric/number

13,0

 

 

 The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System column)

commid

non-displaying

 none

char

10

 

 

 This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System column)

commdoc

non-displaying

 none

char

1

['N']

 

 This field holds a Y/N flag to indicate the existence of a linked document for this row. (System column)

commdate

no label

 none

datetime/date

 

[getdate()]

 

 The date that this Comment row was last updated. This field is automatically entered by the system. (System column)

commuserid

no label

 none

varchar/varchar2

30

[suser_sname()]

 

 The User ID of the operator that last edited this Comment row. It is automatically entered by the system. (System column)

commugroup

non-displaying

 none

char

1

['Z']

 

 This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System column)

commtype

no label

 Comment Type

char

6

[' ']

 

A description of the kind or classification of the information.

If this is an alert row, the comment type is set to 'alert'.

commcommnt

no label

 none

varchar/varchar2

4000

 

 

A brief, free text, set of information about or for the constituent.

This text is displayed in a pop-up for Alerts.

commsource

Source

 Source

char

6

[' ']

 

 The source for this Comment information.

commpoint

non-displaying

 none

numeric/number

10,0

 

 

 This system-assigned field is no longer used or supported. (System Column)

commfnum

non-displaying

 none

char

2

['09']

{'09'}

 The file (table) number for the Comment table. (System Column)

commcrdate

non-displaying

 none

datetime/date

 

[getdate()]

 

 The date that the row was created. (System Column)

commdate1

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate2

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commmny1

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny2

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commnum1

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum2

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commyesno

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commlook1

 

 Comments Lookup1

char

6

 

 

 This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

commlook2

 

 Comments Lookup2

char

6

 

 

 This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

commlook3

 

 Comments Lookup3

char

6

 

 

 This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

commtext

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commjntid

non-displaying

 none

char

10

[' ']

 

 If this row is joint with another constituent (each constituent owns a row containing the same data and which are dynamically updated), this field provides linkage between the two rows. If the row is not joint, this field is blank. If it is joint, this field holds a copy of the ID Number of the other constituent who owns the other data row. (System Column)

commjntkey

non-displaying

 none

numeric/number

13,0

[0]

 

 If this row is joint with another constituent (each constituent owns a row containing the same data and which are dynamically updated), this field provides linkage between the two rows. If the row is not joint, this field is blank. If it is joint, this field holds a copy of the key field from the other data row. (System Column)

commowner

 

 none

varchar

 

 

 

THIS COLUMN IS USED ONLY FOR ALERTS

This field holds the information that is selected from the Type radio buttons. If User is selected, this field will hold the Users login name. If Group is selected, this field will hold the Group name the user belongs to. If Public is selected, this field will hold the name 'PUBLIC '.

commowngrp

 

 none

char

1

 

 

THIS COLUMN IS USED ONLY FOR ALERTS

 

This Y/N flag indicates whether an alert notification is to be used for a group or public/user.

 

'Y' = Group

'N' = 'PUBLIC ' or User

commtblnum

 

 none

char

2

 

 

THIS COLUMN IS USED ONLY FOR ALERTS

This field defines what Profiles Table the alert corresponds to.

commstrtdt

Begin

 none

datetime

 

 

 

THIS COLUMN IS USED ONLY FOR ALERTS

This field allows the user to define when the date for when the alert will start.

commstopdt

End

 none

datetime

 

 

 

THIS COLUMN IS USED ONLY FOR ALERTS

This field allows the user to define when the date for when the alert will end.

commpend

Pending

 none

char

1

['N']

{Not Null}

 This field is a flag to indicate that this data row has linked information in the 'pending' Comments table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is pending incorporation into this data row. (System field)

commpubfl

Publish

 none

char

1

['N']

{Not Null}

 This field is a flag to indicate whether this data row will or will not be available for online publishing. This flag will be applicable when the Options for Publishing Data for the Comments table are set to 'Published by Consent'. Otherwise, the corepub09 column flag in the Basic Data table will be used.

commupkey

non-displaying

 none

numeric/number

13,0

 

 

 This field holds the Timekey of the pending data row that may be updated from the name_pending table. (System field)

commdate3

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate4

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate5

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate6

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate7

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate8

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdate9

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdte10

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdte11

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commdte12

 

 none

datetime/date

 

 

 

 This custom field may be defined and used by your institution to track any date information associated with this data row.

commmny3

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny4

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny5

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny6

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny7

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny8

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny9

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny10

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny11

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commmny12

 

 none

money/number

(19,4)/(16,2)

 

 

 This custom field may be defined and used by your institution to track any monetary information associated with this data row.

commnum3

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum4

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum5

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum6

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum7

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum8

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum9

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum10

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum11

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commnum12

 

 none

numeric/number

10, 0

 

 

 This custom field may be defined and used by your institution to track any numeric information associated with this data row.

commchk1

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk2

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk3

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk4

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk5

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk6

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk7

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk8

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk9

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commchk10

 

 none

char

1

['N']

{'N' or 'Y'}

 This custom field may be defined and used by your institution to flag this data row for any purpose.

commtxt1

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commtxt2

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commtxt3

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commtxt4

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commtxt5

 

 none

varchar/varchar2

255

 

 

 This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

commadesrc

non-displaying

 ade_source

char

30

 

 

 If this row is created or updated from data that originally came from the comments_pending table, then this field will hold information about the data's import source. Data from the Online Constituent Directory will have a source of Online Directory. Data from Soft Edit users will have a source of Soft Edit. Data whose import source is the ADE Import Tool can be assigned a value (other than Online Directory or Soft Edit) from the ade_source lookup table by the user who executes the utility, or the source can be blank.

Indices - Comments

Index Primary Foreign Unique Fields Sort
pk_comments Y   Y commkey ASC
comm02   Y   commid ASC
comm03   Y   commtype ASC
comm04       commjntkey ASC
comm05       commowner ASC
comm06       commtblnum ASC

Top of Page