table - spm_taxonomy_node «Taxonomy Node» - erm4sn

Derivation Hierarchy

spm_taxonomy_node
«Taxonomy Node»

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: spm_taxonomy_node
Label:: Taxonomy Node (en)

Created On:: 2022.09.17 02:11:03
Created By:: system

Updated On:: 2022.09.17 02:55:17
Updated By:: system

Column Updated On:: 2022.09.17 02:31:47
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

+	Status	Name	Label	Datatype	Length	Scope	Reference	Included By
		description	Description	translated_text	4000	Global		spm_taxonomy_node
	M D	name	Name	translated_text	80	Global		spm_taxonomy_node
		parent	Parent	reference	32	Global	spm_taxonomy_node	spm_taxonomy_node
		short_description	Short description	translated_text	1000	Global		spm_taxonomy_node
	M	spm_service_portfolio	Service portfolio	reference	32	Global	spm_service_portfolio	spm_taxonomy_node
	M	spm_taxonomy_layer	Taxonomy layer	reference	32	Global	spm_taxonomy_layer_definition	spm_taxonomy_node
		sys_created_by	Created by	string	40	Global		spm_taxonomy_node
		sys_created_on	Created	glide_date_time	40	Global		spm_taxonomy_node
	K	sys_id	Sys ID	GUID	32	Global		spm_taxonomy_node
		sys_mod_count	Updates	integer	40	Global		spm_taxonomy_node
		sys_updated_by	Updated by	string	40	Global		spm_taxonomy_node
		sys_updated_on	Updated	glide_date_time	40	Global		spm_taxonomy_node
		taxonomy_node_owner	Owned by	reference	32	Global	sys_user	spm_taxonomy_node
		valid_from	Valid from	glide_date_time	40	Global		spm_taxonomy_node
		valid_to	Valid to	glide_date_time	40	Global		spm_taxonomy_node

P

Passive

M

Mandatory

D

Display Value

K

Key

U

Unique

X

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Vancouver	Uta	Tokyo (Vanilla)	Sandiego
perf_score	missing	missing			missing	missing
spm_taxonomy_layer		different	different	different

Referenced

spm_taxonomy_node referenced from table:: cmdb_ci_service, spm_taxonomy_node

Diagram spm_taxonomy_node «Taxonomy Node» / Global (global)

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out