Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! 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
Go to the top.