"sys_dictionary" table missing column entities for some system tables

[Gowtham Rajkuma]

Hi,

I'm new to Servicenow and facing an important issue which is impacting our integration. As mentioned in the Servicenow documentations that "sys_dictionary" table carries information about all the tables and each column of every table that exists in service now : https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/managing-data/concept/c_DataDictionaryTables.html.

But I'm noticing that some columns are missing from `sys_dictionary` table (Both from API and when I access via Portal). The columns exist the table, I can fetch the list of columns via api and it's showing in the portal as well, but when I'm fetching the list of all columns against the provided table name, some columns are missing. 

This is how I'm making the API call:

`https://<instance-name>.service-now.com/api/now/table/sys_dictionary?sysparm_query=name=change_task&sysparm_fields=sys_name,name,sys_id,element` - it list the table along with all the columns of this table, But noticed missing columns for two system tables so far, `change_task` (Missing column : `additional_assignee_list`) and `text_search` (Missing column : `sys_tags`).

Can anyone please tell why the sys_dictionary table is missing these columns, even though it's there in the schema of the tables. Am I missing any parameter in the api call that needs to be included? 

Kindly let me know, Thanks.

[Gowtham Rajkuma]

Hi,
Thanks for the tip, I can see that the column originally belongs to another table, but now my question is, why is the column being listed in the schema of the different table ? Is there a way to figure out if the fields actually belongs to another table via api so we can make a separate query to get column details against that table instead ?

Thanks.