!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QODATASETS.SDDL
!
! Purpose:      This SDDL file defines the qodatasets relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 05/09/96    31365     JJB  Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
LANGUAGE        SQL

RECORD  QODATA_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "This relation is used to provide OPUS with the counts
                       of the number of datasets for a particular SMS_ID 
                       (used for support schedule generation identified by
                       its CCL name) for a PI for a program_id. The values 
                       will be set into support schedule keywords. "
		       
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD sms_id            
        TYPE         C9
        DESCRIPTION "The C&C list is a major data structure within SPSS that 
		    contains information on 'candidates' and the 'calendar'.

		    The candidate data, often referred to as the candidate
		    pool, are scheduling units and their associated 
		    observation set, alignment, and target data.  

		    The calendar is a timeline of activities that are laid 
		    down by the SPSS scheduling utilities.  Example 
		    activities include slews, PCS aquisitions, small angle 
		    maneuvers, science, TDRS contacts, tape recordings, 
		    science instrument reconfigurations, and others.

		    When a C&C List is saved in SPSS (via the CCLIST/SAVE 
		    comand) it receives an identifier.  The identifier can
		    be up to 9 characters long.  Within operations, the C&C
		    list naming convention is:    yydddnxx 

		    where          yy  = last two digits of the year
				   ddd = day of year of start of calendar
				     n = length of calendar in days (usually 7)
				    xx = unique identifier within above info. "

    END_FIELD

    FIELD program_id
        TYPE         C3
        UNITS	     "BASE_36"
        DESCRIPTION  "When a proposal is accepted into the PMDB by SPSS it must
		    be assigned a unique 3 character base 36 program identifier.
		    This is done by the PMDB/ACCEPT_PROP command.  This program 
		    identifier is tagged as 'program_id' in most PMDB relations.
                    Is is used for identification of proposals by spacecraft 
                    and PODPS software. It is also used in the PODPS and DADS 
                    rootname for all archived science data files. 
                    Because of flight design software, program_id must be
                    three characters."
    END_FIELD

    FIELD	ndatasets 
	TYPE 		I2         
	DESCRIPTION	"Number of datasets for exposures and association 
                         products to be sent to the proposal PI. Exposure 
                         datasets already included in products and not 
                         redundantly sent to the PI are not counted. "
    END_FIELD	

    FIELD 	last_obs_time
        TYPE        C17
        UNITS	    "UTC"
	DESCRIPTION "Last pred_strt_tm for all QOBSERVATION records for
                     this sms_id and program_id. This is in the standard SOGS
                     format - yyyy.ddd:hh:mm:ss
		     where yyyy = year
			    ddd = day of year
			     hh = hours
			     mm = minutes
			     ss = seconds"
    END_FIELD

RELATION  qodatasets
 
    TYPE             QODATA_TYPE
 
    DESCRIPTION      "Program Datasets Relation"
 
    SUBSYSTEM_USING  "OPUS"
 
    INDEX  qodatasets_1
        TYPE         unique, clustered
        FIELDS       sms_id, program_id
    END_INDEX

END_RELATION
END_RECORD