SAP ABAP Table ICL_DRGITEM_S_PE (DRG)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_DRGITEM_S_PE | Table Relationship Diagram |
Short Description | DRG |
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 | DRG Item | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
4 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
5 | SUBCLAIM | ICL_SUBCL | ICL_SUBCL | CHAR | 3 | 0 | Subclaim | ICLSUBCL | |
6 | ITEM | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
7 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
8 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
9 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
10 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
11 | .INCLUDE | 0 | 0 | Attributes of ICLDRGITEM | |||||
12 | .INCLUDE | 0 | 0 | Claim Item - Fields for Coverage Check | |||||
13 | COVTYPE | ICL_COVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Coverage Type | * | |
14 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | * | |
15 | RCOVTYPE | ICL_RCOVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Benefit Coverage Type | * | |
16 | XWAITPERIOD | ICL_XWAITPERIOD | XFELD | CHAR | 1 | 0 | Probationary Periods Ignored | ||
17 | COVERAGE | ICL_POLM | ICL_POLM | CHAR | 4 | 0 | Coverage | * | |
18 | .INCLUDE | 0 | 0 | FS-CM: Benefits/Services/Fees Catalogs in ICLITEM | |||||
19 | SCPOSID_INT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
20 | SERVCAT | ICL_SERVCATID_DRG | ICL_SERVCATID | CHAR | 10 | 0 | Catalog of Diagnosis Related Group (DRG) | TICL401 | |
21 | SCPOSID_EXT | ICL_SERVCAT_POSID_DRG | ICL_SERVCAT_POSID | CHAR | 20 | 0 | Item in Catalog of Diagnosis Related Group (DRG) | ||
22 | .INCLUDE | 0 | 0 | Claim Items - Status Fields | |||||
23 | STATUS | ICL_SCLITEMS | ICL_SCLITEMS | CHAR | 2 | 0 | Status of Claim Item | ||
24 | REJREASON | ICL_REJREASON | ICL_REJREASON | CHAR | 2 | 0 | Claim Item Rejection Reason | * | |
25 | MODIFIED | ICL_MODIFIED | XFELD | CHAR | 1 | 0 | Modified | ||
26 | PROCURED | ICL_PROCURED | XFELD | CHAR | 1 | 0 | Ordered | ||
27 | CALCULATED | ICL_CALCULATED | XFELD | CHAR | 1 | 0 | Calculated | ||
28 | CATAID | ICL_MDCCATAID | ICL_CATAID | CHAR | 4 | 0 | Catalog of Major Diagnostic Category (MDC) | TICL350 | |
29 | DIAGID | ICL_MDCPOSID | ICL_DIAGID | CHAR | 10 | 0 | Catalog Item of Major Diagnostic Category (MDC) | TICL351 | |
30 | SEVERITY_CODE | ICL_DRG_SEVERITYCODE | ICL_DRG_SEVERITYCODE_D_PE | CHAR | 1 | 0 | Severity of Diagnosis Related Group (DRG) | * | |
31 | NOTE | ICL_DRG_NOTE | CHAR | 80 | 0 | Note for Diagnosis Related Groups | |||
32 | REMUN_TYPE_AM | ICL_REMUN_TYPE_D_PE | ICL_REMUN_TYPE_D_PE | CHAR | 4 | 0 | Remuneration Category | ICL_CREMUNTYPE | |
33 | AMOUNT | ICL_DRGAMOUNT_D_PE | ICL_ITAMT | CURR | 15 | 2 | DRG Amount | ||
34 | REMUN_TYPE_ADDAM | ICL_REMUN_TYPE_D_PE | ICL_REMUN_TYPE_D_PE | CHAR | 4 | 0 | Remuneration Category | ICL_CREMUNTYPE | |
35 | ADDITIONALAMOUNT | ICL_DRGADDAMOUNT_D_PE | ICL_ITAMT | CURR | 15 | 2 | Additional DRG Amount | ||
36 | CURR | ICL_EVCURR | WAERS | CUKY | 5 | 0 | Currency of Evaluated Amount | TCURC | |
37 | AMOUNTDAYS | ICL_DRG_AMOUNTDAYS_D_PE | ICL_DRG_AMOUNTDAYS_D_PE | NUMC | 3 | 0 | Number of Days for DRG Calculation (Markdown/Markup) | ||
38 | ITEM_REF | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
39 | PROCUREMENT | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | ICLPROCURE | |
40 | .INCLUDE | 0 | 0 | Mechanical Ventilation Duration | |||||
41 | EVQUANTITY | ICL_BREATHINGTIME_D_PE | ICL_LIMAMT | QUAN | 10 | 3 | Duration of Mechanical Ventilation | ||
42 | EVQUANUNIT | ICL_BREATHINGUNIT_D_PE | MEINS | UNIT | 3 | 0 | Unit of Mechanical Ventilation Duration | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_DRGITEM_S_PE | CATAID | TICL350 | CATAID | |||
2 | ICL_DRGITEM_S_PE | CHANGEDBY | USR02 | BNAME | |||
3 | ICL_DRGITEM_S_PE | CLAIM | ICLCLAIM | CLAIM | |||
4 | ICL_DRGITEM_S_PE | CLIENT | T000 | MANDT | KEY | 1 | CN |
5 | ICL_DRGITEM_S_PE | CURR | TCURC | WAERS | |||
6 | ICL_DRGITEM_S_PE | DIAGID | TICL351 | DIAGID | |||
7 | ICL_DRGITEM_S_PE | PROCUREMENT | ICLPROCURE | PROCUREMENT | |||
8 | ICL_DRGITEM_S_PE | REMUN_TYPE_ADDAM | ICL_CREMUNTYPE | REMUN_TYPE | KEY | 1 | CN |
9 | ICL_DRGITEM_S_PE | REMUN_TYPE_AM | ICL_CREMUNTYPE | REMUN_TYPE | KEY | 1 | CN |
10 | ICL_DRGITEM_S_PE | SERVCAT | TICL401 | SERVCATID | |||
11 | ICL_DRGITEM_S_PE | SUBCLAIM | ICLSUBCL | SUBCLAIM |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 700 |