장기요양급여 제공기록지(방문요양) 한글문서->엑셀파일로 변환, 이름 선택시 해당정보 입력

한글문서로 작성되어 있는 장기요양급여 제공기록지 서식은 매번 정보를 입력하거나 수급자별로 여러개를 만들어 사용해야해서 불편한데, 한글파일을 엑셀파일로 변환 후(HTML형식으로 내보내고 엑셀에서 불러오기), 입력된 정보에서 이름을 선택하면 해당정보가 입력되도록(VLOOKUP 함수 이용) 변경하여 한 페이지에서 여러 수급자의 장기요양급여 제공기록지를 출력 할수있게 만들었다.

장기요양급여 제공기록지(방문요양)-견본 엑셀파일 다운로드

재가 방문요양 서비스 가이드라인(5) 최종본 한글문서 무료 다운로드

재가 방문요양 서비스 가이드라인 최종본 책자 한글문서

 방문요양 센터를 운영하는데 필요한 기본 개념부터 운영규정, 서비스 과정과 제공방법, 관리까지 총채적인 정보가 들어있는 책자로 센터운영에 도움이되고, 평가인증시에 필요한 자료들도 다수 들어있다.

 서식부분은 이후 개정된 부분이 많기때문에 책자에 있는것보다는 노인장기요양 홈페이지에 있는 서식자료실에 있는것을 사용하는게 좋다.

방문요양 서비스 가이드라인(5)최종본 한글문서 다운로드 : 다운로드 아이콘 또는 컨트롤+S로 가능
방문요양 서비스 가이드라인(5)최종본 PDF 다운로드 : 다운로드 아이콘 또는 컨트롤+S로 가능

다음의 내용을 포함

1장. 방문요양 서비스 이해 / 1

1. 개념 ·············································································································· 1
2. 인력 기준 ········································································································· 2
3. 시설 기준 ········································································································· 3
4. 급여 서비스 범위 및 수가 ·················································································· 4
4.1 급여 서비스 범위 ························································································· 4
4.2 급여 수가 ···································································································· 6
5. 관련 법정 서식 ································································································· 8
2장. 방문요양 서비스 일반관리 / 11

1. 서비스 제공 원칙 ···························································································· 11
1.1 기본 원칙 필수 ················································································· 11
1.2 기관 운영방향 설정 ···················································································· 12
1) 목적 및 비전 필수 ········································································ 13
2) 행동 원칙 필수 ············································································· 13
2. 직원 윤리 및 이용자 권리 보호 ········································································ 15
2.1 개인정보 보호 필수 ··········································································· 15
ii
2.2 이용자 의사존중 ······················································································· 15
1) 신체구속 및 행위제한 최소화 필수 ················································ 15
2) 선택권 존중 필수 ·········································································· 16
3) 직원의 신분관련 정보 제공 필수 ··················································· 16
2.3 이용자의 권리 및 책임에 대한 안내 필수 ··········································· 16
3. 인력 관리 ······································································································· 17
3.1 인력 채용 및 교육 ···················································································· 17
1) 인력 채용 필수 ············································································· 17
2) 채용 및 계속 교육 필수 ································································ 18
3.2 복무관리 ·································································································· 18
1) 직원의 기본 복무 원칙 필수 ·························································· 18
2) 업무 분장 필수 ············································································· 19
3.3 평가 및 복리후생 ······················································································ 20
1) 직원용 공간 배려 필수 ·································································· 20
2) 평가 및 보상 필수 ········································································ 20
4. 안전관리 ······································································································· 20
4.1 낙상 예방 ·································································································· 20
1) 낙상예방 환경 정비 필수 ······························································ 20
2) 낙상시 처치 필수 ·········································································· 22
4.2 화재 예방 및 대처 ······················································································ 2
1) 소화설비 설치 필수 ······································································ 22
2) 방화관리 계획 및 실천 필수 ·························································· 22
3) 가스 안전사고 예방 필수 ······························································ 24
4.3 자살 예방 필수 ················································································· 25
4.4 이용자 실종 예방법 교육 필수 ··························································· 26
4.5 응급상황 대처 ···························································································· 27
1) 노인 질식(기도 폐쇄) 권장 ···························································· 27
2) 경련 권장 ····················································································· 27
3) 화상 권장 ····················································································· 27
iii
5. 정보 제공 및 관리 ··························································································· 28
5.1 서비스 비용 내역 제공 필수 ···························································· 28
5.2 홈페이지 관리 권장 ··········································································· 28
5.3 기록물 보존 및 관리 ··················································································· 29
1) 문서 편철 필수 ············································································· 29
2) 기록물의 작성 및 등록 필수 ·························································· 29
3) 문서 보존 필수 ············································································· 30
6. 배상보험 가입 ································································································· 32
6.1 의무보험 필수 ··················································································· 32
6.2 가입권장보험 권장 ··········································································· 32

3장. 방문요양 서비스 과정 / 35

1. 이용 상담 및 계약 ··························································································· 36
1.1 이용 신청 ································································································ 36
1) 상담 필수 ····················································································· 36
1.2 방문요양 이용 계약 체결 필수 ··························································· 36
2. 사정 필수 ······························································································· 37
3. 방문요양 서비스제공 계획 수립 ········································································ 38
3.1 서비스 우선순위 결정 필수 ······························································ 38
3.2 목표 수립 필수 ················································································· 38
3.3 서비스 내용 및 양 결정 필수 ···························································· 39
4. 서비스 제공 필수 ···················································································· 39
5. 모니티링 및 재평가 필수 ········································································· 39
6. 이용종료 및 적정서비스 연계 ··········································································· 40
6.1 기본 원칙 필수 ················································································· 40
6.2 서비스 연계 필수 ·············································································· 40
iv

4장. 방문요양 서비스 제공 / 43

1. 신체활동 지원 ································································································· 43
1.1 세면돕기 필수 요양보호사 1급 ················································· 43
1.2 구강위생 ···································································································· 44
1) 완전 구강 관리 필수 요양보호사 1급 ··································· 44
2) 칫솔질하기 필수 요양보호사 1급 ········································· 46
3) 의치 손질하기 필수 요양보호사 1급 ····································· 47
1.3 머리감기 ···································································································· 49
1) 통목욕 시 머리감기기 필수 요양보호사 1급 ························· 49
2) 침상 머리감기기 필수 요양보호사 1급 ································· 50
1.4 옷 갈아입기 ······························································································· 51
1) 편마비시 옷 갈아입기 필수 요양보호사 1급 ························· 53
2) 똑바로 누워서 옷 갈아입기 필수 요양보호사 1급 ················· 54
1.5 식사 돕기 ·································································································· 55
1) 일반 식사 필수 요양보호사 1급 ··········································· 55
2) 경관 영양 필수 요양보호사 1급 ··········································· 58
1.6 약 복용 돕기 ····························································································· 60
1) 경구약 복약 돕기 필수 요양보호사 1급 ································ 60
2) 비경구약 이용하기 권장 요양보호사 1급 ································ 61
3) 약 보관하기 필수 요양보호사 1급 ········································ 62
1.7 배설 ·········································································································· 62
1) 변기 사용 돕기 필수 요양보호사 1급 ··································· 63
2) 침상 배변․배뇨 돕기 필수 요양보호사 1급 ························· 64
3) 기저귀 교환 필수 요양보호사 1급 ········································ 67
4) 유치도뇨관 사용 돕기 필수 요양보호사 1급 ························· 68
1.8 신체 부분 씻기 ·························································································· 69
1) 손 씻기 필수 요양보호사 1급 ·············································· 69
2) 발 씻기 필수 요양보호사 1급 ·············································· 70
3) 회음부 씻기 필수 요양보호사 1급 ········································ 71
v
1.9 목욕 ·········································································································· 72
1) 통 목욕 필수 요양보호사 1급 ·············································· 74
2) 침상 목욕 필수 요양보호사 1급 ··········································· 76
1.10 체위 변경 ································································································ 78
1) 측위(좌 또는 우 옆으로 누운 자세) 필수 요양보호사 1급 ····· 78
2) 앙와위(천정을 보고 똑바로 누운 자세) 필수 요양보호사 1급 ··· 79
3) 복위(엎드려 누운 자세) 필수 요양보호사 1급 ······················· 80
4) 반좌위(상체를 올리고 기대어 앉은 자세) 필수 요양보호사 1급 ·· 80
1.11 이동 ········································································································ 81
1) 침상 내 이동 필수 요양보호사 1급 ······································ 81
2) 휠체어 이동돕기 필수 요양보호사 1급 ································· 83
3) 보행 돕기 필수 요양보호사 1급 ··········································· 86
4) 계단 오르내리기 필수 요양보호사 1급 ································· 88
5) 보행(보조)차 사용돕기 필수 요양보호사 1급 ························ 89
2. 일상생활 지원 ································································································· 90
2.1 식사 준비 ·································································································· 90
1) 식재료 선정 필수 요양보호사 2급 ········································ 90
2) 조리하기 필수 요양보호사 2급 ············································· 95
3) 설거지하기 필수 요양보호사 2급 ········································· 97
4) 식기 등 주방 정리하기 필수 요양보호사 2급 ························ 98
2.2 세탁하기 ···································································································· 99
1) 의복 세탁 및 관리 필수 요양보호사 2급 ······························ 99
2) 침구 관리 필수 요양보호사 2급 ··········································· 99
2.3 청소 및 주변정돈 ······················································································ 100
1) 청소 필수 요양보호사 2급 ·················································· 100
2) 수납장 정리 필수 요양보호사 2급 ······································ 101
2.4 외출동행 및 일상업무 지원 ········································································ 102
1) 외출 동행 필수 요양보호사 2급 ········································· 102
2) 심부름 필수 요양보호사 2급 ·············································· 102
3) 병원 동행 필수 요양보호사 2급 ········································· 103
vi
3. 정서지원 ······································································································· 103
3.1 의사소통 ································································································· 103
1) 의사소통 및 친밀감 형성 필수 요양보호사 2급 ··················· 104
2) 상황별 대화법 필수 요양보호사 2급 ··································· 106
3) 스킨쉽 및 안마 필수 요양보호사 2급 ································· 109
3.2 여가활동 지원 필수 요양보호사 2급 ······································· 110

5장. 방문요양 서비스 질 관리 / 111

1. 감염예방 관리 ······························································································· 111
1.1 손 씻기 필수 ················································································· 111
1.2 전염성 질환자 관리 필수 ································································· 113
1.3 쓰레기 및 오염물 관리 필수 ···························································· 113
1.4 음식물 위생 관리 필수 ···································································· 114
2. 서비스 질 관리 ······························································································ 115
2.1 담당 직원 지정 권장 ········································································ 115
2.2 이용자 및 가족 만족도 조사 필수 ···················································· 115
2.3 QI 활동 ··································································································· 116
1) QI 활동 원칙 필수 ······································································ 116
2) 질관리위원회 운영 권장 ······························································ 117
3) 사례관리 회의 필수 ····································································· 117
2.4 불만 및 고충처리 체계 운영 ······································································ 117
1) 불만 및 고충처리 방법 안내 필수 ················································ 118
2) 불만 및 고충 접수․처리 필수 ····················································· 118
3) 기록 및 보고 필수 ······································································ 118

6장. 방문요양 서비스 제공 사례 / 121

1. 장기요양등급별 서비스 제공 사례 ···································································· 121
2. 가족의 동거 유형별 제공 사례 ········································································ 122
2.1 독거노인 ·································································································· 122
2.2 노부부 ····································································································· 123
vii
2.3 24시간 가족과 함께 사는 노인 ··································································· 123
2.4 전일제 근무가족과 함께 사는 노인 ····························································· 125

7장. 기록 서식 / 127

1. 이용자 단위 기록 서식 ··················································································· 127
1.1 방문요양서비스요구 평가서 필수 ······················································ 127
1.2 방문요양서비스 이용 계약서 필수 ···················································· 129
1.3 방문요양서비스 제공계획서 필수 ···················································· 133
1.4 서비스 일정표 필수 ········································································· 134
1.5 이용자 관리카드 필수 ······································································ 135
1.6 서비스 제공기록지 필수 ··································································· 136
1.7 불만 및 고충처리 기록장 필수 ························································· 137
1.8 서비스 만족도 조사(전화용) 필수 ····················································· 138
1.9 서비스 만족도 조사(면접용) 필수 ····················································· 140
1.10 사례관리 회의 양식 필수 ································································ 143
2. 기관단위 기록서식 ························································································· 144
2.1 시설 물품 관리대장 필수 ································································ 144
2.2 지역사회 자원 목록 (자원) 필수 ······················································· 145
2.3 직원 인사기록 카드 필수 ································································· 146

•참고 문헌 / 149

•부 록 / 151

1. 응급상황 대처법 ··························································································· 151
1.1 질식(기도 폐쇄) 대처법 ··········································································· 151
1.2 기본 심폐소생술 ······················································································· 152
2. 질환별 식단 예시 ··························································································· 157
3. 방문요양 관련 법제도 ····················································································· 160

2015년 방문요양,방문목욕 서비스일정표, 보관 및 출력용 엑셀파일

2015년 방문요양 서비스 일정표 (출력 및 보관용, 만년달력)

서비스 일정 계획을 위해 미리 입력해보고자 할때 또는 요양사나 수급자에게 제공용으로 사용가능, 추가적으로 입력해야하는 하지만 노인장기요양 사이트와 별도로 컴퓨터에 보관해서 관리 할수있고 출력물도 달력모양으로 보기에 편함

서비스일정표2015 방문요양 엑셀파일 다운로드

서비스일정표2015 방문목욕 엑셀파일 다운로드

2014년 재가방문 서비스일정표, 보관 및 출력용 엑셀파일 (방문요양)

2014년 7월 1일자로 변경된 등급별 사용한도와 시간당 수가를 반영한 서비스일정표 보관 및 인쇄용 엑셀파일 갱신

 엑셀파일은 구글드라이브를 통해 공유, 파일 저장은 저장 버튼을 누르거나 컨트롤+S를 누르면 다운로드가 가능
 2014년 서비스일정표 7월이후 수가적용 재가방문 엑셀파일 다운로드

이전글 2014년 재가방문 서비스일정표 보관 및 출력용 엑셀파일 (방문요양,방문목욕)

재가방문 방문요양 7월1일자 변경된 시간별 수가, 요양등급별 한도

노인장기요양 재가방문 이번 2014년 7월 1일자 변경된 급여 수가

등급별 이용한도

1등급 1185300원
2등급 1044300원
3등급   964800원
4등급   903800원

방문요양 시간당수가

60분   17490원
90분   22450원
120분 29610원
180분 37200원
240분 43500원

방문목욕 시간당수가

차량미이용60분 40840원
차량이용 차량내목욕 72540원
차량이용 가정내목욕 65410원

장기요양센터 요양사 급여 계산,관리 파일 (엑셀)

장기요양센터에서 매월 요양사 급여를 정산 할 때 간편하게 사용할수있는 간단한 엑셀파일 견본으로 시급정보를 수정하고 청구금액, 본인부담율, 근무시간, 근무일수를 채우면 나머지 부분을 계산해준다.

월급여청구 및 지급급여2014-견본 엑셀파일 - 다운로드 선택 또는 컨트롤+S

소규모 센터나 매일 일정시간 근무하는 요양사를 관리하는데 적당하다.

2014년 노인장기요양 재가방문 급여지급명세서 견본 (엑셀)

간단하게 급여명세서로 사용 할 수 있는 엑셀 견본파일

우측에 시급과 근무시간을 입력하면 몇가지 자동계산되고, 그외 공제내역을 입력하면 됨.

노인장기요양 재가방문 급여지급명세서 견본 엑셀파일 다운로드 - 저장 또는 컨트롤+S

2014년 재가방문 서비스일정표 보관 및 출력용 엑셀파일 (방문요양,방문목욕)

노인장기요양 사이트에서도 서비스 일정을 입력하고 출력하는게 가능하긴하지만, 달력형식이 아니라 테이블 형식으로서 한눈에 들어오지도 않고, 온라인상태에서만 사용이 가능하다는 점도 불편한 이유중 하나다.

 노인장기요양 사이트에서 제공하는 일정표의 모양이 개선되면 더없이 좋겠지만, 현재 사이트 불편한 인터페이스 상태를 봐서는 그런 개선을 기대할 수 있는 상태는 아닌걸로 보인다.

 이렇게 엑셀파일을 이용해서 별도로 관리하는게 손이 한번 더 가긴하지만, 서비스 일정을 짤 때 오프라인에서 원하는대로 먼저 입력해 볼 수 있어서 편리하고, 이미 짜놓은 서비스일정을 출력 할 때도 원하는 모양으로 보기좋게 만들수 있다는 장점이 있다.

그리 복잡한건 아니지만 참조계산식이 몇개 있어서 원하는대로 수정을 위해서는 아무래도 엑셀이 가능해야겠지만, 일반 노인장기요양 재가방문센터라면 그대로 사용하는것도 가능해 보인다.

엑셀파일은 구글드라이브를 통해 공유하고, 파일 저장은 저장 버튼을 누르거나 컨트롤+S를 누르면 다운로드가 가능하다.
2014년 서비스일정표 방문요양 엑셀파일 다운로드
2014년 서비스일정표 방문목욕 엑셀파일 다운로드
파일에 사용된 폰트 다음체 다운로드 - 다음 고유 서체 '다음체', 무료로 내려 받아 쓰세요!

 한달에 몇만원을 내고 사용하는 외부프로그램도 있다고하는데 소규모사업장 위주로 돌아가는 장기요양센터에서 그정도까지 사용할 필요는 궂이 없어 보이기도하고, 노인장기요양 사이트의 시스템이 변경되면서 오류가 발생하하는 경우도 있다고하니 이런식으로 분리된 파일로 관리하는것도 한가지 방법이 될 수 있다.

 액세스를 이용하면 아무래도 각 정보들간에 연결이 용이해서 더 좋게 만들 수 있겠지만, 관리나 사용방법이 엑셀에 비해서는 어려운 편이라 무난한 엑셀을 이용.

노인장기요양 방문요양 서비스일정표

재가방문 서비스 일정표 (수급자와 요양사에게 제공)
노인장기요양보험 - 급여제공계획서 관리 - 급여제공계획서등록변경에서
각 수급자의 급여계약 내용일정 등록.변경을 인쇄해서 사용하는것과 같다.
별도의 엑셀파일로 손이 더 가는 수고를 해야 하지만, 달력모양으로 보기에도 편하고 계획 수립시에도 좀 더 편하게 이용 가능하다는 장점.

노인장기요양 방문요양 서비스일정표 2013 다운로드

정보탭에 입력한 정보를 각 월 페이지가 공유
각 날짜에 방문요양과 아래 1로 제공일 산정
각 월 페이지에서 우측에 정보 입력으로 대략적인 등급한도와 비용 산정