To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) View - This option is incorrect because a view is a virtual table that is stored in the database. It is created using a SQL query and does not require physical storage of data.
Option B) SQL Table - This option is incorrect because an SQL table is a physical table that is stored in the database. It contains rows and columns to store data.
Option C) Derived/Work Record - This option is incorrect because a derived/work record is a temporary record that is created during the processing of a PeopleSoft program. It is used for calculations, intermediate data storage, or temporary data manipulation. It is not stored on the database and is created dynamically as needed.
Option D) Sub Record - This option is correct because a sub record is a reusable component that is used to define the structure and behavior of a field or a group of fields within a record. It is not stored on the database and is not required to be built separately.
The correct answer is D) Sub Record. This option is correct because a sub record is not stored on the database and is not required to be built separately.