



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
ServiceNow CSA Exam prep "Data Schema"
Typology: Exams
1 / 6
This page cannot be seen from the preview
Don't miss anything!
What is the ServiceNow infrastructure? - Data in ServiceNow is stored and managed according to a database structure that administrators can view and configure: Tables - are a data structure or database component, which contain records Records - are the data stored on tables, which contain fields. Lists and forms - provide a friendly user interface (UI) for managing the data in records and fields. Dictionary - defines every table and field in the system. Table records are identified as a Collection type. Tables - contains a record for each table in the database. Custom tables can be created when the New button is created. Tables & Columns - lists existing tables in the database. Selecting a table name displays its contents. The System Dictionary - contains the definition for each and every table and field in the database. To access the system dictionary to modify table and field attributes. - Navigate to System Definition > Dictionary Each record corresponds to - a row in a table. Each field on a record corresponds to - a column on that table. Applications use - tables and records to manage data and processes. Records - Are identified by a 32-character, globally unique ID, called a sys_id. Record numbers are automatically incremented, and -
the number format per table in the system can be changed by visiting the System Definition
Number Maintenance application. Fields - Store the actual data. They are available in a variety of different field types, such as: Choice, Date/Time, Journal, Reference, and more. Field types - define how a field is interacted with through the interface, as well as the type and format of data it can store. Every field has three key attributes: - Field Label, Field Name, Value Field Label - A user-friendly term for the field.In this example, the Field Labels are: User ID, Name, and Location. Field Name - A unique term for the field. It is very important to note the Field Name does NOT always match the Field Label. Value - The actual data stored in the field, anything that comes after the dot [.] - is the Field Name (a unique identifier). A reference field - stores a unique system identifier (known as the sys_id) of a record on another table which is what establishes the reference relationship. When you define a reference field - he platform creates a relationship between the two tables. Adding a reference field to a form - makes the other fields in the referenced table available to the form. Administrators - can create new reference fields and configure several options for reference fields. Reference fields are identified - with the Reference Lookup icon. Wildcard searches can - be used to locate a record.
Database Views - Two tables can be joined virtually to allow for reporting on data that might be stored in more than one table. Certain views are included in the base system with the Database Views and Database Views for Service Management plugins. Database Views are - read-only. Extensions - A table can extend another table. The extended table includes unique fields plus all of the fields and their properties from the parent table. For tables that stand alone, - only the global default fields are automatically created. Extending a table - incorporates all of the fields of the original table and allows for unique fields to be created on the new table. incorporates all of the fields of the original table and allows for unique fields to be created on the new table. - is used to create subcategories of data. The option to extend a table is only available when - creating a new table. It is important to note however, not all tables are extensible. child class. - A table that extends another table The table it extends is - the parent class. Child tables extended from - Task [task] include Change Request, Incident, and Problem. Child tables extended - from Configuration Item [cmdb_ci] include Database, Hardware, and Software. To add a different label for an extended table, - navigate to System Definition > Language File. Then create a new entry for the extended table. A table's Extensible field is used - to control whether a table can be extended.