NAME:         Total Hours Earned at Current Student Degree Level                

NUMBER:       01087                                                             

FILES/TABLES: PSTU  RET   SDCF                                                  

INTENT:                                                                         
   Enrollment                                                                   
   Student Degree Progress                                                      

DEFINITION:                                                                     
   A count of credit hours earned as of the beginning of the                    
   reported term, including any transfer hours and any non-                     
   instructional credit awarded (CLEP, etc.).  For unclassified                 
   students this element should reflect the total credit hours                  
   earned at this institution in previous terms.                                

EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   MUST BE GT OR = 01061                                  CRITICAL              
        SDCF                                                                    
   NON-NUMERIC                                            CRITICAL              
        SDCF                                                                    
   01087 + 01089 MUST BE GE 110 WHERE                     CRITICAL              
     01112 = H,U,A,C,N & 01081=B                                                
        SDCF                                                                    
   01087 GT 250.0                                         CRITICAL              
        SDCF                                                                    
   01060=L & 01413=B,H,E -01420=CURR                      WARNING               
     TERM & 01087 GT 30                                                         
        SDCF                                                                    
   FREQUENCY COUNTS WILL BE PERFORMED ON                  FREQUENCY             
        SDCF                                                                    

CODING INSTRUCTIONS:                                                            
   To earn a Bachelor's Degree (1081=B) 1087 must be greater than               
   110 hours.  110 hours is used to flag students who do not have               
   enough hours to graduate, though more than 110 hours is needed               
   to graduate.                                                                 
   This element includes                                                        
   (1) any credit hours earned prior to formal admission which may              
   apply to the current degree program.                                         
   (2) all credit hours earned after formal admission to the current            
   degree program.                                                              
   This element excludes hours earned by students in course work                
   determined by the institution to be remedial for them.                       
   Undergraduate students:                                                      
   This element also includes all transfer hours accepted toward the            
   baccalaureate degree program.                                                
   Graduate students:                                                           
   this element includes all credit hours (including transfer hours)            
   earned prior to the reported term which are applicable toward the            
   student's current graduate degree program. (elective hours earned            
   after student began current program are to be included.)                     
   Unclassified students:                                                       
   this element reflects only those hours (including non-                       
   instructional credit) earned at this institution.                            

DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: 9(3)V9                                                 
   COLUMN NAME:          TOT_HRS_DEG_LVL                                        
   SHORT NAME:           STDTHRS                                                

CREATE-CHANGE DATE:  07/05/06