Fall 2014

Regular Meetings (Tasks)

Total Hours :180h (12h*15weeks=180h)
Accumulated Hours Worked : 108h
Remaining Hours : 2h

Last Week:

Hours Worked This Period: 5h

Tasks: Paper – 3h, Paper revise – 1h, Submission, Readmefile – 1h

12/08/2014 :

Hours Worked This Period: 15h

Tasks: paper – 8h, Function Model Map – 4h, program wrap up – 3h

12/01/2014 :

Hours Worked This Period: 10h

Tasks: Finish Task 4 – 2h, Function Model Map – 4h, Save button – 4h

11/24/2014 :

Hours Worked This Period: 12h

Tasks: Task 4 – total 12h

11/17/2014 :

Hours Worked This Period: 14h

11/17/2014[RA]: finish lecture 1, 2 and upload everything [4h] Task3 3h
11/18/2014: Task3 3h
11/19/2014[RA]:
11/20/2014: Task3 3h
11/21/2014[RA]:Task 4 5h

11/10/2014 :

Hours Worked This Period: 14h [10h]

11/10/2014[RA]: finish PHPM 667 website, meeting[4h]  research Task 1   3h
11/11/2014: task 2 2h
11/12/2014[RA]: syllabus,  lecture 1 ppt[4h] study javascript, task 3 box 3h
11/13/2014: study javascript 2h
11/14/2014[RA]: finish syllabus, lecture 1, 2 ppt [2h] task 3 4h

11/03/2014 :

Hours Worked This Period: 13h [10h]

11/03/2014[RA]:
11/04/2014: fix design of class website[2h] abstract revising 4h
11/05/2014[RA]: website design migration[4h] outline revising 2h
11/06/2014: more research on ER, abstract new content, abstract revising 4h
11/07/2014[RA]: wrap up PHPM 677 website[4h] abstract revising and submission 3h

10/27/2014 :

Hours Worked This Period: 14h [10h]

10/27/2014[RA]: finish basic design of website, start on a new course [4h] start on outline 2h
10/28/2014: format outline 2h
10/29/2014[RA]: make css for screen, tablet, and mobile[4h] finish outline 2h
10/30/2014: fix outline, research on ER 3h
10/31/2014[RA]: make css for print[2h] start on abstract research on ER 5h

10/20/2014 :

Hours Worked This Period: 13h [10h]

10/20/2014[RA]: illness -h
10/21/2014: Class webpage for student [2h] Organize function map 2h
10/22/2014[RA]: Class webpage for student [4h] Display function map 2h
10/23/2014: make interesting db example, fixed problem in dob 3h
10/24/2014[RA]: [4h] make digital (pdf) Function map, start on outline 6h(weekends)

10/13/2014 :

Hours Worked This Period: 13h [4h]

10/13/2014[RA]: print & mobile css [4h] make some cells un-clickable (binary & regnum) 2h
10/14/2014:  make some cells un-clickable (dob) 2h
10/15/2014[RA]: make urls, moving nav menu [4h] function map 4h
10/16/2014: function map, research about distance calculation 2h
10/17/2014[RA]: update the PIRG page [2h] function map display, start on midterm draft 3h

10/06/2014 :

Hours Worked This Period: 14h [10h]

10/06/2014[RA]: Assignment 3 web page [4h] Function map 2h
10/07/2014: Expand cells 3h
10/08/2014[RA]: A4 Webpage [4h] Function map 2h
10/09/2014: Function map 3h
10/10/2014[RA]: A4 Webpage [2h] make unnecessary cells un-clickable (lname & fname) 4h

09/29/2014 :

Hours Worked This Period: 12h [10h]

09/29/2014[RA]: add db1, db2, and row number, and tried to make clickable cells. [4h]
09/30/2014: jQuery study 2h
10/01/2014[RA]: assignment 2, clickable cells [4h] clickable cells 4h
10/02/2014: clickable cells 2h
10/03/2014[RA]: meeting, finish Lab 2 [2h] clickable cells, function map 4h

09/22/2014 :

Hours Worked This Period: 7h [10h]

09/22/2014[RA]: Began Assignment 2, meeting [2h] table skeleton display 2h
09/23/2014: table display 1h
09/24/2014[RA]: Webpage for Assignment2, and the navigation tab[4h]
09/25/2014: evaluate table code, tried adding db1 and db2 2h
09/26/2014[RA]: employee training, [4h] tried adding db1 and db2 2h

09/15/2014 :

Hours Worked This Period: 8h [10h]

09/15/2014[RA]: course webpage [4h]
09/16/2014: D3.js study 2h
09/17/2014[RA]: Webpage(HTML) update [2h], JSON & Javascript study 2h
09/18/2014: JSON study 2h
09/19/2014[RA]: Assignment 1, webpage update [4h] Table display 2h

09/08/2014 :

Hours Worked This Period: 4h [8h]

09/08/2014: illness  –h
09/09/2014: D3.js study  1h
09/10/2014[RA]: [4h]
09/11/2014: Tried logging into the sftp server, D3.js study  2h
09/12/2014[RA]: [4h] D3.js study 1h

09/01/2014 :

Hours Worked This Period: 10h [8h]

09/01/2014: Paper work, account setup, class registration (491), web server setup  6h
09/02/2014[RA]: [4h]
09/03/2014[RA]: [4h]
09/05/2014: Unix setup, Page setup, meeting  4h

The Healthcare Transformation and Quality Improvement Program (Program) aims to improve access to health care, increase quality of care, and reduce costs of care by expanding Medicaid Managed Care, revising the Uncompensated Care (UC) system, and creating a Delivery System Reform Incentive Pool (DSRIP). Given the geographic vastness of the State of Texas, as well as the diversity of the populations in different areas of the state, the Texas Health and Human Services Commission (HHSC) elected to implement the UC and DSRIP portions of the Program by facilitating the creation of 20 Regional Healthcare Partnerships (RHPs). The RHPs serve as a mechanism to plan, implement, and track DSRIP projects. In many cases, the counties and subsequent agencies and providers comprising these RHPs have worked together previously in varying capacities; however, as the RHP regions do not reflect exact boundaries of other service region designations, new stakeholders were likely introduced as well.

Through the RHPs, the Program seeks to create collaborative environments for providers to achieve improved system performance. In the Program, Upper Payment Limit (UPL) funds have been replaced with a UC pool, and hospitals must now participate in RHPs to access those funds. Hospitals and other participating providers may also earn DSRIP for collaborative projects designed to improve system performance in various specific ways approved by HHSC and the Centers for Medicare & Medicaid Services (CMS). Such DSRIP activity is expected to improve access to preventive care; improve quality, health, and cost outcomes for the populations served by specific projects; and improve regional health and human service delivery capacity through enhanced collaboration.

To evaluate the Program, we will assess the following questions. Below these questions are reordered from that in the CMS-approved evaluation plan to a sequence that we believe reflects the Program’s implicit theory of change, from system restructuring to delivery innovation to improved health and cost outcomes:

What are stakeholders’ experiences and perceptions about the implementation and effectiveness of the Program, and what are their recommendations for improving it in the future? (Evaluation Goals 10 & 11; STC 69.a.v)

1. Did the Program increase collaboration among entities that comprised the RHPs? (Evaluation Goal 9; STC 68.a.iv)
2. Did DSRIP projects improve value (cost, quality, health outcomes)? (Evaluation Goals 6,7 & 8; STC 68 a.iii)
3. Did participation in DSRIP projects change the trajectory of UC, the other part of the former UPL pool? (5; STC 68.a.iv)

Official 1115 Waiver Website
Some interesting data visualization on the Wavier from the Texas Tribune

TAMHSC School of Public Health, Health Policy and Management

• Faculty & Staff
  • Robert Ohsfeldt (PI)
  • Hye-Chung Kum (co-PI)
  • Michael A. Morrisey (co-Investigator)
• Students
  • Julian ‘Femi’ Sekoni
  • Debra Tan Choi
  • Yuxian Du
  • Affan Ghaffari
  • Prannay Jain
  • Loida Tamayo
  • Kiran Yalasangi

University of Texas School of Public Health, Management, Policy and Community Health

• Faculty & Staff
  • Rebecca Wells (PI)
  • TDB

University of Louisville, School of Public Health

• Faculty & Staff
  • Monica Wendel (PI)
  • Liza Creel (co-PI)

Collaborators: TX HHSC Strategic Decision Support (SDS) Members

• Sarah Roper-Coleman
• Tenaya Sunbury
• Angie Cummings
• Amy Hess

Project CV

Presented in chronological order
Last updated: June 30, 2015

Refereed Presentations:

• Roper-Coleman S. & Sunbury, T. Summary of the Texas Healthcare Transformation and Quality Improvement Program: a section 1115(a) waiver demonstration. American Evaluation Association, Washington, DC, Oct 16-19, 2013. (Oral)
• Sunbury, T. & Roper-Coleman, S. Evaluation Design and Analytic Methodology of Texas’ 1115 Medicaid Demonstration Waiver Evaluation: Expanding Medicaid Managed Care Statewide. American Evaluation Association, Washington, DC, Oct 16-19, 2013. (Oral)
• Wendel M.L. Designing an evaluation for the delivery system reform incentive program supported by Texas’ 1115 Medicaid demonstration waiver. American Evaluation Association, Washington, DC, Oct 16-19, 2013. (Oral)
• Sunbury T., Kum H., Ghaffari A., & Gregory S. Building an efficient hybrid human machine system for ongoing record linkage. Academy Health Annual Research Meeting, San Diego, CA, Jun 8-10, 2014. (Poster)
• Cummings, A., Sunbury, T., & Roper-Coleman, S. Using quality measures to monitor and evaluate the impact of pharmacy carve-in implemented through an 1115(a) demonstration waiver: The Texas healthcare transformation and quality improvement program. American Public Health Association, New Orleans, LA, Nov 15-19, 2014. (Poster)
• Roper-Coleman S., Wendel, M., Wells, R., Sunbury, T., & Cummings, A. A pragmatic approach to guide the design of a mixed methods evaluation of a Medicaid 1115(a) waiver: The Texas healthcare transformation and quality improvement program. American Public Health Association, New Orleans, LA, Nov 15-19, 2014. (Oral)
• Sunbury, T., Roper-Coleman, S. & Cummings, A. Applying health service utilization models to the Texas Healthcare Transformation and Quality Improvement Program: Advancing theory-based evaluation. American Public Health Association, New Orleans, LA, Nov 15-19, 2014. (Round table)
• Sunbury, T., Roper-Coleman, S. & Cummings, A. Texas Healthcare Transformation and Quality Improvement Program: Impacts of Medicaid policy change on quality of care for aged and disabled population. American Public Health Association, New Orleans, LA, Nov 15-19, 2014. (Oral)
• Ghaffari, A. Wells, R., Armstrong, T., Creel, L., Kum, HC, Brossart, D., Roper-Coleman, S., Sunbury, T. Applying relational coordination to inter-agency teamwork and patient experiences with providers. Oral presentation at Organizational Theory in Health Care Conference, Richmond, VA, May 27-29, 2015 (Ghaffari presenting – doctoral students).
• Wendel M, Creel L, McMaughan D, Roper-Coleman S, Cummings, A. Transforming the health care system: implementation strengths and challenges in Texas’ Healthcare Transformation and Quality Improvement Program 1115(a) Medicaid Waiver. Academy Health 2015 Annual Research Meeting, Minneapolis, MN, Jun 11-16, 2015. (Poster)
• Wendel M, Creel L, Wells R, Gregory S, Roper-Coleman S, Cummings, A. Using network analysis to understand regional differences in collaboration resulting from the Texas 1115(a) Medicaid Waiver. Academy Health 2015 Annual Research Meeting, Minneapolis, MN, Jun 11-16, 2015. (Poster)
• Tamayo L, Kum HC, Wells R, Du Y, Roper-Coleman S, Sunbury T. Health Status and Health Experience Among Adult, Hispanic, Frequent ED Users. AcademyHealth 2015 Annual Research Meeting, Minneapolis, MN, Jun 11-16, 2015. (Poster)
• Ghaffari, A. Wells, R., Armstrong, T., Creel, L., Kum, HC, Brossart, D., Roper-Coleman, S., Sunbury, T. Applying relational coordination to inter-agency teamwork and patient experiences with providers. Poster Presentation at 2015 AcademyHealth Annual Research Meeting: Minneapolis, MN.
• Wendel, M., Creel, L. Wells, R., Roper-Coleman, S., Sunbury, T.  Using network analysis to measure changes in local collaboration resulting from implementation of the Texas Healthcare Transformation and Quality Improvement Program. APHA Annual Meeting and Exposition, Chicago, IL, Oct 31 – Nov 4, 2015. (Oral, Wendel/Creel presenting)
• Wendel, M., Creel, L., McMaughan, Roper-Coleman, S., Cummings, A. Stakeholder Perceptions of Strengths and Challenges in Texas’ Healthcare Transformation and Quality Improvement Program. APHA Annual Meeting and Exposition, Chicago, IL, Oct 31 – Nov 4, 2015. (Oral, Wendel/Creel presenting)

Non-refereed Local Presentations:

• Wendel M.L., Wells R., & Gregory S. Intervention II evaluation design. Presentation to the 2013 Evaluation Work Group, Austin, TX, Sept 9, 2013.
• Wells R. Evaluation of regional healthcare partnerships within the healthcare transformation and quality improvement program. Presentation to the HHSC Executive Waiver Advisory Committee, Austin, TX, Jul 11, 2013.
• Roper-Coleman, S. Evaluating the delivery system reform incentive program supported by Texas’ 1115 Medicaid demonstration waiver, Presentation to Regional Health Partnership 15 representatives, El Paso, TX, Jan 22, 2014
• Wells R. Evaluating the delivery system reform incentive program supported by Texas’ 1115 Medicaid demonstration waiver, Presentation to Regional Health Partnership 15 representatives, El Paso, TX, Jan 22, 2014.
• Roper-Coleman S, & Wells R. Evaluating the 1115(a) demonstration waiver – healthcare transformation quality improvement program. Presentation to the Texas Diabetes Council, Apr 24, 2014.
• Wendel M, Creel L. Evaluation of the Texas Healthcare Transformation and Quality Improvement Program: 1115(a) Medicaid Demonstration Waiver. Presentation at the Statewide Learning Collaborative Summit, Sept 10, 2014.

Mid term stuff to do when time permits

• [Date Entered: Date Completed] Item 1

6/12/2014

next meeting: 6/13 9am

• TODO Yuxian
  • item 1
• TODO Kum
  • item 1

If you borrowed a book from Dr. Kum, please make an entry here.

Borrow Books

• Example format: Full name (email) – Book Title (Date borrowed)

Mid term stuff to do when time permits

• [6/14/2014: Date Completed] Update eg5/docs/ on the server

6/12/2014

next meeting: 6/13 9am

• TODO Yuxian
  • item 1
• TODO Kum
  • item 1

 

3/7/2014

next meeting: 3/21 11am

• TODO Liza
  1. format/save into server/readin all excelsheet (unless error)
  2. meet with Monica
• TODO Kum
  1. sheet 4
  2. clean up tpi for prov
  3. Next meeting: discuss ods/where other files (dshs/arf)

Create a tiny database method 1

data test;
do var1=1 to 10;
output;
end;

proc print data=test(obs=20);

Create a tiny database method 2

data test;
infile datalines;
* input varname [vartype];
input id2010 id2001 charid $5.;

* Add rows of data under datalines;
datalines;
1633900 1129771 one
78161 50892 two
14805 7785 three
;

proc print data=test(obs=10);
run;

Read in csv file method 1

data data.outfn;
infile “data/file.txt” missover lrecl=2000;

* The two numbers at the end of the line indicates the starting position and ending position of the var;
* For example, record_id can be read from postion 1 to position 12;
* $ indicates string variables;

input
RECORD_ID $ 1-12
UNITS_OF_SERVICE 34-40
run;

proc print data=data.outfn(obs=10);
run;

Read in xlsx file

%macro readxlsx(infn, sht, outfn);
PROC IMPORT OUT= &outfn
DATAFILE= “raw/&infn”
DBMS=XLSX REPLACE;
SHEET=”&sht”;
GETNAMES=YES;
RUN;

proc print data=&outfn(obs=10);
proc contents data=&outfn;
%mend;

Write out xlsx file

%macro writexlsx(infn, outfn);
PROC EXPORT DATA= &infn
OUTFILE= “raw/&outfn”
DBMS=XLSX REPLACE;
RUN;
%mend;

Write out html files

ods html body=”file.html”;

.. sas code ..

run;
ods html close;

The Command	What it Means	Example	Output
man command	“Manual.” This displays the help pages for a command. Hit the space bar to scroll through each screen, and hit “q” to quit.	man ls	Displays help for the command “ls”.
ls	“List.” Displays the contents of your current directory (folder).	ls	A list of file names.
ls -l	“List.” The “-l” means “list in long format.” Information such as the time a file was last modified is displayed.	ls -l	A list of file names with info about each file is displayed.
cd dirname	“Change Directory.” Changes your current directory (folder) to ~~dirname~~.	cd mySasProgs	You are now in folder “mySasProgs.”
pwd	“Print Working Directory.” Prints the name of the directory (folder) you are in.	pwd	Displays the name of a folder.
cd ~	“Change Directory.” Changes your current directory (folder) to your home directory. Your home directory is the folder you are in when you first login.	cd ~	You are now in your home directory.
cd ..	“Change Directory.” Makes your current directory move up one directory.	cd ..	If you were in folder “mySasProgs/Prog1/”, after you enter “cd ..”, you will be in “mySasProgs/”.
mkdir dirname	“Make Directory.” Makes a new directory (folder) called dirname.	mkdir sasPrograms	No output, but a directory called “sasPrograms” has been created.
cat filename	“Concatenate”. Displays the contents of ~~filename~~.	cat prog1.sas	The contents of “prog1.sas”
more filename	“More”. Displays the contents of ~~filename~~ a screen at a time. Hit the space bar to scroll through each screen, and hit “q” to quit.	more prog1.sas	Displays “prog1.sas” a screen at a time.
pico filename	This is a program to let you edit a file. It is a very basic Word Processor (like Notepad). For more info on how to use this editor, see: http://www.udel.edu/topics/software/general/editors/unix/pico/picotips.html.	pico program1.sas	Opens “program1.sas” for editing.
!letters	Repeats the last command that started with ~~letters~~.	!s	Repeats the last command that started with s.
cp source destination	“Copy”. Copies source to destination (-p : perserve timestamp).	cp program1.sas program1Backup.sas	Makes a copy of “program1.sas” and calls it “program1Backup.sas”
mv source destination	“Move”. Moves source to destination. You can also think of this command as the “Rename” command.	mv program1.sas sampleProgram.sas	Renames “program1.sas” to “sampleProgram.sas”
rm filename	“Remove.” Deletes filename.	rm testProgram.sas	Removes testProgram.sas
rmdir dirname	“Remove Directory.” Deletes the directory (folder) ~~dirname~~.	rm temp	Removes the directory called “temp.”
msas9 filename	Runs SAS in batch mode on file filename.	msas9 program1.sas	Runs SAS on “program1.sas”.
grep patternfilename	Displays all of the lines in filename that contain pattern.	grep obs a.log	Displays any line in “a.log” that contains the word “obs”
chmod g+s dirname	enable sticky bit for group(a: all, u: user) ownership	chmod g+s data	files created under data/ will now by default share group ownership with data
pts membership username	Displays all of the AFS groups of which user username is a member	pts membership vanbusum	A list of groups, such as “workfirst” and “graduate”
pts membership groupname	Displays all the users of the AFS group	pts membership workfirst
fs la(sa) dir userid acesslist	list (set) access for dir for userid	fs la . workfirst rlikwa or fs sa . kum none	permission changes
pts adduser uid gid	add user to group	.	.
pts removeuser uid gid	remove user to group	.	.
pts creategroup gid	create group	group name kum:grp	.
pts delete gid	delete group	group name kum:grp	.
ln -s path fn	create a symbolic link. when you want to make a direct link to a dir	ln -s /afs/isis/projects/workfirst/workfirst/data/ wf	a link to paht named fn is created
du -h	Disk Usage
df -h	Disk status on NFS

Set up Log

clear all
capture log close
set more off
log using filename.log, replace
…Program…
log close

Create a tiny database

clear all
g var1=1
forvalues v=1/10 {
set obs `v’
replace var1=_N if var1==.
}
list