Chart PUR Import Options

Chart PUR Import Options

The following options are allowed. Any other options are unsupported and will be rejected.

Insert Options

• REVISE
• INSERT
• DELETE_THEN_INSERT

Blank Options

• DELETE_BLANK
• IGNORE_BLANK

Distinct Options

DISTINCT is implied for all user patient records

Default Options

For user patient records, the default options are REVISE and DELETE_BLANK..

Examples

The following scenario provides examples of each type of processing possible for PUR import.

Initial Data

We will start with the contents of File: GenericImportTestPUR A.csv .

@patient_mrns.MR,patients.first_name,patients.last_name,patients.birth_date,patients.username,@pur.Supervisor.id,@pur.Supervisor.id_type,@pur.Administrative Assistant.id,@pur.Administrative Assistant.id_type,users.universal_id

1111,Test1,Employee,01/01/2001,user1,,,user8,id:username,11

2222,Test2,Employee,02#02#2002,user2,user1,id:username,user9,id:username,22

3333,Test3,Employee,03/03/2003,user3,user1,id:username,,,33

4444,Test4,Employee,04-04-2004,user4,user2,id:username,,,44

5555,Test5,Employee,05/05/2005,user5,user2,id:username,,,55

6666,Test6,Employee,06/06/2006,user6,user3,id:username,,,66

7777,Test7,Employee,07/07/2007,user7,user3,id:username,,,77

8888,Test8,Employee,08/08/2008,user8,user2,id:username,,,88

9999,Test9,Employee,09/09/2009,user9,user3,id:username,,,99

After this file is loaded:

• user1 is the supervisor of user2 and user3
• user2 is the supervisor of user4, user5, and user8
• user3 is the supervisor of user6, user7, and user9
• user8 is the administrative assistant of user1
• user9 is the administrative assistant of user2

Import Updated Data

The data will be changed by importing another file:GenericImportTestPUR B.csv.

@patient_mrns.MR,patients.first_name,patients.last_name,patients.birth_date,patients.username,@pur.Supervisor.id,@pur.Supervisor.id_type,DELETE_THEN_INSERT @pur.Administrative Assistant.1.id,@pur.Administrative Assistant.1.id_type,INSERT IGNORE_BLANK @pur.Administrative Assistant.2.id,@pur.Administrative Assistant.2.id_type,users.universal_id

1111,Test1,Employee,01/01/2001,user1,,,,,,,11

2222,Test2,Employee,02#02#2002,user2,user3,id:username,user9,id:username,,,22

3333,Test3,Employee,03/03/2003,user3,,,user8,id:username,user4,id:username,33

4444,Test4,Employee,04-04-2004,user4,user3,id:username,,,,,44

5555,Test5,Employee,05/05/2005,user5,user2,id:username,,,,,55

6666,Test6,Employee,06/06/2006,user6,user4,id:username,,,,,66

7777,Test7,Employee,07/07/2007,user7,user4,id:username,,,,,77

8888,Test8,Employee,08/08/2008,user8,user2,id:username,,,,,88

9999,Test9,Employee,09/09/2009,user9,user2,id:username,,,,,99

Import Logic

The imported file is processed as follows:

Supervisor

No options are specified, so the default options of REVISE and DELETE_BLANK are used. Changes to the Supervisor role are as follows:

• user1 is not a supervisor anymore
• user2 is the supervisor for user5, user8, and user9
• user3 is the supervisor for user2 and user4
• user4 is the supervisor for user6 and user7

Administrative Assistant (1)

The DELETE_THEN_INSERT option is used. Changes to the the Administrative Assistant role are as follows:

• user8 is the administrative assistant for user3
• user9 is the administrative assistant for user2

Administrative Assistant (2)

The INSERT and IGNORE_BLANK options are used. Changes to the Administrative Assistant role are as follows:

• user4 is also an administrative assistant for user3

Related Pages

Chart Data CSV Header Options