NAME:         Term Degree Granted                                               

NUMBER:       01412                                                             

FILES/TABLES: HTD   RET   SDCF  TEF                                             
COMPONENTS:   01444 01445                                                       

INTENT:                                                                         
   Student Progression/Retention                                                

DEFINITION:                                                                     
   Code indicating the academic term in which a degree was granted              
   to the student by the reporting institution. This date may or                
   may not be equal to the value coded in Term Identifier (01051).              

EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   CANNOT BE GREATER THAN REPORTING TERM                  CRITICAL              
        SDCF    TEF                                                             
   FALL/SPRING & TERM OUT-OF-RANGE FOR ACD YR             CRITICAL              
        SDCF    TEF                                                             
   INVALID TERM DEGREE GRANTED                            CRITICAL              
        SDCF    TEF                                                             
   MISSING OR INVALID                                     CRITICAL              
        HTD                                                                     
   NON-MATCH ON STUDENT DATA COURSE FILE                  CRITICAL              
        HTD                                                                     
   NOT BLANK AND NO DEGREE REPORTED                       CRITICAL              
        SDCF                                                                    
   SUMMER & TERM < PREVIOUS ACADEMIC YEAR                 CRITICAL              
        SDCF    TEF                                                             
   TERM OUT OF RANGE FOR ACADEMIC YEAR                    CRITICAL              
        HTD                                                                     
   IF BLANK, PGM GEN FROM TERM DATE                       PROGRAM GENERATED     
        SDCF    TEF                                                             
   FREQUENCY COUNTS WILL BE PERFORMED ON                  FREQUENCY             
        HTD     SDCF    TEF                                                     

CODING INSTRUCTIONS:                                                            
   Term Degree Granted is used to indicate that a degree (reported              
   in element 01081, Degree - Level Granted) was awarded by the                 
   reporting institution in a term previous to the current reporting            
   term.  If it is left blank and a degree was awarded to the                   
   student then the edit program will generate the term value coded             
   on the control card into this field.                                         
   On the Hours To Degree File, the date should be confined to the              
   academic year being reported.                                                
   On the Student Data Course File and the Teacher Education File,              
   the date reported should be confined to the current academic year            
   if the Term Identifier(01051) is equal to Fall and Spring Term.              
   For Summer Term submissions the date should be confined to the               
   current summer term or any term within the previous academic year            
   When Level Degree Granted(01081) has a valid degree and Term                 
   Degree Granted is equal to spaces then Reporting Term will be                
   generated into Term Degree Granted. If Term Degree Granted is                
   coded, it cannot be greater than the reporting term.  This                   
   element should be equal to spaces when Level Degree Granted has              
   a value of 'N' or space.                                                     
   On the Retention Late Degree File, the date may be used to report            
   degrees, granted in previous academic years, which were not                  
   reported on the Student Data Course File.  Degrees reported in               
   this manner will be used in Retention reporting only.                        

TABLE VALUES:                                                                   
   FALL TERM      YYYY08                                                        
   SPRING TERM    YYYY01                                                        
   SUMMER TERM    YYYY05                                                        
                  Where YYYY is the calendar year                               

DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: X(6)                                                   
   COLUMN NAME:          TERM_DEGREE_GRANT                                      
   SHORT NAME:           DEGTERM                                                

CREATE-CHANGE DATE:  03/23/07