eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BEN.BEN_PRMRY_CARE_PRVDR_F#

Source

View Text - Preformatted


select PRMRY_CARE_PRVDR_ID PRMRY_CARE_PRVDR_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PRMRY_CARE_PRVDR_TYP_CD PRMRY_CARE_PRVDR_TYP_CD, NAME NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PPR_ATTRIBUTE_CATEGORY PPR_ATTRIBUTE_CATEGORY, PPR_ATTRIBUTE1 PPR_ATTRIBUTE1, PPR_ATTRIBUTE2 PPR_ATTRIBUTE2, PPR_ATTRIBUTE3 PPR_ATTRIBUTE3, PPR_ATTRIBUTE4 PPR_ATTRIBUTE4, PPR_ATTRIBUTE5 PPR_ATTRIBUTE5, PPR_ATTRIBUTE6 PPR_ATTRIBUTE6, PPR_ATTRIBUTE7 PPR_ATTRIBUTE7, PPR_ATTRIBUTE8 PPR_ATTRIBUTE8, PPR_ATTRIBUTE9 PPR_ATTRIBUTE9, PPR_ATTRIBUTE10 PPR_ATTRIBUTE10, PPR_ATTRIBUTE11 PPR_ATTRIBUTE11, PPR_ATTRIBUTE12 PPR_ATTRIBUTE12, PPR_ATTRIBUTE13 PPR_ATTRIBUTE13, PPR_ATTRIBUTE14 PPR_ATTRIBUTE14, PPR_ATTRIBUTE15 PPR_ATTRIBUTE15, PPR_ATTRIBUTE16 PPR_ATTRIBUTE16, PPR_ATTRIBUTE17 PPR_ATTRIBUTE17, PPR_ATTRIBUTE18 PPR_ATTRIBUTE18, PPR_ATTRIBUTE19 PPR_ATTRIBUTE19, PPR_ATTRIBUTE20 PPR_ATTRIBUTE20, PPR_ATTRIBUTE21 PPR_ATTRIBUTE21, PPR_ATTRIBUTE22 PPR_ATTRIBUTE22, PPR_ATTRIBUTE23 PPR_ATTRIBUTE23, PPR_ATTRIBUTE24 PPR_ATTRIBUTE24, PPR_ATTRIBUTE25 PPR_ATTRIBUTE25, PPR_ATTRIBUTE26 PPR_ATTRIBUTE26, PPR_ATTRIBUTE27 PPR_ATTRIBUTE27, PPR_ATTRIBUTE28 PPR_ATTRIBUTE28, PPR_ATTRIBUTE29 PPR_ATTRIBUTE29, PPR_ATTRIBUTE30 PPR_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EXT_IDENT EXT_IDENT from "BEN"."BEN_PRMRY_CARE_PRVDR_F"

View Text - HTML Formatted

SELECT PRMRY_CARE_PRVDR_ID PRMRY_CARE_PRVDR_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PRMRY_CARE_PRVDR_TYP_CD PRMRY_CARE_PRVDR_TYP_CD
, NAME NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PPR_ATTRIBUTE_CATEGORY PPR_ATTRIBUTE_CATEGORY
, PPR_ATTRIBUTE1 PPR_ATTRIBUTE1
, PPR_ATTRIBUTE2 PPR_ATTRIBUTE2
, PPR_ATTRIBUTE3 PPR_ATTRIBUTE3
, PPR_ATTRIBUTE4 PPR_ATTRIBUTE4
, PPR_ATTRIBUTE5 PPR_ATTRIBUTE5
, PPR_ATTRIBUTE6 PPR_ATTRIBUTE6
, PPR_ATTRIBUTE7 PPR_ATTRIBUTE7
, PPR_ATTRIBUTE8 PPR_ATTRIBUTE8
, PPR_ATTRIBUTE9 PPR_ATTRIBUTE9
, PPR_ATTRIBUTE10 PPR_ATTRIBUTE10
, PPR_ATTRIBUTE11 PPR_ATTRIBUTE11
, PPR_ATTRIBUTE12 PPR_ATTRIBUTE12
, PPR_ATTRIBUTE13 PPR_ATTRIBUTE13
, PPR_ATTRIBUTE14 PPR_ATTRIBUTE14
, PPR_ATTRIBUTE15 PPR_ATTRIBUTE15
, PPR_ATTRIBUTE16 PPR_ATTRIBUTE16
, PPR_ATTRIBUTE17 PPR_ATTRIBUTE17
, PPR_ATTRIBUTE18 PPR_ATTRIBUTE18
, PPR_ATTRIBUTE19 PPR_ATTRIBUTE19
, PPR_ATTRIBUTE20 PPR_ATTRIBUTE20
, PPR_ATTRIBUTE21 PPR_ATTRIBUTE21
, PPR_ATTRIBUTE22 PPR_ATTRIBUTE22
, PPR_ATTRIBUTE23 PPR_ATTRIBUTE23
, PPR_ATTRIBUTE24 PPR_ATTRIBUTE24
, PPR_ATTRIBUTE25 PPR_ATTRIBUTE25
, PPR_ATTRIBUTE26 PPR_ATTRIBUTE26
, PPR_ATTRIBUTE27 PPR_ATTRIBUTE27
, PPR_ATTRIBUTE28 PPR_ATTRIBUTE28
, PPR_ATTRIBUTE29 PPR_ATTRIBUTE29
, PPR_ATTRIBUTE30 PPR_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, EXT_IDENT EXT_IDENT
FROM "BEN"."BEN_PRMRY_CARE_PRVDR_F"