Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Process Name

PL4B - Bulk Update Placements using TIS_Placement_ID

Comments
DescriptionAs a Local Office Admin
I want to Bulk update Placements using TIS_Placement_IDs as the only matching criteria
So that I can update any/all other fields on the Template.

ActorsHEE Admin
Pre-conditions

Logged in

Security allows access to Placement Manager

Trainees to exist on TIS already

Posts to exist on TIS already 

Placements to exists with the Specified TIS_Placement_ID/s


Post-conditions

Placement updated for a group of trainees


Process steps
  1. Access bulk upload screen
  2. Download template
  3. User completes template
  4. Upload completed spreadsheet
  5. System validates spreadsheet and presents validation errors if any
  6. System updates existing placements against trainees records based on spreadsheet values
    1. Where system finds matching Placement record on TIS based on the TIS_Placement_ID, the import will update the remaining fields where values have been specified on the template.
    2. Where system cannot find a matching Placement record on TIS, it will be flagged in the list of errors.
    3. where column headers have been left blank on the template, the import will ignore those and no action by the import to the specific columns.
    4. where an Intrepid_Id already exists against a matching placement and there are also values in the Intrepid_Id column of the template, an error will be produced in the Error report. 
  7. System will send/present confirmation when process completes
    1. Confirmation message is displayed on screen
    2. Confirmation of placement is recorded against Trainee record.
    3. where the update impacts on fields sent to ESR, appropriate changes will need to be staged to be sent in ESR Notifications. Please see ESR Notifications.

Please see column specification for  'TIS Placement Update Template' with: 

  • column headers, 
  • mandatory columns
  • fields relating to Matching Criteria or Update,
  • Validation rules for each

Placements - Field Validation#FieldValidation-Placements-BulkUpdateusingTIS_Placement_IDs

Blank Upload Template to be made available for download on TIS:

https://hee-tis.atlassian.net/wiki/download/attachments/532709384/TIS%20Placement%20Update%20Template.xls?version=1&modificationDate=1532006958610&cacheVersion=1&api=v2



Alternative flowPL4, PL10
Rules

Valid template with exact column headers downloaded from TIS to be used.

Structural errors to be validated for.

All fields must be completed with a valid response.

Rules and Validations for each column are specified here:

Placements - Field Validation#FieldValidation-Placements-BulkUpdateusingTIS_Placement_IDs


JIRA Reference
Jira Legacy
serverSystem JIRA
serverId4c843cd5-e5a9-329d-ae88-66091fcfe3c7
keyTISDEV-4441

Audit Log

Who uploaded the template and when.

Who added/updated a placement and when.


...