tableHuman Resourcesofficial - Microsoftderived - from the source, no model text

Table 5205 "Employee Relative"

Base Application · Microsoft.HumanResources.Employee

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC25-27unchanged
  4. BC286 fields changed
  5. BC291 fields changed
  6. BC30unchanged

Neighbourhood 7 connected objects and pages

Table 5200 "Employee" (relates to, 2 links)EmployeeTable 5204 "Relative" (relates to)RelativeTable 5208 "Human Resource Comment Line" (relates to)Human Resource Comment LinePage 5209 "Employee Relatives" (pages and codeunits on it, 3 links)Employee RelativesManage Employee Absence (Learn pages)Manage Employee AbsenceManage human resources (Learn pages)Manage human resourcesRegister Employees and Modify Information (Learn pages)Register Employees and Modif…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Pages and codeunits on this table

Recent changes

Countries that replace it

ES

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.

Evidence 1 sources