relationships for lms
DESCRIPTION
relaTRANSCRIPT
-
Relationships for LMS
03 June 2015
Department_Table
Employee_Master_Table
Grade_No_Table
Leave_Balance_TableLeave_Master_Table
Leave_Transaction_Table
Department_Code
Department_Name
Head_Of_Department
No_Of_Employees
Phone_No1
Phone_No2
Location
Emp_Code
Emp_Name
Gender
Address
Date_Of_Birth
Email
Phone_No
Dept_Code
Grade_No
Designation
Qualification
No_Of_Years_Experience
Date_Of_Joining
Grade_No
Grade_Desc
Effective_Date
Serial_No
Emp_Code
Department_Code
Leave_Code
Leave_Balance
Total_Leave_Balance
Leave_Code
Leave_Desc
No_Of_Days
Grade_No
Trans_No
Emp_Code
Department_Code
Leave_Code
Start_Date
End_Date
No_Of_Days
Reason_For_Leave
Approval_Authorization