Function Points FAQs
Codes Tables/Look-up Tables - Identification and Counting Guidelines
Should Codes Tables be counted as logical files?.
Are there any conditions under which Codes Data may be counted as logical files?
A Code table consists of only:
Sometimes additional effective date fields may be present.
In certain systems the Codes tables:
Issues to be addressed include:
The recommended guidelines are that, tables identified as Codes tables, are not counted as separate logical files, rather one generic System Codes table will be counted. This table will not be counted as an FTR for the transactions that reference it. The System Codes file is counted as a file of LOW complexity comprising 3-5 DETs – Code_Type, Code_Id, and Code_Description (Date Effective, Date End). This decision holds regardless of whether:
Only one set of maintenance transactions (Add, Modify, Delete) and one generic View function will be counted for the Systems Codes table. See also Issue, Drop Down Lists.
Note: The FP Analyst must ensure that the Code Description attribute contains text only. Examples have been identified where the Code Description field contained actual business data that defined the Code. For example, the Code Description attribute may be a repeating field that defines all the field components of an Order Template record. In such cases the table is counted as a Reference table.
Where a Code table comprising only Code Id and Code Description participates in a number of m:m relationships with other tables (which are identified logical files, with perhaps some codes tables), such a table may be counted as a Reference table. The existence of the m:m relationships logically implies that the ‘Codes’ table comprises more attributes than just Code Id and Code Description and therefore the characteristics of Reference tables are satisfied. These attributes provide business information on valid combinations of code occurrences. Where such a table is counted as a Reference table, any associated maintenance and reporting functions are also counted.
The decision to disregard Codes tables is based upon the following reasoning:
Here are hints to identify code tables: