How to Generate Reports › Attribute Definition Report › Attribute Definition Report Examples

Attribute Definition Report Examples

The following illustrates shows the definition of NUMBER, an attribute of the entity type EMPLOYEE. The attribute is designed by a simple algorithm. It is mandatory-each employee must have a number and it belongs to the number domain.

     MM/DD/YY                 ATTRIBUTE DEFINITION REPORT                 Page 1
     HH:MM                                                                      
                                                                                
        MODEL NAME:     TRUST AND STOCKHOLDER MANAGEMENT                        
        SUBSET NAME:                   LSW2                                     
                                                                                
     ENTITY TYPE:     EMPLOYEE                      OBJECT ID:     4980794      
     ATTRIBUTE                                                                  
     NAME:            NUMBER                                                    
        ID:           4981396                                                   
     DESCRIPTION:     AN EMPLOYEE NUMBER IS A 6 DIGIT NUMBER. THE ALGORITHM IS  
        ID:           ADD ONE TO THE PREVIOUSLY ASSIGNED NUMBER. WHEN           
                      EMPLOYEE TERMINATES THAT NUMBER IS NEVER USED AGAIN.      
                                                                                
     SOURCE                                                                     
     CATEGORY:        DERIVED                                                   
     OPTIONALITY:     MANDATORY                                                 
     CASE                                                                       
     SENSITIVITY:     NO                                                        
     NLS OPTION:                                                                
     DOMAIN:          NUMBER                                                    
     NUMBER OF                                                                  
     CHARACTERS:      6                                                         
     NUMBER OF                                                                  
     DECIMALS:        0                                                         

The Attribute Definition Report is arranged alphabetically by entity type and subtype, and then by attribute. The report also defines attributes belonging to entity subtypes. The report fields are the same as for entity types with the addition of a SUBTYPE field beneath ENTITY TYPE.

     ENTITY TYPE:          EMPLOYEE                     OBJECT ID: 4980794   
     SUBTYPE               EXEMPT STAFF                 OBJECT ID: 987651166 
     ATTRIBUTE                                                               
     NAME:                 JOB_GRADE                                         
       ID:                 13145621                                          
     DESCRIPTION:          A JOB GRADE IS A 2 DIGIT NUMBER BETWEEN 10 AND 50 
     SOURCE                                                                  
     CATEGORY:             BASIC                                             
     OPTIONALITY:          MANDATORY                                         
     CASE                                                                    
     SENSITIVITY:          NO                                                
     NLS OPTION:                                                             
     DOMAIN:               NUMBER                                            
     NUMBER OF                                                               
     CHARACTERS:           2                                                 
     NUMBER OF                                                               
     DECIMALS              0                                                 
     DEFAULT VALUE                                                           
     OR ALGORITHM:         10                                                
     PERMITTED                                                               
     VALUES:               10-50                                             
     VALUE:                                                                  
     DESCRIPTION:          JOB GRADE RANGE FOR AN EXEMPT EMPLOYEE IS 10-50   

If the attribute belongs to an entity subtype, the subtype is listed below the entity type. If the attribute has a default value or algorithm, it will be listed. Also, if the attribute has any permitted values, they will be listed along with any descriptions for the permitted values.

If an entity type has more than one subtype, all attributes of the first subtype are listed first. Then the next subtype is listed with its attributes.