Spreadsheet: 140046d1328608118-returning-specific-values-based-on-multiple-criteria-in-a-tablewith-duplicate-entries-training-records-with-compliance-summary
Sheet: Column Descriptions

Column Header | Description
Salary Number | The employee ID number issued by the bank
Surname | Last name as per employee records.
Firstname | Given name(s) as per employee records.
Business Unit | The functional line to which the employee's team belongs. These are the 7 business units; Business Financial Services (BFS) - Formerly Business banking or Sales Consumer Financial Services (CFS) - Retail Network (branches, service centres, etc) Finance & Treasury People & Performance - Human Resources and Learning & Levelopment Information Technology - Applications Support Credit & Risk Operations
Branch/Department | The location of the employee's immediate team. Eg. [NAME], Nadi Branch, Vaitele Branch, L&D, Credit, Marketing, etc
Course ID # | When any of the cells in this column are selected, a search window will pop-up. Use this window to correctly select the appropriate learning event and follow the instructions. After selecting the resource name, the spreadsheet will automatically fill in the columns marked; [NAME]: If you select "OTJ0000", "EXT0000" or "TS0000" as your course code, you will need to fill in the column marked "External or Informal Learning event Name" Learning Event Name - Note: If you have selected "OTJ0000", "EXT0000 or "TS0000", this cell will remain blank. Data Entry Date
Learning Type | There are 6 types of learning events that are listed. Most of the learning that takes place will fall into one of these categories: Note: Make a decision where necessay if you are unsure where the learning event should be recorded. Alternatively, check with your fellow L&D team members across countries to ensure uniformity.
 | Self-Study - Any resource taken from the L&D library that has been completed by an employee. These include the books and interactive CD's that are available. An assessment must be completed for all entries in this category. This category may also include self-study modules outside of our library and driven through local government agencies.
 | On-The-Job - This category can be further broken down to include various learning events that are done on-the-job. These include; Induction Forms Internal "Informal" workshops. These are learning events that do not have a formal approach (not included in the L&D resource list and not an External Workshop) where the attendance form is filled, but no feedback is taken. Most of these sessions are conducted in a group setting.  Some examples are;  product knowledge training, information sessions on OHS training, "Technology Code of Use", "Code of Conduct", Induction Forms/Checklists, ?????????????????.)
 | Cross Learning Through Relief - Working outside of the normal role for a fixed period. A "Relief Appraisal" must be submitted to HR and a copy sent to L&D for recording in these cases.
 | Coaching - Are the 1-to-1 sessions regarding any Coaching that the employee may have undertaken as part of learning.
 | Internal Formal Workshops - This includes all of the facilitated sessions that are included in the L&D Resource List. An attendance form as well as an evaluation form must be completed for all of these sessions. A certificate will also be issued after the learning event.
 | Tertiary Education (Study Assistance Scheme) - All approved tertiary units and/or qualifications. The "Course Briefing" form can be used to capture this data. It must be accompanied by a copy of the transcript/qualification as well as being signed off from HR. Please use your discretion when calculating the hours to be included.
External or Informal Learning event Name | This column should only be filled if the Course Code is "OTJ0000", "EXT0000 or "TS0000".
Learning Hours | The number of Learning Hours that the Learning Event took for completion. Should you require it, there is a minute-to-hour calculator located in the top row of the spreadsheet to help you.
Assessment Result | Only to be filled if an assessment has been completed as in the case of Self-study [NAME].
Data Entry Date | This will be automatically filled. Do not enter anything into this column.
Date Completed | The completion date of the learning event. The date format should be; DD/MM/YYYY
Certificate Delivered (Date) | If a certificate has been issued, then the date of issue is to be entered here.
Facilitator | The name of the facilitator (for resource completion, facilitator is "Self)
Information new | Ratings ranged through 25%, 50%, 75% and 100%. These are recorded on the feedback form.
Inforumation used
Reflector | Ratings to be recorded from the feedback form. These are;  Excellent, Good, Fair and Poor.
Theorist
Pragmatist
Activist
Overall Rating
What worked well | Comments recorded on the feedback form
What could be improved
Any Suggestions or Comments