Global default fields

When you create a new custom table, several fields appear in the Table Columns embedded list. For all tables, required system fields are added automatically. You cannot delete or modify these fields.

For tables that extend another table, fields on the parent table also appear on the Table Columns embedded list for the current table. If you modify these fields, remember that all changes to fields on the parent table also affect all child tables, not just the current table.

These required system fields are added to all tables:
Table 1. Required system fields
Field Type Description
Class [sys_class_name] System Class Name If the table is extensible, a string field that indicates which child table contains the record.
Created [sys_created_on] Date/Time A time-stamp field that indicates when a record was created.
Created by [sys_created_by] String A string field that indicates the user who created the record.
Sys_id [sys_id] Sys ID The unique record identifier for the record.
Updates [sys_mod_count] Integer A numeric field that counts the number of updates for this record since record creation.
Updated by [sys_updated_by] String A string field that indicates the user who most recently updated the record.
Updated [sys_updated] Date/Time A time-stamp field that indicates the date and time of the most recent update.