! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: WISTAT_SUNIT.SDDL ! ! Purpose: This SDDL file defines the wistat_sunit relation. ! ! Modification History: ! ! Date OPR Who Reason ! -------- ------- --- ------------------------------------------------- ! 11/08/94 27329 EGB Original implementation ! 02/02/95 28292 SK Modified "REPLICATION" wording under ! SUBSYSTEM_USING ! 01/16/96 30681 EGB Add lrp_name ! 02/07/97 33001 SXT Rename QSLINK_SPEC to QSLINK_TIMING and created ! link_set_id_timing and link_set_id_orient. ! 10/27/97 26365 EGB Make index #1 unique. ! ! 12/08/97 35755 MMB Convert sched_roll to REAL*8 from REAL*4 ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE C, FORTRAN, SQL INCLUDE ZSPSS_USER_TYPES.SDDL RECORD WISTA_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "This relation contains information about scheduling units with respect to a specific C&C List that they have been saved on (via CCLIST/SAVE command). The SU data that is saved includes: - the position of the SU on the calendar timeline. - the name of the C&C List the SU was saved on. - link set information needed for the calendar baseline. - other data..." !------------------------------------------------------------------------------ ! ! FIELD INFORMATION ! !------------------------------------------------------------------------------ FIELD sunit_id TYPE SUNIT_ID_TYPE DESCRIPTION "This field is the name of a scheduling unit that has been scheduled on the C&C list (named in field below)." END_FIELD FIELD version_num TYPE VERSION_NUM_TYPE END_FIELD FIELD cc_or_sms_na TYPE CCLIST_ID_TYPE DESCRIPTION "This field contains the C&C List name that this scheduling unit was scheduled on." END_FIELD FIELD cc_or_sms_vn TYPE CCLIST_VERSION_NUM_TYPE END_FIELD FIELD add_time TYPE INT_TIME_STAMP_TYPE DESCRIPTION "This field holds the time that the scheduling unit was added onto the C&C List." END_FIELD FIELD beg_tim TYPE SOGS_INT_TIME_TYPE DESCRIPTION "This field is the start time of the scheduling unit on the calendar timeline." END_FIELD FIELD end_tim TYPE SOGS_INT_TIME_TYPE DESCRIPTION "This field is the end time of the scheduling unit on the calendar timeline." END_FIELD FIELD sunit_status TYPE I2 DESCRIPTION "This field contains the status of the scheduling unit where: 0 = The SU is a link set member that was previously scheduled on the C&C List for this record, and this C&C List was once baselined but has since been deleted. 1 = The SU is on a C&C List but is not scheduled. 2 = The SU is scheduled on a calendar, but it cannot be placed on an SMS. 3 = The SU is scheduled on a calendar and can be placed on an SMS for PASS. 4 = The SU is scheduled on a calendar, but the calendar failed SMS generation. 5 = The SU is scheduled on a calendar, and the calendar successfully passed SMS generation. 6 = The SU is scheduled on a calendar and on and SMS that has been sent to PASS or that has been added to the global baseline." END_FIELD FIELD link_set_id_timing TYPE LINK_SET_ID_TYPE DESCRIPTION "If the scheduling unit is a timing link set member, then this field contains the timing link set identifier of the set it belongs to. The field will be blank if it is not a timing link set member. " RELATED_FIELDS "qslink_timing.link_set_id" END_FIELD FIELD link_set_id_orient TYPE LINK_SET_ID_TYPE DESCRIPTION "If the scheduling unit is a orient link set member, then this field contains the orient link set identifier of the set it belongs to. The field will be blank if it is not a orient link set member. " RELATED_FIELDS "qslink_orient.link_set_id" END_FIELD FIELD first_sci TYPE SOGS_INT_TIME_TYPE DESCRIPTION "This field contains the time of the first science activity on the calendar timeline for this scheduling unit. This information is used when scheduling link sets." RELATED_FIELDS "qslink_timing.*", "qslink_orient.*", "qslink_info.*" END_FIELD FIELD sched_type TYPE C1 DESCRIPTION "This field is a tri-state flag that denotes how the candidate was scheduled on the calendar: 'M' - as a Main SU 'I' - as an Interleaver SU 'P' - as a Parallel SU " RELATED_FIELDS "qscheduling.*" END_FIELD FIELD offbase TYPE YES_NO_FLAG_TYPE DESCRIPTION "When the offbase flag is set to 'Y' then the scheduling unit does not count in the baseline for this C&C List. This is important for reusable SUs in that they must appear on multiple calendars. Note that when the reusable SU is in a linked set, you will want at least one version of it known on the baseline if there are intra-calendar links. For that case you will want this offbase flag to be set to 'N', i.e. it is on the baseline. This field can be set to 'Y' by using the BASELINE/ADD/SU= command. See OPR 20709 for original requirements for this flag." RELATED_FIELDS "qscheduling.reusable", "wbase_cat.*" END_FIELD FIELD sched_roll TYPE R8 UNITS "DEGREES" DESCRIPTION "This field contains the V3 position angle at the target at the start of the first targeted (on sky) alignment of the scheduling unit." END_FIELD FIELD lrp_name TYPE LRP_NAME_TYPE DESCRIPTION "Long range plan the SU was actually scheduled against based on what was pulled into the C&C List at the time of the SU (candidate) addition to the pool. If SU was added using /NOPLAN option then the LRP name stored will be 'NO-PLAN-USED'. If SU plan windows were not found, then the LRP name will be stored as 'NO-PLAN-FOUND'. Finally, it is important to store this information here from the C&C List at the SU level because multiple LRPs can be used when scheduling a C&C List." RELATED_FIELDS "lrp_base_cat.lrp_name" END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION wistat_sunit TYPE WISTA_TYPE DESCRIPTION "Scheduling Unit To C&C List Information Relation" SUBSYSTEM_USING "SPSS", "REPLICATION-FROM-SOGS" RELATED_FIELDS "qscheduling.*", "qslink_timing.*", "qslink_orient.*", "qslink_info.*", "wbase_cat.*", "lrp_base_cat.*" INDEX wistat_sunit_1 TYPE unique, clustered FIELDS sunit_id, version_num, cc_or_sms_na, cc_or_sms_vn END_INDEX INDEX wistat_sunit_2 TYPE nonclustered FIELDS cc_or_sms_na, cc_or_sms_vn, sunit_status END_INDEX INDEX wistat_sunit_3 TYPE nonclustered FIELDS link_set_id_timing, cc_or_sms_na, cc_or_sms_vn END_INDEX INDEX wistat_sunit_4 TYPE nonclustered FIELDS link_set_id_orient, cc_or_sms_na, cc_or_sms_vn END_INDEX END_RELATION !------------------------------------------------------------------------------ ! ! INSTANCE DECLARATION ! !------------------------------------------------------------------------------ INSTANCE wistat_sunit GLOBAL TYPE WISTA_TYPE END_INSTANCE