table - cmn_department «Department» - erm4sn

Derivation Hierarchy

cmn_department
«Department»

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: cmn_department
Label:: Department (en)

Created On:: 2022.09.17 01:43:42
Created By:: system

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

Column Updated On:: 2022.09.17 02:02:16
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

+	Status	Name	Label	Datatype	Length	Scope	Reference	Included By
		business_unit	Business unit	reference	32	Global	business_unit	cmn_department
		company	Company	reference	32	Global	core_company	cmn_department
		cost_center	Cost center	reference	32	Global	cmn_cost_center	cmn_department
		dept_head	Department head	reference	32	Global	sys_user	cmn_department
		description	Description	string	1000	Global		cmn_department
		head_count	Head count	integer	40	Global		cmn_department
		id	ID	string	40	Global		cmn_department
	D	name	Name	string	100	Global		cmn_department
		parent	Parent	reference	32	Global	cmn_department	cmn_department
		primary_contact	Primary contact	reference	32	Global	sys_user	cmn_department
		sys_created_by	Created by	string	40	Global		cmn_department
		sys_created_on	Created	glide_date_time	40	Global		cmn_department
	K	sys_id	Sys ID	GUID	32	Global		cmn_department
		sys_mod_count	Updates	integer	40	Global		cmn_department
		sys_updated_by	Updated by	string	40	Global		cmn_department
		sys_updated_on	Updated	glide_date_time	40	Global		cmn_department

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
code	missing	missing			missing	missing

Referenced

cmn_department referenced from table:: alm_asset, ast_license_base, catalog_category_request, change_request_imac, cmdb, cmn_department, sc_category_dept_mtom, sc_category_dept_no_mtom, sc_cat_item_dept_mtom, sc_cat_item_dept_no_mtom, service_subscribe_department, sla, sn_gf_goal, sn_gf_strategy, sys_user, user_criteria, v_ais_result_improvement_rule_condition_builder_values

Diagram cmn_department «Department» / Global (global)

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