Go to the bottom.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL:         LRP_BASE_CAT.SDDL
!
! Purpose:      This structure contains data for the SPIKE/ASSIST database
!		Long Range Planning Windows. It will generate a file containing
!		the FORTRAN data definitions (zlrp_base_cat.all), the C data
!		definitions (zlrp_base_cat.def) and the SQL create
!               (zlrp_base_cat.sql).
!
!		This definition is based on the SPIKE/ASSIST database relation
!		lrp_base_cat and should be updated if the SPIKE/ASSIST
!		relation is modified.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10-18-94    27073     RJS   SPSS Planning Windows Support
! 02-02-95    28292     SK    Modified "REPLICATION" wording under 
!                             SUBSYSTEM_USING
! 01/16/96    30681     EGB   Use new LRP_NAME_TYPE
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
LANGUAGE        FORTRAN,SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL

RECORD  LRP_BASE_CAT_TYPE

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

    DESCRIPTION		"This relation contains data on the LRP baseline
			 and is created by SPIKE users for use by SPSS.  

			 The relation is used to determine what version of
			 plan windows to use from the plan_windows relation.
			 SPSS commands CCLIST/CREATE and /ADDSUS will query
			 this table and get the latest Long Range Plan baseline
			 name for joining to plan_windows relation."


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

    FIELD lrp_name
	TYPE LRP_NAME_TYPE
    END_FIELD


    FIELD base_time
	TYPE TIME_STAMP_TYPE 
	DESCRIPTION	"This field holds the time the LRP was baselined.  The
			 record with the latest date in this table is the LRP
			 to be used by SPSS."
    END_FIELD


    FIELD account
	TYPE		C15
	DESCRIPTION	"This field is the name of the user who baselined the 
			 LRP."
    END_FIELD

END_RECORD

 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  lrp_base_cat
 
    TYPE             LRP_BASE_CAT_TYPE
 
    DESCRIPTION      "Long Range Plan (LRP) Baseline Relation"
 
    SUBSYSTEM_USING  "SPSS", "SPIKE", "REPLICATION-TO-SOGS", "CCLIST"

    RELATED_FIELDS  "plan_windows.*"
 
    INDEX  lrp_base_cat_1
        TYPE         unique, clustered
        FIELDS       lrp_name
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE lrp_base_cat

    TYPE LRP_BASE_CAT_TYPE

END_INSTANCE

Go to the top.