Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	ZWGREQUESTS.SDDL
!
! Purpose:      This SDDL file defines the wgrequests relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/21/94    27329     RSL   Original implementation
! 09/16/96    31084     sfs   Increased size of file_name from C11 to C16
! 11/08/96    32087     sfs   Added "C" to LANGUAGE list
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	FORTRAN, C, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  REQUES_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "The wgrequests relation stores the request type, number,
                       file status, and general information that can be
                       used to track down the origin of the request.
                     
                       Records are inserted into wgrequests by GSSS/REQUEST
                       command.

                       When requests are cancelled with the GSSS/CANCEL 
                       command, a flag is set in this relation. The SPSS
                       Guide Star response program WRESPONS will not process 
                       responses whose requests are marked as cancelled."
 
!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 
 

    FIELD  request_num
        TYPE GS_REQUEST_NUM_TYPE
        RELATED_FIELDS  "wgobsets.request_num"
    END_FIELD
 
 

    FIELD  request_type
        TYPE            C1
        DESCRIPTION     "The request type field can have these values:
                             A = The request was submitted to be run
                                 automatically.
                                 This means no operations intervention
                                 is needed for the request to be run by
                                 the Guide Star Selection System (GSSS). 
                                 The guide star response will automatically 
                                 be sent to SPSS.
                                 
                             S = The request was submitted to be run
                                 interactively.
                                 This means that operations staff
                                 can edit control and diagnostics
                                 parameters from a guide star account
                                 and inspect output before sending
                                 the response to SPSS. Operations must
                                 start the Request Processor and run
                                 the formatting program, which also sends
                                 the response to SPSS.
                   
                             C = The request has been cancelled by the
                                 GSSS/CANCEL command, which means GSSS
                                 is not supposed to send a response for
                                 the request."
        DISCRETE        "A", "S", "C"
    END_FIELD
 
 

    FIELD  req_date
        TYPE BRIEF_TIME_STAMP_TYPE
        DESCRIPTION     "This field contains the date the request was 
                        generated or cancelled."
    END_FIELD
 
 

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
    END_FIELD
 
 

    FIELD  file_status
        TYPE            C1
        DESCRIPTION     "This field contains the status of the request file.

                         The 'TAPE' qualifier referred to for file_status
                         values of 'B' and 'C' was originally supposed to be 
                         used for files that subsequently would be backed up to
                         tape.

                        'T' means the file transfer to GSSS was successful.
                        'U' means the file transfer to GSSS was not successful.
                        'B' means the file was successfully copied to the
                            directory specified on the command line when
                            'TAPE=directory' was used. The file was not 
                            transferred to GSSS. 
                        'C' means the file was not successfully copied to the
                            directory specified on the command line when
                            'TAPE=directory' was used. The file was not 
                            transferred to GSSS.
                        
                        There had previously been a status of 'D' for
                        deleted, and some code still checks for 'D', although
                        this value is no longer set."
        DISCRETE        "T","U","B","C"
    END_FIELD
 
 

    FIELD  account_name
        TYPE            C12
        DESCRIPTION     "This is the account name of the user who generated 
                         this request."
                        
    END_FIELD
 
 

    FIELD  file_name
        TYPE            C16
        DESCRIPTION     "This is the name of the file which holds 
                        the guide star request data. The file is stored 
                        in the default SPSS directory."
    END_FIELD
 
 

    FIELD  can_req_num
        TYPE            I4
        DESCRIPTION     "This is the request sequence number of the 
                        cancellation request. It is only set if the 
                        request_type is set to 'C'."
    END_FIELD
 
 

    FIELD  cancel_flag
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This flag indicates whether or not the request has 
                        been cancelled by a GSSS/CANCEL."
    END_FIELD
 
 

    FIELD  priority
        TYPE YES_NO_FLAG_TYPE
        DESCRIPTION     "This is an obsolete field."
    END_FIELD
 
 
END_RECORD
 
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  wgrequests
 
    TYPE             REQUES_TYPE
 
    DESCRIPTION      "Guide Star General Request Data Relation"
 
    SUBSYSTEM_USING  "SPSS"
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  wgrequests
 
    GLOBAL
 
    TYPE        REQUES_TYPE
 
END_INSTANCE

Go to the top.