Get documents about "Master Employee Data
Description
Master Employee Data document sample
Document Sample
Table : 1
EMPLOYEE MASTER DATA
1 Employee Number
2 Salutation
3 First Nam
4 Middle Name
5 Last Name
6 Gender
7 Date of Birth
8 Blood Group
9 Appointment Category
10 Employee Category
11 Sub-Category
12 PH Category
13 PH Category Percentage
14 Appointment Date
15 ESIC Joining Date
16 Mother Toungue
17 Group
18 Cadre Type
19 Regional/ All-India Cadre
20 Cadre
21 Designation
22 Office Type
23 Office Name
24 Office State
25 Office District
26 Office Address
Substantive
27 Division Name
28 Branch Name
29 Controlling Officer's First Name
30 Controlling Officer's Middle Name
31 Controlling Officer's Last Name
32 Controlling Officer's Office Type
33 Controlling Officer's Office Name
34 Supervising Officer's First Name
35 Supervising Officer's Middle Name
36 Supervising Officer's Last Name
37 Supervising Officer's Office Type
38 Supervising Officer's Office Name
39 Officiating Group
40 Officiating Cadre Type
41 Regional/ All-India Cadre
42 Officiating Cadre
43 Officiating Designation
44 Office Type
45 Office Name
46 Office State
47 Office District
OFFICIATING
48 Office Address
49 Division Name
50 Branch Name
51 Controlling Officer's First Name
52 Controlling Officer's Middle Name
53 Controlling Officer's Last Name
54 Controlling Officer's Office Type
55 Controlling Officer's Office Name
56 Supervising Officer's First Name
57 Supervising Officer's Middle Name
58 Supervising Officer's Last Name
59 Supervising Officer's Office Type
60 Supervising Officer's Office Name
61 Uniform Provided (Y/N)
62 Recruitment Method
63 Employment Type
64 Employee Status
65 Suspended (Y/N)
Suspension Details effecing Payroll
66 and other items
Seperation Type (If Employee Status
67 = Seperated)
Seperation Date (If Employee Status
68 = Seperated)
69 Marital Status
70 Father's Name
71 Height
72 Identification Marks
73 Religion
74 Sect/ Cast
75 Nationality
town Details
Home 76 State
77 District
78 Area Type
79 Area
80 Date of Fixation
Fixed Pay
81 Pay Band
82 Pay Band Value
83 Grade Pay
84 Pay Band Value
85 State
86 District
87 Area Type
Residential
88 Area
Details
89 Address
90 PIN Code
91 Phone Number
92 Residential Number
93 Bank Name
94 Bank Branch
95 State
Bank Details
96 District
97 Bank Address
98 PIN Code
99 Account Number
100 MICR Code
101 IFSC Code
Details
102 GPF/ PF Account Numer
GPF
103 GPF/ PF Balance
2. Pay Fixations 3. Transfer
1 Employee_Number 1 Employee_Number
2 Employee_First_Name 2 Employee_First_Name
3 Employee_Middle_Name 3 Employee_Middle_Name
4 Employee_Last_Name 4 Employee_Last_Name
5 Reason for Fixation 5 Transfer Mode
Reference/ Order Number (For Reason for
6 fixation) 6 Transfer Type
Increment Amount (If Reason for Fixation =
7 Increment 7 Reference (If Transfer Mode = Public Interest)
No. Of Increments (If Reason for Fixation =
8 increment) 8 Transfer Order Number
9 Fixation Date 9 From_State
10 Old Pay Band 10 From_District
11 Old Grade Pay 11 From_Office
12 Old Pay Band Value 12 From_Office_Type
13 New Pay Band 13 Releaving Date
14 New Grade Pay 14 To_State
15 New Pay Band Value 15 To_District
16 Effective Date 16 To_Office
17 Arrear Date (if applicable) 17 To_Office_Type
18 Charge Takeover Date
4. Promotions
1 Employee_Number 5. Adhoc Promotion
2 Employee_First_Name 1 Employee_Number
3 Employee_Middle_Name 2 Employee_First_Name
4 Employee_Last_Name 3 Employee_Middle_Name
5 Promotion Order Number 4 Employee_Last_Name
6 Promotion Date 5 Promotion Order Number
7 From_Cadre 6 Promotion Date
8 From_Designation 7 From_Cadre
9 To_Cadre 8 From_Designation
10 To_Designation 9 To_Cadre
11 Transfer Applicable (Y/N) 10 To_Designation
12 If Yes, then add "Transfers" sheet 11 Transfer Applicable (Y/N)
12 If Yes, then add "Transfers" sheet
6. Demotion
1 Employee_Number 8. Nominee - Pension
2 Employee_First_Name 1 Employee_Number
3 Employee_Middle_Name 2 Employee_First_Name
4 Employee_Last_Name 3 Employee_Middle_Name
5 Demotion Order Number 4 Employee_Last_Name
6 Demotion Date 5 First_Name
7 From_Cadre 6 Last_Name
8 From_Designation 7 Gender
9 To_Cadre 8 Date_of_Birth
10 To_Designation 9 Nationality
11 Transfer Applicable (Y/N) 10 Relation
12 If Yes, then add "Transfers" sheet 11 Percentage
9. Nominee - GPF/CPF
1 Employee_Number 10. Nominee - DCRG
2 Employee_First_Name 1 Employee_Number
3 Employee_Middle_Name 2 Employee_First_Name
4 Employee_Last_Name 3 Employee_Middle_Name
5 First_Name 4 Employee_Last_Name
6 Last_Name 5 First_Name
7 Gender 6 Last_Name
8 Date_of_Birth 7 Gender
9 Nationality 8 Date_of_Birth
10 Relation 9 Nationality
11 Percentage 10 Relation
11 Percentage
7. Family Details
1 Employee_Number
2 Employee Employee_First_Name
3 Details Employee_Middle_Name
4 Employee_Last_Name
5 First_Name
6 Last_Name
7 Gender
8 Date_of_Birth
9 Nationality
10 Relationship
11 Marriage Date
Family
Member
12 Spouse Govt Employee (Y/N)
13 Details Date when became PH
14 PH Category
15 PH Category Percentage
16 Dependency Start Date
17 Dependency End Date
Eligibility for Medical Benefits
18 (Y/N)
11. Asset 13. Reimbursement
1 Employee_Number 1 Employee_Number
2 Employee_First_Name 2 Employee_First_Name
3 Employee_Middle_Name 3 Employee_Middle_Name
4 Employee_Last_Name 4 Employee_Last_Name
5 Asset Type 5 Reimbursment Type
6 Asset Value 6 Opening Balance Amount
7 Asset Buying Date
12. Quarters 14. Loans & Advances
1 Employee_Number 1 Employee_Number
2 Employee_First_Name 2 Employee_First_Name
3 Employee_Middle_Name 3 Employee_Middle_Name
4 Employee_Last_Name 4 Employee_Last_Name
5 State 5 Loan/ Advance Type
6 District 6 Status
7 Area Type 7 Request Date
8 Area 8 Sanctioned Date
9 Colony Name 9 Sanctioned Amount
10 Building Name 10 No. of EMI
11 Building Number 11 Paid EMIs
12 Quarter Type 12 EMI Amount
13 Quarter Area (Sq Mt) 13 Total Paid Amount till Date
14 Quarter Number 14 Remaining Amount
15 Floor Number 15 EMI Deduction Start Date
16 Care Taker Number 16 EMI Deduction End Date
17 Occupied (Y/N)
18 Allocation Date
19 Surrender Date (expected)
20 Quarter Allocation Number/ Order Number
15. Vigilance 16. Leave Particulars
1 Employee_Number 1 Employee_Number
2 Employee_First_Name 2 Employee_First_Name
3 Employee_Middle_Name 3 Employee_Middle_Name
4 Employee_Last_Name 4 Employee_Last_Name
5 Chief Vigilance Officer 5 Leave Type
6 Vigilance Officer 6 Opening Balance
7 Departmental Enquiry Officer 7 Encashment Availed in the current year (Y/N)
8 Presenting Officer 8 Leaves Availed in Current Month
Leaves Availed in Current Year (With Reason &
9 Case Start Date 9 Purpose)
10 Status Open 10 Total Leaves Availed in Service Period
No. of Leaves availed which are suppose to set-
11 Suspension Date (If Any) 11 off against HPL
12 Suspension Order Number (If Any) 12 Leaves Availed in Current Block
Total Leaves Availed in Service Period with
13 Suspension Order Details 13 Disablity Type
If the above is more than 120 days, then no. of
14 Penalty (Major/Minor) 14 days in current month
15 Actual Penalty Imposed
End Date of the imposed Penalty if
16 applicable
17 Case Details 17. New Pension Scheme
1 Employee Number
2 First Name
3 Middle Name
4 Last Name
5 NPS Registration Number
6 Employee Contribution
Signature : 7 ESIC Contribution
Date : 8 Month
9 Year
10 Interest Amount
