!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! 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 ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 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" END_RELATION INSTANCE pm_constants GLOBAL TYPE PMCONS_TYPE END_INSTANCE