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