!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	sgs_display_pref.SDDL
!
! Purpose:      This SDDL file defines the sgs_display_pref relation.
!
!               All software to manipulate this relation is isolated 
!               to file SGS_DISPLAY_PREF_PKG.C.
!
!               LETS KEEP IT ISOLATED TO SGS_DISPLAY_PREF_PKG.C  !
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 01/04/96   24263      sss   Original Version
! 10/08/99   32594      sss   Added GSU, CWV, and offset activity display
! 10/24/00   42515      sss   Added Orient windows in relation QSWINDOWS
! 
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	C, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  sgs_pref_type
 
 DESCRIPTION    "This relation contains display preferences data for the
                 SGS program.  Each row in the table contains the basic
                 information to save and restore an SGS display line for
                 a specific set of display lines.

                 This relation will generally contain multiple rows with
                 the same 'name' field.  The combination of 'name' and 
                 'order' fields must be unique. 
            
                 This relation is only manipulated by the 'Display Editor'
                 in the SGS program."

 FIELD  name
   TYPE            C20
   DESCRIPTION     "This field is the name of the user defined preference 
                    setting.  The name 'DEFAULT' is special.  If the SGS 
                    user fails to specify a preference then 'DEFAULT' rows
                    in this table are used by SGS for the display."
 END_FIELD
 
 FIELD  order_index
   TYPE            I4
   DESCRIPTION     "This field specifies the 'top-to-bottom' order of each
                    display line in the display.  Lower numbers appear near
                    the top and higher numbers appear near the bottom."
 END_FIELD

 FIELD  activity_type
   TYPE            I4
   DESCRIPTION     "This field is an integer which defines the type of item
                    to display : Shadow, TDRS, SAA, US window, etc.  The value
                    for this field are determined by the SGS program in 
                    file SGS.H.  A dbms 'blast' program may be required
                    if the values defined in SGS.H are changed."
 END_FIELD

 FIELD  activity_name
   TYPE            C20
   DESCRIPTION     "This field is the name of the activity type which 
                    corresponds to the value in field 'activity_type'."
 END_FIELD
 
 FIELD  align_obset_id
   TYPE            C11
   DESCRIPTION     "This field is the alignment ID or the obset ID 
                    (without version number) for an activity which is 
                    associated with a particular alignment or obset.  If the 
                    alignment or obset does not appear in the C&C list 
                    currently loaded then the display line will be blank.
                    No version number is used because the C&C list only
                    allows one version of a particular SU or obset in
                    the C&C list at one time.  The version number can
                    thus only cause trouble..."
 END_FIELD

 FIELD  version
   TYPE            C2
   DESCRIPTION     "Version number associated with an SU."
 END_FIELD

 FIELD  alias_name
   TYPE            C20
   DESCRIPTION     "This field is the user defined name of the activity 
                    type which corresponds to the value in field 
                   'activity_type'."
 END_FIELD

 FIELD  acq_id
   TYPE            C3
   DESCRIPTION     "This field is the acquisition set ID associated 
                    with a guide star usability window.  This field
                    is set to blank when activity_type is not Guide
                    Star Usability (GSR)."
 END_FIELD

 FIELD  range_id
   TYPE            I4
   DESCRIPTION     "This field is the range ID associated 
                    with an SU orient range."
 END_FIELD

END_RECORD
 
RELATION  sgs_display_pref
  TYPE             sgs_pref_type
  DESCRIPTION      "SGS Preferences Relation"
  SUBSYSTEM_USING  "SPSS"
  INDEX            sgs_display_pref_1
    TYPE             unique, clustered
    FIELDS           name, order_index
  END_INDEX
END_RELATION