ACA_CS_CLASS_FAMILY
Contains the Business Class Families that any classes belong to. A Class Family is nothing more than a normalization of class definitions. It represents the metadata associated with all classes whose objects are stored in the same set of tables and are governed by the same entity object in the application. The term family simply signifies that the same application business logic is applied to all business objects in a set. That is, the business objects are not necessarily related to one another in the data, but they are related to one another in the application logic. The existence of this table keeps us from either repeating the same data for each class using it or using a sparse data matrix to only store the class metadata with a base class. One advantage to factoring the metadata out into a separate table, it allows a class family to have more than one base class while ensuring that the metadata for each base class remains the same. The Class Family table is also the table where Common Services groups can add named attributes which represent business logic parameters. These parameters are specified at the Class Family because they apply to all classes within a class family. When the application views a class definition, the Class Family is automatically joined with the class definition. One can think of the Class Family as a normalization of the Class definitions. Note: no official requirements for this type of business logic parameter has been communicated; for now we are simply offering the design for how Class Family business logic parameters would be implemented. This table is preloaded with seeded data. This table is not modified by customers.
Details
-
Schema: FUSION
-
Object owner: ACA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ACA_CS_CLASS_FAMILY_PK |
CLASS_FAMILY_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CLASS_FAMILY_CODE | VARCHAR2 | 80 | Yes | Primary Key. This table uses the code as the primary key instead of a numerical ID. The reason for this choice is to allow easy lookup of class data by the family code rather than having to join with this table only for the lookup. The values for this column are maintained in FND_LOOKUPS under the ACA_CS_CLASS_FAMILY lookup type. This allows the class family names to be translated without having to provide an additional UI just to localize the family names. | |
| DELETED_FLAG | NUMBER | 18 | Yes | Used to control soft deletes. 0 = Active; ALL other values identify the row as deleted. | |
| NUMBER_GENERATION_FLAG | VARCHAR2 | 1 | Flag if number generation method is used for the class types within this class family. | ||
| APPLICATION_MODULE | VARCHAR2 | 240 | Yes | Used as a callback to the owning product module to allow the Class Management framework to determine if a class is in-use as well as other useful information. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| aca_cs_class_b | aca_cs_class_family | CLASS_FAMILY_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACA_CS_CLASS_FAMILY_U1 | Unique | Default | CLASS_FAMILY_CODE, ORA_SEED_SET1 |
| ACA_CS_CLASS_FAMILY_U11 | Unique | Default | CLASS_FAMILY_CODE, ORA_SEED_SET2 |
| ACA_CS_CLASS_FAMILY_U2 | Unique | Default | CLASS_FAMILY_CODE, DELETED_FLAG, ORA_SEED_SET1 |
| ACA_CS_CLASS_FAMILY_U21 | Unique | Default | CLASS_FAMILY_CODE, DELETED_FLAG, ORA_SEED_SET2 |