Table 5203 "Employee Qualification"

Base Application · Microsoft.HumanResources.Employee · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5206 “Employee Qualifications” (3 Learn pages).

Properties

Property	Value
Caption	Employee Qualification
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Employee No. Δ BC28	Code[20]	Specifies a number for the employee.	TableRelation Table 5200 “Employee”; NotBlank
2	Line No.	Integer	—
3	Qualification Code Δ BC28	Code[10]	Specifies a qualification code for the employee.	TableRelation Table 5202 “Qualification”
4	From Date Δ BC28	Date	Specifies the date when the employee started working on obtaining this qualification.
5	To Date Δ BC28	Date	Specifies the date when the employee is considered to have obtained this qualification.
6	Type Δ BC28	Option	Specifies a type for the qualification, which specifies where the qualification was obtained.	OptionCaption: ,Internal,External,Previous Position
7	Description Δ BC28	Text[100]	Specifies a description of the qualification.
8	Institution/Company Δ BC28	Text[100]	Specifies the institution from which the employee obtained the qualification.
9	Cost Δ BC28	Decimal	Specifies the cost of the qualification.
10	Course Grade Δ BC28	Text[50]	Specifies the grade that the employee received for the course, specified by the qualification on this line.
11	Employee Status	Enum “Employee Status”	—	enum Enum 5200 “Employee Status”; not editable
12	Comment Δ BC28	Boolean	Specifies whether a comment was entered for this entry.	FlowField: exist(“Human Resource Comment Line” where(“Table Name” = const(“Employee Qualification”), “No.” = field(“Employee No.”), “Table Line No.” = field(“Line No.”))); not editable
13	Expiration Date Δ BC28	Date	Specifies the date when the qualification on this line expires.

Keys

Key1: Employee No., Line No. (clustered)
Key2: Qualification Code

Triggers

OnDelete, OnInsert

Relations

lookup page Page 5206 “Employee Qualifications”
drill-down page Page 5207 “Qualified Employees”
Employee No.: TableRelation Table 5200 “Employee”
Qualification Code: TableRelation Table 5202 “Qualification”
Comment: CalcFormula Table 5208 “Human Resource Comment Line”

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5202 “Qualification”: Qualified Employees
Table 5208 “Human Resource Comment Line”: No.

Pages and codeunits on this table

Page 5206 “Employee Qualifications” (source table)
Page 5207 “Qualified Employees” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Employee Qualification"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.