Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PASS_STATUS.SDDL
!
! Purpose:      This SDDL file defines the pass_status relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 02/13/96   30697      MRB   Original implementation
! 02/22/96   30697      MRB   Incorporate Taylor, Chandler, and Owens comments
! 03/13/96   31033      EGB   Modified to be consistent with all other SDDLs
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE	C, FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL

RECORD  PASS_STAT_TYPE

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


    DESCRIPTION     "This relation contains general information about  
                     the processing of the Science Mission Specifications(SMS)
                     by PASS. Its fields help PASS operators to determine
                     which steps must be done, when all steps have been done,
                     and whether all products have been distributed to the 
                     proper people. It is intended to help simplify PASS 
                     operations.

                     If a field has a blank value it signifies that the
                     corresponding step has not been done.  In some cases 
                     initial processing is not necessary so their fields 
                     can be blank even though the final information is present.

                     Most of the fields in this table will be populated by SPST
                     tracking tools.  The pass_sms_id field is populated by 
                     SMSG/SEND."


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


    FIELD  pass_sms_id
        TYPE PASS_SMS_ID_TYPE
    END_FIELD


    FIELD init_megg_gen
        DESCRIPTION    "The field contains the time at which the initial 
                        mission schedule was generated."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD init_prod_trans
        DESCRIPTION    "The field contains the time when the initial mission 
                        scheduler and command loader reports were transferred."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD sars_to_ncc
        DESCRIPTION    "The field contains the date when the Schedule Add 
                        Request Sent (SARS) message was transferred to the 
                        TDRS Network Control Center (NCC)."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD finl_megg_gen
        DESCRIPTION    "The field contains the date when the final schedule 
                        was generated."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD finl_prod_trans
        DESCRIPTION    "The field contains the date when the final products 
                        were transferred."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD catalog_built
        DESCRIPTION    "The field houses the date when the catalog was built. 
                        This indicates that OPCMAN generated items needed for 
                        PRS."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD


    FIELD usm_to_pass_field
        DESCRIPTION    "The field contains the date at which the User Schedule 
                        Message (USM) was sent to PASS from the NCC.  This is 
                        an acknowledgement that the NCC received the SAR."
        TYPE SOGS_CHAR_TIME_TYPE
    END_FIELD

END_RECORD


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


RELATION  pass_status

    TYPE             PASS_STAT_TYPE

    DESCRIPTION      "PASS Status Relation"

    SUBSYSTEM_USING  "SPSS", "SCS", "PASS"

    RELATED_FIELDS  "pass_run_names.*" "pass_config_update.*" "pass_sms_edits.*"


    INDEX  pass_status_1
        TYPE         unique, clustered
        FIELDS       pass_sms_id
    END_INDEX

END_RELATION

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


INSTANCE  pass_status

    GLOBAL

    TYPE        PASS_STAT_TYPE

END_INSTANCE

Go to the top.