Table 5207 "Employee Absence"
Base Application · Microsoft.HumanResources.Absence
Across versions
- BC23present
- BC24declaration changed
- BC251 events added
- BC26-27unchanged
- BC2810 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.HumanResources.Absence · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5211 “Employee Absences” (3 Learn pages), Page 5212 “Absence Registration” (2).
Properties
| Property | Value |
|---|---|
| Caption | Employee Absence |
| 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 | Entry No. | Integer | — | |
| 3 | From Date Δ BC28 | Date | Specifies the first day of the employee’s absence registered on this line. | |
| 4 | To Date Δ BC28 | Date | Specifies the last day of the employee’s absence registered on this line. | |
| 5 | Cause of Absence Code Δ BC28 | Code[10] | Specifies a cause of absence code to define the type of absence. | TableRelation Table 5206 “Cause of Absence” (Cause of Absence) |
| 6 | Description Δ BC28 | Text[100] | Specifies a description of the absence. | |
| 7 | Quantity Δ BC28 | Decimal | Specifies the quantity associated with absences, in hours or days. | |
| 8 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5220 “Human Resource Unit of Measure” (Human Resource Unit of Measure) |
| 11 | Comment Δ BC28 | Boolean | Specifies if a comment is associated with this entry. | FlowField: exist(“Human Resource Comment Line” where(“Table Name” = const(“Employee Absence”), “Table Line No.” = field(“Entry No.”))); not editable |
| 12 | Quantity (Base) Δ BC28 | Decimal | Specifies the quantity associated with absences, in hours or days. via Page 5211 “Employee Absences” | |
| 13 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Employee No., From Date
- Key3: Employee No., Cause of Absence Code, From Date
- Key4: Cause of Absence Code, From Date
- Key5: From Date, To Date
Events published
OnBeforeOnInsert(var EmployeeAbsence: Record "Employee Absence"; var IsHandled: Boolean)+ BC25 (integration)
Procedures
1 local procedures, no public ones.
Triggers
OnInsert
Relations
- drill-down page Page 5211 “Employee Absences”
- lookup page Page 5211 “Employee Absences”
- Employee No.: TableRelation Table 5200 “Employee”
- Cause of Absence Code: TableRelation Table 5206 “Cause of Absence”
- Comment: CalcFormula Table 5208 “Human Resource Comment Line”
- Unit of Measure Code: TableRelation Table 5220 “Human Resource Unit of Measure”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 5200 “Employee”: Total Absence (Base)
- Table 5206 “Cause of Absence”: Total Absence (Base)
Pages and codeunits on this table
- Page 5211 “Employee Absences” (source table)
- Page 5212 “Absence Registration” (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 Absence"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.