/*********************************************************************
File: rowsviolating20.sql
SIR: 1539
Author: Ganesh Thadkamalla
Date : 8/19/2003

Description: Check Referential Integrity for STORET 2.0 
Checks for new relations are added to STORET v1.1 rowsviolating.sql file 
to create this file.
For Permitted values, the table_name and field_name clauses are added.
09/08/2003 - Fixed TIR 001. Ganesh.
**********************************************************************/
set echo off
set verify off
set feedback off
set termout off
set time on
set timing off
set heading off
set trimspool on
set linesize 6000
set pagesize 0
set echo on

SPOOL C:\rowsviolatingv20.log
SET ECHO OFF;
/*
DROP TABLE TSMRICHECK_TEMP; 
CREATE TABLE TSMRICHECK_TEMP
( RELATIONSHIP VARCHAR2(150), org_id char(16), "RI PROBLEMS" NUMBER(12,0) )
storage (initial 1M next 512K ); 
TRUNCATE TABLE TSMRICHECK_TEMP; 
*/

Prompt    TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMSTATN  AS  RELATIONSHIP    
--
SELECT
*
FROM   storet1.TSMADDR   TSMADDR                          
WHERE                                         
      TSMADDR.TSMSTATN_IS_NUMBER                       IS NOT NULL                       
      AND TSMADDR.TSMSTATN_ORG_ID                          IS NOT NULL                   
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMADDR.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSMADDR.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )                                       
ORDER BY 1,TSMADDR_ORG_ID                   
; 
Prompt     TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMCPORG  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMADDR   TSMADDR                          
WHERE                                         
      TSMADDR.TSMCPORG_IS_NUMBER                       IS NOT NULL                       
      AND TSMADDR.TSMCPORG_ORG_ID                          IS NOT NULL                   
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMCPORG   TSMCPORG              
      WHERE TSMADDR.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER        
      AND TSMADDR.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID             
      )                                       
ORDER BY 1,TSMADDR_ORG_ID                   
; 
Prompt     TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSRLAB  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMADDR   TSMADDR                          
WHERE                                         
      TSMADDR.TSRLAB_IS_NUMBER                         IS NOT NULL                       
      AND TSMADDR.TSRLAB_ORG_ID                            IS NOT NULL                   
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLAB   TSRLAB                  
      WHERE TSMADDR.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER            
      AND TSMADDR.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID                 
      )                                       
ORDER BY 1,TSMADDR_ORG_ID                   
; 
Prompt     TSMADDR    SOMETIMES IS_ASSIGNED_TO                  TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMADDR   TSMADDR                          
WHERE                                         
      TSMADDR.TSMORGAN_IS_NUMBER                       IS NOT NULL                       
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMADDR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )                                       
ORDER BY 1,TSMADDR_ORG_ID                   
; 
Prompt     TSMADDR    SOMETIMES IS_FOR                          TSMWLE  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMADDR   TSMADDR                          
WHERE                                         
      TSMADDR.TSMWELL_ORG_ID                           IS NOT NULL                       
      AND TSMADDR.TSMWELL_IS_NUMBER                        IS NOT NULL                   
      AND TSMADDR.TSMWLE_TYPE_NAME                         IS NOT NULL                   
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWLE   TSMWLE                  
      WHERE TSMADDR.TSMWELL_ORG_ID                  = TSMWLE.TSMWELL_ORG_ID              
      AND TSMADDR.TSMWELL_IS_NUMBER               = TSMWLE.TSMWELL_IS_NUMBER             
      AND TSMADDR.TSMWLE_TYPE_NAME                = TSMWLE.TSMWLE_TYPE_NAME              
      )                                       
ORDER BY 1,TSMADDR_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMRRR  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMRRR_IS_NUMBER                         IS NOT NULL                        
      AND TSMALP.TSMRRR_ORG_ID                            IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMRRR   TSMRRR                  
      WHERE TSMALP.TSMRRR_IS_NUMBER                = TSMRRR.TSMRRR_IS_NUMBER             
      AND TSMALP.TSMRRR_ORG_ID                   = TSMRRR.TSMRRR_ORG_ID                  
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMFHU  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMFHU_IS_NUMBER                         IS NOT NULL                        
      AND TSMALP.TSMFHU_ORG_ID                            IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMFHU   TSMFHU                  
      WHERE TSMALP.TSMFHU_IS_NUMBER                = TSMFHU.TSMFHU_IS_NUMBER             
      AND TSMALP.TSMFHU_ORG_ID                   = TSMFHU.TSMFHU_ORG_ID                  
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_ASSOCIATED_WITH              TSMNAL  AS  RELATIONSHIP ,TSMALP_ORG_ID AS ORG_ID 
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMNAL_CD                                IS NOT NULL                        
      AND TSMALP.TSMNAL_STATE                             IS NOT NULL                    
      AND TSMALP.TSMNAL_ORG_ID                            IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMNAL   TSMNAL                  
      WHERE TSMALP.TSMNAL_CD                       = TSMNAL.TSMNAL_CD                    
      AND TSMALP.TSMNAL_STATE                    = TSMNAL.TSMNAL_STATE                   
      AND TSMALP.TSMNAL_ORG_ID                   = TSMNAL.TSMNAL_ORG_ID                  
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_LOCATION_OF                  TSMSTATN  AS  RELATIONSHIP ,TSMALP_ORG_ID AS ORG_ID
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMSTATN0IS_NUMBER                       IS NOT NULL                        
      AND TSMALP.TSMSTATN0ORG_ID                          IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMALP.TSMSTATN0IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER         
      AND TSMALP.TSMSTATN0ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID              
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_PRIMARILY_LOCATED_BY         TSMGEOPA  AS  RELATIONSHIP ,TSMALP_ORG_ID
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMGEOPA_IS_NUMBER                       IS NOT NULL                        
      AND TSMALP.TSMGEOPA_ORG_ID                          IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMGEOPA   TSMGEOPA              
      WHERE TSMALP.TSMGEOPA_IS_NUMBER              = TSMGEOPA.TSMGEOPA_IS_NUMBER         
      AND TSMALP.TSMGEOPA_ORG_ID                 = TSMGEOPA.TSMGEOPA_ORG_ID              
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES IS_SECONDARILY_LOCATED_BY       TSMGEOPA  AS  RELATIONSHIP 
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMGEOPA0IS_NUMBER                       IS NOT NULL                        
      AND TSMALP.TSMGEOPA0ORG_ID                          IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMGEOPA   TSMGEOPA              
      WHERE TSMALP.TSMGEOPA0IS_NUMBER              = TSMGEOPA.TSMGEOPA_IS_NUMBER         
      AND TSMALP.TSMGEOPA0ORG_ID                 = TSMGEOPA.TSMGEOPA_ORG_ID              
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES LOCATES                         TSMPMGRD  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMSTATN_ORG_ID                          IS NOT NULL                        
      AND TSMALP.TSMSTATN_IS_NUMBER                       IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPMGRD   TSMPMGRD              
      WHERE TSMALP.TSMSTATN_ORG_ID                 = TSMPMGRD.TSMSTATN_ORG_ID            
      AND TSMALP.TSMSTATN_IS_NUMBER              = TSMPMGRD.TSMSTATN_IS_NUMBER           
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES LOCATES                         TSMPMTCT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMSTATN1ORG_ID                          IS NOT NULL                        
      AND TSMALP.TSMSTATN1IS_NUMBER                       IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPMTCT   TSMPMTCT              
      WHERE TSMALP.TSMSTATN1ORG_ID                 = TSMPMTCT.TSMSTATN_ORG_ID            
      AND TSMALP.TSMSTATN1IS_NUMBER              = TSMPMTCT.TSMSTATN_IS_NUMBER           
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES LOCATES                         TSMPIPE  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMPIPE_IS_NUMBER                        IS NOT NULL                        
      AND TSMALP.TSMPIPE_ORG_ID                           IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPIPE   TSMPIPE                
      WHERE TSMALP.TSMPIPE_IS_NUMBER               = TSMPIPE.TSMPIPE_IS_NUMBER           
      AND TSMALP.TSMPIPE_ORG_ID                  = TSMPIPE.TSMPIPE_ORG_ID                
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMALP     SOMETIMES LOCATES                         TSMWELL  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMALP   TSMALP                            
WHERE                                         
      TSMALP.TSMWELL_IS_NUMBER                        IS NOT NULL                        
      AND TSMALP.TSMWELL_ORG_ID                           IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWELL   TSMWELL                
      WHERE TSMALP.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER           
      AND TSMALP.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID                
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMCPORG   ALWAYS    ASSISTS                         TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMCPORG   TSMCPORG                        
WHERE                                         
      TSMCPORG.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMCPORG.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSMCPORG_ORG_ID                   
; 
Prompt     TSMCSNG    ALWAYS    IS_USED_IN                      TSMINTVL  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMCSNG   TSMCSNG                          
WHERE                                         
      TSMCSNG.TSMINTVL_IS_NUMBER                       IS NULL                           
      OR TSMCSNG.TSMINTVL_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMINTVL   TSMINTVL              
      WHERE TSMCSNG.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER        
      AND TSMCSNG.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID             
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMEADDR   SOMETIMES IS_ASSIGNED_TO                  TSMCPORG  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMEADDR   TSMEADDR                        
WHERE                                         
      TSMEADDR.TSMCPORG_IS_NUMBER                       IS NOT NULL                      
      AND TSMEADDR.TSMCPORG_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMCPORG   TSMCPORG              
      WHERE TSMEADDR.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER       
      AND TSMEADDR.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID            
      )                                       
ORDER BY 1,TSMEADDR_ORG_ID                   
; 
Prompt     TSMEADDR   SOMETIMES IS_FOR                          TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMEADDR   TSMEADDR                        
WHERE                                         
      TSMEADDR.TSMSTATN_IS_NUMBER                       IS NOT NULL                      
      AND TSMEADDR.TSMSTATN_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMEADDR.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMEADDR.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMEADDR_ORG_ID                   
; 
Prompt     TSMEADDR   SOMETIMES IS_FOR                          TSRLAB  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMEADDR   TSMEADDR                        
WHERE                                         
      TSMEADDR.TSRLAB_IS_NUMBER                         IS NOT NULL                      
      AND TSMEADDR.TSRLAB_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLAB   TSRLAB                  
      WHERE TSMEADDR.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER           
      AND TSMEADDR.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID                
      )                                       
ORDER BY 1,TSMEADDR_ORG_ID                   
; 
Prompt     TSMEADDR   SOMETIMES IS_FOR                          TSMPERSN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMEADDR   TSMEADDR                        
WHERE                                         
      TSMEADDR.TSMPERSN_IS_NUMBER                       IS NOT NULL                      
      AND TSMEADDR.TSMPERSN_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPERSN   TSMPERSN              
      WHERE TSMEADDR.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER       
      AND TSMEADDR.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID            
      )                                       
ORDER BY 1,TSMEADDR_ORG_ID                   
; 
Prompt     TSMEADDR   SOMETIMES IS_FOR                          TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMEADDR   TSMEADDR                        
WHERE                                         
      TSMEADDR.TSMORGAN_IS_NUMBER                       IS NOT NULL                      
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMEADDR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSMEADDR_ORG_ID                   
; 
Prompt     TSMERS     ALWAYS    IS_DEFINED_BY                   TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMERS   TSMERS                            
WHERE                                         
      TSMERS.TSMORGAN_IS_NUMBER                       IS NULL                            
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMERS.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER         
      )                                       
ORDER BY 1,TSMERS_ORG_ID                   
; 
Prompt     TSMESTLC   ALWAYS    CHARACTERIZES                   TSMALP  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMESTLC   TSMESTLC                        
WHERE   
--	TSMESTLC.TSMALP_ORG_ID <>  DEMOTEST  AND                                      
      (TSMESTLC.TSMALP_IS_NUMBER                         IS NULL                          
      OR TSMESTLC.TSMALP_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMALP   TSMALP                  
      WHERE TSMESTLC.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER           
      AND TSMESTLC.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                
      ))                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMESTLC   SOMETIMES IS_CHARACTERIZED_BY             TSMESTRY  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMESTLC   TSMESTLC                        
WHERE                                         
      TSMESTLC.TSMESTRY_ORG_ID                          IS NOT NULL                      
      AND TSMESTLC.TSMESTRY_IS_NUMBER                       IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMESTRY   TSMESTRY              
      WHERE TSMESTLC.TSMESTRY_ORG_ID                 = TSMESTRY.TSMESTRY_ORG_ID          
      AND TSMESTLC.TSMESTRY_IS_NUMBER              = TSMESTRY.TSMESTRY_IS_NUMBER         
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMESTRY   SOMETIMES IS_LOCATED_IN                   TSMESTRY  AS  RELATIONSHIP      
--
SELECT
*
FROM   STORET.TSMESTRY   TSMESTRY                        
WHERE                                         
      TSMESTRY.TSMESTRY0ORG_ID                          IS NOT NULL                      
      AND TSMESTRY.TSMESTRY0IS_NUMBER                       IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMESTRY   IN_TSMESTRY           
      WHERE TSMESTRY.TSMESTRY0ORG_ID                 = IN_TSMESTRY.TSMESTRY_ORG_ID       
      AND TSMESTRY.TSMESTRY0IS_NUMBER              = IN_TSMESTRY.TSMESTRY_IS_NUMBER      
      )                                       
ORDER BY 1,TSMESTRY_ORG_ID                   
; 
Prompt     TSMFCLTY   ALWAYS    IS                              TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMFCLTY   TSMFCLTY                        
WHERE                                         
      TSMFCLTY.TSMSTATN_IS_NUMBER                       IS NULL                          
      OR TSMFCLTY.TSMSTATN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMFCLTY.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMFCLTY.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMFILL    ALWAYS    IS_USED_IN                      TSMINTVL  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMFILL   TSMFILL                          
WHERE                                         
      TSMFILL.TSMINTVL_IS_NUMBER                       IS NULL                           
      OR TSMFILL.TSMINTVL_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMINTVL   TSMINTVL              
      WHERE TSMFILL.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER        
      AND TSMFILL.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID             
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMFSA     ALWAYS    DESCRIBES                       TSMFCLTY  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMFSA   TSMFSA                            
WHERE                                         
      TSMFSA.TSMSTATN_ORG_ID                          IS NULL                            
      OR TSMFSA.TSMSTATN_IS_NUMBER                       IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMFCLTY   TSMFCLTY              
      WHERE TSMFSA.TSMSTATN_ORG_ID                 = TSMFCLTY.TSMSTATN_ORG_ID            
      AND TSMFSA.TSMSTATN_IS_NUMBER              = TSMFCLTY.TSMSTATN_IS_NUMBER           
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMFSA     ALWAYS    IS_DESCRIBED_BY                 TSMSIC  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMFSA   TSMFSA                            
WHERE                                         
      TSMFSA.TSMSIC_CODE                              IS NULL                            
      OR TSMFSA.TSMSIC_ORG_ID                            IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMSIC   TSMSIC                  
      WHERE TSMFSA.TSMSIC_CODE                     = TSMSIC.TSMSIC_CODE                  
      AND TSMFSA.TSMSIC_ORG_ID                   = TSMSIC.TSMSIC_ORG_ID                  
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt TSMGLL     ALWAYS    CHARACTERIZES                   TSMALP  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMGLL   TSMGLL                            
WHERE                                         
      TSMGLL.TSMALP_IS_NUMBER                         IS NULL                            
      OR TSMGLL.TSMALP_ORG_ID                            IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMALP   TSMALP                  
      WHERE TSMGLL.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER             
      AND TSMGLL.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                  
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMGNTXT   SOMETIMES DEFINES                         TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMGNTXT   TSMGNTXT                        
WHERE                                         
      TSMGNTXT.TSRRSULT_IS_NUMBER                       IS NOT NULL                      
      AND TSMGNTXT.TSRRSULT_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSMGNTXT.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER       
      AND TSMGNTXT.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID            
      )                                       
ORDER BY 1,TSMGNTXT_ORG_ID                   
; 
Prompt     TSMGNTXT   SOMETIMES DESCRIBES                       TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMGNTXT   TSMGNTXT                        
WHERE                                         
      TSMGNTXT.TSMPROJ_IS_NUMBER                        IS NOT NULL                      
      AND TSMGNTXT.TSMPROJ_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMGNTXT.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER         
      AND TSMGNTXT.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID              
      )                                       
ORDER BY 1,TSMGNTXT_ORG_ID                   
; 
Prompt     TSMGNTXT   SOMETIMES DESCRIBES                       TSMPROGM  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMGNTXT   TSMGNTXT                        
WHERE                                         
      TSMGNTXT.TSMPROGM_IS_NUMBER                       IS NOT NULL                      
      AND TSMGNTXT.TSMPROGM_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROGM   TSMPROGM              
      WHERE TSMGNTXT.TSMPROGM_IS_NUMBER              = TSMPROGM.TSMPROGM_IS_NUMBER       
      AND TSMGNTXT.TSMPROGM_ORG_ID                 = TSMPROGM.TSMPROGM_ORG_ID            
      )                                       
ORDER BY 1,TSMGNTXT_ORG_ID                   
; 
Prompt     TSMGNTXT   SOMETIMES DESCRIBES                       TSRGRCFG  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMGNTXT   TSMGNTXT                        
WHERE                                         
      TSMGNTXT.TSRGRCFG_IS_NUMBER                       IS NOT NULL                      
      AND TSMGNTXT.TSRGRCFG_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRGRCFG   TSRGRCFG              
      WHERE TSMGNTXT.TSRGRCFG_IS_NUMBER              = TSRGRCFG.TSRGRCFG_IS_NUMBER       
      AND TSMGNTXT.TSRGRCFG_ORG_ID                 = TSRGRCFG.TSRGRCFG_ORG_ID            
      )                                       
ORDER BY 1,TSMGNTXT_ORG_ID                   
; 
Prompt     TSMHOLE    ALWAYS    IS                              TSMINTVL  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMHOLE   TSMHOLE                          
WHERE                                         
      TSMHOLE.TSMINTVL_IS_NUMBER                       IS NULL                           
      OR TSMHOLE.TSMINTVL_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMINTVL   TSMINTVL              
      WHERE TSMHOLE.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER        
      AND TSMHOLE.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID             
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMIGUA    ALWAYS    FURTHER_DEFINES                 TSMINTVL  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMIGUA   TSMIGUA                          
WHERE                                         
      TSMIGUA.TSMINTVL_IS_NUMBER                       IS NULL                           
      OR TSMIGUA.TSMINTVL_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMINTVL   TSMINTVL              
      WHERE TSMIGUA.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER        
      AND TSMIGUA.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID             
      )                                       
ORDER BY 1,TSMIGUA_ORG_ID                   
; 
Prompt     TSMIGUA    ALWAYS    IS_DESCRIBED_BY                 TSMGEOUN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMIGUA   TSMIGUA                          
WHERE                                         
      TSMIGUA.TSMGEOUN_CD                              IS NULL                           
      OR TSMIGUA.TSMGEOUN_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMGEOUN   TSMGEOUN              
      WHERE TSMIGUA.TSMGEOUN_CD                     = TSMGEOUN.TSMGEOUN_CD               
      AND TSMIGUA.TSMGEOUN_ORG_ID                 = TSMGEOUN.TSMGEOUN_ORG_ID             
      )                                       
ORDER BY 1,TSMIGUA_ORG_ID                   
; 
Prompt     TSMINTVL   SOMETIMES CONSISTS_OF                     TSMLTHUN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMINTVL   TSMINTVL                        
WHERE                                         
      TSMINTVL.TSMLTHUN_CD                              IS NOT NULL                      
      AND TSMINTVL.TSMLTHUN_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMLTHUN   TSMLTHUN              
      WHERE TSMINTVL.TSMLTHUN_CD                     = TSMLTHUN.TSMLTHUN_CD              
      AND TSMINTVL.TSMLTHUN_ORG_ID                 = TSMLTHUN.TSMLTHUN_ORG_ID            
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMINTVL   ALWAYS    PARTITIONS                      TSMWELL  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMINTVL   TSMINTVL                        
WHERE                                         
      TSMINTVL.TSMWELL_IS_NUMBER                        IS NULL                          
      OR TSMINTVL.TSMWELL_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWELL   TSMWELL                
      WHERE TSMINTVL.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER         
      AND TSMINTVL.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID              
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMLOG     ALWAYS    DESCRIBES_CONSTRUCTION_OF       TSMWELL  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMLOG   TSMLOG                            
WHERE                                         
      TSMLOG.TSMWELL_IS_NUMBER                        IS NULL                            
      OR TSMLOG.TSMWELL_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWELL   TSMWELL                
      WHERE TSMLOG.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER           
      AND TSMLOG.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID                
      )                                       
ORDER BY 1,TSMLOG_ORG_ID                   
; 
Prompt     TSMOCNLC   ALWAYS    CHARACTERIZES                   TSMALP  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMOCNLC   TSMOCNLC                        
WHERE                                         
      TSMOCNLC.TSMALP_IS_NUMBER                         IS NULL                          
      OR TSMOCNLC.TSMALP_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMALP   TSMALP                  
      WHERE TSMOCNLC.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER           
      AND TSMOCNLC.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                
      )                                       
ORDER BY 1,TSMALP_ORG_ID                   
; 
Prompt     TSMOPNG    ALWAYS    IS                              TSMINTVL  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMOPNG   TSMOPNG                          
WHERE                                         
      TSMOPNG.TSMINTVL_IS_NUMBER                       IS NULL                           
      OR TSMOPNG.TSMINTVL_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMINTVL   TSMINTVL              
      WHERE TSMOPNG.TSMINTVL_IS_NUMBER              = TSMINTVL.TSMINTVL_IS_NUMBER        
      AND TSMOPNG.TSMINTVL_ORG_ID                 = TSMINTVL.TSMINTVL_ORG_ID             
      )                                       
ORDER BY 1,TSMINTVL_ORG_ID                   
; 
Prompt     TSMPCOA    ALWAYS    INVOLVES                        TSMCPORG  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPCOA   TSMPCOA                          
WHERE                                         
      TSMPCOA.TSMCPORG_IS_NUMBER                       IS NULL                           
      OR TSMPCOA.TSMCPORG_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMCPORG   TSMCPORG              
      WHERE TSMPCOA.TSMCPORG_IS_NUMBER              = TSMCPORG.TSMCPORG_IS_NUMBER        
      AND TSMPCOA.TSMCPORG_ORG_ID                 = TSMCPORG.TSMCPORG_ORG_ID             
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPCOA    ALWAYS    IS_INVOLVED_IN                  TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMPCOA   TSMPCOA                          
WHERE                                         
      TSMPCOA.TSMPROJ_IS_NUMBER                        IS NULL                           
      OR TSMPCOA.TSMPROJ_ORG_ID                           IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMPCOA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSMPCOA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPERSN   ALWAYS    IS_PART_OF                      TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPERSN   TSMPERSN                        
WHERE                                         
      TSMPERSN.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMPERSN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSMPERSN_ORG_ID                   
; 
Prompt     TSMPIPE    ALWAYS    IS_PART_OF                      TSMFCLTY  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPIPE   TSMPIPE                          
WHERE                                         
      TSMPIPE.TSMSTATN_ORG_ID                          IS NULL                           
      OR TSMPIPE.TSMSTATN_IS_NUMBER                       IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMFCLTY   TSMFCLTY              
      WHERE TSMPIPE.TSMSTATN_ORG_ID                 = TSMFCLTY.TSMSTATN_ORG_ID           
      AND TSMPIPE.TSMSTATN_IS_NUMBER              = TSMFCLTY.TSMSTATN_IS_NUMBER          
      )                                       
ORDER BY 1,TSMPIPE_ORG_ID                   
; 
Prompt     TSMPMGRD   ALWAYS    BELONGS_TO                      TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPMGRD   TSMPMGRD                        
WHERE                                         
      TSMPMGRD.TSMSTATN_IS_NUMBER                       IS NULL                          
      OR TSMPMGRD.TSMSTATN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMPMGRD.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMPMGRD.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPMTCT   ALWAYS    BELONGS_TO                      TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPMTCT   TSMPMTCT                        
WHERE                                         
      TSMPMTCT.TSMSTATN_IS_NUMBER                       IS NULL                          
      OR TSMPMTCT.TSMSTATN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMPMTCT.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMPMTCT.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPPA     ALWAYS    HAS                             TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMPPA   TSMPPA                            
WHERE                                         
      TSMPPA.TSMPROJ_IS_NUMBER                        IS NULL                            
      OR TSMPPA.TSMPROJ_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMPPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSMPPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPPA     ALWAYS    HAS                             TSMPERSN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPPA   TSMPPA                            
WHERE                                         
      TSMPPA.TSMPERSN_IS_NUMBER                       IS NULL                            
      OR TSMPPA.TSMPERSN_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPERSN   TSMPERSN              
      WHERE TSMPPA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER         
      AND TSMPPA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID              
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPPRA    ALWAYS    HAS                             TSMPPA  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMPPRA   TSMPPRA                          
WHERE                                         
      TSMPPRA.TSMPERSN_ORG_ID                          IS NULL                           
      OR TSMPPRA.TSMPERSN_IS_NUMBER                       IS NULL                        
      OR TSMPPRA.TSMPROJ_ORG_ID                           IS NULL                        
      OR TSMPPRA.TSMPROJ_IS_NUMBER                        IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPPA   TSMPPA                  
      WHERE TSMPPRA.TSMPERSN_ORG_ID                 = TSMPPA.TSMPERSN_ORG_ID             
      AND TSMPPRA.TSMPERSN_IS_NUMBER              = TSMPPA.TSMPERSN_IS_NUMBER            
      AND TSMPPRA.TSMPROJ_ORG_ID                  = TSMPPA.TSMPROJ_ORG_ID                
      AND TSMPPRA.TSMPROJ_IS_NUMBER               = TSMPPA.TSMPROJ_IS_NUMBER             
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPPRA    ALWAYS    IS_FOR                          TSMPROLE  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPPRA   TSMPPRA                          
WHERE                                         
      TSMPPRA.TSMPROLE_IS_NUMBER                       IS NULL                           
      OR TSMPPRA.TSMPROLE_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMPROLE   TSMPROLE              
      WHERE TSMPPRA.TSMPROLE_IS_NUMBER              = TSMPROLE.TSMPROLE_IS_NUMBER        
      AND TSMPPRA.TSMPROLE_ORG_ID                 = TSMPROLE.TSMPROLE_ORG_ID             
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPRA     ALWAYS    IS_FOR                          TSMPERSN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPRA   TSMPRA                            
WHERE                                         
      TSMPRA.TSMPERSN_IS_NUMBER                       IS NULL                            
      OR TSMPRA.TSMPERSN_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPERSN   TSMPERSN              
      WHERE TSMPRA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER         
      AND TSMPRA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID              
      )                                       
ORDER BY 1,TSMPERSN_ORG_ID                   
; 
Prompt     TSMPRA     ALWAYS    IS_FOR                          TSMPROLE  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPRA   TSMPRA                            
WHERE                                         
      TSMPRA.TSMPROLE_IS_NUMBER                       IS NULL                            
      OR TSMPRA.TSMPROLE_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMPROLE   TSMPROLE              
      WHERE TSMPRA.TSMPROLE_IS_NUMBER              = TSMPROLE.TSMPROLE_IS_NUMBER         
      AND TSMPRA.TSMPROLE_ORG_ID                 = TSMPROLE.TSMPROLE_ORG_ID              
      )                                       
ORDER BY 1,TSMPERSN_ORG_ID                   
; 
Prompt     TSMPROGM   ALWAYS    SPONSORED_BY                    TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPROGM   TSMPROGM                        
WHERE                                         
      TSMPROGM.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMPROGM.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSMPROGM_ORG_ID                   
; 
Prompt     TSMPROJ    ALWAYS    IS_THE_RESPONSIBILITY_OF        TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPROJ   TSMPROJ                          
WHERE                                         
      TSMPROJ.TSMORGAN_IS_NUMBER                       IS NULL                           
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMPROJ.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPRPRA   ALWAYS    IS_FOR                          TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMPRPRA   TSMPRPRA                        
WHERE                                         
      TSMPRPRA.TSMPROJ_IS_NUMBER                        IS NULL                          
      OR TSMPRPRA.TSMPROJ_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMPRPRA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER         
      AND TSMPRPRA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID              
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPRPRA   ALWAYS    PARTICIPATED_IN_BY              TSMPROGM  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPRPRA   TSMPRPRA                        
WHERE                                         
      TSMPRPRA.TSMPROGM_IS_NUMBER                       IS NULL                          
      OR TSMPRPRA.TSMPROGM_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROGM   TSMPROGM              
      WHERE TSMPRPRA.TSMPROGM_IS_NUMBER              = TSMPROGM.TSMPROGM_IS_NUMBER       
      AND TSMPRPRA.TSMPROGM_ORG_ID                 = TSMPROGM.TSMPROGM_ORG_ID            
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSMPSA     ALWAYS    IS_USED_BY                      TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMPSA   TSMPSA                            
WHERE                                         
      TSMPSA.TSMPROJ_IS_NUMBER                        IS NULL                            
      OR TSMPSA.TSMPROJ_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMPSA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSMPSA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPSA     ALWAYS    USES                            TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMPSA   TSMPSA                            
WHERE                                         
      TSMPSA.TSMSTATN_IS_NUMBER                       IS NULL                            
      OR TSMPSA.TSMSTATN_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMPSA.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER         
      AND TSMPSA.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID              
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPSRA    ALWAYS    IS_FOR                          TSMPSA  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMPSRA   TSMPSRA                          
WHERE                                         
      TSMPSRA.TSMSTATN_ORG_ID                          IS NULL                           
      OR TSMPSRA.TSMSTATN_IS_NUMBER                       IS NULL                        
      OR TSMPSRA.TSMPROJ_ORG_ID                           IS NULL                        
      OR TSMPSRA.TSMPROJ_IS_NUMBER                        IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPSA   TSMPSA                  
      WHERE TSMPSRA.TSMSTATN_ORG_ID                 = TSMPSA.TSMSTATN_ORG_ID             
      AND TSMPSRA.TSMSTATN_IS_NUMBER              = TSMPSA.TSMSTATN_IS_NUMBER            
      AND TSMPSRA.TSMPROJ_ORG_ID                  = TSMPSA.TSMPROJ_ORG_ID                
      AND TSMPSRA.TSMPROJ_IS_NUMBER               = TSMPSA.TSMPROJ_IS_NUMBER             
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPSRA    ALWAYS    IS_FOR                          TSMPSR  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMPSRA   TSMPSRA                          
WHERE                                         
      TSMPSRA.TSMPSR_IS_NUMBER                         IS NULL                           
      OR TSMPSRA.TSMPSR_ORG_ID                            IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMPSR   TSMPSR                  
      WHERE TSMPSRA.TSMPSR_IS_NUMBER                = TSMPSR.TSMPSR_IS_NUMBER            
      AND TSMPSRA.TSMPSR_ORG_ID                   = TSMPSR.TSMPSR_ORG_ID                 
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMPUMP    ALWAYS    DRAWS_WATER_FROM                TSMWELL  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMPUMP   TSMPUMP                          
WHERE                                         
      TSMPUMP.TSMWELL_IS_NUMBER                        IS NULL                           
      OR TSMPUMP.TSMWELL_ORG_ID                           IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWELL   TSMWELL                
      WHERE TSMPUMP.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER          
      AND TSMPUMP.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID               
      )                                       
ORDER BY 1,TSMPUMP_ORG_ID                   
; 
Prompt     TSMRFLBL   ALWAYS    REFERENCES                      TSMERS  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMRFLBL   TSMRFLBL                        
WHERE                                         
      TSMRFLBL.TSMERS_IS_NUMBER                         IS NULL                          
      OR TSMRFLBL.TSMERS_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMERS   TSMERS                  
      WHERE TSMRFLBL.TSMERS_IS_NUMBER                = TSMERS.TSMERS_IS_NUMBER           
      AND TSMRFLBL.TSMERS_ORG_ID                   = TSMERS.TSMERS_ORG_ID                
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMRFLBL   ALWAYS    REFERENCES                      TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMRFLBL   TSMRFLBL                        
WHERE                                         
      TSMRFLBL.TSMSTATN_IS_NUMBER                       IS NULL                          
      OR TSMRFLBL.TSMSTATN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMRFLBL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMRFLBL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMSPRNG   ALWAYS    IS                              TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMSPRNG   TSMSPRNG                        
WHERE                                         
      TSMSPRNG.TSMSTATN_IS_NUMBER                       IS NULL                          
      OR TSMSPRNG.TSMSTATN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMSPRNG.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER       
      AND TSMSPRNG.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMSPRNG   SOMETIMES IS_DESCRIBED_BY                 TSMGEOUN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMSPRNG   TSMSPRNG                        
WHERE                                         
      TSMSPRNG.TSMGEOUN_CD                              IS NOT NULL                      
      AND TSMSPRNG.TSMGEOUN_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMGEOUN   TSMGEOUN              
      WHERE TSMSPRNG.TSMGEOUN_CD                     = TSMGEOUN.TSMGEOUN_CD              
      AND TSMSPRNG.TSMGEOUN_ORG_ID                 = TSMGEOUN.TSMGEOUN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMSPRNG   SOMETIMES IS_DESCRIBED_BY                 TSMLTHUN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMSPRNG   TSMSPRNG                        
WHERE                                         
      TSMSPRNG.TSMLTHUN_CD                              IS NOT NULL                      
      AND TSMSPRNG.TSMLTHUN_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSMLTHUN   TSMLTHUN              
      WHERE TSMSPRNG.TSMLTHUN_CD                     = TSMLTHUN.TSMLTHUN_CD              
      AND TSMSPRNG.TSMLTHUN_ORG_ID                 = TSMLTHUN.TSMLTHUN_ORG_ID            
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMSTATN   ALWAYS    IS_CLASSIFIED_BY                TSMVSTC  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMSTATN   TSMSTATN                        
WHERE                                         
      TSMSTATN.TSMVSTC_IS_NUMBER                        IS NULL                          
      OR TSMSTATN.TSMVSTC_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSMVSTC   TSMVSTC                
      WHERE TSMSTATN.TSMVSTC_IS_NUMBER               = TSMVSTC.TSMVSTC_IS_NUMBER         
      AND TSMSTATN.TSMVSTC_ORG_ID                  = TSMVSTC.TSMVSTC_ORG_ID              
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMSTATN   ALWAYS    IS_ESTABLISHED_BY               TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMSTATN   TSMSTATN                        
WHERE                                         
      TSMSTATN.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMSTATN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
Prompt     TSMUOA     ALWAYS    ESTABLISHES_ACCESS_TO           TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMUOA   TSMUOA                            
WHERE                                         
      TSMUOA.TSMORGAN_IS_NUMBER                       IS NULL                            
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSMUOA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER         
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSMUOA     ALWAYS    PROVIDES_ACCESS_FOR             TSMUSER  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMUOA   TSMUOA                            
WHERE                                         
      TSMUOA.TSMUSER_USERID                           IS NULL                            
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMUSER   TSMUSER                
      WHERE TSMUOA.TSMUSER_USERID                  = TSMUSER.TSMUSER_USERID              
      )                                       
ORDER BY 1,TSMUSER_USERID                   
; 
Prompt     TSMVSC     ALWAYS    IS_DESIGNATED_BY                TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMVSC   TSMVSC                            
WHERE                                         
      TSMVSC.TSMPROJ_IS_NUMBER                        IS NULL                            
      OR TSMVSC.TSMPROJ_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSMVSC.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSMVSC.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMVSC_ORG_ID                   
; 
Prompt     TSMWELL    ALWAYS    IS                              TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSMWELL   TSMWELL                          
WHERE                                         
      TSMWELL.TSMSTATN_IS_NUMBER                       IS NULL                           
      OR TSMWELL.TSMSTATN_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSMWELL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER        
      AND TSMWELL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID             
      )                                       
ORDER BY 1,TSMWELL_ORG_ID                   
; 
Prompt     TSMWLE     ALWAYS    IS_FOR                          TSMWELL  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSMWLE   TSMWLE                            
WHERE                                         
      TSMWLE.TSMWELL_IS_NUMBER                        IS NULL                            
      OR TSMWLE.TSMWELL_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMWELL   TSMWELL                
      WHERE TSMWLE.TSMWELL_IS_NUMBER               = TSMWELL.TSMWELL_IS_NUMBER           
      AND TSMWLE.TSMWELL_ORG_ID                  = TSMWELL.TSMWELL_ORG_ID                
      )                                       
ORDER BY 1,TSMWELL_ORG_ID                   
; 
Prompt     TSRAAL     ALWAYS    IS_CONDUCTED_AT                 TSMALP  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRAAL   TSRAAL                            
WHERE
--	TSRAAL.TSMALP_ORG_ID <>  DEMOTEST  AND
      (TSRAAL.TSMALP_IS_NUMBER                         IS NULL                            
      OR TSRAAL.TSMALP_ORG_ID                            IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMALP   TSMALP                  
      WHERE TSRAAL.TSMALP_IS_NUMBER                = TSMALP.TSMALP_IS_NUMBER             
      AND TSRAAL.TSMALP_ORG_ID                   = TSMALP.TSMALP_ORG_ID                  
      ))                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRAAL     ALWAYS    PLACES                          TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRAAL   TSRAAL                            
WHERE                                         
      TSRAAL.TSRFDACT_IS_NUMBER                       IS NULL                            
      OR TSRAAL.TSRFDACT_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRAAL.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER         
      AND TSRAAL.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID              
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRADL     ALWAYS    COLLECTS_DATA_AT                TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRADL   TSRADL                            
WHERE                                         
      TSRADL.TSMSTATN_IS_NUMBER                       IS NULL                            
      OR TSRADL.TSMSTATN_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSRADL.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER         
      AND TSRADL.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID              
      )                                       
ORDER BY 1,TSRADL_ORG_ID                   
; 
Prompt     TSRANLPR   SOMETIMES HAS_AS_ITS_NATIONAL_MODEL       TSRANLPR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRANLPR   TSRANLPR                        
WHERE                                         
      TSRANLPR.TSRANLPR0IS_NUMBER                       IS NOT NULL                      
      AND TSRANLPR.TSRANLPR0ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRANLPR   IN_TSRANLPR           
      WHERE TSRANLPR.TSRANLPR0IS_NUMBER              = IN_TSRANLPR.TSRANLPR_IS_NUMBER    
      AND TSRANLPR.TSRANLPR0ORG_ID                 = IN_TSRANLPR.TSRANLPR_ORG_ID         
      )                                       
ORDER BY 1,TSRANLPR_ORG_ID                   
; 
Prompt     TSRANLPR   SOMETIMES IS_DESCRIBED_IN                 TSRCITN  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRANLPR   TSRANLPR                        
WHERE                                         
      TSRANLPR.TSRCITN_IS_NUMBER                        IS NOT NULL                      
      AND TSRANLPR.TSRCITN_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                
      WHERE TSRANLPR.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER         
      AND TSRANLPR.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID              
      )                                       
ORDER BY 1,TSRANLPR_ORG_ID                   
; 
Prompt     TSRANLPR   SOMETIMES USES                            TSRANLEQ  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRANLPR   TSRANLPR                        
WHERE                                         
      TSRANLPR.TSRANLEQ_IS_NUMBER                       IS NOT NULL                      
      AND TSRANLPR.TSRANLEQ_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRANLEQ   TSRANLEQ              
      WHERE TSRANLPR.TSRANLEQ_IS_NUMBER              = TSRANLEQ.TSRANLEQ_IS_NUMBER       
      AND TSRANLPR.TSRANLEQ_ORG_ID                 = TSRANLEQ.TSRANLEQ_ORG_ID            
      )                                       
ORDER BY 1,TSRANLPR_ORG_ID                   
; 
Prompt     TSRBRG     SOMETIMES HAS_RESULT_TAXON_OF             TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRBRG   TSRBRG                            
WHERE                                         
      TSRBRG.TSRCHAR_IS_NUMBER                        IS NOT NULL                        
      AND TSRBRG.TSRCHAR_ORG_ID                           IS NOT NULL                    
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRBRG.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER           
      AND TSRBRG.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID                
      )                                       
ORDER BY 1,TSRBRG_ORG_ID                   
; 
Prompt     TSRBRG     ALWAYS    IS_FOR                          TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRBRG   TSRBRG                            
WHERE                                         
      TSRBRG.TSRFDACT_IS_NUMBER                       IS NULL                            
      OR TSRBRG.TSRFDACT_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRBRG.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER         
      AND TSRBRG.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID              
      )                                       
ORDER BY 1,TSRBRG_ORG_ID                   
; 
Prompt     TSRBRGI    ALWAYS    IS_PART_OF                      TSRBRG  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRBRGI   TSRBRGI                          
WHERE                                         
      TSRBRGI.TSRBRG_IS_NUMBER                         IS NULL                           
      OR TSRBRGI.TSRBRG_ORG_ID                            IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRBRG   TSRBRG                  
      WHERE TSRBRGI.TSRBRG_IS_NUMBER                = TSRBRG.TSRBRG_IS_NUMBER            
      AND TSRBRGI.TSRBRG_ORG_ID                   = TSRBRG.TSRBRG_ORG_ID                 
      )                                       
ORDER BY 1,TSRBRGI_ORG_ID                   
; 
Prompt     TSRCCGA    ALWAYS    INCORPORATES_A_CHARACTERISTIC_TOTSRCHGRP  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRCCGA   TSRCCGA                          
WHERE                                         
      TSRCCGA.TSRCHGRP_IS_NUMBER                       IS NULL                           
      OR TSRCCGA.TSRCHGRP_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCHGRP   TSRCHGRP              
      WHERE TSRCCGA.TSRCHGRP_IS_NUMBER              = TSRCHGRP.TSRCHGRP_IS_NUMBER        
      AND TSRCCGA.TSRCHGRP_ORG_ID                 = TSRCHGRP.TSRCHGRP_ORG_ID             
      )                                       
ORDER BY 1,TSRCCGA_ORG_ID                   
; 
Prompt     TSRCCGA    ALWAYS    PLACES_IN_A_GROUP               TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCCGA   TSRCCGA                          
WHERE                                         
      TSRCCGA.TSRCHAR_IS_NUMBER                        IS NULL                           
      OR TSRCCGA.TSRCHAR_ORG_ID                           IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRCCGA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER          
      AND TSRCCGA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID               
      )                                       
ORDER BY 1,TSRCCGA_ORG_ID                   
; 
Prompt     TSRCHALS   ALWAYS    ALTERNATIVELY_NAMES             TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   STORET.TSRCHALS   TSRCHALS                        
WHERE                                         
      TSRCHALS.TSRCHAR_IS_NUMBER                        IS NULL                          
      OR TSRCHALS.TSRCHAR_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRCHALS.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRCHALS.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )                                       
ORDER BY 1,TSRCHAR_ORG_ID                   
; 
Prompt     TSRCHDEF   ALWAYS    DESCRIBES                       TSRCCGA  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSRCCGA_ORG_ID                           IS NULL                          
      OR TSRCHDEF.TSRCCGA_IS_NUMBER                        IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCCGA   TSRCCGA                
      WHERE TSRCHDEF.TSRCCGA_ORG_ID                  = TSRCCGA.TSRCCGA_ORG_ID            
      AND TSRCHDEF.TSRCCGA_IS_NUMBER               = TSRCCGA.TSRCCGA_IS_NUMBER           
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
Prompt     TSRCHDEF   SOMETIMES IS_DESCRIBED_BY                 TSRANLPR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSRANLPR_IS_NUMBER                       IS NOT NULL                      
      AND TSRCHDEF.TSRANLPR_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRANLPR   TSRANLPR              
      WHERE TSRCHDEF.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER       
      AND TSRCHDEF.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID            
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
Prompt     TSRCHDEF   SOMETIMES IS_DESCRIBED_BY                 TSRLSPP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSRLSPP_IS_NUMBER                        IS NOT NULL                      
      AND TSRCHDEF.TSRLSPP_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLSPP   TSRLSPP                
      WHERE TSRCHDEF.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER         
      AND TSRCHDEF.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID              
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
Prompt     TSRCHGRP   SOMETIMES IS_DEFINED_IN                   TSRCITN  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCHGRP   TSRCHGRP                        
WHERE                                         
      TSRCHGRP.TSRCITN_IS_NUMBER                        IS NOT NULL                      
      AND TSRCHGRP.TSRCITN_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                
      WHERE TSRCHGRP.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER         
      AND TSRCHGRP.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID              
      )                                       
ORDER BY 1,TSRCHGRP_ORG_ID                   
; 
Prompt     TSRCHGRP   ALWAYS    IS_ESTABLISHED_AND_CONTROLLED_BYTSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRCHGRP   TSRCHGRP                        
WHERE                                         
      TSRCHGRP.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRCHGRP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSRCHGRP_ORG_ID                   
; 
Prompt     TSRCITN    ALWAYS    IS_REFERENCED_BY                TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRCITN   TSRCITN                          
WHERE                                         
      TSRCITN.TSMORGAN_IS_NUMBER                       IS NULL                           
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRCITN.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )                                       
ORDER BY 1,TSRCITN_ORG_ID                   
; 
Prompt     TSRCLDES   ALWAYS    DESCRIBES_CELL_FORMS_FOR        TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRCLDES   TSRCLDES                        
WHERE                                         
      TSRCLDES.TSRRSULT_IS_NUMBER                       IS NULL                          
      OR TSRCLDES.TSRRSULT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSRCLDES.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER       
      AND TSRCLDES.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID            
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRCPA     ALWAYS    ASSIGNS                         TSRCITN  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCPA   TSRCPA                            
WHERE                                         
      TSRCPA.TSRCITN_IS_NUMBER                        IS NULL                            
      OR TSRCPA.TSRCITN_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                
      WHERE TSRCPA.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER           
      AND TSRCPA.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID                
      )                                       
ORDER BY 1,TSRCITN_ORG_ID                   
; 
Prompt     TSRCPA     ALWAYS    CORRESPONDS_TO                  TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRCPA   TSRCPA                            
WHERE                                         
      TSRCPA.TSMPROJ_IS_NUMBER                        IS NULL                            
      OR TSRCPA.TSMPROJ_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSRCPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSRCPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSRCPV     ALWAYS    SERVES_AS_THE_RESULT_FOR        TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   STORET.TSRCPV   TSRCPV                            
WHERE                                         
      TSRCPV.TSRCHAR_IS_NUMBER                        IS NULL                            
      OR TSRCPV.TSRCHAR_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRCPV.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER           
      AND TSRCPV.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID                
      )                                       
ORDER BY 1,TSRCPV_ORG_ID                   
; 
Prompt     TSRCTCA    ALWAYS    ASSIGNS                         TSRCHTYP  AS  RELATIONSHIP      
--
SELECT
*
FROM   STORET.TSRCTCA   TSRCTCA                          
WHERE                                         
      TSRCTCA.TSRCHTYP_CATEGORY                        IS NULL                           
      OR TSRCTCA.TSRCHTYP_SUBCATGRY                       IS NULL                        
      OR TSRCTCA.TSRCHTYP_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHTYP   TSRCHTYP              
      WHERE TSRCTCA.TSRCHTYP_CATEGORY               = TSRCHTYP.TSRCHTYP_CATEGORY         
      AND TSRCTCA.TSRCHTYP_SUBCATGRY              = TSRCHTYP.TSRCHTYP_SUBCATGRY          
      AND TSRCTCA.TSRCHTYP_ORG_ID                 = TSRCHTYP.TSRCHTYP_ORG_ID             
      )                                       
ORDER BY 1,TSRCHTYP_ORG_ID                   
; 
Prompt     TSRCTCA    ALWAYS    IS_ASSIGNED_TO                  TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   STORET.TSRCTCA   TSRCTCA                          
WHERE                                         
      TSRCTCA.TSRCHAR_IS_NUMBER                        IS NULL                           
      OR TSRCTCA.TSRCHAR_ORG_ID                           IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRCTCA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER          
      AND TSRCTCA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID               
      )                                       
ORDER BY 1,TSRCHAR_ORG_ID                   
; 
Prompt     TSRDQL     ALWAYS    HAS                             TSRUOM  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRDQL   TSRDQL                            
WHERE                                         
      TSRDQL.TSRUOM_IS_NUMBER                         IS NULL                            
      OR TSRDQL.TSRUOM_ORG_ID                            IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRUOM   TSRUOM                  
      WHERE TSRDQL.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER             
      AND TSRDQL.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                  
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRDQL     ALWAYS    QUALIFIES                       TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRDQL   TSRDQL                            
WHERE                                         
      TSRDQL.TSRRSULT_IS_NUMBER                       IS NULL                            
      OR TSRDQL.TSRRSULT_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSRDQL.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER         
      AND TSRDQL.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSREOD     ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSREOD   TSREOD                            
WHERE                                         
      TSREOD.TSRFDACT_ORG_ID                          IS NULL                            
      OR TSREOD.TSRFDACT_IS_NUMBER                       IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSMPLE   TSRSMPLE              
      WHERE TSREOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID            
      AND TSREOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER           
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRFAFSA   ALWAYS    BELONGS_TO                      TSRFDSET  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAFSA   TSRFAFSA                        
WHERE                                         
      TSRFAFSA.TSRFDSET_IS_NUMBER                       IS NULL                          
      OR TSRFAFSA.TSRFDSET_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDSET   TSRFDSET              
      WHERE TSRFAFSA.TSRFDSET_IS_NUMBER              = TSRFDSET.TSRFDSET_IS_NUMBER       
      AND TSRFAFSA.TSRFDSET_ORG_ID                 = TSRFDSET.TSRFDSET_ORG_ID            
      )                                       
ORDER BY 1,TSRFDSET_ORG_ID                   
; 
Prompt     TSRFAFSA   ALWAYS    HAS                             TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAFSA   TSRFAFSA                        
WHERE                                         
      TSRFAFSA.TSRFDACT_IS_NUMBER                       IS NULL                          
      OR TSRFAFSA.TSRFDACT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRFAFSA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRFAFSA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRFAPEA   ALWAYS    COLLECTS                        TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAPEA   TSRFAPEA                        
WHERE                                         
      TSRFAPEA.TSRFDACT_IS_NUMBER                       IS NULL                          
      OR TSRFAPEA.TSRFDACT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRFAPEA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRFAPEA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRFAPEA   ALWAYS    IS_COLLECTED_BY                 TSMPERSN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAPEA   TSRFAPEA                        
WHERE                                         
      TSRFAPEA.TSMPERSN_IS_NUMBER                       IS NULL                          
      OR TSRFAPEA.TSMPERSN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPERSN   TSMPERSN              
      WHERE TSRFAPEA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER       
      AND TSRFAPEA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID            
      )                                       
ORDER BY 1,TSMPERSN_ORG_ID                   
; 
Prompt     TSRFAPRA   ALWAYS    IS_FOR                          TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRFAPRA   TSRFAPRA                        
WHERE                                         
      TSRFAPRA.TSMPROJ_IS_NUMBER                        IS NULL                          
      OR TSRFAPRA.TSMPROJ_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSRFAPRA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER         
      AND TSRFAPRA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID              
      )                                       
ORDER BY 1,TSMPROJ_ORG_ID                   
; 
Prompt     TSRFAPRA   ALWAYS    IS_FOR                          TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAPRA   TSRFAPRA                        
WHERE                                         
      TSRFAPRA.TSRFDACT_IS_NUMBER                       IS NULL                          
      OR TSRFAPRA.TSRFDACT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRFAPRA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRFAPRA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRFAQSA   ALWAYS    HAS_CHECK_PROVIDED_BY           TSRFQS  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFAQSA   TSRFAQSA                        
WHERE                                         
      TSRFAQSA.TSRFQS_IS_NUMBER                         IS NULL                          
      OR TSRFAQSA.TSRFQS_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFQS   TSRFQS                  
      WHERE TSRFAQSA.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER           
      AND TSRFAQSA.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID                
      )                                       
ORDER BY 1,TSRFQS_ORG_ID                   
; 
Prompt     TSRFAQSA   ALWAYS    VALIDATES                       TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFAQSA   TSRFAQSA                        
WHERE                                         
      TSRFAQSA.TSRFDACT_IS_NUMBER                       IS NULL                          
      OR TSRFAQSA.TSRFDACT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRFAQSA.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRFAQSA.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRFDACT   SOMETIMES COMPOSITES_INTO                 TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRFDACT0IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRFDACT0ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   IN_TSRFDACT           
      WHERE TSRFDACT.TSRFDACT0IS_NUMBER              = IN_TSRFDACT.TSRFDACT_IS_NUMBER    
      AND TSRFDACT.TSRFDACT0ORG_ID                 = IN_TSRFDACT.TSRFDACT_ORG_ID         
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES HAS_AS_ITS_SUBJECT              TSRBIOPT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRBIOPT_IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRBIOPT_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRBIOPT   TSRBIOPT              
      WHERE TSRFDACT.TSRBIOPT_IS_NUMBER              = TSRBIOPT.TSRBIOPT_IS_NUMBER       
      AND TSRFDACT.TSRBIOPT_ORG_ID                 = TSRBIOPT.TSRBIOPT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES HAS_A_SUBJECT_TAXON_OF          TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRCHAR_IS_NUMBER                        IS NOT NULL                      
      AND TSRFDACT.TSRCHAR_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRFDACT.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRFDACT.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES IS_FURNISHED_BY                 TSRGRCFG  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRGRCFG_IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRGRCFG_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRGRCFG   TSRGRCFG              
      WHERE TSRFDACT.TSRGRCFG_IS_NUMBER              = TSRGRCFG.TSRGRCFG_IS_NUMBER       
      AND TSRFDACT.TSRGRCFG_ORG_ID                 = TSRGRCFG.TSRGRCFG_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES IS_FURNISHED_BY                 TSRFLDGR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRFLDGR_IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRFLDGR_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRFLDGR   TSRFLDGR              
      WHERE TSRFDACT.TSRFLDGR_IS_NUMBER              = TSRFLDGR.TSRFLDGR_IS_NUMBER       
      AND TSRFDACT.TSRFLDGR_ORG_ID                 = TSRFLDGR.TSRFLDGR_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES IS_GATHERED_BY                  TSRFLDPR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRFLDPR_IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRFLDPR_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFLDPR   TSRFLDPR              
      WHERE TSRFDACT.TSRFLDPR_IS_NUMBER              = TSRFLDPR.TSRFLDPR_IS_NUMBER       
      AND TSRFDACT.TSRFLDPR_ORG_ID                 = TSRFLDPR.TSRFLDPR_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES IS_SPLIT_FROM                   TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRFDACT1IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRFDACT1ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   IN_TSRFDACT           
      WHERE TSRFDACT.TSRFDACT1IS_NUMBER              = IN_TSRFDACT.TSRFDACT_IS_NUMBER    
      AND TSRFDACT.TSRFDACT1ORG_ID                 = IN_TSRFDACT.TSRFDACT_ORG_ID         
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES OCCURS_DURING                   TSRSTVST  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRSTVST_IS_NUMBER                       IS NOT NULL                      
      AND TSRFDACT.TSRSTVST_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSTVST   TSRSTVST              
      WHERE TSRFDACT.TSRSTVST_IS_NUMBER              = TSRSTVST.TSRSTVST_IS_NUMBER       
      AND TSRFDACT.TSRSTVST_ORG_ID                 = TSRSTVST.TSRSTVST_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDACT   SOMETIMES OCCURS_WITHIN                   TSROPPRD  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSROPPRD_ORG_ID                          IS NOT NULL                      
      AND TSRFDACT.TSROPPRD_IS_NUMBER                       IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSROPPRD   TSROPPRD              
      WHERE TSRFDACT.TSROPPRD_ORG_ID                 = TSROPPRD.TSROPPRD_ORG_ID          
      AND TSRFDACT.TSROPPRD_IS_NUMBER              = TSROPPRD.TSROPPRD_IS_NUMBER         
      )                                       
ORDER BY 1,TSRFDACT_org_id                   
; 
Prompt     TSRFDSET   ALWAYS    IS_DEFINED_BY                   TSRSTVST  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFDSET   TSRFDSET                        
WHERE                                         
      TSRFDSET.TSRSTVST_IS_NUMBER                       IS NULL                          
      OR TSRFDSET.TSRSTVST_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSTVST   TSRSTVST              
      WHERE TSRFDSET.TSRSTVST_IS_NUMBER              = TSRSTVST.TSRSTVST_IS_NUMBER       
      AND TSRFDSET.TSRSTVST_ORG_ID                 = TSRSTVST.TSRSTVST_ORG_ID            
      )                                       
ORDER BY 1,TSRFDSET_ORG_ID                   
; 
Prompt     TSRFLDPR   ALWAYS    IS_DEFINED_BY                   TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFLDPR   TSRFLDPR                        
WHERE                                         
      TSRFLDPR.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRFLDPR.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSRFLDPR_ORG_ID                   
; 
Prompt     TSRFLDPR   SOMETIMES IS_DEFINED_IN                   TSRCITN  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRFLDPR   TSRFLDPR                        
WHERE                                         
      TSRFLDPR.TSRCITN_IS_NUMBER                        IS NOT NULL                      
      AND TSRFLDPR.TSRCITN_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                
      WHERE TSRFLDPR.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER         
      AND TSRFLDPR.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID              
      )                                       
ORDER BY 1,TSRFLDPR_ORG_ID                   
; 
Prompt     TSRFQS     ALWAYS    IS_CREATED_FOR                  TSRTRIP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRFQS   TSRFQS                            
WHERE                                         
      TSRFQS.TSRTRIP_IS_NUMBER                        IS NULL                            
      OR TSRFQS.TSRTRIP_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRTRIP   TSRTRIP                
      WHERE TSRFQS.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER           
      AND TSRFQS.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID                
      )                                       
ORDER BY 1,TSRFQS_ORG_ID                   
; 
Prompt     TSRFQSDP   ALWAYS    IS_OWNED_BY                     TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFQSDP   TSRFQSDP                        
WHERE                                         
      TSRFQSDP.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRFQSDP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSRFQSDP_ORG_ID                   
; 
Prompt     TSRFQSPA   ALWAYS    IS_FOR                          TSMPERSN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRFQSPA   TSRFQSPA                        
WHERE                                         
      TSRFQSPA.TSMPERSN_IS_NUMBER                       IS NULL                          
      OR TSRFQSPA.TSMPERSN_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPERSN   TSMPERSN              
      WHERE TSRFQSPA.TSMPERSN_IS_NUMBER              = TSMPERSN.TSMPERSN_IS_NUMBER       
      AND TSRFQSPA.TSMPERSN_ORG_ID                 = TSMPERSN.TSMPERSN_ORG_ID            
      )                                       
ORDER BY 1,TSMPERSN_ORG_ID                   
; 
Prompt     TSRFQSPA   ALWAYS    IS_FOR                          TSRFQS  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFQSPA   TSRFQSPA                        
WHERE                                         
      TSRFQSPA.TSRFQS_IS_NUMBER                         IS NULL                          
      OR TSRFQSPA.TSRFQS_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFQS   TSRFQS                  
      WHERE TSRFQSPA.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER           
      AND TSRFQSPA.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID                
      )                                       
ORDER BY 1,TSRFQS_ORG_ID                   
; 
Prompt     TSRGRCFG   ALWAYS    DESCRIBES                       TSRFLDGR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRGRCFG   TSRGRCFG                        
WHERE                                         
      TSRGRCFG.TSRFLDGR_IS_NUMBER                       IS NULL                          
      OR TSRGRCFG.TSRFLDGR_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRFLDGR   TSRFLDGR              
      WHERE TSRGRCFG.TSRFLDGR_IS_NUMBER              = TSRFLDGR.TSRFLDGR_IS_NUMBER       
      AND TSRGRCFG.TSRFLDGR_ORG_ID                 = TSRFLDGR.TSRFLDGR_ORG_ID            
      )                                       
ORDER BY 1,TSRGRCFG_ORG_ID                   
; 
Prompt     TSRGRCFG   ALWAYS    IS_DEFINED_BY                   TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRGRCFG   TSRGRCFG                        
WHERE                                         
      TSRGRCFG.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRGRCFG.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1,TSRGRCFG_ORG_ID                   
; 
Prompt     TSRHCSC    ALWAYS    EVALUATES                       TSRCHGRP  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRHCSC   TSRHCSC                          
WHERE                                         
      TSRHCSC.TSRCHGRP_IS_NUMBER                       IS NULL                           
      OR TSRHCSC.TSRCHGRP_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCHGRP   TSRCHGRP              
      WHERE TSRHCSC.TSRCHGRP_IS_NUMBER              = TSRCHGRP.TSRCHGRP_IS_NUMBER        
      AND TSRHCSC.TSRCHGRP_ORG_ID                 = TSRCHGRP.TSRCHGRP_ORG_ID             
      )                                       
ORDER BY 1,TSRHCSC_ORG_ID                   
; 
Prompt     TSRLAB     ALWAYS    IS_IDENTIFIED_BY                TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRLAB   TSRLAB                            
WHERE                                         
      TSRLAB.TSMORGAN_IS_NUMBER                       IS NULL                            
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRLAB.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER         
      )                                       
ORDER BY 1,TSRLAB_ORG_ID                   
; 
Prompt     TSRLSPP    SOMETIMES IS_DESCRIBED_BY                 TSRCITN  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRLSPP   TSRLSPP                          
WHERE                                         
      TSRLSPP.TSRCITN_IS_NUMBER                        IS NOT NULL                       
      AND TSRLSPP.TSRCITN_ORG_ID                           IS NOT NULL                   
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                
      WHERE TSRLSPP.TSRCITN_IS_NUMBER               = TSRCITN.TSRCITN_IS_NUMBER          
      AND TSRLSPP.TSRCITN_ORG_ID                  = TSRCITN.TSRCITN_ORG_ID               
      )                                       
ORDER BY 1,TSRLSPP_ORG_ID                   
; 
Prompt     TSROAPA    ALWAYS    ASSIGNS                         TSRANLPR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSROAPA   TSROAPA                          
WHERE                                         
      TSROAPA.TSRANLPR_IS_NUMBER                       IS NULL                           
      OR TSROAPA.TSRANLPR_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRANLPR   TSRANLPR              
      WHERE TSROAPA.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER        
      AND TSROAPA.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID             
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROAPA    ALWAYS    IS_ASSIGNED_TO                  TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSROAPA   TSROAPA                          
WHERE                                         
      TSROAPA.TSMORGAN_IS_NUMBER                       IS NULL                           
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSROAPA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROAPCA   ALWAYS    ACCEPTS                         TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSROAPCA   TSROAPCA                        
WHERE                                         
      TSROAPCA.TSRCHAR_IS_NUMBER                        IS NULL                          
      OR TSROAPCA.TSRCHAR_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSROAPCA.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSROAPCA.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROAPCA   ALWAYS    IS_ACCEPTED_FOR                 TSROAPA  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSROAPCA   TSROAPCA                        
WHERE                                         
      TSROAPCA.TSRANLPR_ORG_ID                          IS NULL                          
      OR TSROAPCA.TSRANLPR_IS_NUMBER                       IS NULL                       
      OR TSROAPCA.TSMORGAN_IS_NUMBER                       IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSROAPA   TSROAPA                
      WHERE TSROAPCA.TSRANLPR_ORG_ID                 = TSROAPA.TSRANLPR_ORG_ID           
      AND TSROAPCA.TSRANLPR_IS_NUMBER              = TSROAPA.TSRANLPR_IS_NUMBER          
      AND TSROAPCA.TSMORGAN_IS_NUMBER              = TSROAPA.TSMORGAN_IS_NUMBER          
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROLSPA   ALWAYS    ASSIGNS                         TSRLSPP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSROLSPA   TSROLSPA                        
WHERE                                         
      TSROLSPA.TSRLSPP_IS_NUMBER                        IS NULL                          
      OR TSROLSPA.TSRLSPP_ORG_ID                           IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLSPP   TSRLSPP                
      WHERE TSROLSPA.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER         
      AND TSROLSPA.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID              
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROLSPA   ALWAYS    IS_ASSIGNED_TO                  TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSROLSPA   TSROLSPA                        
WHERE                                         
      TSROLSPA.TSMORGAN_IS_NUMBER                       IS NULL                          
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSROLSPA.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER       
      )                                       
ORDER BY 1, 'ISN= '||TSMORGAN_IS_NUMBER                   
; 
Prompt     TSROPPRD   ALWAYS    IS_MONITORED_BY                 TSRADL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSROPPRD   TSROPPRD                        
WHERE                                         
      TSROPPRD.TSRADL_IS_NUMBER                         IS NULL                          
      OR TSROPPRD.TSRADL_ORG_ID                            IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRADL   TSRADL                  
      WHERE TSROPPRD.TSRADL_IS_NUMBER                = TSRADL.TSRADL_IS_NUMBER           
      AND TSROPPRD.TSRADL_ORG_ID                   = TSRADL.TSRADL_ORG_ID                
      )                                       
ORDER BY 1,TSROPPRD_ORG_ID                   
; 
Prompt     TSRPOPA    ALWAYS    LINKS_AN_OPERATING_PERIOD_TO    TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRPOPA   TSRPOPA                          
WHERE                                         
      TSRPOPA.TSMPROJ_IS_NUMBER                        IS NULL                           
      OR TSRPOPA.TSMPROJ_ORG_ID                           IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSRPOPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER          
      AND TSRPOPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID               
      )                                       
ORDER BY 1,TSROPPRD_ORG_ID                   
; 
Prompt     TSRPOPA    ALWAYS    LINKS_A_PROJECT_TO              TSROPPRD  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRPOPA   TSRPOPA                          
WHERE                                         
      TSRPOPA.TSROPPRD_ORG_ID                          IS NULL                           
      OR TSRPOPA.TSROPPRD_IS_NUMBER                       IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSROPPRD   TSROPPRD              
      WHERE TSRPOPA.TSROPPRD_ORG_ID                 = TSROPPRD.TSROPPRD_ORG_ID           
      AND TSRPOPA.TSROPPRD_IS_NUMBER              = TSROPPRD.TSROPPRD_IS_NUMBER          
      )                                       
ORDER BY 1,TSROPPRD_ORG_ID                   
; 
Prompt     TSRRCI     ALWAYS    INCLUDES                        TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRCI   TSRRCI                            
WHERE                                         
      TSRRCI.TSRRSULT_IS_NUMBER                       IS NULL                            
      OR TSRRCI.TSRRSULT_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSRRCI.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER         
      AND TSRRCI.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRCI     ALWAYS    IS_MEASURED_BY                  TSRUOM  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRCI   TSRRCI                            
WHERE                                         
      TSRRCI.TSRUOM_IS_NUMBER                         IS NULL                            
      OR TSRRCI.TSRUOM_ORG_ID                            IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRUOM   TSRUOM                  
      WHERE TSRRCI.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER             
      AND TSRRCI.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                  
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRLRA    ALWAYS    QUALIFIES                       TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRLRA   TSRRLRA                          
WHERE                                         
      TSRRLRA.TSRRSULT_IS_NUMBER                       IS NULL                           
      OR TSRRLRA.TSRRSULT_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSRRLRA.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER        
      AND TSRRLRA.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID             
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRLRA    ALWAYS    QUALIFIES_A_RESULT_WITH         TSRLBRMK  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRLRA   TSRRLRA                          
WHERE                                         
      TSRRLRA.TSRLBRMK_IS_NUMBER                       IS NULL                           
      OR TSRRLRA.TSRLBRMK_ORG_ID                          IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   STORET.TSRLBRMK   TSRLBRMK              
      WHERE TSRRLRA.TSRLBRMK_IS_NUMBER              = TSRLBRMK.TSRLBRMK_IS_NUMBER        
      AND TSRRLRA.TSRLBRMK_ORG_ID                 = TSRLBRMK.TSRLBRMK_ORG_ID             
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRQCAF   SOMETIMES IS_QUALIFIED_BY                 TSRUOM  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRQCAF   TSRRQCAF                        
WHERE                                         
      TSRRQCAF.TSRUOM_IS_NUMBER                         IS NOT NULL                      
      AND TSRRQCAF.TSRUOM_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRUOM   TSRUOM                  
      WHERE TSRRQCAF.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER           
      AND TSRRQCAF.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                
      )                                       
ORDER BY 1,TSRRQCAF_ORG_ID                   
; 
Prompt     TSRRQCAF   ALWAYS    QUALIFIES                       TSRRSULT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRQCAF   TSRRQCAF                        
WHERE                                         
      TSRRQCAF.TSRRSULT_IS_NUMBER                       IS NULL                          
      OR TSRRQCAF.TSRRSULT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT              
      WHERE TSRRQCAF.TSRRSULT_IS_NUMBER              = TSRRSULT.TSRRSULT_IS_NUMBER       
      AND TSRRQCAF.TSRRSULT_ORG_ID                 = TSRRSULT.TSRRSULT_ORG_ID            
      )                                       
ORDER BY 1,TSRRQCAF_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES DESCRIBES                       TSRBRGI  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRBRGI_IS_NUMBER                        IS NOT NULL                      
      AND TSRRSULT.TSRBRGI_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRBRGI   TSRBRGI                
      WHERE TSRRSULT.TSRBRGI_IS_NUMBER               = TSRBRGI.TSRBRGI_IS_NUMBER         
      AND TSRRSULT.TSRBRGI_ORG_ID                  = TSRBRGI.TSRBRGI_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_CONTAINED_IN                 TSRBRG  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRBRG_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSRBRG_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRBRG   TSRBRG                  
      WHERE TSRRSULT.TSRBRG_IS_NUMBER                = TSRBRG.TSRBRG_IS_NUMBER           
      AND TSRRSULT.TSRBRG_ORG_ID                   = TSRBRG.TSRBRG_ORG_ID                
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_CREATED_BY                   TSRANLPR  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRANLPR_IS_NUMBER                       IS NOT NULL                      
      AND TSRRSULT.TSRANLPR_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRANLPR   TSRANLPR              
      WHERE TSRRSULT.TSRANLPR_IS_NUMBER              = TSRANLPR.TSRANLPR_IS_NUMBER       
      AND TSRRSULT.TSRANLPR_ORG_ID                 = TSRANLPR.TSRANLPR_ORG_ID            
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_DESCRIBED_BY                 TSRUOM  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRUOM_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSRUOM_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRUOM   TSRUOM                  
      WHERE TSRRSULT.TSRUOM_IS_NUMBER                = TSRUOM.TSRUOM_IS_NUMBER           
      AND TSRRSULT.TSRUOM_ORG_ID                   = TSRUOM.TSRUOM_ORG_ID                
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_FOR                          TSRFQS  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRFQS_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSRFQS_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFQS   TSRFQS                  
      WHERE TSRRSULT.TSRFQS_IS_NUMBER                = TSRFQS.TSRFQS_IS_NUMBER           
      AND TSRRSULT.TSRFQS_ORG_ID                   = TSRFQS.TSRFQS_ORG_ID                
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_FOR                          TSRHCSC  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRHCSC_IS_NUMBER                        IS NOT NULL                      
      AND TSRRSULT.TSRHCSC_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRHCSC   TSRHCSC                
      WHERE TSRRSULT.TSRHCSC_IS_NUMBER               = TSRHCSC.TSRHCSC_IS_NUMBER         
      AND TSRRSULT.TSRHCSC_ORG_ID                  = TSRHCSC.TSRHCSC_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_MADE_BY                      TSRLSPP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRLSPP_IS_NUMBER                        IS NOT NULL                      
      AND TSRRSULT.TSRLSPP_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLSPP   TSRLSPP                
      WHERE TSRRSULT.TSRLSPP_IS_NUMBER               = TSRLSPP.TSRLSPP_IS_NUMBER         
      AND TSRRSULT.TSRLSPP_ORG_ID                  = TSRLSPP.TSRLSPP_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_PRODUCED_IN                  TSRLAB  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRLAB_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSRLAB_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRLAB   TSRLAB                  
      WHERE TSRRSULT.TSRLAB_IS_NUMBER                = TSRLAB.TSRLAB_IS_NUMBER           
      AND TSRRSULT.TSRLAB_ORG_ID                   = TSRLAB.TSRLAB_ORG_ID                
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_QUALIFIED_BY                 TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRCHAR_IS_NUMBER                        IS NOT NULL                      
      AND TSRRSULT.TSRCHAR_ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRRSULT.TSRCHAR_IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRRSULT.TSRCHAR_ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_SECONDARILY_QUALIFIED_BY     TSRCHAR  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRCHAR0IS_NUMBER                        IS NOT NULL                      
      AND TSRRSULT.TSRCHAR0ORG_ID                           IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   STORET.TSRCHAR   TSRCHAR                
      WHERE TSRRSULT.TSRCHAR0IS_NUMBER               = TSRCHAR.TSRCHAR_IS_NUMBER         
      AND TSRRSULT.TSRCHAR0ORG_ID                  = TSRCHAR.TSRCHAR_ORG_ID              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRRSULT   SOMETIMES IS_YIELDED_FROM                 TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRFDACT_IS_NUMBER                       IS NOT NULL                      
      AND TSRRSULT.TSRFDACT_ORG_ID                          IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRRSULT.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRRSULT.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
Prompt     TSRSDP     ALWAYS    IS_OWNED_BY                     TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRSDP   TSRSDP                            
WHERE                                         
      TSRSDP.TSMORGAN_IS_NUMBER                       IS NULL                            
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRSDP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER         
      )                                       
ORDER BY 1,TSRSDP_ORG_ID                   
; 
Prompt     TSRSMPLE   ALWAYS    IS_PART_OF                      TSRFDACT  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRSMPLE   TSRSMPLE                        
WHERE                                         
      TSRSMPLE.TSRFDACT_IS_NUMBER                       IS NULL                          
      OR TSRSMPLE.TSRFDACT_ORG_ID                          IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT              
      WHERE TSRSMPLE.TSRFDACT_IS_NUMBER              = TSRFDACT.TSRFDACT_IS_NUMBER       
      AND TSRSMPLE.TSRFDACT_ORG_ID                 = TSRFDACT.TSRFDACT_ORG_ID            
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRSTVST   ALWAYS    IS_FOR                          TSRTSA  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSTVST   TSRSTVST                        
WHERE                                         
      TSRSTVST.TSMSTATN_ORG_ID                          IS NULL                          
      OR TSRSTVST.TSMSTATN_IS_NUMBER                       IS NULL                       
      OR TSRSTVST.TSRTRIP_ORG_ID                           IS NULL                       
      OR TSRSTVST.TSRTRIP_IS_NUMBER                        IS NULL                       
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRTSA   TSRTSA                  
      WHERE TSRSTVST.TSMSTATN_ORG_ID                 = TSRTSA.TSMSTATN_ORG_ID            
      AND TSRSTVST.TSMSTATN_IS_NUMBER              = TSRTSA.TSMSTATN_IS_NUMBER           
      AND TSRSTVST.TSRTRIP_ORG_ID                  = TSRTSA.TSRTRIP_ORG_ID               
      AND TSRSTVST.TSRTRIP_IS_NUMBER               = TSRTSA.TSRTRIP_IS_NUMBER            
      )                                       
ORDER BY 1,TSRSTVST_ORG_ID                   
; 
Prompt     TSRTNOD    ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRTNOD   TSRTNOD                          
WHERE                                         
      TSRTNOD.TSRFDACT_ORG_ID                          IS NULL                           
      OR TSRTNOD.TSRFDACT_IS_NUMBER                       IS NULL                        
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSMPLE   TSRSMPLE              
      WHERE TSRTNOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID           
      AND TSRTNOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER          
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
Prompt     TSRTOD     ALWAYS    PROVIDES_DETAIL_ABOUT           TSRSMPLE  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRTOD   TSRTOD                            
WHERE                                         
      TSRTOD.TSRFDACT_ORG_ID                          IS NULL                            
      OR TSRTOD.TSRFDACT_IS_NUMBER                       IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSMPLE   TSRSMPLE              
      WHERE TSRTOD.TSRFDACT_ORG_ID                 = TSRSMPLE.TSRFDACT_ORG_ID            
      AND TSRTOD.TSRFDACT_IS_NUMBER              = TSRSMPLE.TSRFDACT_IS_NUMBER           
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                           
; 
Prompt     TSRTPA     ALWAYS    IS_FOR                          TSMPROJ  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRTPA   TSRTPA                            
WHERE                                         
      TSRTPA.TSMPROJ_IS_NUMBER                        IS NULL                            
      OR TSRTPA.TSMPROJ_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                
      WHERE TSRTPA.TSMPROJ_IS_NUMBER               = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSRTPA.TSMPROJ_ORG_ID                  = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSRTRIP_ORG_ID                   
; 
Prompt     TSRTPA     ALWAYS    IS_FOR                          TSRTRIP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRTPA   TSRTPA                            
WHERE                                         
      TSRTPA.TSRTRIP_IS_NUMBER                        IS NULL                            
      OR TSRTPA.TSRTRIP_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRTRIP   TSRTRIP                
      WHERE TSRTPA.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER           
      AND TSRTPA.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID                
      )                                       
ORDER BY 1,TSRTRIP_ORG_ID                   
; 
Prompt     TSRTRIP    ALWAYS    SPONSORED_BY                    TSMORGAN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRTRIP   TSRTRIP                          
WHERE                                         
      TSRTRIP.TSMORGAN_IS_NUMBER                       IS NULL                           
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMORGAN   TSMORGAN              
      WHERE TSRTRIP.TSMORGAN_IS_NUMBER              = TSMORGAN.TSMORGAN_IS_NUMBER        
      )                                       
ORDER BY 1,TSRTRIP_ORG_ID                   
; 
Prompt     TSRTSA     ALWAYS    IS_FOR                          TSMSTATN  AS  RELATIONSHIP      
--
SELECT
*
FROM   storet1.TSRTSA   TSRTSA                            
WHERE                                         
      TSRTSA.TSMSTATN_IS_NUMBER                       IS NULL                            
      OR TSRTSA.TSMSTATN_ORG_ID                          IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN              
      WHERE TSRTSA.TSMSTATN_IS_NUMBER              = TSMSTATN.TSMSTATN_IS_NUMBER         
      AND TSRTSA.TSMSTATN_ORG_ID                 = TSMSTATN.TSMSTATN_ORG_ID              
      )                                       
ORDER BY 1,TSRTRIP_ORG_ID                   
; 
Prompt     TSRTSA     ALWAYS    IS_FOR                          TSRTRIP  AS  RELATIONSHIP       
--
SELECT
*
FROM   storet1.TSRTSA   TSRTSA                            
WHERE                                         
      TSRTSA.TSRTRIP_IS_NUMBER                        IS NULL                            
      OR TSRTSA.TSRTRIP_ORG_ID                           IS NULL                         
      OR    NOT EXISTS                        
      (                                       
      SELECT 1                                
      FROM   storet1.TSRTRIP   TSRTRIP                
      WHERE TSRTSA.TSRTRIP_IS_NUMBER               = TSRTRIP.TSRTRIP_IS_NUMBER           
      AND TSRTSA.TSRTRIP_ORG_ID                  = TSRTRIP.TSRTRIP_ORG_ID                
      ) 
ORDER BY 1,TSRTRIP_ORG_ID                   
; 

-- New for V2.0
-- BLOB TABLE
--TSMBLOB --> TSMPROJ
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSMPROJ  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSMPROJ_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSMPROJ_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPROJ   TSMPROJ                  
      WHERE TSMBLOB.TSMPROJ_IS_NUMBER                = TSMPROJ.TSMPROJ_IS_NUMBER           
      AND TSMBLOB.TSMPROJ_ORG_ID                   = TSMPROJ.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--TSMBLOB --> TSRRSULT
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSRRSULT  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSRRSULT_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSRRSULT_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRRSULT   TSRRSULT                  
      WHERE TSMBLOB.TSRRSULT_IS_NUMBER                = TSRRSULT.TSRRSULT_IS_NUMBER           
      AND TSMBLOB.TSRRSULT_ORG_ID                   = TSRRSULT.TSRRSULT_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
--TSMBLOB --> TSRFDACT
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSRFDACT  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSRFDACT_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSRFDACT_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT                  
      WHERE TSMBLOB.TSRFDACT_IS_NUMBER                = TSRFDACT.TSRFDACT_IS_NUMBER           
      AND TSMBLOB.TSRFDACT_ORG_ID                   = TSRFDACT.TSRFDACT_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
--TSMBLOB --> TSRSTVST
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSRSTVST  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSRSTVST_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSRSTVST_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRSTVST   TSRSTVST                  
      WHERE TSMBLOB.TSRSTVST_IS_NUMBER                = TSRSTVST.TSRSTVST_IS_NUMBER           
      AND TSMBLOB.TSRSTVST_ORG_ID                   = TSRSTVST.TSRSTVST_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
--TSMBLOB --> TSMSTATN
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSMSTATN  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSMSTATN_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSMSTATN_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN                  
      WHERE TSMBLOB.TSMSTATN_IS_NUMBER                = TSMSTATN.TSMSTATN_IS_NUMBER           
      AND TSMBLOB.TSMSTATN_ORG_ID                   = TSMSTATN.TSMSTATN_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
--TSMBLOB --> TSRCITN
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSRCITN  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSRCITN_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSRCITN_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRCITN   TSRCITN                  
      WHERE TSMBLOB.TSRCITN_IS_NUMBER                = TSRCITN.TSRCITN_IS_NUMBER           
      AND TSMBLOB.TSRCITN_ORG_ID                   = TSRCITN.TSRCITN_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
--TSMBLOB --> TSROPPRD
Prompt     TSMBLOB   IS SOMETIMES ASSIGNED TO           TSROPPRD  AS  RELATIONSHIP        
--
SELECT
TSMBLOB_IS_NUMBER,TSMBLOB_ORG_ID,
--BLOB_CONTENT,
TABLE_NAME,TSMPROJ_IS_NUMBER,TSMPROJ_ORG_ID,TSRRSULT_IS_NUMBER,TSRRSULT_ORG_ID,TSMSTATN_IS_NUMBER,TSMSTATN_ORG_ID,TSRSTVST_IS_NUMBER,TSRSTVST_ORG_ID,
TSRCITN_IS_NUMBER,TSRCITN_ORG_ID,TSROPPRD_IS_NUMBER,TSROPPRD_ORG_ID,D_USERID_CODE,D_LAST_UPDATE_TS,TSRFDACT_IS_NUMBER,TSRFDACT_ORG_ID
FROM   storet1.TSMBLOB   TSMBLOB                        
WHERE                                         
      TSMBLOB.TSROPPRD_IS_NUMBER                         IS NOT NULL                      
      AND TSMBLOB.TSROPPRD_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSROPPRD   TSROPPRD                  
      WHERE TSMBLOB.TSROPPRD_IS_NUMBER                = TSROPPRD.TSROPPRD_IS_NUMBER           
      AND TSMBLOB.TSROPPRD_ORG_ID                   = TSROPPRD.TSROPPRD_ORG_ID                
      )                                       
ORDER BY 1,TSMBLOB_ORG_ID                   
; 
--
-- AUTOMATED DATA LOGGER
--TSRADL --> TSRMATRX
Prompt     TSRADL   IS DESCRIBED BY           TSRMATRX  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRADL   TSRADL                        
WHERE                                         
      TSRADL.TSRMATRX_IS_NUMBER                         IS NOT NULL                      
      AND TSRADL.TSRMATRX_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSRMATRX   TSRMATRX                  
      WHERE TSRADL.TSRMATRX_IS_NUMBER                = TSRMATRX.TSRMATRX_IS_NUMBER           
      AND TSRADL.TSRMATRX_ORG_ID                   = TSRMATRX.TSRMATRX_ORG_ID                
      )                                       
ORDER BY 1,TSRADL_ORG_ID                   
; 
--CHARACTERISTIC DEFAULT
--TSRCHDEF --> TSMPRMVL (TSMPRMVL_IS_NUMBER)
Prompt     TSRCHDEF Sometimes HAS_SAMPLE_FRACTION_TYPE_OF one PERMITTED_VALUE TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRCHDEF.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRCHDEF.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRCHDEF.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID  
      and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'SMPL_FRAC_TYPE_NM'               
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
--TSRCHDEF --> TSMPRMVL (TSMPRMVL0IS_NUMBER)
Prompt     TSRCHDEF Sometimes HAS_VOLTINISM_OF one PERMITTED_VALUE TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRCHDEF.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRCHDEF.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRCHDEF.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID                
    and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'VOLTINISM' 
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
--TSRCHDEF --> TSMPRMVL (TSMPRMVL1IS_NUMBER)
Prompt     TSRCHDEF Sometimes HAS_HABIT_OF one PERMITTED_VALUE TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRCHDEF   TSRCHDEF                        
WHERE                                         
      TSRCHDEF.TSMPRMVL1IS_NUMBER                         IS NOT NULL                      
      AND TSRCHDEF.TSMPRMVL1ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRCHDEF.TSMPRMVL1IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRCHDEF.TSMPRMVL1ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID                
    and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'HABIT' 
      )                                       
ORDER BY 1,TSRCHDEF_ORG_ID                   
; 
--TSRDLIN
--TSRDLIN --> TSRFDACT
Prompt     TSRDLIN Always IS_PART_OF one TSRFDACT  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRDLIN   TSRDLIN                        
WHERE                                         
      TSRDLIN.TSRFDACT_IS_NUMBER                         IS NOT NULL                      
      AND TSRDLIN.TSRFDACT_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT                  
      WHERE TSRDLIN.TSRFDACT_IS_NUMBER                = TSRFDACT.TSRFDACT_IS_NUMBER           
      AND TSRDLIN.TSRFDACT_ORG_ID                   = TSRFDACT.TSRFDACT_ORG_ID                
      )                                       
ORDER BY 1,TSRDLIN_ORG_ID                   
; 
--TSMFNA
--TSMFNA --> TSMSTATN
Prompt     TSMFNA Always DESCRIBES one Facility  TSMSTATN  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMFNA   TSMFNA                        
WHERE                                         
      TSMFNA.TSMSTATN_IS_NUMBER                         IS NOT NULL                      
      AND TSMFNA.TSMSTATN_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMSTATN   TSMSTATN                  
      WHERE TSMFNA.TSMSTATN_IS_NUMBER                = TSMSTATN.TSMSTATN_IS_NUMBER           
      AND TSMFNA.TSMSTATN_ORG_ID                   = TSMSTATN.TSMSTATN_ORG_ID                
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
--
--TSMFNA --> TSMNAICS
Prompt     TSMFNA Always IS DESCRIBED BY TSMNAICS  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMFNA   TSMFNA                        
WHERE                                         
      TSMFNA.TSMNAICS_IS_NUMBER                         IS NOT NULL                      
      AND TSMFNA.TSMNAICS_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMNAICS   TSMNAICS                  
      WHERE TSMFNA.TSMNAICS_IS_NUMBER                = TSMNAICS.TSMNAICS_IS_NUMBER           
      AND TSMFNA.TSMNAICS_ORG_ID                   = TSMNAICS.TSMNAICS_ORG_ID                
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
--
--TSRFDACT --> TSRMATRX
Prompt     TSRFDACT Sometimes DESCRIBED BY TSRMATRX  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFDACT   TSRFDACT                        
WHERE                                         
      TSRFDACT.TSRMATRX_IS_NUMBER                         IS NOT NULL                      
      AND TSRFDACT.TSRMATRX_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSRMATRX   TSRMATRX                  
      WHERE TSRFDACT.TSRMATRX_IS_NUMBER                = TSRMATRX.TSRMATRX_IS_NUMBER           
      AND TSRFDACT.TSRMATRX_ORG_ID                   = TSRMATRX.TSRMATRX_ORG_ID                
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--
--TSRFACOA --> TSRFDACT
Prompt     TSRFACOA Always COLLECTS one TSRFDACT  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFACOA   TSRFACOA                        
WHERE                                         
      TSRFACOA.TSRFDACT_IS_NUMBER                         IS NOT NULL                      
      AND TSRFACOA.TSRFDACT_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRFDACT   TSRFDACT                  
      WHERE TSRFACOA.TSRFDACT_IS_NUMBER                = TSRFDACT.TSRFDACT_IS_NUMBER           
      AND TSRFACOA.TSRFDACT_ORG_ID                   = TSRFDACT.TSRFDACT_ORG_ID                
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--TSRFACOA --> TSMCPORG
Prompt     TSRFACOA Always IS_COLLECTED_BY one TSMCPORG  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFACOA   TSRFACOA                        
WHERE                                         
      TSRFACOA.TSMCPORG_IS_NUMBER                         IS NOT NULL                      
      AND TSRFACOA.TSMCPORG_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMCPORG   TSMCPORG                  
      WHERE TSRFACOA.TSMCPORG_IS_NUMBER                = TSMCPORG.TSMCPORG_IS_NUMBER           
      AND TSRFACOA.TSMCPORG_ORG_ID                   = TSMCPORG.TSMCPORG_ORG_ID                
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--TSRFQS
--TSRFQS --> TSMPRMVL (tsmprmvl_is_number)
Prompt     TSRFQS Sometimes IS_CONTAINED_BY one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFQS   TSRFQS                        
WHERE                                         
      TSRFQS.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRFQS.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRFQS.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRFQS.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID 
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_TYPE_NM'                
      )                                       
ORDER BY 1,TSRFQS_ORG_ID                   
; 
--
--TSRFQS --> TSMPRMVL (tsmprmvl0is_number)
Prompt     TSRFQS Sometimes HAS_CONTAINER_COLOR_OF TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFQS   TSRFQS                        
WHERE                                         
      TSRFQS.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRFQS.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRFQS.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRFQS.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID 
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_COLOR' 
      )                                       
ORDER BY 1,TSRFQS_ORG_ID                   
; 
--TSRFQSDP
--TSRFQSDP --> TSMPRMVL (tsmprmvl_is_number)
Prompt     TSRFQSDP Sometimes IS_CONTAINED_BY one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFQSDP   TSRFQSDP                        
WHERE                                         
      TSRFQSDP.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRFQSDP.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRFQSDP.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRFQSDP.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID 
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_TYPE_NM'                
      )                                       
ORDER BY 1,TSRFQSDP_ORG_ID                   
; 
--
--TSRFQSDP --> TSMPRMVL (tsmprmvl0is_number)
Prompt    TSRFQSDP Sometimes HAS_CONTAINER_COLOR_OF TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRFQSDP   TSRFQSDP                        
WHERE                                         
      TSRFQSDP.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRFQSDP.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRFQSDP.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRFQSDP.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID 
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_COLOR' 
      )                                       
ORDER BY 1,TSRFQSDP_ORG_ID                   
; 
--TSMPSW --> TSMPSA
Prompt     TSMPSW Always IS_GATHERED_FOR one TSMPSA  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSMPSW   TSMPSW                        
WHERE                                         
      TSMPSW.TSMSTATN_IS_NUMBER                         IS NOT NULL                      
      AND TSMPSW.TSMSTATN_ORG_ID                            IS NOT NULL  
      AND TSMPSW.TSMPROJ_IS_NUMBER  IS NOT NULL
      AND TSMPSW.TSMPROJ_ORG_ID     IS NOT NULL                
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSMPSA   TSMPSA                  
      WHERE TSMPSW.TSMSTATN_IS_NUMBER                = TSMPSA.TSMSTATN_IS_NUMBER           
      AND TSMPSW.TSMSTATN_ORG_ID                   = TSMPSA.TSMSTATN_ORG_ID
      AND TSMPSW.TSMPROJ_IS_NUMBER                 = TSMPSA.TSMPROJ_IS_NUMBER
      AND TSMPSW.TSMPROJ_ORG_ID                    = TSMPSA.TSMPROJ_ORG_ID                
      )                                       
ORDER BY 1,TSMSTATN_ORG_ID                   
; 
--TSRRSULT
--TSRRSULT --> TSMPRMVL (tsmprmvl_is_number)
Prompt     TSRRSULT Sometimes HAS_SAMPLE_FRACTION_TYPE_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRRSULT.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRRSULT.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID  
    and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'SMPL_FRAC_TYPE_NM'               
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
--
--TSRRSULT --> TSRDLIN
Prompt     TSRRSULT Sometimes DESCRIBES one TSRDLIN  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSRDLIN_IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSRDLIN_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet1.TSRDLIN   TSRDLIN                  
      WHERE TSRRSULT.TSRDLIN_IS_NUMBER                = TSRDLIN.TSRDLIN_IS_NUMBER           
      AND TSRRSULT.TSRDLIN_ORG_ID                   = TSRDLIN.TSRDLIN_ORG_ID                
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
--TSRRSULT --> TSMPRMVL (tsmprmvl0is_number)
Prompt     TSRRSULT Sometimes HAS_HABIT_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRRSULT.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRRSULT.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID  
    and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'HABIT'               
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
--TSRRSULT --> TSMPRMVL (tsmprmvl1is_number)
Prompt     TSRRSULT Sometimes HAS_VOLTINISM_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRSULT   TSRRSULT                        
WHERE                                         
      TSRRSULT.TSMPRMVL1IS_NUMBER                         IS NOT NULL                      
      AND TSRRSULT.TSMPRMVL1ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRRSULT.TSMPRMVL1IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRRSULT.TSMPRMVL1ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID   
    and tsmprmvl.table_name= 'TSRRSULT'  and tsmprmvl.field_name= 'VOLTINISM'              
      )                                       
ORDER BY 1,TSRRSULT_ORG_ID                   
; 
--TSRRQCAF --> TSMPRMVL
Prompt     TSRRQCAF Always HAS_TYPE_NAME_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRRQCAF   TSRRQCAF                        
WHERE                                         
      TSRRQCAF.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRRQCAF.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRRQCAF.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRRQCAF.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID  
    and tsmprmvl.table_name= 'TSRRQCAF'  and tsmprmvl.field_name= 'TYPE_NAME'               
      )                                       
ORDER BY 1,TSRRQCAF_ORG_ID                   
; 
--TSRSMPLE
--TSRSMPLE --> TSMPRMVL (TSMPRMVL_IS_NUMBER)
Prompt     TSRSMPLE Sometimes IS_CONTAINED_BY one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSMPLE   TSRSMPLE                        
WHERE                                         
      TSRSMPLE.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRSMPLE.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSMPLE.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSMPLE.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID    
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_TYPE_NM'             
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--TSRSMPLE --> TSMPRMVL (TSMPRMVL0IS_NUMBER)
Prompt     TSRSMPLE Sometimes HAS_CONTAINER_COLOR_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSMPLE   TSRSMPLE                        
WHERE                                         
      TSRSMPLE.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRSMPLE.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSMPLE.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSMPLE.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID   
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_COLOR'              
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--TSRSMPLE --> TSMPRMVL (TSMPRMVL1IS_NUMBER)
Prompt     TSRSMPLE Sometimes HAS_TEMP_PRESRVTN_TYPE_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSMPLE   TSRSMPLE                        
WHERE                                         
      TSRSMPLE.TSMPRMVL1IS_NUMBER                         IS NOT NULL                      
      AND TSRSMPLE.TSMPRMVL1ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSMPLE.TSMPRMVL1IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSMPLE.TSMPRMVL1ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID   
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'TEMP_PRESERVN_TYPE'              
      )                                       
ORDER BY 1,TSRFDACT_ORG_ID                   
; 
--TSRSDP
--TSRSDP --> TSMPRMVL (TSMPRMVL_IS_NUMBER)
Prompt     TSRSDP Sometimes IS_CONTAINED_BY one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSDP   TSRSDP                        
WHERE                                         
      TSRSDP.TSMPRMVL_IS_NUMBER                         IS NOT NULL                      
      AND TSRSDP.TSMPRMVL_ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSDP.TSMPRMVL_IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSDP.TSMPRMVL_ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID    
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_TYPE_NM'             
      )                                       
ORDER BY 1,TSRSDP_ORG_ID                   
; 
--TSRSDP --> TSMPRMVL (TSMPRMVL0IS_NUMBER)
Prompt     TSRSDP Sometimes HAS_CONTAINER_COLOR_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSDP   TSRSDP                        
WHERE                                         
      TSRSDP.TSMPRMVL0IS_NUMBER                         IS NOT NULL                      
      AND TSRSDP.TSMPRMVL0ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSDP.TSMPRMVL0IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSDP.TSMPRMVL0ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID    
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'CONTAINER_COLOR'             
      )                                       
ORDER BY 1,TSRSDP_ORG_ID                   
; 
--TSRSDP --> TSMPRMVL (TSMPRMVL1IS_NUMBER)
Prompt     TSRSDP Sometimes HAS_TEMP_PRESRVTN_TYPE_OF one TSMPRMVL  AS  RELATIONSHIP        
--
SELECT
*
FROM   storet1.TSRSDP   TSRSDP                        
WHERE                                         
      TSRSDP.TSMPRMVL1IS_NUMBER                         IS NOT NULL                      
      AND TSRSDP.TSMPRMVL1ORG_ID                            IS NOT NULL                  
      AND    NOT EXISTS                       
      (                                       
      SELECT 1                                
      FROM   storet.TSMPRMVL   TSMPRMVL                  
      WHERE TSRSDP.TSMPRMVL1IS_NUMBER                = TSMPRMVL.TSMPRMVL_IS_NUMBER           
      AND TSRSDP.TSMPRMVL1ORG_ID                   = TSMPRMVL.TSMPRMVL_ORG_ID    
    and tsmprmvl.table_name= 'TSRSMPLE'  and tsmprmvl.field_name= 'TEMP_PRESERVN_TYPE'             
      )                                       
ORDER BY 1,TSRSDP_ORG_ID                   
; 
Prompt 

select * from v$instance;
SPOOL OFF;
prompt Check D:\rowsviolating20.log
--
-- SQL Plus Environment Variables
set echo off
set verify on
set feedback on
set termout on
set time off
set timing off
set heading on
set trimspool off
set linesize 100
set pagesize 24
set serveroutput off
set echo on
exit