table - sn_employee_profile «Employee Profile» - erm4sn

Derivation Hierarchy

sn_employee_profile
«Employee Profile»

Employee Profile

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: sn_employee_profile
Label:: Employee Profile (en)

Created On:: 2022.09.17 02:35:25
Created By:: system

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

Column Updated On:: 2022.09.17 02:35:25
Column Updated By:: system

Scope Name:: Employee Profile
Scope:: sn_employee

Listing:: open
Dictionary:: open

Columns

+	Status	Name	Label	Datatype	Length	Scope	Reference	Included By
		background_banner	Background banner	user_image	40	Employee Profile		sn_employee_profile
		employment_end_date	Employment end date	glide_date	40	Employee Profile		sn_employee_profile
		employment_start_date	Employment start date	glide_date	40	Employee Profile		sn_employee_profile
		location_type	Location type	string[choice]	40	Employee Profile		sn_employee_profile
		nickname	Nickname	string	40	Employee Profile		sn_employee_profile
		number	Number	string	40	Employee Profile		sn_employee_profile
		position_type	Position type	string[choice]	40	Employee Profile		sn_employee_profile
		preferred_pronoun	Preferred pronoun	string[choice]	40	Employee Profile		sn_employee_profile
		short_bio	Short bio	string	255	Employee Profile		sn_employee_profile
		sys_created_by	Created by	string	40	Employee Profile		sn_employee_profile
		sys_created_on	Created	glide_date_time	40	Employee Profile		sn_employee_profile
	K	sys_id	Sys ID	GUID	32	Employee Profile		sn_employee_profile
		sys_mod_count	Updates	integer	40	Employee Profile		sn_employee_profile
		sys_updated_by	Updated by	string	40	Employee Profile		sn_employee_profile
		sys_updated_on	Updated	glide_date_time	40	Employee Profile		sn_employee_profile
	M	user	User	reference	32	Employee Profile	sys_user	sn_employee_profile
		work_mobile	Work mobile phone	phone_number_e164	40	Employee Profile		sn_employee_profile
		work_phone	Work phone	phone_number_e164	40	Employee Profile		sn_employee_profile

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
background_banner						missing
employee_type	missing	missing			missing	missing
primary_resource_group	missing	missing			missing	missing
primary_resource_role	missing	missing			missing	missing
primary_resource_skill	missing	missing			missing	missing

Diagram sn_employee_profile «Employee Profile» / Employee Profile (sn_employee)

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