Show TOC

 IS-H: DataSource for InfoProvider Case

Technical name: 0HC_PATCASE_ATTR

Technical Data

Type of DataSource

Attributes (Master Data)

Application Component

Healthcare General 0IS_HC_ALL

Available as of OLTP Release

SAP Patient Management 4.72

Available as of Plug-In Release

--

RemoteCube-enabled?

No

Use

This DataSource provides access to case attributes from the source system. The DataSource supplies all attributes of a case that cannot be assigned to a patient classification system (PCS).

The DataSource is based on table NFAL of SAP Patient Management and patient information from tables NPAT and NADR as well as the case-to-person assignment from table NFPZ with role 1 = referring physician (inpatient case) or 5 = referring physician (outpatient case) in field RPHYS and role 3 = postdischarge physician in field PPHYS.

The Case InfoObject (0HC_PATCASE) is implemented as a master data InfoProvider in SAP BI and can thus be filled using multiple InfoSources.

The PCS-relevant attributes are completed in the master data of the case only using the IS-H: DataSource for Transaction Data PCS (0HC_PCS).

Delta Update

The DataSource supports the AIM delta method ( After Images Using Delta Queue (for example FI-AP/AR) with generic delta using timestamp (field TIMESTAMP).

When a delta init upload and a delta upload are performed, the institution, the case number, and the timestamp for when the case master data is loaded are recorded in table NFALBW to enable the other DataSource extractors to access this information for their delta init and delta.

For more information about this, see Delta Upload Using Leading Object .

Fields of Origin for the Extract Structure

Field in the Extract Structure

Description of the Field in the Extract Structure

Extractor

Table of Origin

Field in the table of Origin

ABRKZ

IS-H: Billing Indicator for Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ABRKZ

ADMDPTM

IS-H: Admitting Departmental Organizational Unit

NBWD_0HC_PATCASE_ATTR_GET

ADMDT

IS-H: Admission Date

NBWD_0HC_PATCASE_ATTR_GET

ADMNURS

IS-H: Admitting Treatment Organizational Unit (Care Unit)

NBWD_0HC_PATCASE_ATTR_GET

ADMTP

IS-H: Admission Type for Data Transfer IS-H -> EIS

NBWD_0HC_PATCASE_ATTR_GET

ARBUN

IS-H: Work Incapacity To-Date

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ARBUN

BEGDT

IS-H: Start Date of Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

BEGDT

BEKAT

IS-H: Treatment Category

NBWD_0HC_PATCASE_ATTR_GET

NFAL

BEKAT

CHILD

IS-H: Number of Children

NBWD_0HC_PATCASE_ATTR_GET

NFAL

CHILD

DISPTM

IS-H: Discharging Departmental Organizational Unit

NBWD_0HC_PATCASE_ATTR_GET

DISDT

IS-H: Discharge Date

NBWD_0HC_PATCASE_ATTR_GET

DISNURS

IS-H: Discharging Treatment Organizational Unit (Care Unit)

NBWD_0HC_PATCASE_ATTR_GET

DISTP

IS-H: Discharge Type for Data Transfer IS-H -> EIS

NBWD_0HC_PATCASE_ATTR_GET

DOCNR

IS-H: Subvention Document Number (Long)

NBWD_0HC_PATCASE_ATTR_GET

NFAL

DOCNR

DOCTY

IS-H: Subvention Document Type (Long)

NBWD_0HC_PATCASE_ATTR_GET

NFAL

DOCTY

DOCW

IS-H: Indicator Denoting Referral to Specific Physician

NBWD_0HC_PATCASE_ATTR_GET

NFAL

DOCW

EAUFN

IS-HCO: Receiver (Order)

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EAUFN

EINRI

IS-H: Institution

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EINRI

EINZG

IS-H: Geographical Area

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EINZG

EMTYP

IS-H: Employee Type

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EMTYP

ENDAT

IS-H: Date of Delivery

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ENDAT

ENDDT

IS-H: End Date of Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ENDDT

ENDTYP

IS-H: Type of Case End

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ENDTYP

ENTIM

IS-H: Time of Delivery

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ENTIM

ERDAT

IS-H: Date at which Record Was Created

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ERDAT

ERUSR

IS-H: Name of User Who Created Record

NBWD_0HC_PATCASE_ATTR_GET

NFAL

ERUSR

FACHR

IS-H: Specialty for Organizational Unit

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FACHR

FALAR

IS-H: Case Type

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FALAR

FALNR

IS-H: Case Number

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FALNR

FATYP

IS-H: Case Category

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FATYP

FGTYP

IS-H: Delivery Category

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FGTYP

FOREI

IS-H: Foreign Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FOREI

FPEDT

IS-H: Date of Wound Healing

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FPEDT

FSPER

IS-H: Billing Block for Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FSPER

FZIFF

IS-H: Check Digit for Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

FZIFF

GEBDT

IS-H: Birthdate

NBWD_0HC_PATCASE_ATTR_GET

NPAT

GBAT

GREIN

IS-H: Unit of Measurement for Patient’s Size

NBWD_0HC_PATCASE_ATTR_GET

NFAL

GREIN

GSCHL

IS-H: Sex Indicator (Internal)

NBWD_0HC_PATCASE_ATTR_GET

NPAT

GSCHL

GWEIN

IS-H: Unit of Measurement for Patient's Weight

NBWD_0HC_PATCASE_ATTR_GET

NFAL

GWEIN

INFKZ

IS-H: Infection Indicator

NBWD_0HC_PATCASE_ATTR_GET

NFAL

INFKZ

KRZAN

IS-H: Quick Admission Indicator

NBWD_0HC_PATCASE_ATTR_GET

NFAL

KRZAN

KV_KZ

IS-H: Relevant for Panel Physician Association Billing

NBWD_0HC_PATCASE_ATTR_GET

NFAL

KV_KZ

KVUEB

IS-H: Status of PPA Billing Case

NBWD_0HC_PATCASE_ATTR_GET

NFAL

KVUEB

KZKOM

IS-H: Indicator the Complications Arose

NBWD_0HC_PATCASE_ATTR_GET

NFAL

KZKOM

LAND

IS-H: Country

NBWD_0HC_PATCASE_ATTR_GET

NADR

KZTXT

NATIO

IS-H: Person’s Nationality

NBWD_0HC_PATCASE_ATTR_GET

NPAT

NATIO

NOTAN

IS-H: Emergency Admission Indicator

NBWD_0HC_PATCASE_ATTR_GET

NFAL

NOTAUF

PATGEW

IS-H: Weight of Patient at Admission

NBWD_0HC_PATCASE_ATTR_GET

NFAL

PATGEW

PATGRO

IS-H: Height of Patient at Admission

NBWD_0HC_PATCASE_ATTR_GET

NFAL

PATGRO

PATNR

IS-H: Patient Number

NBWD_0HC_PATCASE_ATTR_GET

NFAL

PATNR

PATW

IS-H: Patient Requested Referral Indicator

NBWD_0HC_PATCASE_ATTR_GET

NFAL

PATW

PHOSP

IS-H: ID of External Hospital

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EXTKH

PPHYS

IS-H: Personnel Number of Postdischarge Physician

NBWD_0HC_PATCASE_ATTR_GET

NFAL

NARNR

PSTLZ

IS-H: Postal Code

NBWD_0HC_PATCASE_ATTR_GET

NADR

PSTLZ

REGIO

IS-H: Region (State, Province, County)

NBWD_0HC_PATCASE_ATTR_GET

NADR

REGION

RESID

IS-H: Indicator That Patient Is Non-Resident

NBWD_0HC_PATCASE_ATTR_GET

NFAL

RESID

RESPI

IS-H: Duration of Mechanical Ventilation in Hours

NBWD_0HC_PATCASE_ATTR_GET

NFAL

RESPI

RHOSP

IS-H: ID of External Hospital

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EXTKH

RPHYS

IS-H: Personnel Number of Referring Physician

NBWD_0HC_PATCASE_ATTR_GET

NFAL

EARNR

SICHV

IS-H: Indicator for Restricted Patient

NBWD_0HC_PATCASE_ATTR_GET

NFAL

SICHV

STASP

IS-H: Indicator for Admission Type “Statistics Block”

NBWD_0HC_PATCASE_ATTR_GET

NFAL

STASP

STATU

IS-H: Case Status

NBWD_0HC_PATCASE_ATTR_GET

NFAL

STATU

STDAT

IS-H: Cancellation Date

NBWD_0HC_PATCASE_ATTR_GET

NFAL

STDAT

STORN

IS-H: Cancellation Indicator

NBWD_0HC_PATCASE_ATTR_GET

NFAL

STORN

STUSR

IS-H: Name of User Who Made Cancellation

NBWD_0HC_PATCASE_ATTR_GET

NFAL

STUSR

UPDAT

IS-H: Date at Which Record Was Last Changed

NBWD_0HC_PATCASE_ATTR_GET

NFAL

UPDAT

UPUSR

IS-H: Name of User Who Made Cancellation

NBWD_0HC_PATCASE_ATTR_GET

NFAL

UPUSR

VORGR

IS-H: Previous Days to Be Deducted from Max. Length of Stay

NBWD_0HC_PATCASE_ATTR_GET

NFAL

VORGR

VORPT

IS-H: Number of Days of Previous Treatment in Calendar Year

NBWD_0HC_PATCASE_ATTR_GET

NFAL

VORPT

WKAT

IS-H: Choice of Ward Category

NBWD_0HC_PATCASE_ATTR_GET

NFAL

WKAT

Features of the Extractor

For outpatient cases, the system takes the admission and discharge information from the first and last visit of the case. However, when selection is made by admission date or discharge date, the system always includes an outpatient case in the selection if it has a visit in the specified period, even though this visit does not occur at the start or end of a visit chain.

By contrast, the system uses the admission movement or discharge movement for an inpatient case when selection is made by admission date or discharge date.

SAP Patient Management supplies canceled cases with cancellation indicator STORN = ‘X’, date of cancellation and the user who made the cancellation. SAP BI stores the indicator as an attribute for the case. This allows you to restrict the analyses, since you cannot delete the master data records in SAP BI using an upload.