NAME:         Term Identifier                                                   

NUMBER:       01051                                                             

FILES/TABLES: ADM   DEG   EMPL  HTD   IAF   IRD   LAP   PSTU  RET   SDCF  SPA   
              TEF                                                               
COMPONENTS:   01444 01445                                                       

INTENT:                                                                         
   Community Colleges Follow-Up Study                                           
   Community Colleges Articulation Agreement                                    
   Personnel Analyses                                                           
   Enrollment Projection                                                        
   Budgeting                                                                    

DEFINITION:                                                                     
   Code indicating the academic term within the fiscal or                       
   academic year.                                                               
   University Employee and OPS use this element to support three                
   years of records in the main tables to support year-over-year                
   queries.                                                                     

EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   CANNOT BE > TERM DEGREE GRANTED                        CRITICAL              
        HTD                                                                     
   MISSING OR INVALID - PRELIMINARY                       CRITICAL              
        ADM                                                                     
   TERM NOT VALID FOR ACADEMIC YEAR                       CRITICAL              
        IRD                                                                     
   TERM OUT OF RANGE FOR ACADEMIC YEAR                    CRITICAL              
        LAP                                                                     
   FORCED AGREEMENT WITH CONTROL CARD                     PROGRAM GENERATED     
        IAF     SDCF    SPA  <  TEF                                             
   FORCED AGREEMENT WITH CONTROL CARD - FINAL             PROGRAM GENERATED     
        ADM                                                                     
   PROGRAM GENERATED                                      PROGRAM GENERATED     
        EMPL                                                                    
   FREQUENCY COUNTS WILL BE PERFORMED ON                  FREQUENCY             
        IRD     LAP     TEF                                                     

CODING INSTRUCTIONS:                                                            
   Term Identifier is used for historical identification purposes               
   and can be generated via edit program control card. (all except              
   IRD, LAP, OPER).                                                             
   Term Identifier for the Hours to Degree Course Records should                
   identify the term a course was attempted, not when the credit                
   was posted.                                                                  
   Term Identifier for Operating Budget data is program generated               
   (without the use of a control card) for all budget entities                  
   except Faculty Practice.  Must be coded in fall term format for              
   Faculty Practice.                                                            
   For University Employee and OPS Reporting this will be program               
   generated for loading into tables.                                           

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_ID                                                
   SHORT NAME:           TERMID                                                 

CREATE-CHANGE DATE:  04/25/07