Change Priorities: Difference between revisions

Line 17:

==Run these on Live CFE after testing on copy and passing the SAS check up==

===ARF data fix: "enter 0,1 to yes, no."===

===CFE ARF data fix: "enter 0,1 to yes, no."===

* 1_use_only_ARF_fix - show Pagasa. Discuss after July 2 with trish (this has to do with created variables showing Yes, No, 0, -1 when all should either be -1 or 0.

**P + T tested query on copy of CFE on Tue 2014-07-29 16:59 (see email) - reported back to tina & julie that it works. SAS is happy also. --[[User:TOstryzniuk|Trish Ostryzniuk]] 18:09, 2014 July 30 (CDT)

===CFE FIX DX casing===

*1_use_only_fix_dx_casing

**P+T tested- check passed on copy of CFE and SAS - July 28.14

===CFE transfer dates 3000 to null===

*1_use_only_update_3000_transfer_dates_to_null

**P+T tested - passed on copy of CFE and SAS - July 28.14

===CFE upper casing vetted to Vetted===

*vet_all_sent (is this the query?)

*vet_all_sent (is this the query name?)

*fix to upper casing in record status field vetted vs Vetted to first letter always capital

**P+T check with SAS. Passed. all vetted changed to '''V'''etted

===CFE med apache NULL values AFTER Dec 31.06===

*1_use_med_apache_null_after_SAP

**P+T found some things with SAS in in copy of CFE- not ready to run on live. Tina to review with Trish.

**P+T found some things with SAS in in copy of CFE- not ready to run on live. Tina to review with Trish. Trish sent Tina email.

===TMP re-import / data changes:===

@@ Line 17: / Line 17: @@
 ==Run these on Live CFE after testing on copy and passing the SAS check up==
-===ARF data fix: "enter 0,1 to yes, no."===
+===CFE ARF data fix: "enter 0,1 to yes, no."===
 * 1_use_only_ARF_fix - show Pagasa.  Discuss after July 2 with trish (this has to do with created variables showing Yes, No, 0, -1 when all should either be -1 or 0.
 **P + T tested query on copy of CFE on Tue 2014-07-29 16:59 (see email) - reported back to tina & julie that it works.  SAS is happy also. --[[User:TOstryzniuk|Trish Ostryzniuk]] 18:09, 2014 July 30 (CDT)
+===CFE FIX DX casing===
 *1_use_only_fix_dx_casing
 **P+T tested- check passed  on copy of CFE and SAS - July 28.14
+===CFE transfer dates 3000 to null===
 *1_use_only_update_3000_transfer_dates_to_null
 **P+T tested - passed on copy of CFE and SAS - July 28.14
+===CFE upper casing vetted to Vetted===
-*vet_all_sent (is this the query?)
+*vet_all_sent (is this the query name?)
 *fix to upper casing in record status field vetted vs Vetted to first letter always capital
 **P+T check with SAS.  Passed. all vetted changed to '''V'''etted
+===CFE med apache NULL values AFTER Dec 31.06===
 *1_use_med_apache_null_after_SAP
-**P+T found some things with SAS in in copy of CFE- not ready to run on live. Tina to review with Trish.
+**P+T found some things with SAS in in copy of CFE- not ready to run on live. Tina to review with Trish.  Trish sent Tina email.
 ===TMP re-import / data changes:===