Diagrams


Table

Human Resource Comment Line

DynamicsDocs.comHuman Resource Comment Line«Table 5208»Human Resource Comment LineTable Name; [Employee,Alternative Addr...No. [PK]Table Line No. [PK]Alternative Address Code [PK]Line No. [PK]DateCodeComment«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 5201»Alternative AddressEmployee No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeCountyPhone No.Fax No.E-MailCommentCountry/Region Code«Table 5203»Employee QualificationEmployee No. [PK,NN]Line No. [PK]Qualification CodeFrom DateTo DateType; [,Internal,External,Previous Pos...DescriptionInstitution/CompanyCostCourse GradeEmployee Status; [Active,Inactive,Term...CommentExpiration Date«Table 5214»Misc. Article InformationEmployee No. [PK,NN]Misc. Article Code [PK,NN]Line No. [PK]DescriptionFrom DateTo DateIn UseCommentSerial No.«Table 5216»Confidential InformationEmployee No. [PK,NN]Confidential Code [PK,NN]Line No. [PK,NN]DescriptionComment«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 5205»Employee RelativeEmployee No. [PK,NN]Line No. [PK]Relative CodeFirst NameMiddle NameLast NameBirth DatePhone No.Relative's Employee No.Comment<No.><No.><Alternative Address Code><No.><No.><No.><No.><No.><Alt. Address Code><Employee No.><Manager No.><Employee No. Filter><Employee No.><Employee No.><Relative's Employee No.><Employee No.><Employee No.><Employee No.>

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

Fields

# Name Type
1 Table Name Option
2 No. Code20
3 Table Line No. Integer
4 Alternative Address Code Code10
6 Line No. Integer
7 Date Date
8 Code Code10
9 Comment Text80

Keys

# Fields
0 Table Name,No.,Table Line No.,Alternative Address Code,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Alternative Address Code Alternative Address Code 1..n
No. Confidential Information Employee No. 1..n
No. Employee No. 1..n
No. Employee Absence Employee No. 1..n
No. Employee Qualification Employee No. 1..n
No. Employee Relative Employee No. 1..n
No. Misc. Article Information Employee No. 1..n

Table Relations From Other Tables

From Table From Field