rca_reminder
       
       
       
       
       
       
       
       
        
         Stores reminder settings for a review instance.
        
        
         
          
           
            | 
              
              Field name
              
             | 
            
              
              Field data type
              
             | 
            
              
              Purpose
              
             | 
           
          
          
           
            | 
              
              id (PRI)
              
             | 
            
              
              varchar(255)
              
             | 
            
              
              The reminder settings identifier.
              
             | 
           
           
            | 
              
              daysBeforeExpiry
              
             | 
            
              
              int(11)
              
             | 
            
              
              The number of days before the expiry date
to send a reminder.
              
             | 
           
           
            | 
              
              recipient
              
             | 
            
              
              varchar(255)
              
             | 
            
              
              The recipient of the reminder. The possible
values are ALL, REMAINING_PARTICIPANTS, MODERATOR, and INITIATOR.
              
             | 
           
           
            | 
              
              reviewStage(MUL)
              
             | 
            
              
              varchar(255)
              
             | 
            
              
              The foreign key to parent record in review
stage.
              
             | 
           
           
            | 
              
              reminderNo
              
             | 
            
              
              int(11)
              
             | 
            
              
              The index used to access a list of reminders.
The field is used for internal purposes.
              
             |