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