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_on]	Date/Time	A time-stamp field that indicates the date and time of the most recent update.

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.

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_on]	Date/Time	A time-stamp field that indicates the date and time of the most recent update.

How search works:

Topics are ranked in search results by how closely they match your search terms

Global default fields

Global default fields

On this page

Global default fields

Global default fields

Log in to personalize your search results and subscribe to topics