Pats 0 Systems Management Guide

PATIENT ADVOCATE TRACKING SYSTEM (PATS)
Systems Management Guide
April 2013

Department of Veterans Affairs

Office of Enterprise Development (OED)


This page is left blank intentionally

Revision History
The following table displays the revision history for this document.

Date	Revision	Description	Author
04/11/07	Initial		Susan Bunker PATS Developers: Patrick Brady, Daryl Krauter, Adam Nisenbaum, Tami Winn Don Morgan, PM
6-2-09	1.1	Updated information pertaining to KAAJEE Upgrade	Padma Subbaraman Developer
10-30-09	1.2	Updated the formatting of the document. Changed the logo. Added the boilerplate ROC resolution text clarification.	Arsen Mikhailutsa, Developer
10-07-2010	1.3	Updated information on SDS, VistALink version and HSI name change	Arsen Mikhailutsa, Developer
08-12-2010	1.4	Removed link and exemplary connection information	Arsen Mikhailutsa, Developer
06-08-2011	1.5	Corrected the misspelling in the database job, added information regarding the root context.	Arsen Mikhailutsa, Developer
11-21-11	1.6	Updated formatting of the document, Updated Oracle version information	Arsen Mikhailutsa, Developer
04-01-2013	1.7	Added PAD servlet information detailing automatic ROC generation	Joshua Faulkner, Developer
04-04-2013	1.8	Updated document with ESE – HIS group rename.	Arsen Mikhailutsa, Developer

This page is left blank intentionally

Table of Contents

Introduction 1

1.0 PATS Application 3

1.1 Enterprise Archive 3

1.1.1 Application.xml 3

1.1.2 Weblogic-application.xml 3

1.1.3 APP-INF 3

1.1.4 Web Application 6

1.1.5 Ejb-jar Archive 9

1.2 HealtheVet Configuration Files 9

1.3 PATS Loggers 13

1.4 Exceptions 15

1.5 Service Imports 15

1.6 Requirement for Sending Notifications 17

1.7 Integration Agreements for use of Java Components 17

1.8 PAD Servlet ROC Creation 18

1.8.1 Troubleshooting PAD 18

2.0 Java Enterprise Developer Workstation 20

2.1 Development Platform 20

2.2 Development Projects 20

2.3 Development Tools 21

2.3.1 ANT 21

2.3.2 XDoclet 21

2.3.3 Log4j 21

2.3.4 Libraries 21

2.3.5 Junit and Cactus 23

2.3.6 Rational XDE 23

2.3.7 Maven 23

2.3.8 PAD Tools 23

2.4 Services 25

3.1 Web Security 26

3.2 Ejb Method Permission Security 26

3.3 Transactions 26

3.4 ROC 26

3.5 Notification 26

3.6 Table Maintenance 26

3.7 Concurrency 26

3.8 Application Design Parameters 27

3.8.1 Timeout Parameters 27

3.8.2 Date Parameters 27

3.8.3 Report Instance Limits 27

3.8.4 Text Field Length 27

4.0 M VistA 27

4.1 Namespace 28

4.2 Routine Descriptions 28

4.3 Temporary Globals 29

4.4 Options 29

4.5 Remote Procedure Calls 30

4.6 External Relations 31

4.7 VistA Integration Agreements 33

4.7.1 Supported 33

4.7.2 Controlled Subscription 34

4.8 Online Documentation 35

4.9 Check Sum Values for Routines 35

4.10 Security and Keys 35

5.0 Database - Oracle 37

5.2 Schemas 37

5.3 Users 37

5.4 Roles 38

5.5 Tablespaces 38

5.6 Tables 38

5.6.1 PATS Schema 38

5.6.2 PATSRPTS Schema 42

5.7 Field Information 44

5.8 Report Data Tables in PATSRPTS Schema 45

5.9 Procedures 45

5.9.1 PATS Schema 45

5.9.2 PATSRPTS Schema 51

5.10 Techniques used in PATS Procedures 54

5.11 Scheduled Jobs 55

5.12 Developer Workstation Setup 55

5.13 External Relations 57

5.14 Database Integration Agreements 57

6.0 Business Objects XI (BOEXI) 58

6.1 Repository and Central Management Console 58

6.1.1 Report Folder Structure 58

6.1.2 Standard Report Database Source 60

6.1.3 Users 60

6.1.4 Groups 61

6.1.5 Instance Limits 61

6.1.6 Security 61

6.1.7 Universe Connections 65

6.1.8 Universes 65

6.1.9 Licensing 65

6.2 WebIntelligence 66

6.2.1 PATS/WebLogic – WebIntelligence/Tomcat integration notes 66

6.2.2 Universe Connection 66

6.2.3 Universe 67

6.2.4 Universe Data Filtering 68

6.3 Business Objects Software 69

6.3.1 Crystal Reports XI 69

6.3.2 WebI Universe Designer XI 69

6.3.3 Central Management Console 70

6.3.4 InfoView 70

6.3.5 Web Intelligence 70

6.4 Multiple PATS Instances Sharing the Same BOEXI Repository 70

6.4.1 Standard Reports 71

6.4.2 Ad Hoc Reports 71

7.0 Rollup PATS Data to VSSC 73

7.1 Scheduled Job to Build Rollup Data 73

7.2 VSSC Fetches Rollup Data 73

7.3 Format of Rollup Data Records 73

7.3.1 ROC Main Data Records 73

7.3.2 Patient Data Records 74

7.3.3 Issue Multiple Records 75

7.3.4 Contacting Entity Records 75

7.3.5 Method of Contact Records 76

7.3.6 Patient Race Records 76

8.0 Troubleshooting PATS Reports 77

This page is left blank intentionally