!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	NIC_SAA_EXIT.SDDL 
!
! Purpose:      This SDDL file defines the NIC_SAA_EXIT relation.
!
! Modification History:
!
!   Date       PR      Who                       Reason
! --------   -------   ---   -------------------------------------------------
! 02/04/00    40559    bao   Create Relation for NICMOS SAA Exit Information
! 03/13/00    40931    bao   Modify Index of NIC_SAA_EXIT Database Table
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE  C, FORTRAN, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL
 
RECORD  NIC_SAA_EXIT_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
DESCRIPTION      "The NIC_SAA_EXIT relation contains data needed to support the 
                  NICMOS post-SAA (South Atlantic Anomaly) dark exposures. SAA 
                  exit times are significant to the NIC because beginning in 
                  cycle 10, NICMOS will execute a series of dark calibration 
                  observations immediately after an SAA passage, in order to 
                  eliminate persistence due to cosmic rays. (See NICMOS ISR 
                  98-001, Najita, Dickinson, & Holfeltz).
                  
                  The data in this relation originates in the logical SMS. SCPL 
                  pseudo-instruction #NICSAAEXIT populates the logical SMS with 
                  SAA exit data for the SMSG/Schedule command. (See chapter 35 
                  of the SCS User's Guide for a description of #NICSAAEXIT).
                  SMSG/Schedule builds support schedule files for Science Data 
                  Processing from the logical SMS. Command OBSR/Generate uses 
                  the SCS support schedule files to populate this relation, in 
                  addition to qolink, qobservation and stis_dith. Note, this 
                  relation and stis_dith are only populated for specific obser-
                  vations. Qolink and qobservation are populated for all obser-
                  vations.

                  The NIC_SAA_EXIT relation is replicated to the OPUS database."

 

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    FIELD  program_id
        TYPE            PROGRAM_ID_TYPE
	RELATED_FIELDS  "qolink.program_id",
                        "qobservation.program_id"
    END_FIELD
 
 
    FIELD  obset_id
        TYPE            OBSET_ID_TYPE
	RELATED_FIELDS  "qolink.obset_id",
                        "qobservation.obset_id"
    END_FIELD
 
 
    FIELD  ob_number
        DESCRIPTION     "Observations are numbered sequentially throughout
                         an observation set for OPUS use.  Please note an
                         ob_number is _NOT_ the same as an obset_ID."
        TYPE            C2
        UNITS           "BASE_36"
        RANGE           "00..ZZ"
	RELATED_FIELDS  "qolink.ob_number",
                        "qobservation.ob_number"
    END_FIELD
 
 
    FIELD  saa_exit 
        TYPE            SOGS_CHAR_TIME_TYPE
        DESCRIPTION     "This is the time of the last exit from SAA contour
			 level 23. SAA contour level 23 is deemed significant
                         to the NIC."
    END_FIELD
 
 
    FIELD  delta_time
        DESCRIPTION     "This is the time since the last exit from SAA contour
			 level 23. It is the difference between the NICMOS 
			 exposure's start time and the time of the last exit 
			 from the SAA contour 23."
        TYPE            I4
        UNITS           "SECONDS"
    END_FIELD
 
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  nic_saa_exit 
 
    TYPE             NIC_SAA_EXIT_TYPE
 
    DESCRIPTION      "NICMOS SAA Exit Relation"
 
    SUBSYSTEM_USING  "OPUS", "SCS"

    INDEX  nic_saa_exit_1
        TYPE         clustered
        FIELDS       program_id, obset_id, ob_number
        ATTRIBUTES   ignore_dup_row
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------


INSTANCE  nic_saa_exit

    TYPE        NIC_SAA_EXIT_TYPE

END_INSTANCE