SAP ABAP Table RNJPIR (IS-H: IR Structure for Patient Merge)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPAS (Package) Application development patient accounting system
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPAS (Package) Application development patient accounting system
Basic Data
Table Category | INTTAB | Structure |
Structure | RNJPIR | Table Relationship Diagram |
Short Description | IS-H: IR Structure for Patient Merge |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship Proposal Pool | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
4 | LFDNR | LFDVV | LFDVV | NUMC | 3 | 0 | IS-H: Sequence Number of Insurance Relationship | ||
5 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship - Case- and Patient-Related | |||||
6 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | NGPA | |
7 | PATKZ | ISH_PATKZ | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Self-Payer Insurance Relationship | ||
8 | MGART | MITART_VER | MITART_VER | CHAR | 1 | 0 | IS-H: Type of Insurance Coverage | TN16M | |
9 | UNTGR | UNTGR | UNTGR | CHAR | 2 | 0 | IS-H: Insurance Subgroup | TN16C | |
10 | VERAB | BEGDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Insurance Relationship | ||
11 | VERBI | ENDDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-to Date of Insurance Relationship | ||
12 | RANGF | ISH_RANGF | ISH_RANGF | NUMC | 2 | 0 | IS-H: Ranking Order of Case-Rel. Insurance Relationships | ||
13 | VKVST | ISH_VK_VST | TEXT4 | CHAR | 4 | 0 | Healthcare Smart Card - Status of Insured Person | ||
14 | VKVSE | ISH_VK_VSE | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ||
15 | VKNRA | ISH_VK_VKN | TEXT5 | CHAR | 5 | 0 | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ||
16 | VKNUM | ISH_VK_KNR | TEXT7 | CHAR | 7 | 0 | Healthcare Smart Card - Health Insurer Number | ||
17 | KVDAT | ISH_KVDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date Healthcare Smart Card Imported | ||
18 | VKMAN | ISH_KVMAN | XFELD | CHAR | 1 | 0 | IS-H: Indicator that HCSC Data Entered Manually | ||
19 | VCEND | ISH_VK_END | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Validity | ||
20 | PCARD | ISH_VK_PKV | XFELD | CHAR | 1 | 0 | IS-H: HC smart card - private card indicator (CfP) | ||
21 | VERNR | VERSNR | CHAR20 | CHAR | 20 | 0 | IS-H: Patient Health Insurance Number | ||
22 | VERGE | VERGE | GSCHL | CHAR | 1 | 0 | IS-H: Sex of Person Insured | ||
23 | VERNN | VERNN | TEXT30 | CHAR | 30 | 0 | Last Name of Insured Person | ||
24 | VERVN | VERVN | TEXT30 | CHAR | 30 | 0 | First Name of Insured Person | ||
25 | VERAN | RI_ANRDS | RI_ANRDS | CHAR | 2 | 0 | IS-H: Form-of-Address Key | TN17U | |
26 | VERTI | VERTI | TITEL | CHAR | 15 | 0 | Title of Insured Person | T535N | |
27 | VERNZ | VERNZ | TITEL | CHAR | 15 | 0 | Name Affix of Insured Person | T535N | |
28 | VERVW | VERVW | TITEL | CHAR | 15 | 0 | Name Prefix of Insured Person | T535N | |
29 | VERGB | VERGB | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Birth of Person Insured | ||
30 | VERNA | ISH_NATIO | LAND1 | CHAR | 3 | 0 | IS-H: Nationality of Person | T005 | |
31 | VERSV | VERSV | ISH_SVNUM | CHAR | 20 | 0 | Social Insurance Number of Insured Person | ||
32 | VERVV | N1HVD | N1HVV | CHAR | 1 | 0 | IS-H: Relationship to Main Insured | TNVVA | |
33 | VERGN | VERGN | TEXT30 | CHAR | 30 | 0 | IS-H: Name at Birth of Person Insured | ||
34 | VERSN | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
35 | ADNHV | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
36 | ADOHV | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
37 | BERUF | BERUF | TEXT25 | CHAR | 25 | 0 | IS-H: Patient Occupation | ||
38 | AGNUM | KH_ARBGEB | RI_KUNNR | CHAR | 10 | 0 | IS-H: Employer | NGPA | |
39 | AGNAM | VERAGNA | TEXT30 | CHAR | 30 | 0 | Name of Insured Person's Employer | ||
40 | ADNAG | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
41 | ADOAG | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
42 | SZDEB | SZ_DEBNR | KUNNR | CHAR | 10 | 0 | IS-H: Customer Number of Self-Payer in Financial Accounting | KNA1 | |
43 | ABREE | ABWREMPF | XFELD | CHAR | 1 | 0 | Indicator Whether Alternative Invoice Recipient Exists | ||
44 | KZTXT | TEXT_VVP | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Patient-Related Insurance Relationship | ||
45 | LGTXT | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
46 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
47 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
48 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
49 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
50 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
51 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
52 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
53 | VTRTY | ISH_VTRTY | ISH_VTRTY | CHAR | 6 | 0 | IS-H: Insurance Contract Scheme | TN16 | |
54 | VSCOD | ISH_VERSIONCODE | ISH_VERSIONCODE | CHAR | 2 | 0 | IS-H CA: Version Code for OHIP Health Number | ||
55 | ADRNR | ISH_CADRNR | CADRNR | CHAR | 10 | 0 | IS-H: Number of Address in General Address Management | * | |
56 | CPDKT | ISH_CPDKTO | KUNNR | CHAR | 10 | 0 | IS-H: One-Time Account for Alternative Invoice Recipient | * | |
57 | VAL_QUARTER | ISH_VAL_QUARTER_BEGIN | DATS | 8 | 0 | IS-H: Validity Quarter Start Date | |||
58 | VKZML | ISH_VK_ZML | NUM3 | NUMC | 3 | 0 | IS-H: Health Insurance Card - Mobile Card Reader License No. | ||
59 | VKTITEL | ISH_VK_TIT | TEXT15 | CHAR | 15 | 0 | IS-H: Healthcare smart card - title | ||
60 | VKVNAM | ISH_VK_VNM | TEXT28 | CHAR | 28 | 0 | Healthcare Smart Card - First Name | ||
61 | VKNZU | ISH_VK_NZU | TEXT15 | CHAR | 15 | 0 | IS-H: Healthcare Smart Card - Name Affix | ||
62 | VKNNAM | ISH_VK_NAM | TEXT28 | CHAR | 28 | 0 | IS-H: Healthcare smart card - last name | ||
63 | VKGBDAT | ISH_VK_GBD | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Date of Birth | ||
64 | VKSTRAS | ISH_VK_STR | TEXT28 | CHAR | 28 | 0 | IS-H: Healthcare smart card - street | ||
65 | VKLAND | ISH_VK_LAN | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Country | ||
66 | VKPLZ | ISH_VK_PLZ | TEXT7 | CHAR | 7 | 0 | IS-H: Healthcare Smart Card - Postal Code | ||
67 | VKORT | ISH_VK_ORT | TEXT23 | CHAR | 23 | 0 | IS-H: Healthcare Smart Card - City | ||
68 | LNCRD | ISH_LNCARD | ISH_LNCARD | NUMC | 10 | 0 | Sequence Number of Health Insurance Card | ||
69 | LNCRD_PAT | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
70 | LNCRD_INS | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
71 | VKUNKNOWN_GBDAT | ISH_VK_UNKNOWN_GBDAT | ISH_UNKNOWN_GBDAT | CHAR | 1 | 0 | Healthcare Smart Card: Exact Birthdate Unknown | ||
72 | VERNR_KVK | ISH_VERNR_KVK | CHAR20 | CHAR | 20 | 0 | Insurance Number PPA Card | ||
73 | .INCLUDE | 0 | 0 | IS-H Vers.verh. fall- und pat.bezogen (Zusatzfelder CH) | |||||
74 | MCDKZ | NWCH_MCDKZ | NWCH_MCDKZ | CHAR | 1 | 0 | MCD Versandoption | ||
75 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship - Patient-Related Data | |||||
76 | CURNT | ISH_NPIR_CURNT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Insurance Relationship is Proposal for New Case | ||
77 | PATKENNZ | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
78 | CONKZ | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
79 | LFDNW | LFDVV | LFDVV | NUMC | 3 | 0 | IS-H: Sequence Number of Insurance Relationship |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNJPIR | AGNUM | NGPA | GPART | |||
2 | RNJPIR | KOSTR | NGPA | GPART | |||
3 | RNJPIR | LGTXT | T002 | SPRAS | |||
4 | RNJPIR | MANDT | T000 | MANDT | |||
5 | RNJPIR | MGART | TN16M | MGART | REF | 1 | CN |
6 | RNJPIR | PATNR | NPAT | PATNR | |||
7 | RNJPIR | SZDEB | KNA1 | KUNNR | |||
8 | RNJPIR | UNTGR | TN16C | UNTGR | REF | 1 | CN |
9 | RNJPIR | VERAN | TN17U | ANRDS | |||
10 | RNJPIR | VERNA | T005 | LAND1 | |||
11 | RNJPIR | VERNZ | T535N | TITEL | REF | 1 | CN |
12 | RNJPIR | VERTI | T535N | TITEL | |||
13 | RNJPIR | VERVV | TNVVA | VERVA | REF | 1 | CN |
14 | RNJPIR | VERVW | T535N | TITEL | REF | 1 | CN |
15 | RNJPIR | VTRTY | TN16 | VTRTY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |