Attributes
An Attribute row is used to maintain information that is specific to your institution, concerning a constituent, and which is not recorded elsewhere in the Millennium tables. A constituent can have an unlimited number of Attribute rows. You define the Attributes through the Attribute Types lookup table which contains all possible Attribute codes. Examples of the use of Attributes include: board memberships, sports participation, fraternity memberships, donor interests, alumni activities, civic interests, and undergraduate activities.
Note: An Administrator can remove the Attributes table from the Millennium Explorer if not used. See Table Options for more information.
You may assign a Group designation to any of the Attribute Types so that they can be displayed or selected based on a common Grouping. For example, if all Attribute Types that represent participation in civic organizations are given the same Group code, then filtering, sorting or reporting criteria can select rows with that Group code, rather than listing each of the Types individually.
A free text Position field is available to maintain the name of a position held in an organization. Two Descriptor fields are available to categorize the Attribute. Start and End dates may be assigned to each Attribute row to show whether this is an on-going association or the duration and timing of a previous or future one.
Attribute rows may be inserted one by one into the database via standard Millennium Data Maintenance procedures, or en masse by utilizing the Add Attribute Utility.
Attribute rows may be deleted one by one from the database via standard Millennium Data Maintenance procedures, or en masse via the Delete Attribute Utility.
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).
Note: Millennium system administrators or the database administrator can configure audit logging for the Attribute data table. For more information, see Audit Log.
Linked Attributes
An Attribute row may be linked to particular rows in several other Millennium Data tables: Basic Data, Employment, Education, or Tracking. Attributes linked in this way display with the primary row to which they are linked, and if the Display Linked Attributes in the Attribute Display user option is checked, they will also display with the Attribute table display. These secondary linked attribute rows are stored with the Attribute table. However, for data maintenance purposes, users should access them through the display of the primary rows to which they link and not through the constituent's Attribute display.
When an Attribute row exists for a constituent, you may also create a one-to-one linked Attribute 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 Attribute row to an Attribute row that also already exists for the spouse or another constituent; when you do so, the Attribute row for the second constituent will be overwritten with the first constituent's Attribute row information.
Because the Attributes 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 Attribute 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
The Attribute Type field is driven by the Attribute Type lookup table. Each entry in that lookup table may be flagged for use in an independent Attribute data row, or in any of the linked Attribute situations, or in any combination of those situations. For example, an entry in the Attribute Types lookup table might be flagged for use in an independent Attribute row (table_03 is set to 'Y'), and in an Attribute row linked to Basic Data (table_00 is set to 'Y'). This lookup table entry then, will not be available in the Attribute insert or update forms when used for an Attribute that is linked to Employment, Education or Tracking.
Attribute Field Descriptions
Attribute data is stored in the attribute 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 template.
Field Name Field Label |
Lookup Table |
Type SQL/Oracle Length [Default] {Check} |
Description |
---|---|---|---|
attrkey 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) |
attrid 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) |
attrdoc 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) |
attrdate no label |
none |
datetime/date
[getdate()]
|
The date that this attribute row was last updated. This field is automatically entered by the system. (System column) |
attruserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this attribute row. It is automatically entered by the system. (System column) |
attrugroup 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) |
no label |
Attribute Type |
char 6
|
The characteristic associated with this constituent. When an entry from the Attribute Type lookup table is chosen for this row, the code from that entry is held in this field and the value is held in the attrtypenm field. |
attrgroup Group |
Table Groups |
char 6 [' ']
|
A user defined method of grouping similar types of attributes. (System column) |
Start |
none |
datetime/date
|
Indicates the date on which this attribute became effective. |
Stop |
none |
datetime/date
|
Indicates the date on which this attribute ceases to be valid. |
attrsource Source |
Source |
char 6 [' ']
|
The source for this attribute information. |
attrpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (System column) |
attrlnkfil non-displaying |
none |
char 2
|
If this Attribute row is linked to another row, this field holds the file (table) number of that row. (System column) |
attrlnkkey non-displaying |
none |
numeric/number 13,0
|
If this Attribute row is linked to another row in the database, this field holds a copy of the Key field from the row to which it is linked. (System column) |
Descriptor 1 |
Attribute Descriptors |
char 6 [' ']
|
An institution-defined classification or categorization system for Attributes. |
attrdescr2 Descriptor 2 |
Attribute Descriptors2 |
char 6 [' ']
|
An institution-defined classification or categorization system for Attributes. |
Position |
none |
char 30
|
If this Attribute represents an association with a club, team, or other organization, this field might be used for the Position held by the constituent in that organization. |
attrfnum non-displaying |
none |
char 2 ['03'] {'03} |
The file (table) number for the Attribute table. (System column) |
attrcrdate non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (System column) |
attrcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
no label |
Attribute Type |
char 65
|
This field holds a copy of the value from the Attribute Type lookup table that is chosen for this row. The attrtype field holds a copy of the code from that lookup entry. |
attrdate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrmny1
|
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. |
attrmny2
|
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. |
attrnum1
|
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. |
attrnum2
|
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. |
attryesno
|
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. |
attrlook1
|
Attribute 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. |
attrlook2
|
Attribute 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. |
attrlook3
|
Attribute 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. |
attrtext
|
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. |
attrpend Pending |
none |
char 1 ['N'] {Not Null} |
This field is a flag to indicate that this data row has linked information in the 'pending' Attribute 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 column) |
attrpubfl 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 Attribute table are set to 'Published by Consent'. Otherwise, the corepub03 field flag in the Basic Data table will be used. |
attrjntid non-displaying |
none |
char 10 [' ']
|
This field holds a copy of the constituent ID Number for the constituent with whom this row is jointly linked. (System column) |
attrjntkey non-displaying |
none |
numeric/number 13, 0 [0]
|
This field holds a copy of the key field from the row with which this row is jointly linked. (System column) |
attrupkey non-displaying |
none |
numeric/number 13, 0
|
This field holds the Timekey of the pending data row that may be updated from the attribute_pending table. |
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrdte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
attrmny3
|
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. |
attrmny4
|
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. |
attrmny5
|
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. |
attrmny6
|
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. |
attrmny7
|
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. |
attrmny8
|
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. |
attrmny9
|
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. |
attrmny10
|
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. |
attrmny11
|
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. |
attrmny12
|
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. |
attrnum3
|
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. |
attrnum4
|
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. |
attrnum5
|
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. |
attrnum6
|
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. |
attrnum7
|
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. |
attrnum8
|
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. |
attrnum9
|
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. |
attrnum10
|
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. |
attrnum11
|
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. |
attrnum12
|
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. |
attrchk1
|
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. |
attrchk2
|
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. |
attrchk3
|
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. |
attrchk4
|
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. |
attrchk5
|
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. |
attrchk6
|
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. |
attrchk7
|
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. |
attrchk8
|
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. |
attrchk9
|
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. |
attrchk10
|
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. |
attrtxt1
|
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. |
attrtxt2
|
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. |
attrtxt3
|
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. |
attrtxt4
|
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. |
attrtxt5
|
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. |
attrlook4
|
Attribute lookup4 |
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. |
attrlook5
|
Attribute lookup5 |
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. |
attrlook6
|
Attribute lookup6 |
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. |
attradesrc non-displaying |
ade_source |
char 30
|
If this row is created or updated from data that originally came from the attribute_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 - Attributes
Index | Primary | Foreign | Unique | Fields | Sort |
---|---|---|---|---|---|
pk_attribute | Y | Y | attrkey | ASC | |
attribut02 | Y | attrid | ASC | ||
attribut03 | Y | attrtype | ASC | ||
attribut04 |
attrlnkkey, |
ASC | |||
attribut05 | attrdate | ASC | |||
attribut06 | attrjntkey | ASC | |||
attribut07 | attrstrt | ASC | |||
attribut08 | attrstop | ASC |
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.