Table 5200 "Employee"

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

Learn documents this table through its pages: Page 30017 “APIV2 - Employees” (9 Learn pages), Page 20017 “APIV1 - Employees” (8), Page 5200 “Employee Card” (6), Page 5201 “Employee List” (3), Page 5228 “Misc. Articles Overview” (2).

Properties

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.

Keys

• Key1: No. (clustered)
• Key2: Search Name
• Key3: Status, Union Code
• Key4: Status, Emplymt. Contract Code
• Key5: Last Name, First Name, Middle Name

Events published

• OnBeforeGetFullName(Employee: Record Employee; var NewFullName: Text[100]; var Handled: Boolean) (integration)
• OnAfterValidateShortcutDimCode(var Employee: Record Employee; var xEmployee: Record Employee; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeAssistEdit(var Employee: Record Employee; xEmployee: Record Employee; var Result: Boolean; var IsHandled: Boolean) (integration)
• OnBeforeOnInsert(var Employee: Record Employee; var xEmployee: Record Employee; var IsHandled: Boolean) (integration)
• OnBeforeValidateShortcutDimCode(var Employee: Record Employee; var xEmployee: Record Employee; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeCheckBlockedEmployee(Employee: Record Employee; IsPosting: Boolean; var IsHandled: Boolean) (integration)
• OnBeforeValidateCity(var Employee: Record Employee; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
• OnBeforeValidatePostCode(var Employee: Record Employee; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
• OnModifyOnBeforeEmployeeSalespersonUpdate(var Employee: Record "Employee"; xEmployee: Record "Employee"; var IsHandled: Boolean) (integration)
• OnModifyOnBeforeEmployeeResourceUpdate(var Employee: Record "Employee"; xEmployee: Record "Employee"; var IsHandled: Boolean) (integration)
• OnBeforeSetEmployeeLedgEntryFilterByAccPeriod(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; var IsHandled: Boolean) + BC27 (integration)

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeleteEmployee, Codeunit 6908 “Expense Event Subscriber” OnAfterDeleteEmployeeEvent
• OnAfterRenameEvent: Codeunit 1173 “Document Attachment Mgmt” MoveAttachedDocumentsOnAfterRenameEmployee
• OnAfterValidateEvent(Company E-Mail): Codeunit 6908 “Expense Event Subscriber” OnAfterValidateCompanyEmailEvent
• OnAfterValidateEvent(First Name): Codeunit 6908 “Expense Event Subscriber” OnAfterValidateFirstNameEvent
• OnAfterValidateEvent(Job Title): Codeunit 6908 “Expense Event Subscriber” OnAfterValidateJobTitleEvent
• OnAfterValidateEvent(Last Name): Codeunit 6908 “Expense Event Subscriber” OnAfterValidateLastNameEvent
• OnAfterValidateEvent(Middle Name): Codeunit 6908 “Expense Event Subscriber” OnAfterValidateMiddleNameEvent
• OnBeforeDeleteEvent: Codeunit 6908 “Expense Event Subscriber” OnBeforeDeleteEmployeeEvent

Procedures

• AssistEdit(): Boolean
• FullName(): Text[100]
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
• DisplayMap()
• GetBankAccountNo(): Text
• CheckBlockedEmployeeOnJnls(IsPosting: Boolean)
• CheckAllowMultiplePostingGroups() + BC27

Plus 7 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• drill-down page Page 5201 “Employee List”
• lookup page Page 5201 “Employee List”
• Cost Center Code: TableRelation Table 1112 “Cost Center”
• Cost Object Code: TableRelation Table 1113 “Cost Object”
• SWIFT Code: TableRelation Table 1210 “SWIFT Code”
• Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
• Resource No.: TableRelation Table 156 “Resource”
• City: TableRelation Table 225 “Post Code” (conditional)
• Post Code: TableRelation Table 225 “Post Code” (conditional)
• No. Series: TableRelation Table 308 “No. Series”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
• Currency Code: TableRelation Table 4 “Currency”
• Currency Filter: TableRelation Table 4 “Currency”
• Payroll Currency Code: TableRelation Table 4 “Currency”
• Employee No. Filter: TableRelation Table 5200 “Employee”
• Manager No.: TableRelation Table 5200 “Employee”
• Alt. Address Code: TableRelation Table 5201 “Alternative Address”
• Cause of Absence Filter: TableRelation Table 5206 “Cause of Absence”
• Total Absence (Base): CalcFormula Table 5207 “Employee Absence”
• Comment: CalcFormula Table 5208 “Human Resource Comment Line”
• Union Code: TableRelation Table 5209 “Union”
• Cause of Inactivity Code: TableRelation Table 5210 “Cause of Inactivity”
• Emplymt. Contract Code: TableRelation Table 5211 “Employment Contract”
• Statistics Group Code: TableRelation Table 5212 “Employee Statistics Group”
• Grounds for Term. Code: TableRelation Table 5217 “Grounds for Termination”
• Employee Posting Group: TableRelation Table 5221 “Employee Posting Group”
• Balance: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
• Balance (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
• Nationality: TableRelation Table 5226 “Nationality”
• Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

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

• Table 5200 “Employee”: Employee No. Filter, Manager No.
• Table 5205 “Employee Relative”: Employee No., Relative’s Employee No.
• Table 5877 “Phys. Invt. Record Header”: Person Recorded, Person Responsible
• Table 5881 “Pstd. Phys. Invt. Record Hdr”: Person Recorded, Person Responsible
• Table 1384 “Employee Templ.”: Manager No.
• Table 1570 “G/L Entry Posting Preview”: Source No.
• Table 17 “G/L Entry”: Source No.
• Table 179 “Reversal Entry”: Source No.
• Table 181 “Posted Gen. Journal Line”: Source No.
• Table 5054 “Contact Business Relation”: No.
• Table 5201 “Alternative Address”: Employee No.
• Table 5203 “Employee Qualification”: Employee No.
• Table 5206 “Cause of Absence”: Employee No. Filter
• Table 5207 “Employee Absence”: Employee No.
• Table 5209 “Union”: No. of Members Employed
• Table 5211 “Employment Contract”: No. of Contracts
• Table 5214 “Misc. Article Information”: Employee No.
• Table 5216 “Confidential Information”: Employee No.
• Table 5219 “HR Confidential Comment Line”: No.
• Table 5222 “Employee Ledger Entry”: Employee No.
• Table 5223 “Detailed Employee Ledger Entry”: Employee No.
• Table 5224 “Payable Employee Ledger Entry”: Employee No.
• Table 5225 “Employee Payment Buffer”: Employee No.
• Table 5600 “Fixed Asset”: Responsible Employee
• Table 5875 “Phys. Invt. Order Header”: Person Responsible
• Table 5878 “Phys. Invt. Record Line”: Person Recorded
• Table 5879 “Pstd. Phys. Invt. Order Hdr”: Person Responsible
• Table 5882 “Pstd. Phys. Invt. Record Line”: Person Recorded
• Table 6788 “Withholding Tax Entry”: Employee No.
• Table 6794 “WHT Threshold Accumulator”: Employee No.
• Table 6840 “Spend Request”: Requested By
• Table 6912 “Expense Ledger Entry”: Employee No.
• Table 6923 “Expense User”: Employee Status
• Table 81 “Gen. Journal Line”: Source No.
• Table extension 5280 “Company Contact SAF-T”: Contact No. SAF-T

Pages and codeunits on this table

• Page 20017 “APIV1 - Employees” (source table)
• Page 30017 “APIV2 - Employees” (source table)
• Page 5200 “Employee Card” (source table)
• Page 5201 “Employee List” (source table)
• Page 5202 “Employee Picture” (source table)
• Page 5225 “Absence Overview by Periods” (source table)
• Page 5226 “Empl. Absences by Categories” (source table)
• Page 5228 “Misc. Articles Overview” (source table)
• Page 5229 “Confidential Info. Overview” (source table)
• Page 5231 “Absence Overview by Categories” (source table)
• Page 6917 “Employees API” (source table)
• Page 9247 “Abs. Overview by Period Matrix” (source table)
• Page 9271 “Qualification Overview Matrix” (source table)
• Page 9281 “Misc. Articles Overview Matrix” (source table)
• Page 9283 “Conf. Info. Overview Matrix” (source table)
• Page 979 “Time Sheet Setup Employees” (source table)

Extended by

• Table extension 6809 “WHT Employee Ext”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

• Codeunit 408 “DimensionManagement” (5 calls: OnDelete → DeleteDefaultDim, OnInsert → UpdateDefaultDim, OnRename → RenameDefaultDim, …)
• Page 456 “No. Series” (2 calls: AssistEdit → (object), OnInsert → (object))
• Codeunit 5200 “Employee/Resource Update” (1 call: OnModify → HumanResToRes)
• Codeunit 5201 “Employee/Salesperson Update” (1 call: OnModify → HumanResToSalesPerson)
• Codeunit 802 “Online Map Management” (1 call: DisplayMap → MakeSelectionIfMapEnabled)

Countries that replace it

CA, ES, FR, IT, MX, NL, RU, US

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). The call sections above are our own, per object, from the BC29 call graph. 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"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.