More information

Field Descriptions

Indices

Profiles World

Site Specific Notes

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.

Notes:

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

Top of Page