Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QBCOMMENTS.SDDL
!
! Purpose:      This SDDL file defines the qbcomments relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11-04-94    27329     EGB   Original implementation
! 02-02-95    28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  OBCOM_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation enables comment text to be entered that
                       describes various features of, or modifications to, 
                       an observation set.  

                       The comment relations are similar at the proposal,
		       scheduling unit, obset, alignment, exposure and target
                       levels.  They all contain 24 free format 80 character 
		       string fields for entering the comment information."
  
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
        FORM
            NAME         "BCM"
            LABEL        "PROPOSAL ID"
        END_FORM
    END_FIELD
 

    FIELD  obset_id
        TYPE OBSET_ID_TYPE
        FORM
            NAME         "BCM"
            LABEL        "OBSET    ID"
        END_FORM
    END_FIELD
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
        FORM
            NAME         "BCM"
            LABEL        "VERSION NUM"
        END_FORM
    END_FIELD
 

    FIELD  page_num
        TYPE COMMENT_PAGE_TYPE
        FORM
            NAME         "BCM"
            LABEL        "PAGE"
        END_FORM
    END_FIELD
 

    FIELD  comment_type
        TYPE            C2
        DESCRIPTION     "This field contains the type of comment information
			 contained in the record.  The comment types include:

				GT = generic target selection procedure,
				TO = target of opportunity requirement,
	                        CO = coordinated observation requirement,
		                PC = proposer comments,
			        TC = technical reviewer comments,
				CR = constraints and restrictions override
	                             comments,
	                        GS = comments for gsss,
		                RI = reserved time intervals comments,
	                        MC = miscellaneous comments "
        FORM
            NAME         "BCM"
            LABEL        "(CO/CR/GS/GT/MC/PC/RI/TC/TO)"
        END_FORM
        DISCRETE        "CO",  "CR",  "GS",  "GT",  "MC",  "PC",  
                        "RI",  "TC",  "TO"
    END_FIELD
  

    FIELD  comment1
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment2
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment3
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment4
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment5
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment6
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment7
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment8
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment9
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment10
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment11
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment12
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment13
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment14
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment15
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment16
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment17
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment18
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment19
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment20
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment21
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment22
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment23
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 

    FIELD  comment24
        TYPE COMMENT_LINE_TYPE
        FORM
            NAME         "BCM"
            LABEL        ""
        END_FORM
    END_FIELD
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qbcomments
 
    TYPE             OBCOM_TYPE
 
    DESCRIPTION      "Observation Set Comments Relation"
 
    SUBSYSTEM_USING  "SPSS", "SPIKE", "REPLICATION-FROM-SOGS", "TRANS"

    RELATED_FIELDS  "qppcomments.*" "qsucomments.*" "qacomments.*" "qecomments.*" "qtcomments.*"

    FORM
        NAME         "BCM"
    END_FORM
 
    INDEX  qbcomments_1
        TYPE         unique, clustered
        FIELDS       proposal_id, obset_id, version_num, comment_type, page_num
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qbcomments
 
    GLOBAL
 
    TYPE        OBCOM_TYPE
 
END_INSTANCE

Go to the top.