More information

Field Descriptions

Indices

Site Specific Notes

Events World

Audio Video Needs

The Other Info data table may be used to track any equipment that is needed for an Event or a particular Activity. While this is usually audio and or video equipment, you may specify any sort of equipment by defining a corresponding entry in the Other Lookup table.

Though this information is maintained in the Other Info (other_info) data table, when it is displayed or when it is being maintained, the header for the information or data form will be shown as Audio Video Needs. (For more information on the use and applications of this data table, see Other Info.)

This use of the Other Info data table allows you to track the equipment that is needed, the location where it is needed, the start and stop time and dates when it will be needed, the name of the contact person, a phone number for that contact, and a free text comment.

Audio Video Needs rows may be linked to either an Event row or an Activity row.

Creating a New Audio Video Needs Record

  1. Verify that the Other lookup table includes an entry that describes any equipment name that you plan to use in the Audio Video Needs row. If not, use Events Lookup Table Maintenance to create that entry.
  2. Access the display of the Event row or the Activity row to which the AV row will be linked.
  3. Pass the mouse pointer over the edit button to the left of the Event or Activity row to access a context menu and then hover on the word Link, to access the cascading menu. Click the Audio Video Needs
  4. You will be given an Insert form.

  5. Enter data in the following text boxes as desired:
    Equipment     - The kind of AV equipment needed, as shown in the list from the Other lookup table.

    Location - Type any description of the location where the equipment will be needed.

    Start Date - Type the date when the equipment will first be needed.

    Start Time - Type the time when the equipment will first be needed.

    End Date - Type the date when the equipment will no longer be needed.

    End Time - Type the time when the equipment will no longer be needed.

    Comments - Type any free text information concerning this AV row.

    Contact - Type the name of a person to contact concerning this equipment.

    Phone Number - Type the phone number where the contact person can be reached.

  6. When all data appears in the form as you want, click Insert to create the Audio Video Needs row,

    OR

    Click Cancel to halt the process without creating the AV row.

Editing an Existing Audio Video Needs Record

  1. Access the display of the Event row or the Activity row to which the AV row is linked. If necessary, scroll to locate the AV row you want to edit.
  2. Pass the mouse pointer over the Edit button to the left to access a context menu. Locate and click Update/Delete. You will be given an Update form showing the current data in the corresponding text boxes.
  3. Tab or mouse click to any of the text boxes and edit the data as desired.

  4. When all data appears in the form as you want, click Update to register the edits,

    OR

    Click Cancel to halt the process without making any edits to the row.

Display an Existing Audio Video Needs Record

Access the display of the Event row or the Activity row to which the AV row is linked. The AV row will be displayed as a linked, secondary data row.

Other Info Field Descriptions for Audio Video Needs Data

Audio Video Needs data is stored in the other_info 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

Length

[Default]

{Check}

 Description

oinfokey

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)

oinfodoc

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)

oinfodate

no label

 none

datetime/date

 

[getdate()]

 

 The date that this row was last updated. This field is automatically entered by the system. (system field)

oinfouid

no label

 none

varchar/varchar2

30

{suser_sname()]

 

 The User ID of the operator who last edited this row. It is automatically entered by the system. (system field)

oinfougrp

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)

oinfonum1

non-displaying

 none

numeric/number

19,4

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfonum2

non-displaying

 none

numeric/number

19,4

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfodate1

Start Date

 none

datetime/date

 

 

 

 This field may be used to track the date that the equipment is needed.

oinfodate2

End Date

 none

datetime/date

 

 

 

 This field may be used to track the date that the equipment will no longer be needed.

oinfotype1

Equipment

 Other Lookup

char

6

[' ']

 

 This field is used to specify the particular equipment that is needed, as defined in the Other Lookup table. All lookup table entries must have a Group code (table_type) of av in order to display in this field

oinfotype2

non-displaying

 Other Lookup

char

6

[' ']

 

 The system does not use this field for Special Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose. All lookup table entries must have a Group code (table_type) of av2 in order to display in this field.

oinfocol1

Location

 none

varchar/varchar2

255

 

 

 This field is used to define the location where the AV equipment is needed.

oinfocol2

Contact

 none

varchar/varchar2

255

 

 

 This field is used to specify the name of the person who should be contacted concerning this equipment.

oinfolnkfl

non-displaying

 none

char

2

 

 

 This system-generated field is used to hold a copy of the table number for the primary row within the Events World to which this Other Info row is linked. (system field)

oinfolnkky

non-displaying

 none

numeric/number

13, 0

[0]

 

 This system-generated field is used to hold a copy of the key field from the primary row within the Events World to which this Other Info row is linked. (system field)

oinfofnum

non-displaying

 none

char

2

['62']

{'62'}

 This field holds the table number for the Other Info table (62). (system field)

oinfocrdat

non-displaying

 none

datetime/date

 

[getdate()]

 

 This system-generated field holds the date on which this Other Info row was created. (system field)

oinfocomm

Comment

 none

varchar/varchar2

255

 

 

 This field may be used to hold a free text Comment associated with this row.

oinfostim1

Start Time

 none

char

8

 

 

 This field may be used to track the time that the equipment is needed.

oinfoetim1

End Time

 none

char

8

 

 

 This field may be used to track the time that the equipment will no longer be needed.

oinfostim2

non-displaying

 none

char

8

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfoetim2

non-displaying

 none

char

8

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfoevncd

non-displaying

 none

char

10

[' ']

 

 This system-generated field holds a copy of the code for the Event with which this row is associated. (system field)

oinfoevent

Event

 none

varchar/varchar2

110

 

 

 This system-generated field holds a copy of the name of the Event with which this row is associated. (system field)

oinfoactvt

Activity

 none

varchar/varchar2

110

 

 

 This system-generated field holds a copy of the Activity name with which this row is associated. (system field)

oinfotemp1

non-displaying

 none

char

6

 

 

 This system-generated field holds the code that signals the system as to the nature of this Other Info data row. In this case, this field will contain the code, av signifying Audio Video Needs. (system field)

oinfocol3

Phone Number

 none

varchar/varchar2

255

 

 

 This field is used to track the phone number of the Contact person for this equipment.

oinfoyn1

 

 none

char

1

['N']

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.
oinfoyn2 none

char

1

['N']

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.
oinfoyn3 none

char

1

['N']

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.
oinfotype3 Other Lookup

char

6

[' ']

 

 The system does not use this field for Special Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose. All lookup table entries must have a Group code (table_type) of av3 in order to display in this field.

oinfotype4

 

 Other Lookup

char

6

[' ']

 

 The system does not use this field for Special Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose. All lookup table entries must have a Group code (table_type) of av4 in order to display in this field.

oinfomny1

 

 none

money/number

(19,4)/(16,2)

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfocol4

 

 none

varchar/varchar2

255

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfocol5

 

 none

varchar/varchar2

255

 

 

 The system does not use this field for Audio Video Needs. Sites can use the Custom Display Designer to add this field to data display and maintenance forms, and then use it in any way they choose.

oinfoid

 

 none

char

10

 

{null}

 If this Other Info row is used as an Audio Video row, this field is not used. (system field)

Indices - Other Info

Index Primary Foreign Unique Fields Sort
pk_other_info Y     oinfokey  
other_info02      

oinfolnkky,

oinfolnkfl

  
other_info03       oinfoevncd  
other_info04       oinfouid  

Top of Page