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