SAP ABAP Table RNVIRA (IS-H: Insurance Data with Update Indicator)
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 | RNVIRA | Table Relationship Diagram |
Short Description | IS-H: Insurance Data with Update Indicator |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | LFDNR | LFDVV | LFDVV | NUMC | 3 | 0 | IS-H: Sequence Number of Insurance Relationship | ||
3 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship - Case- and Patient-Related | |||||
4 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | * | |
5 | PATKZ | ISH_PATKZ | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Self-Payer Insurance Relationship | ||
6 | MGART | MITART_VER | MITART_VER | CHAR | 1 | 0 | IS-H: Type of Insurance Coverage | TN16M | |
7 | UNTGR | UNTGR | UNTGR | CHAR | 2 | 0 | IS-H: Insurance Subgroup | TN16C | |
8 | VERAB | BEGDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Insurance Relationship | ||
9 | VERBI | ENDDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-to Date of Insurance Relationship | ||
10 | RANGF | ISH_RANGF | ISH_RANGF | NUMC | 2 | 0 | IS-H: Ranking Order of Case-Rel. Insurance Relationships | ||
11 | VKVST | ISH_VK_VST | TEXT4 | CHAR | 4 | 0 | Healthcare Smart Card - Status of Insured Person | ||
12 | VKVSE | ISH_VK_VSE | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ||
13 | VKNRA | ISH_VK_VKN | TEXT5 | CHAR | 5 | 0 | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ||
14 | VKNUM | ISH_VK_KNR | TEXT7 | CHAR | 7 | 0 | Healthcare Smart Card - Health Insurer Number | ||
15 | KVDAT | ISH_KVDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date Healthcare Smart Card Imported | ||
16 | VKMAN | ISH_KVMAN | XFELD | CHAR | 1 | 0 | IS-H: Indicator that HCSC Data Entered Manually | ||
17 | VCEND | ISH_VK_END | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Validity | ||
18 | PCARD | ISH_VK_PKV | XFELD | CHAR | 1 | 0 | IS-H: HC smart card - private card indicator (CfP) | ||
19 | VERNR | VERSNR | CHAR20 | CHAR | 20 | 0 | IS-H: Patient Health Insurance Number | ||
20 | VERGE | VERGE | GSCHL | CHAR | 1 | 0 | IS-H: Sex of Person Insured | ||
21 | VERNN | VERNN | TEXT30 | CHAR | 30 | 0 | Last Name of Insured Person | ||
22 | VERVN | VERVN | TEXT30 | CHAR | 30 | 0 | First Name of Insured Person | ||
23 | VERAN | RI_ANRDS | RI_ANRDS | CHAR | 2 | 0 | IS-H: Form-of-Address Key | TN17U | |
24 | VERTI | VERTI | TITEL | CHAR | 15 | 0 | Title of Insured Person | T535N | |
25 | VERNZ | VERNZ | TITEL | CHAR | 15 | 0 | Name Affix of Insured Person | T535N | |
26 | VERVW | VERVW | TITEL | CHAR | 15 | 0 | Name Prefix of Insured Person | T535N | |
27 | VERGB | VERGB | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Birth of Person Insured | ||
28 | VERNA | ISH_NATIO | LAND1 | CHAR | 3 | 0 | IS-H: Nationality of Person | T005 | |
29 | VERSV | VERSV | ISH_SVNUM | CHAR | 20 | 0 | Social Insurance Number of Insured Person | ||
30 | VERVV | N1HVD | N1HVV | CHAR | 1 | 0 | IS-H: Relationship to Main Insured | TNVVA | |
31 | VERGN | VERGN | TEXT30 | CHAR | 30 | 0 | IS-H: Name at Birth of Person Insured | ||
32 | VERSN | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
33 | ADNHV | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
34 | ADOHV | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
35 | BERUF | BERUF | TEXT25 | CHAR | 25 | 0 | IS-H: Patient Occupation | ||
36 | AGNUM | KH_ARBGEB | RI_KUNNR | CHAR | 10 | 0 | IS-H: Employer | NGPA | |
37 | AGNAM | VERAGNA | TEXT30 | CHAR | 30 | 0 | Name of Insured Person's Employer | ||
38 | ADNAG | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
39 | ADOAG | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
40 | SZDEB | SZ_DEBNR | KUNNR | CHAR | 10 | 0 | IS-H: Customer Number of Self-Payer in Financial Accounting | * | |
41 | ABREE | ABWREMPF | XFELD | CHAR | 1 | 0 | Indicator Whether Alternative Invoice Recipient Exists | ||
42 | KZTXT | TEXT_VVP | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Patient-Related Insurance Relationship | ||
43 | LGTXT | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
44 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
45 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
46 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
47 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
48 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
49 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
50 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
51 | VTRTY | ISH_VTRTY | ISH_VTRTY | CHAR | 6 | 0 | IS-H: Insurance Contract Scheme | TN16 | |
52 | VSCOD | ISH_VERSIONCODE | ISH_VERSIONCODE | CHAR | 2 | 0 | IS-H CA: Version Code for OHIP Health Number | ||
53 | ADRNR | ISH_CADRNR | CADRNR | CHAR | 10 | 0 | IS-H: Number of Address in General Address Management | * | |
54 | CPDKT | ISH_CPDKTO | KUNNR | CHAR | 10 | 0 | IS-H: One-Time Account for Alternative Invoice Recipient | * | |
55 | VAL_QUARTER | ISH_VAL_QUARTER_BEGIN | DATS | 8 | 0 | IS-H: Validity Quarter Start Date | |||
56 | VKZML | ISH_VK_ZML | NUM3 | NUMC | 3 | 0 | IS-H: Health Insurance Card - Mobile Card Reader License No. | ||
57 | VKTITEL | ISH_VK_TIT | TEXT15 | CHAR | 15 | 0 | IS-H: Healthcare smart card - title | ||
58 | VKVNAM | ISH_VK_VNM | TEXT28 | CHAR | 28 | 0 | Healthcare Smart Card - First Name | ||
59 | VKNZU | ISH_VK_NZU | TEXT15 | CHAR | 15 | 0 | IS-H: Healthcare Smart Card - Name Affix | ||
60 | VKNNAM | ISH_VK_NAM | TEXT28 | CHAR | 28 | 0 | IS-H: Healthcare smart card - last name | ||
61 | VKGBDAT | ISH_VK_GBD | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Date of Birth | ||
62 | VKSTRAS | ISH_VK_STR | TEXT28 | CHAR | 28 | 0 | IS-H: Healthcare smart card - street | ||
63 | VKLAND | ISH_VK_LAN | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Country | ||
64 | VKPLZ | ISH_VK_PLZ | TEXT7 | CHAR | 7 | 0 | IS-H: Healthcare Smart Card - Postal Code | ||
65 | VKORT | ISH_VK_ORT | TEXT23 | CHAR | 23 | 0 | IS-H: Healthcare Smart Card - City | ||
66 | LNCRD | ISH_LNCARD | ISH_LNCARD | NUMC | 10 | 0 | Sequence Number of Health Insurance Card | ||
67 | LNCRD_PAT | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
68 | LNCRD_INS | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
69 | VKUNKNOWN_GBDAT | ISH_VK_UNKNOWN_GBDAT | ISH_UNKNOWN_GBDAT | CHAR | 1 | 0 | Healthcare Smart Card: Exact Birthdate Unknown | ||
70 | VERNR_KVK | ISH_VERNR_KVK | CHAR20 | CHAR | 20 | 0 | Insurance Number PPA Card | ||
71 | .INCLUDE | 0 | 0 | IS-H Vers.verh. fall- und pat.bezogen (Zusatzfelder CH) | |||||
72 | MCDKZ | NWCH_MCDKZ | NWCH_MCDKZ | CHAR | 1 | 0 | MCD Versandoption | ||
73 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship - Patient-Related Data | |||||
74 | CURNT | ISH_NPIR_CURNT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Insurance Relationship is Proposal for New Case | ||
75 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | * | |
76 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | * | |
77 | .INCLUDE | 0 | 0 | IS-H: Insurance Relationship - Case-Related Data | |||||
78 | WAERS | WAERS_VVH | WAERS | CUKY | 5 | 0 | IS-H: Currency in Case-Related Insurance Relationship | TCURC | |
79 | AKTKZ | RI_AKTKZ | CHAR20 | CHAR | 20 | 0 | IS-H: Number of Case on File with Insurance Provider | ||
80 | KKFAL | ISH_KKFAL | ISH_KKFAL | CHAR | 12 | 0 | IS-H: Case Number Used by Insurance Provider | ||
81 | VBGDT | ISH_VBGDT | RI_DATUM | DATS | 8 | 0 | IS-H: Insurance coverage start date | ||
82 | PFLZZ | ISH_ZZPFL | XFELD | CHAR | 1 | 0 | IS-H: Copayment Obligation Indicator | ||
83 | NZZGR | GRKZZ | GRKZZ | CHAR | 2 | 0 | Reason for Copayment Waiver | TN22A | |
84 | BTRZZ | ISH_BTRZZ | WERT6 | CURR | 11 | 2 | IS-H: Amount of Copayment Request | ||
85 | VTAGE | ISH_VTAGE | ISH_VTAGE | NUMC | 2 | 0 | IS-H: Previous Days | ||
86 | VTDAT | ISH_VTDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Report on Paid Copayment Days | ||
87 | EXTTY | ISH_EXTTY | ISH_EXTTY | CHAR | 2 | 0 | IS-H SG: External Contract Scheme | ||
88 | TWKTR | ISH_MAINI | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Main Insurance Relationship | ||
89 | APSTATE | ISH_APSTATE | ISH_APSTATE | CHAR | 2 | 0 | IS-H: Application Status | TNC301SA | |
90 | PAYAM | ISH_PAYAM | WERTV8 | CURR | 15 | 2 | IS-H: Amount Covered (by Insurance Relationship) | ||
91 | KUAUS | NWCH_KUAUS | NWCH_KUAUS | CHAR | 1 | 0 | IS-H CH: Disable Case-Related Insurance Verification | ||
92 | TPPROC | NWCH_TPP | XFLAG | CHAR | 1 | 0 | IS-H CH: Tiers Payant Verfahren | ||
93 | REPAP | ISH_REPAP | XFELD | CHAR | 1 | 0 | IS-H: Invoice requested as printout | ||
94 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | ||
95 | RFLNR | ISH_REFLNR | LFDVV | NUMC | 3 | 0 | IS-H: Reference to Sequence Number of Patient-Related IR | NPIR | |
96 | KKFAL_NEW | ISH_KKFAL_NEW | ISH_KKFAL_NEW | CHAR | 30 | 0 | Case Number at Insurance Provider (New) | ||
97 | CONTRACT_IND | ISH_CONTRACT_INDICATOR_301 | ISH_CONTRACT_INDICATOR_301 | CHAR | 30 | 0 | Vertragskennzeichen für §301 | ||
98 | LNCRD_E111 | ISH_LNCARD_DET | NUMC | 5 | 0 | Sequential Details of Health Insurance Card | |||
99 | KOUB_COPAYDAYS | ISH_301_KOUB_COPAYDAYS | ISH_301_KOUB_COPAYDAYS | NUMC | 2 | 0 | §301 - Zuzahlungsvortage aus Kostenübernahmesatz | ||
100 | KOUB_COPD_STAT | ISH_301_KOUB_COPAYDAYS_STATUS | ISH_301_KOUB_COPAYDAYS_STATUS | CHAR | 1 | 0 | Status Kostenübernahme/Entlassungsanzeige | ||
101 | COP_RECEIPT | ISH_COP_RECEIPT | XFELD | CHAR | 1 | 0 | Kennzeichen, ob Patient Nachweis vorgelegt hat | ||
102 | SUSPEND_CLAIM | ISH_KV_SUSPEND_CLAIM | XFELD | CHAR | 1 | 0 | Eingeschränkter Leistungsanspruch | ||
103 | VVFAL | ISH_FALGEF | XFELD | CHAR | 1 | 0 | IS-H: Insurance Maintained for Case | ||
104 | TKZ | ISH_MARK | XFELD | CHAR | 1 | 0 | IS-H: Selection Field (for Table Control, for Example) | ||
105 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
106 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNVIRA | AGNUM | NGPA | GPART | REF | 1 | CN |
2 | RNVIRA | APSTATE | TNC301SA | APSTATE | KEY | CN | |
3 | RNVIRA | LGTXT | T002 | SPRAS | |||
4 | RNVIRA | MGART | TN16M | MGART | REF | 1 | CN |
5 | RNVIRA | NZZGR | TN22A | NZZGR | KEY | 1 | CN |
6 | RNVIRA | RFLNR | NPIR | LFDNR | REF | 1 | CN |
7 | RNVIRA | UNTGR | TN16C | UNTGR | REF | 1 | CN |
8 | RNVIRA | VERAN | TN17U | ANRDS | |||
9 | RNVIRA | VERNA | T005 | LAND1 | REF | 1 | CN |
10 | RNVIRA | VERNZ | T535N | TITEL | REF | 1 | CN |
11 | RNVIRA | VERTI | T535N | TITEL | |||
12 | RNVIRA | VERVV | TNVVA | VERVA | REF | 1 | CN |
13 | RNVIRA | VERVW | T535N | TITEL | REF | 1 | CN |
14 | RNVIRA | VTRTY | TN16 | VTRTY | |||
15 | RNVIRA | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |