Custom Bio
The Custom Bio data table is made available as part of Millennium for maintaining data that does not readily fit into any of the other, standard data tables. Some institutions have unique, or highly specialized data requirements, or perhaps a need to segregate highly sensitive information within a specialized table. The Custom Bio table serves as a way to do so.
For example, a hospital may want to track patient history details, such as the duration of the hospital stay, treatment, outcome, or cost. A research foundation may need to track the nature of a constituent's involvement with a disorder or disease, such as whether the constituent is a patient or a care-giver, the specific form or status of the disease, or treatments. A service foundation might want to track the details of services that have been provided to the constituent, such as a guide dog's name, breed, age, or training.
The use of the Custom Bio table is entirely at the discretion of the institution. In addition to the standard, system-generated, and system-use fields, the table structure offers several data fields of each data type, including several that are driven by custom lookup tables. Therefore, your institution may define the use of any or all of those discretionary data fields in the Custom Bio table for any use that you find beneficial to your data maintenance needs. Your institution may use the Custom Display Designer to add or remove data fields from the Data Display and Data Maintenance forms, as well as to create meaningful labels for each data field in use.
- You can create multiple rows in the Custom Bio table for any constituent.
- The Custom Bio data table can be renamed and customized, or removed by an Administrator (if not used) to better suit your organization's needs. See Table Options for more information.
- The Millennium system administrator or the database administrator can configure audit logging for the Custom Bio data table. For more information, see Audit Log.
Display an Existing Custom Bio Record
- From the Millennium Explorer, expand the Profiles World, and then the Biographical item. Click to highlight the item, Custom Bio.
- Click Next Search and use the standard or Advanced Search function to locate the desired constituent. When the Search has been successful, the Custom Bio data row(s) will be displayed.
Create a New Custom Bio Record
- From the Millennium Explorer, expand the Profiles World, and then the Biographical item. Click to highlight the item, Custom Bio.
- Click Next Search and use the standard or Advanced Search function to locate the desired constituent. When the Search has been successful, any existing Custom Bio data row(s) will be displayed.
- Pass the mouse pointer over the table name in the header or over the edit button for an existing Custom Bio row to access a context menu. Click Insert or Insert via Default. You will be given an Insert form.
- Tab or mouse click to the individual text boxes on the form, entering the desired information, according to data type.
- When all information appears in the form as desired, click Insert to create the data row.
Edit an Existing Custom Bio Record
- From the Millennium Explorer, expand the Profiles World, and then the Biographical item. Click to highlight the item, Custom Bio.
- Click Next Search and use the standard or Advanced Search function to locate the desired constituent. When the Search has been successful, the Custom Bio data row(s) will be displayed. If necessary, scroll to locate the display of the desired data row.
- Pass the mouse pointer over the table name in the header or over the edit button for an existing Custom Bio row to access a context menu. Click Update/Delete. You will be given an Update form containing the existing data.
- Tab or mouse click to highlight the desired text box and make the changes according to the field's data type.
- When all information appears in the form as desired, click Update to make the changes.
Custom Bio Field Descriptions
Custom Bio data is stored in the custombio 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.
|
Field Name Field Label |
Lookup Table |
Type SQL/Oracle Length [Default] {Check} |
Description |
|---|---|---|---|
|
cbiokey 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 field) |
|
cbioid
|
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 field) |
|
cbiodoc 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 field) |
|
cbiodate no label |
none |
datetime/date
[getdate()]
|
The date that this row was last updated. This field is automatically entered by the system. (System field) |
|
cbiouserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this row. It is automatically entered by the system. (System field) |
|
cbiougroup non-displaying |
none |
char 1 [' ']
|
This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field) |
|
cbiomoney1 Money 1 |
none |
money/number (19,4)/(16,2)
|
This field may be used to hold any monetary data that you want to associate with this row. |
|
cbiomoney2 Money 2 |
none |
money/number (19,4)/(16,2)
|
This field may be used to hold any monetary data that you want to associate with this row. |
|
cbiomoney3 Money 3 |
none |
money/number (19,4)/(16,2)
|
This field may be used to hold any monetary data that you want to associate with this row. |
|
cbiodate1 Date 1 |
none |
datetime/date
|
This field may be used to hold any date information that you want to associate with this row. |
|
cbiodate2 Date 2 |
none |
datetime/date
|
This field may be used to hold any date information that you want to associate with this row. |
|
cbiodate3 Date 3 |
none |
datetime/date
|
This field may be used to hold any date information that you want to associate with this row. |
|
cbionum1 Number 1 |
none |
numeric/number 10,0
|
This field may be used to hold any numerical information that you want to associate with this row. |
|
cbionum2 Number 2 |
none |
numeric/number 10,0
|
This field may be used to hold any numerical information that you want to associate with this row. |
|
cbionum3 Number 3 |
none |
numeric/number 10,0
|
This field may be used to hold any numerical information that you want to associate with this row. |
|
cbioflag1 Flag 1 |
none |
char 1 ['N'] {'N' or 'Y'} |
This field may be used to hold any sort of flagged information (Yes or No) that you want to associate with this row. |
|
cbioflag2 Flag 2 |
none |
char 1 ['N'] {'N' or 'Y'} |
This field may be used to hold any sort of flagged information (Yes or No) that you want to associate with this row. |
|
cbioflag3 Flag 3 |
none |
char 1 ['N'] {'N' or 'Y'} |
This field may be used to hold any sort of flagged information (Yes or No) that you want to associate with this row. |
|
cbiolook1 Lookup 1 |
char 6
|
This field may be used to hold an entry from the Custom Bio Lookup Table 1 that you want to associate with this row. The use of that lookup table is entirely at the direction of your institution. |
|
|
cbiolook2 Lookup 2 |
char 6
|
This field may be used to hold an entry from the Custom Bio Lookup Table 2 that you want to associate with this row. The use of that lookup table is entirely at the direction of your institution. |
|
|
cbiolook3 Lookup 3 |
char 6
|
This field may be used to hold an entry from the Custom Bio Lookup Table 3 that you want to associate with this row. The use of that lookup table is entirely at the direction of your institution. |
|
|
cbiolook4 Lookup 4 |
char 6
|
This field may be used to hold an entry from the Custom Bio Lookup Table 4 that you want to associate with this row. The use of that lookup table is entirely at the direction of your institution. |
|
|
cbiotext1 Text 1 |
none |
varchar/varchar2 255
|
This field may be used to hold any free text information that you want to associate with this row. |
|
cbiotext2 Text 2 |
none |
varchar/varchar2 255
|
This field may be used to hold any free text information that you want to associate with this row. |
|
cbiosource Source |
char 6 [' ']
|
This field may be used to hold an entry from the Sources lookup table to describe the origin of the information in this data row. |
|
|
cbiofnum non-displaying |
none |
char 2 ['69'] {'69'} |
This system-generated field contains the number of the Custom Bio data table (69). (System field) |
|
cbiocrdate non-displaying |
none |
datetime/date
[getdate()]
|
This system-generated field contains the date on which this data row was created. (System field) |
|
cbiocomm no label |
none |
varchar/varchar2 4000
|
This field may contain any free-text comment you want to associate with this data row. |
|
cbiotext3 Text 3 |
none |
varchar/varchar2 255
|
This field may be used to hold any free text information that you want to associate with this row. |
|
cbiopend non-displaying |
none |
char
['N'] {'N' or 'Y'} |
This field is a flag to indicate that this data row has linked information in the 'pending' custombio table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is awaiting incorporation into this data row. (System field) |
|
cbioupkey non_displaying |
none |
numeric/number 13, 0
|
This field holds the timekey of the pending data row that may be updated from the custombio_pending table. (System field) |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiodte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cbiomny3
|
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. |
|
cbiomny4
|
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. |
|
cbiomny5
|
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. |
|
cbiomny6
|
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. |
|
cbiomny7
|
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. |
|
cbiomny8
|
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. |
|
cbiomny9
|
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. |
|
cbiomny10
|
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. |
|
cbiomny11
|
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. |
|
cbiomny12
|
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. |
|
cbionum3
|
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. |
|
cbionum4
|
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. |
|
cbionum5
|
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. |
|
cbionum6
|
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. |
|
cbionum7
|
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. |
|
cbionum8
|
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. |
|
cbionum9
|
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. |
|
cbionum10
|
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. |
|
cbionum11
|
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. |
|
cbionum12
|
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. |
|
cbiochk1
|
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. |
|
cbiochk2
|
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. |
|
cbiochk3
|
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. |
|
cbiochk4
|
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. |
|
cbiochk5
|
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. |
|
cbiochk6
|
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. |
|
cbiochk7
|
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. |
|
cbiochk8
|
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. |
|
cbiochk9
|
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. |
|
cbiochk10
|
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. |
|
cbiotxt1
|
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. |
|
cbiotxt2
|
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. |
|
cbiotxt3
|
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. |
|
cbiotxt4
|
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. |
|
cbiotxt5
|
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. |
|
cbiolook5
|
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. |
|
|
cbiolook6
|
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. |
|
|
cbiolook7
|
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. |
|
|
cbioadesrc non-displaying |
char 30
|
If this row is created or updated from data that originally came from the custombio_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 - Custom Bio
|
Index |
Primary |
Foreign |
Unique |
Fields |
Sort |
|---|---|---|---|---|---|
|
pk_custombio |
Y |
|
|
cbiokey |
|
|
custombio02 |
|
|
|
cbioid |
|