Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WICCL_CAT.SDDL
!
! Purpose:      This SDDL file defines the WICCL_CAT relation
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/05/94    27329     NSS   Original implementation
! 02/02/95    28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
! 06/23/95    28910     NLC   Remove SPSS_NODE processing;
!			      the LOCATION field should be removed from this 
!			      relation the next time the relation is modified.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  CCLCAT_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation is used to catalog Candidate & Calendar
                       (C&C) Lists. This relation is populated when a user
                       performs a CCLIST/SAVE. Catalog information includes:

			 o name and version

                         o status

                         o administrative information: who, where, why

                         o other information

                       When a CCLIST/SAVE command is issued:

                         o a disk file is saved in the SPSSCCL directory

                         o a single entry is created in the wiccl_cat relation

                         o multiple entries (for each SU) are created in the
                           wistat_sunit relation."
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 

    FIELD  ccl_name
        TYPE CCLIST_ID_TYPE
	DESCRIPTION     "This field is populated from the name specified by the
                         user when performing a CCLIST/SAVE."
    END_FIELD
 
 

    FIELD  ccl_version
        TYPE CCLIST_VERSION_NUM_TYPE
    END_FIELD
 
 

    FIELD  account_name
        TYPE            C12
        DESCRIPTION     "This field is the account name of the USER who 
                         performed the CCLIST/SAVE. This name is required to 
                         prevent other users from deleting this C&C List."
    END_FIELD
 
 

    FIELD  location
        TYPE            C8
        DESCRIPTION     "This is an obsolete field."
    END_FIELD
 
 

    FIELD  tim_ccl_crea
        TYPE TIME_STAMP_TYPE
        DESCRIPTION     "This field is the time when the C&C list was created."
    END_FIELD
 
 

    FIELD  cal_beg_tim
        TYPE SOGS_CHAR_TIME_TYPE
        DESCRIPTION     "This field is the calendar begin time of the C&C list.
                         The C&C List calendar begin time is set when performing
                         a CCLIST/CREATE or CCLIST/SUBSET."

    END_FIELD
 
 

    FIELD  cal_end_tim
        TYPE SOGS_CHAR_TIME_TYPE
        DESCRIPTION     "This field is the calendar end time of the C&C list.
			 The C&C List calendar end time is set when performing
                         a CCLIST/CREATE or CCLIST/SUBSET."
    END_FIELD
 
 

    FIELD  ccl_status
        TYPE            I2
        DESCRIPTION     "C&C list status where:

                         0 = no candidates in cclist
                         1 = candidates, none on calendar
                         2 = candidates on cal, not all ready for pass
                         3 = all sched candidates ready for pass
                         4 = an sms generated, but with errors
                         5 = an sms generated ok, and is ready for pass
                         6 = sms sent to pass or cclist on global baseline

                         Parameters representing these values can be found in 
                         the ZSU_CC_STAT_VALS.PAR include file."

        RANGE           "0..6"
    END_FIELD
 
 

    FIELD  chk_and_cor
        TYPE            C1
        DESCRIPTION     "This field is the check and correct flag where 'U' 
                         denotes uncorrected, and 'C' denotes corrected. 

                         A calendar's state can become 'uncorrect' when the 
                         user modifies or overrides a constraint via 
                         CCLIST/MODPARMS. 

                         For example, a user might lower the amount of Data 
                         Volume allowed per day on the calendar. The calendar  
                         may contain currently scheduled activities such that 
                         the new Data Volume constraint is violated. In this 
                         case, the user must run CALENDAR/CORRECT to attempt 
                         to reschedule all candidates on the calendar. 

                         The term correct implies that all activities on the 
                         calendar are scheduled within the currently specified
                         calendar constraints."

        DISCRETE        "U", "C"
    END_FIELD
 
 

    FIELD  goals_chnged
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is a flag indicating whether goals have  
                         been changed in this C&C List. There are 6 goal 
                         parameters that are used when scheduling candidates: 
                         maximize science return, minimize slew time, minimize 
                         SI change time, schedule time critical, minimize wasted
                         time within the SU, and schedule candidates prior to 
                         the end of the plan window. Each of these goals has a 
                         weight, which can be modified by CCLIST/MODPARMS."
    END_FIELD
 
 

    FIELD  stand_consts
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This field is a flag indicating whether standard 
                         constraints were used on this C&C List. An SMS cannot 
                         be generated unless the originating C&C List used all 
                         standard constraints. This field applies to constraints
                         in the C&C List control parameters record, not to the 
                         overridden constraints per candidate."
    END_FIELD
 
 

    FIELD  orbit_file_n
        TYPE ORBIT_FILE_ID_TYPE
	DESCRIPTION     "This field is the name of the orbit file that was used
                         to build this C&C List."
    END_FIELD
 
 

    FIELD  orbit_file_v
        TYPE ORBIT_FILE_VERSION_NUM_TYPE
    END_FIELD
 
 

    FIELD  beg_link
        TYPE CCLIST_ID_TYPE
        DESCRIPTION     "This field is the name of the C&C list file whose 
                         boundary conditions determine the beginning boundary
                         conditions of the present C&C list. CALENDAR/MODBOUNDS
                         is used to perform begin boundary linkage.

                         Note that boundary linkage is not used operationally."
    END_FIELD
 
 

    FIELD  beg_link_ver
        TYPE CCLIST_VERSION_NUM_TYPE
        DESCRIPTION     "This field is the version number of the C&C list file  
                         whose boundary conditions determine the beginning 
                         boundary conditions of the present C&C list."
    END_FIELD
 
 

    FIELD  end_link
        TYPE CCLIST_ID_TYPE
        DESCRIPTION     "This field is the name of the C&C list file whose 
                         boundary conditions determine the end boundary 
                         conditions of the present C&C list. CALENDAR/MODBOUNDS 
                         is used to perform end boundary linkage.

                         Note that boundary linkage is not used operationally."
    END_FIELD
 
 

    FIELD  end_link_ver
        TYPE CCLIST_VERSION_NUM_TYPE
        DESCRIPTION     "This field is the version number of the C&C list file 
                         whose boundary conditions determine the end boundary 
                         conditions of the present C&C list."
    END_FIELD
 
 

    FIELD  description
        TYPE            C132
        DESCRIPTION     "This field is an optional string set upon CCLIST/SAVE 
                         (using the /DESCRIPTION= qualifier) that describes the 
                         purpose and/or content of this C&C list."
    END_FIELD
 
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  wiccl_cat
 
    TYPE             CCLCAT_TYPE
 
    DESCRIPTION      "C&C List Catalog Relation"
 
    SUBSYSTEM_USING  "SPSS", "REPLICATION-FROM-SOGS"
 
    RELATED_FIELDS  "wistat_sunit.*" "wbase_cat.*"


    INDEX  wiccl_cat_1
        TYPE         unique, clustered
        FIELDS       ccl_name, ccl_version, location
    END_INDEX

END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  wiccl_cat
 
    GLOBAL
 
    TYPE        CCLCAT_TYPE
 
END_INSTANCE

Go to the top.