Go to the bottom.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name: PM_CONSTANTS.SDDL
!
! Purpose: This SDDL file defines the pm_constants relation.
!
! Modification History:
!
! Date PR Who Reason
! -------- ------- --- -------------------------------------------------
! 11/15/94 27329 SSS Original implementation
! 10/03/95 29467 SXT SPSS OPS controls the contents of this relation,
! not SCIOPSDB
! 07/02/97 34471 EGB Add C language support
! 04/16/98 31837 MRB Change field name from su_load_date to af_load_date
! 02/28/99 35645 MMD Added 7 constants for Bright Objects
! 04/07/00 38857 sss Added segregate_smov column
! 10/01/01 44572 sss Added index
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
LANGUAGE C, FORTRAN, SQL
INCLUDE ZSPSS_USER_TYPES.SDDL
RECORD PMCONS_TYPE
DESCRIPTION "This relation contains miscellaneous constants
used throughout SPSS. The data in this table is
maintained by SPSS OPS. There should be just one
record in this relation."
FIELD priviledg_oa
TYPE C12
DESCRIPTION "This is the user account name of the privileged
Operational Astronomer (OA). This field may only
be changed by the privileged OA himself or the
database administrator.
The privileged OA has complete privileges to
update or delete C&C lists, orbit files, and
PMDB data regardless of the ownership of those
files or data. The privileged OA is also the
only user who can change the GLOBAL C&C baseline."
END_FIELD
FIELD window_begin
TYPE SOGS_CHAR_TIME_TYPE
DESCRIPTION "This is the default start time of a window. This
is a generic time to be used whenever a window
start time needs to be defaulted. The value
should be updated every 6 months."
END_FIELD
FIELD window_end
TYPE SOGS_CHAR_TIME_TYPE
DESCRIPTION "This is the default end time of a window. This
is a generic time to be used whenever a window
end time needs to be defaulted. The value should
be updated every 6 months."
END_FIELD
FIELD file_retentn
TYPE I2
DESCRIPTION "Unused."
END_FIELD
FIELD inv_targ_id
TYPE C3
DESCRIPTION "Unused."
END_FIELD
FIELD devi_norm_kp
TYPE R*4
DESCRIPTION "This is the statistical deviation from the norm for
the pitch/yaw error coefficient for guide star
acquisitions. This is used in the GSSS/ACQ program."
END_FIELD
FIELD devi_norm_kr
TYPE R*4
DESCRIPTION "This is the statistical deviation from the norm for
the roll error coefficient for guide star
acquisitions. This is used in the GSSS/ACQ program."
END_FIELD
FIELD fir_spl_prob
TYPE R*4
DESCRIPTION "This is the first guide star spoiler acquisition
probability. This value is currently used in
the GSSS/REPORT and the GSSELECT/SELECT programs."
END_FIELD
FIELD sec_spl_prob
TYPE R*4
DESCRIPTION "This is the second guide star spoiler acquisition
probability. This value is currently used in
the GSSS/REPORT and the GSSELECT/SELECT programs."
END_FIELD
FIELD step_size
TYPE R*4
DESCRIPTION "This is the step size for evaluation of integrals.
It is used in calculating the probability of
a successful acquistion of a gs pair."
END_FIELD
FIELD bin_prob
TYPE R*4
DESCRIPTION "This is the probability that a guide star is actually
a binary star (2 stars)."
END_FIELD
FIELD global_name
TYPE C8
DESCRIPTION "This is the name of the global C&C list baseline.
See the BASELINE command documentation for more
more information on the global baseline."
RELATED_FIELDS "wbase_cat.*"
END_FIELD
FIELD max_sam_dur
TYPE SOGS_INT_TIME_TYPE
DESCRIPTION "This is the maximum time duration of a small angle
maneuver (SAM)."
RELATED_FIELDS "qalignment.sam_time"
END_FIELD
FIELD algn_sep_pad
TYPE SOGS_INT_TIME_TYPE
DESCRIPTION "This is the default period in seconds to pad out the
maximum separation duration between alignments.
It is used to compute the default value of the
maximum separation duration between alignments."
RELATED_FIELDS "qalignment.max_sep_dur" "qalignment.min_sep_dur"
END_FIELD
FIELD sgd_window_delta
TYPE SOGS_INT_TIME_TYPE
DESCRIPTION "This is the default period in seconds to set
the scheduling unit general data (SGD) windows.
PMDB /Load will set SGD windows to begin on the
current day and end at this delta time later."
END_FIELD
FIELD bo_def_start_time
TYPE SOGS_CHAR_TIME_TYPE
DESCRIPTION "This field is the default start time of a BO_unsafe_window.
This is a generic time to be used for inserting a
default Bright Object record in the wgbrit_obj relation and
for converting BO_safe_windows to BO_unsafe_windows It will
be set to a time past the end of the mission."
END_FIELD
FIELD bo_def_end_time
TYPE SOGS_CHAR_TIME_TYPE
DESCRIPTION "This field is the default end time of a BO_unsafe window.
This is a generic time to be used for inserting a
default Bright Object record in the wgbrit_obj relation and
for converting BO_safe_windows to BO_unsafe_windows."
END_FIELD
FIELD bo_def_min_v3
TYPE R8
DESCRIPTION "This field is the default minimum V3 position angle for
the BO_unsafe_window. This is a generic angle to be
used for inserting a default Bright Object record in the
wgbrit_obj relation."
UNITS "DEGREES"
RANGE "0..360"
END_FIELD
FIELD bo_def_max_v3
TYPE R8
DESCRIPTION "This field is the default maximum V3 position angle for
the BO_unsafe_window. This is a generic angle to be
used for inserting a default Bright Object record in the
wgbrit_obj relation."
UNITS "DEGREES"
RANGE "0..360"
END_FIELD
FIELD bo_alert_obj_id
TYPE TARGET_ID_TYPE
DESCRIPTION "This field is the alert id for Bright Objects that are
supplied by the Contact Scientist(CS). The CS
supplies Bright Object window data for SUs using
detectors which are more sensitive than the Guide Star
Catalog. SUs that have an exposure configuration that
matches a configuration found in the wsi_bo_check
relation are manually checked by the CS for possible
Bright Objects."
RELATED_FIELDS "wgbrit_obj.alert_obj_id" "wsi_bo_check"
END_FIELD
FIELD bo_angle_tolerance
TYPE R8
UNITS "DEGREES"
RANGE "0..360"
DESCRIPTION "This field is the separation tolerance that is applied
to the Bright Object angle ranges."
RELATED_FIELDS "wgbrit_obj.min_v3_angle" "wgbrit_obj.max_v3_angle"
END_FIELD
FIELD bo_rej_name
TYPE C10
DESCRIPTION "This field is the value of the waiver_from field for
CSBOWINDOW Bright Objects It indicates the status of
the Bright Object and is set when the Bright Object is
loaded."
RELATED_FIELDS "wgbo_waiver.waiver_from"
END_FIELD
FIELD segregate_smov
TYPE YES_NO_FLAG_TYPE
DESCRIPTION "Prior to a servicing mission, SMOV program implementation
is done using a PMDB that is separate from the PMDB used
for operational program implementation. After the
servicing mission, the SMOV programs are moved from the
SMOV PMDB to the operational PMDB. Often non-SMOV programs
will also be implemented during SMOV processing times.
This field helps to prevent the loading of SMOV or non-SMOV
programs into the wrong PMDB.
The pmdb -load program uses four pieces of information:
this field, environment variable SMOV_SPSS_DB, environment
variable SPSS_DB, and the program type which is stored in
Assist field coverpage.type.
if pm_constants.segregate_smov = 'Y', then
if coverpage.type = 'SM%' then
if SPSS_DB = SMOV_SPSS_DB then
data loaded into SPSS_DB
else
error is reported, SMOV data must be loaded
into SMOV_SPSS_DB
else
if SPSS_DB != SMOV_SPSS_DB then
data loaded into SPSS_DB
else
error is reported, only SMOV data may be loaded
into SMOV_SPSS_DB
else
data loaded into SPSS_DB"
RELATED_FIELDS "assist.coverpage.type"
END_FIELD
END_RECORD
RELATION pm_constants
TYPE PMCONS_TYPE
DESCRIPTION "PMDB Constants Relation"
SUBSYSTEM_USING "SPSS", "CCLIST"
INDEX pm_constants_1
TYPE clustered
FIELDS priviledg_oa
END_INDEX
END_RELATION
INSTANCE pm_constants
GLOBAL
TYPE PMCONS_TYPE
END_INSTANCE
Go to the top.