Employee Personal Details:
Data Source: TRN_EmployeePersonalDetails,
HST_TRN_EmployeePersonnelDetails
Stored Procedure: usp_TRN_EmployeePersonalDetails
Business Logic:
User can add, edit and delete employee personal details.
New Employee code (i.e. YYYYMMfourdigituniquecode 2013020001) has
been assigned to employee as a user name.
Employee code has been send to their personal Email Id with Password.
Person with any kind of disability also add, edit and delete their details.
Employee can search their data as various search options is available. I.e. by
Station, by Designation, by Name.
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Validations:
All mandatory fields are required.
If field Category is PH i.e. physically handicapped then disability section is
enabled for user to add, edit and delete details.
Children Details:
Data Source: TRN_ChildrenDetails,
HST_TRN_ChildrenDetails
Stored Procedure: usp_TRN_ChildrenDetails
Business Logic:
User can add, edit and delete Children details.
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Card Number:
Data Source: TRN_CardNo,
HST_TRN_CardNo
Stored Procedure: usp_TRN_CardNo
Business Logic:
User can add, edit and delete Card Number details.
Name of cards available from look up. i.e.LKP_Cards
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Residential and Contact Details:
Data Source: TRN_ResAddressPersContactDetails,
HST_TRN_ResAddressPersContactDetails
Stored Procedure: usp_TRN_ResAddressPersContactDetails
Business Logic:
User can add, edit and delete Residential and Contact details.
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Marital Details:
Data Source: TRN_MaritalDetails,
HST_TRN_MaritalDetails
Stored Procedure: usp_TRN_MaritalDetails
Business Logic:
User can add, edit and delete marital details.
All Marital Status details available from look up. i.e. LKP_MaritalStatus
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Photograph Details:
Data Source: TRN_EMPPhotoDetails,
HST_TRN_EMPPhotoDetails
Stored Procedure: usp_TRN_EMPPhotoDetails
Business Logic:
User can add, edit and delete Photo Details of family, upload thumb
impression and upload signature,.
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Certificate and Attestation:
Data Source: TRN_CertificatesAndAttestation,
HST_TRN_MaritalDetails
Stored Procedure: usp_TRN_CertificatesAndAttestation
Business Logic:
User can add, edit and delete certificate and attestation details.
All Types of certificate details available from master. i.e. MST_Certificates
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Previous Qualifying and Foreign Services:
Data Source: TRN_ResAddressPersContactDetails,
HST_TRN_ResAddressPersContactDetails
Stored Procedure: usp_PreviousQualifyingAndForeignServices
Business Logic:
User can add, edit and delete Previous Qualifying and foreign services.
Existing details of same employee has been display in Grid while select from
drop down of Employee.
Employee can search their data by Station.
Validations:
All mandatory fields are required.
Training Details:
Data Input
: LKP_organization
: LKP_Station
: MST_Station
Data Output : TRN_TrainingDetails,
HST_TRN_TrainingDetails
Stored Procedure: usp_TrainingDetails
Business Logic:
User can add, edit and delete Training Details.
User can fill some mandatory fields like title of course , Date from and date
to.
After fill these fields user click on save button .
After click on save button data will save in respective table.
Validations:
All mandatory fields are required.
Disciplinary Proceeding :
Data Input
: LKP_organization
: LKP_Station
: MST_Station
Data Output : TRN_DisciplinaryProceeding,
HST_TRN_ DisciplinaryProceeding
Stored Procedure: usp_TRN_DisciplinaryProceeding
Business Logic:
User can add, edit and delete Disciplinary Proceeding.
User can fill some mandatory fields like Date of Preliminary Inquiry
Report, Date of CVC Advice. Date of Initiation Discipinary Action.
After fill these fields user click on save button .
After click on save button data will save in respective table.
Validations:
All mandatory fields are required.
History Of Services:
Data Input
: LKP_Station
: MST_Station
Data Output : TRN_HistoryOfService,
HST_ TRN_HistoryOfService
Stored Procedure: USP_TRN_HistoryOfService
Business Logic:
Firstly user will do the add details then click on save button.
Here user can add multiple details of the user.
User can add, edit and delete History of Service.
User can fill some mandatory fields like Type Of Posting, Order No, Order
Date, Date From.
After fill these fields user click on save button .
After click on save button data will save in respective table.
Validations:
All mandatory fields are required.
Appointment Details:
Data Input
: LKP_Station
: MST_Station
: MST_Post
Data Output : TRN_AppointmentDetails,
HST_ TRN_AppointmentDetails
Stored Procedure: usp_Trn_AppointmentDetails
Business Logic:
User can add, edit and delete Appointment Details.
User can fill fields like Issuing Authority.
After fill these fields user click on save button .
After click on save button data will save in respective table.
Validations:
All mandatory fields are required.