Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QPMDB_CHANGE.SDDL 
!
! Purpose:      This SDDL file defines the qpmdb_change relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 03/29/96   31192	BAO   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL  
 
RECORD  QPMDBCH_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION    "This relation is used by SPST to track and catalog changes 
		    to the PMDB which occur when required PMDB values are not 
		    populated via the TRANS assignment file. It is populated 
		    via PRESTO tools."

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

    FIELD  week_id
        TYPE             C*5
        DESCRIPTION      "This field specifies the calendar week that contains 
			  the proposal affected by this PMDB change." 
    END_FIELD


    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE   
        DESCRIPTION      "The proposal id affected by this PMDB change is 
			  found in this field."
    END_FIELD


    FIELD  originator
        TYPE            C*4 
        DESCRIPTION      "This field contains the name of the organization that
			  originated the change; e.g., SSD, SESD, PCT or SPST."
    END_FIELD


    FIELD  orig_date
        TYPE            I*4
        DESCRIPTION      "The date that the PMDB change was submitted for 
			  approval and implementation is located in this field."
    END_FIELD


    FIELD  type
        TYPE            C*4
        DESCRIPTION      "This field contains the proposal type; e.g., CAL/FOC."
        RELATED_FIELDS  "qpdescrip.proposal_typ"
    END_FIELD


    FIELD  change_num
        TYPE            I*2
        DESCRIPTION      "The integer number assigned to the change event is in 
			  this field."
    END_FIELD


    FIELD  description
        TYPE COMMENT_LINE_TYPE
        DESCRIPTION      "This field holds a brief description of the change."
    END_FIELD


    FIELD  changed_by 
        TYPE            C*10
        DESCRIPTION      "The name of the person who implemented the change in 
			  the PMDB is found here."
    END_FIELD


    FIELD  change_date
        TYPE            I*4
        DESCRIPTION      "This field holds the date at which the change was 
			  implemented in the PMDB."
    END_FIELD


    FIELD  verified_by
        TYPE            C*10
        DESCRIPTION      "The name of the person who verified that the change 
			  was implemented is in this field."
    END_FIELD


    FIELD  verify_date
        TYPE            I*4
        DESCRIPTION      "This field stores the date at which the change was 
			  verified."
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  qpmdb_change 
 
    TYPE             QPMDBCH_TYPE
 
    DESCRIPTION      "PMDB Change Relation"
 
    SUBSYSTEM_USING  "SPST" 

    INDEX  qpmdb_change_1
        TYPE         unique, clustered
        FIELDS       proposal_id, change_num
    END_INDEX

END_RELATION
 

Go to the top.