!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WBASE_CAT.SDDL
!
! Purpose:      This SDDL file defines the wbase_cat 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
! 02/07/97    33001     SXT   Rename QSLINK_SPEC to QSLINK_TIMING
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  BSCAT_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation is used to store a C&C List baseline.  

		       A baseline is a mechanism for grouping a set of C&C Lists
		       together.

		       Baselining a C&C List causes certain information on
		       the C&C List to constrain or influence other C&C Lists
		       (that are created with respect to the baseline).  The
		       following rules apply to baselined C&C Lists:

			   - An SU that collects science data can only appear 
			     on one C&C List on a named baseline.  This helps to
                             make sure no science SUs fly twice accidentally.

			   - SUs that are link set members must be scheduled 
			     to adhere to the timing/orient relationships to 
                             other sus on the same baseline.  Without the 
                             baseline, link set scheduling would not be able
                             to span multiple calendars.

		       When a C&C List is created, it utilizes scheduled link 
		       set member information.  For more information on link
		       sets see qslink_timing/qslink_orient relations.

		       After a C&C List has been completely scheduled, it is
		       added into the baseline via the SPSS BASELINE command.  
		       If baselining is successful (i.e. above rules pass), then
		       a record gets populated in this table.

		       Finally, there are two kinds of baselines that can 
		       exist at a given time:  LOCAL and GLOBAL baselines.  The 
		       GLOBAL baseline is the master baseline that is used 
		       for production of final flight SMSes.  An SMS cannot be 
		       sent to PASS if its corresponding C&C List is not on 
		       the GLOBAL baseline.  A LOCAL baseline is a working copy 
		       of a set of C&C Lists.  Data from a LOCAL baseline 
		       supercedes data from the GLOBAL baseline when the 
		       timespans of the C&C lists intersect.

		       For more information on the baselining and how it affects
		       link set scheduling, see OPR 16869."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD  base_name
        TYPE            C8
        DESCRIPTION     "This field contains the name of the baseline and
			 is used to group a set of related C&C lists together
			 by a common name."
	RELATED_FIELDS  "pm_constants.global_name"
    END_FIELD
 
    FIELD  base_time
        TYPE            INT_TIME_STAMP_TYPE
        DESCRIPTION     "This field time stamps the addition of this record to 
			 designate when the C&C list was added to the baseline."
    END_FIELD
 
    FIELD  ccl_name
        TYPE            CCLIST_ID_TYPE
	DESCRIPTION     "This field contains the name of the C&C List that was
			 added as specified on the BASELINE/ADD command."
    END_FIELD
 
    FIELD  ccl_vers
        TYPE            CCLIST_VERSION_NUM_TYPE
    END_FIELD
 
    FIELD  cal_beg_time
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field contains the start time of the C&C List."
	RELATED_FIELDS  "wiccl_cat.cal_beg_tim"
    END_FIELD
 
    FIELD  cal_end_time
        TYPE            SOGS_INT_TIME_TYPE
        DESCRIPTION     "This field contains the end time of the C&C List."
	RELATED_FIELDS  "wiccl_cat.cal_end_tim"
    END_FIELD
 
    FIELD  account_name
        TYPE            C12
        DESCRIPTION     "This field lists the user account that issued the 
			 BASELINE command to populate this record."
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  wbase_cat
 
    TYPE             BSCAT_TYPE
 
    DESCRIPTION      "Baselined C&C List Relation"
 
    SUBSYSTEM_USING  "SPSS", "SCS", "REPLICATION-FROM-SOGS"

    RELATED_FIELDS   "qslink_timing.*"
                     "qslink_orient.*"
 
    INDEX  wbase_cat_1
        TYPE         unique, clustered
        FIELDS       base_name, ccl_name, ccl_vers
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  wbase_cat
 
    GLOBAL
 
    TYPE        BSCAT_TYPE
 
END_INSTANCE