born ontario: unaccomodated client upload. 2 building your file the file you wish to upload must be...
TRANSCRIPT
![Page 1: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/1.jpg)
BORN Ontario: Unaccomodated Client Upload
![Page 2: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/2.jpg)
2
Building Your File
• The file you wish to upload must be in a specific Excel layout.
• There are 8 mandatory columns and 16 conditional columns
• All column headers are mandatory and must be in the correct order
![Page 3: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/3.jpg)
3
Building Your File – Mandatory Fields• TPA, MPG, FirstName, LastName, DateOfBirth,
PostalCode, EstimateDeliveryDate, RequestDate
• All dates must be entered in the format YYYYMMDD. Example: 20130927
• The Postal Code must be entered with no spaces
![Page 4: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/4.jpg)
4
Building Your File – Mandatory Fields• If you do not have a client’s date of birth
please use 19000101• If you do not have a client’s postal code or
they are from out of the country, please use the postal code of your practice group.
![Page 5: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/5.jpg)
5
Building Your File – Conditional Fields• PracticeFull, DistanceCatchment,
OtherReasons, HospitalIntegrationIssue, Hospital1, Hospital1Issue, Hospital1issueOther, Hospital2, Hospital2Issue, Hospital2issueOther, Hospital3, Hospital3Issue, Hospital3issueOther, Hospital4, Hospital4Issue, Hospital4issueOther
![Page 6: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/6.jpg)
6
Building Your File – Field Rules• You must select 1 of the 4 main reasons (i.e.
PracticeFull, DistanceCatchment, OtherReasons, or HospitalIntegrationIssue)
• Enter the letter Y in the column that applies to the reason the client was unaccomodated
• Leave the column blank if the reason does not apply
• If OtherReasons is selected, you may enter up to 100 characters for the reason
![Page 7: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/7.jpg)
7
Building Your File – Field Rules
• Example:
PracticeFull DistanceCatchment OtherReasons HospitalIntegrationIssue
Y
Y
Enter reason here
Y
![Page 8: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/8.jpg)
8
Building Your File – Field Rules• If you select HospitalIntegrationIssue you may
supply reasons for up to 4 hospitals• You must supply details for at least 1 hospital• When selecting the hospital, you must enter
the correct 4 digit reference code NOT the hospital name.
• When entering the reason you must enter the appropriate reference code OR up to 100 characters for the “other” reason.
![Page 9: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/9.jpg)
9
Building Your File – Field Rules• Hospital Integration Issue Codes:
Pick List Value Pick List item
1 lack of privleges
2 cap on number of births
![Page 10: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/10.jpg)
10
Building Your File – Field Rules
• Example:
HospitalIntegrationIssue Hospital1 Hospital1issue Hospital1IssueOther
Y 1936 1
Y 1777 2
Y 1661 Enter reason here
![Page 11: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/11.jpg)
11
Upload Screen
• When you have logged in to the invoice system click the Un-accom Client tab
• You will presented with 4 sub-options, select Upload File
![Page 12: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/12.jpg)
12
Upload Screen
• On the next screen click Browse to find the file you wish to upload.
![Page 13: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/13.jpg)
13
Upload Screen
• An dialog box will open that will let you navigate to where you have saved you Excel file.
• Once you have selected your file click the Upload File button.
![Page 14: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/14.jpg)
14
Upload Screen
• An dialog box will open that will let you navigate to where you have saved you Excel file.
• Once you have selected your file click the Upload File button.
![Page 15: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/15.jpg)
15
Upload Screen
• If the upload is successful you will receive a message showing the number of records uploaded.
![Page 16: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/16.jpg)
16
Upload Screen
• A copy of what you have uploaded will be displayed on the screen for verification.
![Page 17: BORN Ontario: Unaccomodated Client Upload. 2 Building Your File The file you wish to upload must be in a specific Excel layout. There are 8 mandatory](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649e665503460f94b617e5/html5/thumbnails/17.jpg)
17
File Specifications
The specifications needed to build your Excel file and the associated reference codes is posted on the BORN Ontario Website:
http://www.bornontario.ca/born-information-system/data-entry-training/
Under the Midwifery section – Training Tools
Microsoft Excel 97-2003 Worksheet