Diagrams


Table

Cause of Absence

DynamicsDocs.comCause of Absence«Table 5206»Cause of AbsenceCode [PK,NN]DescriptionUnit of Measure CodeTotal Absence [Base]Global Dimension 1 FilterGlobal Dimension 2 FilterEmployee No. FilterDate Filter«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 5207»Employee AbsenceEmployee No. [NN]Entry No. [PK]From DateTo DateCause of Absence CodeDescriptionQuantityUnit of Measure CodeCommentQuantity [Base]Qty. per Unit of Measure«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«Table 955»Time Sheet Line ArchiveTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 956»Time Sheet Detail ArchiveTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...PostedDocument No.Posting Date«Table 5220»Human Resource Unit of MeasureCode [PK,NN]Qty. per Unit of Measure«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time<Unit of Measure Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Employee No. Filter><Cause of Absence Filter><Cause of Absence Code><Cause of Absence Code><Cause of Absence Code><Cause of Absence Code><Cause of Absence Code><Manager No.><Employee No. Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Employee No.><Unit of Measure Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Unit of Measure Code Code10
4 Total Absence (Base) Decimal (0:5) Editable: No
FlowField
5 Global Dimension 1 Filter Code20 FlowFilter
6 Global Dimension 2 Filter Code20 FlowFilter
7 Employee No. Filter Code20 FlowFilter
8 Date Filter Date FlowFilter

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Filter Dimension Value Code 1..n
Employee No. Filter Employee No. 1..n
Unit of Measure Code Human Resource Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field
Employee Cause of Absence Filter 1..n
Employee Absence Cause of Absence Code 1..n
Time Sheet Detail Cause of Absence Code 1..n
Time Sheet Detail Archive Cause of Absence Code 1..n
Time Sheet Line Cause of Absence Code 1..n
Time Sheet Line Archive Cause of Absence Code 1..n