Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	WPRSU_RETLIS.SDDL
!
! Purpose:      This SDDL file defines the wprsu_retlis relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/10/94    27329     EGB   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  WPRSU_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "This relation is used by the candidate addition software
		       to store what candidates, or scheduling units, are being 
		       added to the C&C List for a particular command.  This
		       information is used to join into other PMDB tables.

		       The commands that use this table include:

				CCLIST/CREATE
				CANDLIST/ADDSUS
				CANDLIST/DELSUS

		       Information is logged into the table using some process
		       specific datatags (see proc_fac_id field below) and it 
		       is deleted at the end of the command. "

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

    FIELD  cand_id
        TYPE SUNIT_ID_TYPE
	DESCRIPTION     "This field is the scheduling unit that is being added
			 (or possible deleted) from the C&C List."
    END_FIELD
 

    FIELD  version_num
        TYPE VERSION_NUM_TYPE
    END_FIELD
 

    FIELD  proc_fac_id
        TYPE            C*16
        DESCRIPTION     "This field contains a VMS process identifier and node
			 name and is part of this record to create unique 
			 record sets and also to fascilitate cleanup of the 
			 data on a command by command basis."
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  wprsu_retlis
 
    TYPE             WPRSU_TYPE
 
    DESCRIPTION      "Candidate List Join Relation"
 
    SUBSYSTEM_USING  "SPSS"
 
    INDEX  wprsu_retlis_1
        TYPE         unique, clustered
        FIELDS       cand_id, version_num, proc_fac_id
    END_INDEX

END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  wprsu_retlis
 
    GLOBAL
 
    TYPE        WPRSU_TYPE

END_INSTANCE

Go to the top.