Media
The Media table can be used to record a constituent's involvement with any sort of media presentation. This might be a newspaper, magazine, book, or other printed material. It might also be an association with a radio, television, or cinematic presentation. You may use this table to track media appearances that feature the constituent as the subject matter, or you may also want to track those for which the constituent was an author, contributor, producer, performer, editor, or any other association with a media appearance.
The name, date, volume, issue and even page number of a publication may be recorded in the row. The Type field allows you to apply a standardized description of the kind of reference information that is represented in the row.
If the media reference is printed (and the scope is appropriate), the item may be scanned electronically and stored as an attachment. Attachments may be any "object" (a Word document, a spreadsheet, an image, etc.) and each will be associated with an application (Word, Excel, Paint, etc.). Attached objects are denoted by a hyperlink message in the display of the Media row, and when that jump is executed, the application will automatically be launched in order to display the object. The attached object must be associated with an application (the appropriate software program for that type of file) prior to attaching it in order to open and view or edit the file. This is usually done automatically as the file is created. It must also include the file extension (.doc, .jpg, .txt, etc.) when entering the name of the attachment within the system and must be stored in the Inetpub/wwwroot/mill/docs directory or in a sub-directory of docs.
- An Administrator can remove the Media table from the Millennium Explorer if not used. See Table Options for more information.
- Millennium system administrators or the database administrator can configure audit logging for the Media data table. For more information, see Audit Log.
Media Field Descriptions
Media Reference information is stored in the media 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.
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 |
|---|---|---|---|
|
mediakey 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) |
|
mediaid 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 field) |
|
mediadoc 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) |
|
mediadate no label |
none |
datetime/date
[getdate()]
|
The date that this Media row was last updated. This field is automatically entered by the system. (system field) |
|
mediauid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this Media row. It is automatically entered by the system. (system field) |
|
mediaugrp 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 field) |
|
mediaref Reference |
Reference Name |
char 6 [' ']
|
The name of the publication in which the constituent's name appears. |
|
mediarefdt Date |
none |
datetime/date
|
The publication date for the reference. |
|
mediarftyp Type |
Reference Type |
char 6 [' ']
|
The kind or type of reference that is made to the constituent. (Is the constituent the feature of the article, mentioned in the article, the author of an article, etc.) |
|
mediaissue Issue |
none |
char 10
|
The issue number of the publication in which the constituent's name appears. |
|
mediavol Volume |
none |
char 10
|
The volume number of the publication in which the constituent's name appears. |
|
mediapage Page |
none |
char 10
|
The page number on which the constituent's name appears. |
|
mediasourc Source |
Source |
char 6 [' ']
|
The source for the information in this row. |
|
mediapoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (system field) |
|
mediafnum non-displaying |
none |
char 2 ['13'] {'13} |
The file (table) number for the Media table. (system field) |
|
mediacrdat non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (system field) |
|
mediacomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
| mediadate1 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate2 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediamny1 | 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. |
| mediamny2 | 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. |
| medianum1 | 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. |
| medianum2 | 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. |
| mediayesno | 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. |
| medialook1 | Media 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. |
| medialook2 | Media 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. |
| medialook3 | Media 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. |
| mediatext | 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. |
|
mediapend non-displaying |
none |
char 1 ['N'] {'N' or 'Y'} |
This field is a flag to indicate that this data row has linked information in the 'pending' media 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) |
|
mediaupkey non-displaying |
none |
numeric/number 13, 0
|
This field holds the timekey of the pending data row that may be updated from the media_pending table. (system field) |
| mediadate3 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate4 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate5 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate6 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate7 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate8 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadate9 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadte10 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadte11 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediadte12 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| mediamny3 | 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. |
| mediamny4 | 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. |
| mediamny5 | 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. |
| mediamny6 | 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. |
| mediamny7 | 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. |
| mediamny8 | 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. |
| mediamny9 | 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. |
| mediamny10 | 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. |
| mediamny11 | 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. |
| mediamny12 | 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. |
| medianum3 | 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. |
| medianum4 | 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. |
| medianum5 | 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. |
| medianum6 | 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. |
| medianum7 | 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. |
| medianum8 | 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. |
| medianum9 | 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. |
| medianum10 | 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. |
| medianum11 | 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. |
| medianum12 | 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. |
| mediachk1 | 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. |
| mediachk2 | 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. |
| mediachk3 | 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. |
| mediachk4 | 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. |
| mediachk5 | 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. |
| mediachk6 | 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. |
| mediachk7 | 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. |
| mediachk8 | 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. |
| mediachk9 | 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. |
| mediachk10 | 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. |
| mediatxt1 | 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. |
| mediatxt2 | 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. |
| mediatxt3 | 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. |
| mediatxt4 | 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. |
| mediatxt5 | 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. |
|
mediaadesr non-displaying |
ade_source |
char 30
|
If this row is created or updated from data that originally came from the media_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 - Media
| Index | Primary | Foreign | Unique | Fields | Sort |
|
pk_media |
Y |
|
Y |
mediakey |
ASC |
|
media02 |
|
Y |
|
mediaid |
ASC |