| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDRGITEM | DRG Item | 18 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
2 | ICLITEM | Claim Item | 21 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
3 | ICLPOLL | Limit and Deductible in Policy Snapshot | 23 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
4 | ICSDRGITEM | DRG Item | 18 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
5 | ICSITEM | Claim Item | 21 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
6 | ICSPOLL | Limit and Deductible in Policy Snapshot | 23 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
7 | TICL022 | Claim Item Rejection Reason | 2 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
8 | TICL022T | Claim Item Rejection Reason Text | 3 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
9 | TICL043 | Internal Claim Type: Permitted Claim Item Rejection Reason | 6 | REJREASON | Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
10 | TICL056 | Internal Claim Type: Permitted Benefit Type | 27 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
11 | TICL083 | Internal Claim Type: Limit and Deductible | 21 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
12 | TICL162 | Benefit Type Tree: Permitted Benefit Type | 27 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
13 | TICL163 | Benefit Type Tree: Limit and Deductible | 21 | REJREASON | Automatically Set Claim Item Rejection Reason | nvarchar | 2 | 0 | | |
TOPFinancials Basis |
14 | UBC_TB_REJ | Rejection Control | 4 | REJREASON | Reason for Rejection | nvarchar | 2 | 0 | | |