Table 5205 "Employee Relative"
Base Application · Microsoft.HumanResources.Employee
Across versions
- BC23present
- BC241 fields changed
- BC25-27unchanged
- BC286 fields changed
- BC291 fields changed
- BC30unchanged
Neighbourhood 7 connected objects and pages
Base Application · Microsoft.HumanResources.Employee · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5209 “Employee Relatives” (3 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Employee Relative |
| 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. | Code[20] | — | TableRelation Table 5200 “Employee”; NotBlank |
| 2 | Line No. | Integer | — | |
| 3 | Relative Code Δ BC28 | Code[10] | Specifies a relative code for the employee. | TableRelation Table 5204 “Relative” |
| 4 | First Name Δ BC28 | Text[30] | Specifies the first name of the employee’s relative. | |
| 5 | Middle Name Δ BC28 | Text[30] | Specifies the middle name of the employee’s relative. | |
| 6 | Last Name Δ BC29 | Text[30] | Specifies the last name of the employee’s relative. | |
| 7 | Birth Date Δ BC28 | Date | Specifies the relative’s date of birth. | |
| 8 | Phone No. Δ BC28 | Text[30] | Specifies the relative’s telephone number. | |
| 9 | Relative’s Employee No. | Code[20] | Specifies the relative’s employee number, if the relative also works at the company. via Page 5209 “Employee Relatives” | TableRelation Table 5200 “Employee” |
| 10 | Comment Δ BC24 Δ BC28 | Boolean | Specifies if a comment was entered for this entry. | FlowField: exist(“Human Resource Comment Line” where(“Table Name” = const(“Employee Relative”), “No.” = field(“Employee No.”), “Table Line No.” = field(“Line No.”))); not editable |
Keys
- Key1: Employee No., Line No. (clustered)
Triggers
OnDelete
Relations
- drill-down page Page 5209 “Employee Relatives”
- lookup page Page 5209 “Employee Relatives”
- Employee No.: TableRelation Table 5200 “Employee”
- Relative’s Employee No.: TableRelation Table 5200 “Employee”
- Relative Code: TableRelation Table 5204 “Relative”
- Comment: CalcFormula Table 5208 “Human Resource Comment Line”
Pages and codeunits on this table
- Page 5209 “Employee Relatives” (source table)
Recent changes
- 2026-09-10 #11214 [29.x][All-e][SaaS] Last name of the employee relative is not editable when customized using “Profile (Role)” (releases/29.x, BC29, fix)
- 2026-09-10 #11113 [Master][All-e][FTE][SaaS] Last name of the employee relative is not editable when customized using “Profile (Role)”. (main, BC30, fix)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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 Relative"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.