How to Generate Reports › Entity Definition Report › Entity Type

Entity Type

The following illustration shows the contents of an Entity Definition Report for the entity type EMPLOYEE. The entity type name, description, properties and attributes appear as they do in the Entity Relationship Diagram (ERD).

  MM/DD/YY                   ENTITY DEFINITION REPORT                  PAGE 13
  HH:MM
           MODEL NAME:         TRUST AND STOCKHOLDER MANAGEMENT
           SUBSET NAME:        MQH2
        NAME:        EMPLOYEE
      OBJECT ID:     54903211
                              (WORKER)
                              (STAFF)

  DESCRIPTION:  Individual who currently is or formerly was employed
                by company. This person may become a participant of
                the various plans and trusts

       SUBJ AREA:       ENCY REPORT MODEL

       PROPERTIES:      MINIMUM OCCURRENCE:     60000
                        AVERAGE OCCURRENCE:     85000
                        MAXIMUM OCCURRENCE:    100000
                        GROWTH RATE: 5% PER YEAR

       ATTRIBUTES:
                        CALENDAR_SERVICE_YEARS
                        CITIZENSHIP
                        DIVISION
                        EMPLOYMENT_STATUS
                        EXTERNAL_ADDRESS
                        INTERNAL_ADDRESS
                        NAME             
                             (EMPLOYEE_NAME)
                        NUMBER
                        ORIGINAL_EMPLOYMENT_DATE
                             (SERVICE_DATE)
                             (BEGIN_DATE)

  RELATIONSHIPS:

  SOMETIMES OWNS                            MANY PARTICIPANT_ACCOUNT
     CAN TRANSFER  (50%)                    1 MINIMUM  3 MAXIMUM  1 AVERAGE
  ALWAYS APPLIES AS                         ONE APPLICANT
                CANNOT TRANSFER             
  ALWAYS EMPLOYED BY                        ONE DIVISION
                CAN TRANSFER

  IDENTIFIERS:
              NUMBER
              NAME
              DIVISION
              EMPLOYED BY                   DIVISION

  PARTITIONED
  BY:     TYPE
       CLASSIFYING VALUE                    SUBTYPE
       -----------------                    -------

       EXEMPT                               EXEMPT_STAFF
       NONEXEMPT                            NONEXEMPT_STAFF