Changeset 37945

Timestamp:

Mar 3, 2015, 3:04:29 PM (11 years ago)

Author:

heather

Message:

changes to view for sas37

File:

• trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_VIEWS/Views (modified) (1 diff)

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_VIEWS/Views

@@ -1 +1 @@
 PSPS VIEWS - examples (not complete, please suggest others) 
 
-MeanObjectView     = ObjectThin join MeanObject 
-StackObjectView    = ObjectThin join StackObjectThin join StackObjectAttributes
-StackApFlxObjectView      = ObjectThin join StackApFlx  
-StackApFlxEGObjectView     = ObjectThin join StackApFlxEGUnc join StackApFlxEGCon6 join StackApFlxEGCon8
-StackModelObjectView    = ObjectThin join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian   
-ForcedMeanObjectView  = ObjectThin join ForcedMeanObject
-StackObjectPrimaryView     = ObjectThin join StackObjectThin join StackObjectAttributes join StackApFlx where primaryDection is true
-StackObjectBestView        = ObjectThin join StackObject join StackObjectAttributes join StackApFlx where bestDetection is true
-DiffDetObjectView          = DiffDetObject join DiffDetection
+*note: drop batchID it is not needed
+
+MeanObjectView              = ObjectThin join MeanObject 
+StackObjectView             = ObjectThin join StackObjectThin join StackObjectAttributes
+StackApFlxObjectView        = ObjectThin join StackApFlx  
+StackApFlxEGUncObjectView   = ObjectThin join StackApFlxEGUnc 
+StackApFlxEGCon6ObjectView  = ObjectThin join StackApFlxEGCon6 
+StackApFlxEGCon8ObjectView  = ObjectThin join StackApFlxEGCon8
+StackModelObjectView        = ObjectThin join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian   
+StackModelFitExpObjectView  = ObjectThin join StackModelFitExp
+StackModelFitDeVObjectView  = ObjectThin join StackModelFitDeV
+StackModelFitSerObjectView  = ObjectThin join StackModelFitSer
+StackModelFitPetObjectView  = ObjectThin join StackPetrosian
+StackObjectPrimaryView      = ObjectThin join StackObjectThin join StackObjectAttributes join StackApFlx where primaryDection is true
+* StackObjectBestView         = ObjectThin join StackObject join StackObjectAttributes join StackApFlx where bestDetection is true
+ForcedMeanObjectView        = ObjectThin join ForcedMeanObject
+DetectionObjectView         = ObjectThin join MeanObject join Detection
+DiffDetObjectView           = DiffDetObject join DiffDetection
+ForcedDetObjectView         = ObjectThin join ForcedWarpDetection
+
+
+*note1: StackObjectBestView - skip - we don't currently set bestDetection
+*note2: drop batchID it is not needed
 
 
 
-
-