! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! ! SDDL Name: QPDESCRIP.SDDL ! ! Purpose: This SDDL file defines the qpdescrip relation. ! ! Modification History: ! ! Date PR Who Reason ! -------- ------- --- ------------------------------------------------- ! 05/08/92 22841 ! 10/21/94 22685 Delete some obsolete fields from qpdescrip. ! 11/08/94 27726 Kao Change QPDTTL_PROPOSAL_TTL $ITMTYP to C136 ! and add $ITMNAM = QPDCAT section. ! 11/28/94 27329 EGB SDDL conversion's original implementation. ! 01/20/95 27329 SXT Add new field af_rev_number. ! 12/19/96 32768 EGB Extend prop_category field. ! 04/16/98 31837 MRB Change field name from su_load_date to af_load_date !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! LANGUAGE C, FORTRAN, SQL INCLUDE ZSPSS_USER_TYPES.SDDL RECORD QPDES_TYPE !------------------------------------------------------------------------------ ! ! RECORD INFORMATION ! !------------------------------------------------------------------------------ DESCRIPTION "This is the master, or top-level relation for proposal data. It contains general proposal information such as the proposal identifier, title, some tracking dates, and other information. A proposal consists of many individual observations submitted as a package by a proposer. When a proposal is processed by the proposal entry system (PEPSI, RPS2), it is assigned a proposal identifier. This identifier can be found in all proposal level relations and many (most) other subordinate level relations. The identifier field is typically called 'proposal_id' in these PMDB tables. Most of the data in this table is populated by TRANS. Some of the fields get modified through SPSS commands. Also, many of the fields are not being used at all and are marked as such." !------------------------------------------------------------------------------ ! ! FIELD INFORMATION ! !------------------------------------------------------------------------------ FIELD proposal_id TYPE PROPOSAL_ID_TYPE DESCRIPTION "This is the master proposal id." FORM NAME "PGD" LABEL "PROPOSAL ID" END_FORM END_FIELD FIELD program_id TYPE PROGRAM_ID_TYPE FORM NAME "ACM" LABEL "PROGRAM ID" END_FORM END_FIELD FIELD access_code TYPE C9 DESCRIPTION "This field is always blank." END_FIELD FIELD af_load_date TYPE TIME_STAMP_TYPE DESCRIPTION "This field holds the date this proposal level information was entered into the database (PMDB) from the TRANSformation assigment files." FORM NAME "PGD" LABEL "ALIGN ID" END_FORM END_FIELD FIELD proposal_typ TYPE C2 DESCRIPTION "This field holds the type of the proposal, where: GS = standard general observation (GO), GP = GO with only parallel obsets, GT = GO with only target of opportunity obsets, AR = archive research proposal. The default is GS." RELATED_FIELDS "qpdescrip.prop_category" FORM NAME "PGD" LABEL "" END_FORM DISCRETE "AR", "GP", "GS", "GT" END_FIELD FIELD dir_sel_flag TYPE YES_NO_FLAG_TYPE DESCRIPTION "Direct selection is ?. If this flag is 'Y', then this proposal is a direct selection proposal." FORM NAME "PGD" LABEL "DIRECT SELECTION? YES/NO (Y/N)" END_FORM DISCRETE "N", "Y" END_FIELD FIELD dir_sel_type TYPE C3 DESCRIPTION "This field contains the direct selection type of this proposal. It is only valid when the above dir_sel_flag is 'Y'. It can be set at: IDT = Investigation Definition Team, STC = Space Telescope Calibration, SIC = Science Instrument routine Calibration, DD = Director's Discretion, GTO = Guaranteed Time Observer, VER = VERification, BRP = ??? " FORM NAME "PGD" LABEL "DIRECT SELECTION? TYPE " END_FORM DISCRETE " ", "BRP", "DD", "GTO", "IDT", "SIC", "STC", "VER" END_FIELD FIELD proposal_ttl TYPE C136 DESCRIPTION "This field contains a `one-liner' title for the proposal. " FORM NAME "PGD" LABEL "TITLE" END_FORM END_FIELD FIELD priority TYPE I2 DESCRIPTION "This unused field should contain the priority of this proposal as assigned by the TAC and/or director. It is always 0." END_FIELD FIELD complet_thrs TYPE I2 DESCRIPTION "This unused field contains the number of observation sets needed for acceptable completion of this proposal as assigned by the TAC and/or director. It is always 0." END_FIELD FIELD approval_sts TYPE C3 DESCRIPTION "This field contains the approval status of the proposal, where: ACC = ACCepted, AWM = Accepted With Modifications, REJ = REJected. Blank implies ACC. In the PMDB you should only find statuses of ACC and blank." DISCRETE "ACC", "AWM", "REJ" END_FIELD FIELD status_dte TYPE BRIEF_TIME_STAMP_TYPE DESCRIPTION "This field contains the date the proposal status was determined. " END_FIELD FIELD active_flg TYPE YES_NO_FLAG_TYPE DESCRIPTION "This field is always 'Y' in the PMDB, and it means that the proposal is still under active consideration. In reality this is a pre-PMDB type of status and does not belong here." FORM NAME "PGD" LABEL "PROGRAM ACTIVE (Y/N)" END_FORM END_FIELD FIELD cont_id TYPE I4 DESCRIPTION "This field contains a continuation id set via PEPSI, passed through to PODPS and unaffected by SPSS. It gives some indication of the parentage of the proposal. " END_FIELD FIELD prop_category TYPE C20 DESCRIPTION "This field contains the original proposal type from the RPSS/RPS2 file. It is passed through by TRANS and will be utilized by DADS and POMS." RELATED_FIELDS "qpdescrip.proposal_typ" END_FIELD FIELD af_rev_number TYPE AF_REVISION_NUMBER_TYPE RELATED_FIELDS "qscheduling.af_rev_number", "qslink_info.af_rev_number" END_FIELD END_RECORD !------------------------------------------------------------------------------ ! ! RELATION DECLARATION ! !------------------------------------------------------------------------------ RELATION qpdescrip TYPE QPDES_TYPE DESCRIPTION "Proposal Description Master Relation" SUBSYSTEM_USING "SPSS", "TRANS", "PODPS", "SPIKE", "PEPSI" FORM NAME "ACM", "PGD" END_FORM INDEX qpdescrip_1 TYPE unique, clustered FIELDS proposal_id END_INDEX END_RELATION !------------------------------------------------------------------------------ ! ! INSTANCE DECLARATION ! !------------------------------------------------------------------------------ INSTANCE qpdescrip GLOBAL TYPE QPDES_TYPE END_INSTANCE