Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QPERSONNEL.SDDL
!
! Purpose:      This SDDL file defines the qpersonnel relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/28/94    27329     EGB   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE	FORTRAN, SQL

RECORD  QPPER_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION       "This relation stores personnel information for all
                       proposers including name, address, phone, and 
		       affiliation data."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------


    FIELD  last_name
        TYPE            C15
        DESCRIPTION     "This field holds the last name of the proposer."
    END_FIELD


    FIELD  first_name
        TYPE            C15
        DESCRIPTION     "This field holds the first name of the proposer."
    END_FIELD


    FIELD  middle_initl
        TYPE            C1
        DESCRIPTION     "This field holds the middle initial of the proposer."
    END_FIELD


    FIELD  personnel_id
        TYPE            C5
        DESCRIPTION     "This is a 5 character personnel identifier assigned 
		         by ????? as an identifier for the proposer."
        FORM
            NAME         "PGD"
            LABEL        "ID"
        END_FORM
    END_FIELD


    FIELD  affiliation
        TYPE            C3
        DESCRIPTION     "This field contains the affiliation of this
			 proposer.  An incomplete list of possible values
                         follows:

                            GO  = General Observer, 
                            AR  = Archival Research,
                            IDT = Investigation Definition Team,
                            IS  = Interdisciplinary Scientist, 
                            SCI = STScI staff, 
                            ESA = European Space Agency,
                            MOC = Mission Operation Contractor. "
        FORM
            NAME         "PGD"
            LABEL        "AFFILIATION"
        END_FORM
        DISCRETE        " ",  "AR",  "ESA",  "GO",  "IDT",  "IS",  "MOC", "SCI"
    END_FIELD


    FIELD  address1
        TYPE            C80
        DESCRIPTION     "This field is the first of 5 lines of the proposer's 
                         mailing/other address."
        FORM
            NAME         "PGD"
            LABEL        "ADDRESS"
        END_FORM
    END_FIELD


    FIELD  address2
        TYPE            C80
        DESCRIPTION     "This field is the second of 5 lines of the proposer's 
                         mailing/other address."
        FORM
            NAME         "PGD"
            LABEL        "ADDRESS"
        END_FORM
    END_FIELD


    FIELD  address3
        TYPE            C80
        DESCRIPTION     "This field is the third of 5 lines of the proposer's 
                         mailing/other address."
        FORM
            NAME         "PGD"
            LABEL        "ADDRESS"
        END_FORM
    END_FIELD


    FIELD  address4
        TYPE            C80
        DESCRIPTION     "This field is the fourth of 5 lines of the proposer's 
                         mailing/other address."
        FORM
            NAME         "PGD"
            LABEL        "ADDRESS"
        END_FORM
    END_FIELD


    FIELD  address5
        TYPE            C80
        DESCRIPTION     "This field is the fifth of 5 lines of the proposer's 
                         mailing/other address."
        FORM
            NAME         "PGD"
            LABEL        "ADDRESS"
        END_FORM
    END_FIELD


    FIELD  phone_number
        TYPE            C20
        DESCRIPTION     "This field is the phone number for the proposer."
        FORM
            NAME         "PGD"
            LABEL        "PHONE NUMBER"
        END_FORM
    END_FIELD


    FIELD  telex_number
        TYPE            C20
        DESCRIPTION     "This field is the telex number for the proposer."
        FORM
            NAME         "PGD"
            LABEL        "TELEX NUMBER"
        END_FORM
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------

RELATION  qpersonnel

    TYPE             QPPER_TYPE

    DESCRIPTION      "Proposer Personnel Information Relation"

    SUBSYSTEM_USING  "SPSS", "TRANS", "PODPS", "PEPSI"

    RELATED_FIELDS  "qpcoproposer.*"

    FORM
        NAME         "PGD"
    END_FORM

    INDEX  qpersonnel_1
        TYPE         unique, clustered
        FIELDS       last_name, first_name, middle_initl
        ATTRIBUTES   ignore_dup_key
    END_INDEX

END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------

INSTANCE  qpersonnel

    GLOBAL

    TYPE        QPPER_TYPE

END_INSTANCE

Go to the top.