Table 5206 "Cause of Absence"
Base Application · Microsoft.HumanResources.Absence
Across versions
- BC23present
- BC241 fields changed
- BC25-27unchanged
- BC284 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.HumanResources.Absence · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Cause of 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 | Code Δ BC28 | Code[10] | Specifies a cause of absence code. | NotBlank |
| 2 | Description Δ BC28 | Text[100] | Specifies a description for the cause of absence. | |
| 3 | 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) |
| 4 | Total Absence (Base) Δ BC24 Δ BC28 | Decimal | Specifies the total number of absences (calculated in days or hours) for all employees. via Page 5210 “Causes of Absence” | FlowField: sum(“Employee Absence”.“Quantity (Base)” where(“Cause of Absence Code” = field(Code), “Employee No.” = field(“Employee No. Filter”), “From Date” = field(“Date Filter”))); not editable |
| 5 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))); FlowFilter |
| 6 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))); FlowFilter |
| 7 | Employee No. Filter | Code[20] | — | TableRelation Table 5200 “Employee”; FlowFilter |
| 8 | Date Filter | Date | — | FlowFilter |
Keys
- Key1: Code (clustered)
Relations
- drill-down page Page 5210 “Causes of Absence”
- lookup page Page 5210 “Causes of Absence”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- Employee No. Filter: TableRelation Table 5200 “Employee”
- Total Absence (Base): CalcFormula Table 5207 “Employee Absence”
- Unit of Measure Code: TableRelation Table 5220 “Human Resource Unit of Measure”
Referenced by
6 fields in 6 objects relate to this table (TableRelation or CalcFormula).
- Table 5200 “Employee”: Cause of Absence Filter
- Table 5207 “Employee Absence”: Cause of Absence Code
- Table 951 “Time Sheet Line”: Cause of Absence Code
- Table 952 “Time Sheet Detail”: Cause of Absence Code
- Table 955 “Time Sheet Line Archive”: Cause of Absence Code
- Table 956 “Time Sheet Detail Archive”: Cause of Absence Code
Pages and codeunits on this table
- Page 5210 “Causes of Absence” (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: "Cause of Absence"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.