Cognos data import: Difference between revisions

Line 20:

=== newly encountered units ===

If a unit is encountered that isn't in [[s_Cognos_Units table]], an email will be sent to Tina. ~~The~~ new unit then needs to be added to [[s_Cognos_Units table]] ~~with~~ the ~~other~~ fields ~~filled in appropriately~~. [[~~Boarding Loc~~]] and [[~~Level of care hierarchy~~]]/[[s_level_of_care table]] ~~entries need to be considered to see if they need to be updated~~.

If a unit is encountered that isn't in [[s_Cognos_Units table]], an email will be sent to Tina and Herman. One of them will contact a data collector at the site where the new unit appeared to find out whether this is a unit we collect.

Regardless whether we collect the new unit, the new unit then needs to be added to [[s_Cognos_Units table]], see more info there about what the fields mean.

If the unit is one we collect then [[Level of care hierarchy]] needs to be determined (discuss with Julie if not clear) and entries need to be added to [[Boarding Loc]] and [[s_level_of_care table]].

=== newly encountered services ===

If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. ~~The~~ new service ~~then~~ needs to be added to [[s_Cognos_Services table]] ~~with~~ the ~~other~~ fields ~~filled in appropriately~~. [[Service tmp entry]] ~~entries need to be considered to see if they need to be updated~~.

If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina and Herman. One of them will contact a data collector at the site where the new service is located to find out if this is a service we collect.

Regardless whether we collect the new unit, the new service needs to be added to [[s_Cognos_Services table]], see more info there about what the fields mean.

If the service is one we collect then it needs to be added to [[Service tmp entry]] options.

== Known problems with data import ==

@@ Line 20: / Line 20: @@
 === newly encountered units ===
-If a unit is encountered that isn't in [[s_Cognos_Units table]], an email will be sent to Tina. The new unit then needs to be added to [[s_Cognos_Units table]] with the other fields filled in appropriately. [[Boarding Loc]] and [[Level of care hierarchy]]/[[s_level_of_care table]] entries need to be considered to see if they need to be updated.
+If a unit is encountered that isn't in [[s_Cognos_Units table]], an email will be sent to Tina and Herman. One of them will contact a data collector at the site where the new unit appeared to find out whether this is a unit we collect.
+Regardless whether we collect the new unit, the new unit then needs to be added to [[s_Cognos_Units table]], see more info there about what the fields mean.
+If the unit is one we collect then [[Level of care hierarchy]] needs to be determined (discuss with Julie if not clear) and entries need to be added to [[Boarding Loc]] and [[s_level_of_care table]].
 === newly encountered services ===
-If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. The new service then needs to be added to [[s_Cognos_Services table]] with the other fields filled in appropriately. [[Service tmp entry]] entries need to be considered to see if they need to be updated.
+If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina and Herman. One of them will contact a data collector at the site where the new service is located to find out if this is a service we collect.
+Regardless whether we collect the new unit, the new service needs to be added to [[s_Cognos_Services table]], see more info there about what the fields mean.
+If the service is one we collect then it needs to be added to [[Service tmp entry]] options.
 == Known problems with data import ==