More information

!Field Descriptions

Indices

Profiles World

Site Specific Notes

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)

attrtype

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)

attrstrt

Start

none

datetime/date

 

 

 

Indicates the date on which this attribute became effective.

attrstop

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)

attrdescr1

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.

attrpositn

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.

attrtypenm

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.

attrdate3

 

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,
attrlnkfil

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.

Top of Page