!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SU_TRACK.SDDL
!
! Purpose:      This SDDL file declares the ASSIST su_track relation.
!
!		See ASSIST WWW schema for additional details off DBSA
!		Homepage for details.  This file is sparsely documented 
!		with the main purpose being we also use it in SPSS.  If
!		the ASSIST version changes we should be notified and should 
!		make coincident changes here.
!
!		Note that some of the SDDL constructs do not map directly into 
!		how they are represented in assist.   For example, SDDL only 
!		supports a varchar SQL construct while su_track has both
!		char and varchar SQL constructs.
!
! Modification History:
!
!   Date       PR     Who                       Reason
! --------   -------  ---   -------------------------------------------------
! 08/31/98   36386    EGB   Created for access purposes.  DBSA-maintained table.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

 
LANGUAGE  C, SQL

INCLUDE  ZSPSS_USER_TYPES.SDDL

RECORD  SUTRK_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
    DESCRIPTION       "The su_track relation is used to track pertinant 
		       information about the status of a scheduling unit 
		       or `visit'.  

		       For details documentation, see the DBSA WWW Data 
		       Dictionary."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
    FIELD	prop_id
        TYPE	INT_PROPOSAL_ID_TYPE
    END_FIELD

    FIELD	visit_id
        TYPE    VISIT_ID_TYPE
    END_FIELD

    FIELD	sunit_id
        TYPE    SUNIT_ID_TYPE
    END_FIELD

    FIELD	gasp_extract_req
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	confirm_chart_sent
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	status
        TYPE	C20
	DISCRETE "pi", "implementation", "scheduling", 
		 "completed", "failed", "withdrawn"
    END_FIELD

    FIELD	status_time
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	status_user
        TYPE	C15
    END_FIELD

    FIELD	status_comment
        TYPE	C255
    END_FIELD

    FIELD	active_flag
        TYPE	C1
    END_FIELD

    FIELD	lrp_state
        TYPE	C25
    END_FIELD

    FIELD	internal_su
        TYPE	C4
    END_FIELD

    FIELD	external_su
        TYPE	C4
    END_FIELD

    FIELD	flight_ready_date
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	phase_a_prob
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	phase_a_comp
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	phase_b_prob
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	phase_b_comp
        TYPE    SYBASE_DATETIME
    END_FIELD

    FIELD	est_orbits
        TYPE	I4
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  su_track
 
    TYPE             SUTRK_TYPE
 
    DESCRIPTION      "SU (Visit) Level Status Tracking Relation"
 
    SUBSYSTEM_USING  "SPSS", "DBSA", "OTHER"

    INDEX  su_track_index1
        TYPE         unique, clustered
        FIELDS       prop_id, visit_id
    END_INDEX

    INDEX  su_track_index2
        TYPE         nonclustered
	FIELDS	     sunit_id
    END_INDEX

END_RELATION