JContSkill

Last updated
Save as PDF

JContSkill contains information about the skills in a contact record including the skill level, skill type (such as underwriting or litigation), and contact record to which each skill belongs.

This table represents the Skills block on the Skills tab of a contact record.

Object: JContSkill (J_CONT_SKILL)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
owner-->	CONTACT_ID (NUMBER)		x	x	TContact	object	8 The contact to which the skill belongs. --> Links to specific information for the contact record.
skillLevel	SKILL_LEVEL (NUMBER)	Level of Expertise	x			int	The skill level assigned to the contact for the skill type.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the skill.
skillType--> Before TeamConnect 3.3 SP2: type-->	TYPE_ID (NUMBER)	Type	x	x	LContSkillType	object	8 The type of the skill. --> Links to definition information for the skill type.
version	VERSION (NUMBER)		x			int	Indicates how many times the skill record was updated.

LContSkillType

LContSkillType contains information about the skill types defined for contact skills. This information includes the name of the skill, tree position, and display order. This table represents the Skill Type system lookup table.

Object: LContSkillType (L_CONT_SKILL_TYPE)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
childList-->	n/a		x	x	LContSkillType		8 The child skill types for the current skill type. --> Links to definition information for a child skill type.
displayOrder	DISPLAY_ ORDER (NUMBER)	Order	x			int	The order in which the table items will be listed in the GUI, lowest number first.
isActive	IS_ACTIVE					boolean
name	NAME (VARCHAR2) (50)	Item Name	x			string (50)	The name of the skill type.
parent-->	PARENT_ID (NUMBER)	Show items in node	x	x	LContSkillType	object	8 The parent item of the current item. --> Links to definition information for the parent skill type.
primaryKey	PRIMARY_ KEY (NUMBER)		x			int	The unique ID of the skill type list item.
treePosition	TREE_ POSITION (VARCHAR2) (250)	Tree Position	x			string (250)	The unique four- character alphanumeric code that is created when the skill type is defined.
version	VERSION (NUMBER)		x			int	Indicates how many times the skill type list item was updated.