VIEW: BEN.BEN_ICD_TRANSACTION#

Source

View Text - Preformatted

select ICD_TRANSACTION_ID ICD_TRANSACTION_ID, ICD_CHC_RATE_ID ICD_CHC_RATE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_STEP_ID TRANSACTION_STEP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, DML_OPERATION DML_OPERATION, DATETRACK_MODE DATETRACK_MODE, EFFECTIVE_DATE EFFECTIVE_DATE, PL_TYP_ID PL_TYP_ID, PL_ID PL_ID, OPT_ID OPT_ID, OIPL_ID OIPL_ID, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT RT_STRT_DT, RT_STRT_DT_RL RT_STRT_DT_RL, RT_END_DT_CD RT_END_DT_CD, RT_END_DT RT_END_DT, RT_END_DT_RL RT_END_DT_RL, NNMNTRY_UOM NNMNTRY_UOM, BNF_RQD_FLAG BNF_RQD_FLAG, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, ELEMENT_LINK_ID ELEMENT_LINK_ID, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID, ELEMENT_TYPE_CONTEXT ELEMENT_TYPE_CONTEXT, INPUT_VALUE_ID1 INPUT_VALUE_ID1, INPUT_VALUE1 INPUT_VALUE1, INPUT_VALUE_ID2 INPUT_VALUE_ID2, INPUT_VALUE2 INPUT_VALUE2, INPUT_VALUE_ID3 INPUT_VALUE_ID3, INPUT_VALUE3 INPUT_VALUE3, INPUT_VALUE_ID4 INPUT_VALUE_ID4, INPUT_VALUE4 INPUT_VALUE4, INPUT_VALUE_ID5 INPUT_VALUE_ID5, INPUT_VALUE5 INPUT_VALUE5, INPUT_VALUE_ID6 INPUT_VALUE_ID6, INPUT_VALUE6 INPUT_VALUE6, INPUT_VALUE_ID7 INPUT_VALUE_ID7, INPUT_VALUE7 INPUT_VALUE7, INPUT_VALUE_ID8 INPUT_VALUE_ID8, INPUT_VALUE8 INPUT_VALUE8, INPUT_VALUE_ID9 INPUT_VALUE_ID9, INPUT_VALUE9 INPUT_VALUE9, INPUT_VALUE_ID10 INPUT_VALUE_ID10, INPUT_VALUE10 INPUT_VALUE10, INPUT_VALUE_ID11 INPUT_VALUE_ID11, INPUT_VALUE11 INPUT_VALUE11, INPUT_VALUE_ID12 INPUT_VALUE_ID12, INPUT_VALUE12 INPUT_VALUE12, INPUT_VALUE_ID13 INPUT_VALUE_ID13, INPUT_VALUE13 INPUT_VALUE13, INPUT_VALUE_ID14 INPUT_VALUE_ID14, INPUT_VALUE14 INPUT_VALUE14, INPUT_VALUE_ID15 INPUT_VALUE_ID15, INPUT_VALUE15 INPUT_VALUE15, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, STATUS STATUS, PL_ORDR_NUM PL_ORDR_NUM, OIPL_ORDR_NUM OIPL_ORDR_NUM, REASON REASON, FUTURE_DATA_EXISTS FUTURE_DATA_EXISTS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, E_OBJECT_VERSION_NUMBER E_OBJECT_VERSION_NUMBER, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ENTRY_INFORMATION_CATEGORY ENTRY_INFORMATION_CATEGORY, ENTRY_INFORMATION1 ENTRY_INFORMATION1, ENTRY_INFORMATION2 ENTRY_INFORMATION2, ENTRY_INFORMATION3 ENTRY_INFORMATION3, ENTRY_INFORMATION4 ENTRY_INFORMATION4, ENTRY_INFORMATION5 ENTRY_INFORMATION5, ENTRY_INFORMATION6 ENTRY_INFORMATION6, ENTRY_INFORMATION7 ENTRY_INFORMATION7, ENTRY_INFORMATION8 ENTRY_INFORMATION8, ENTRY_INFORMATION9 ENTRY_INFORMATION9, ENTRY_INFORMATION10 ENTRY_INFORMATION10, ENTRY_INFORMATION11 ENTRY_INFORMATION11, ENTRY_INFORMATION12 ENTRY_INFORMATION12, ENTRY_INFORMATION13 ENTRY_INFORMATION13, ENTRY_INFORMATION14 ENTRY_INFORMATION14, ENTRY_INFORMATION15 ENTRY_INFORMATION15, ENTRY_INFORMATION16 ENTRY_INFORMATION16, ENTRY_INFORMATION17 ENTRY_INFORMATION17, ENTRY_INFORMATION18 ENTRY_INFORMATION18, ENTRY_INFORMATION19 ENTRY_INFORMATION19, ENTRY_INFORMATION20 ENTRY_INFORMATION20, ENTRY_INFORMATION21 ENTRY_INFORMATION21, ENTRY_INFORMATION22 ENTRY_INFORMATION22, ENTRY_INFORMATION23 ENTRY_INFORMATION23, ENTRY_INFORMATION24 ENTRY_INFORMATION24, ENTRY_INFORMATION25 ENTRY_INFORMATION25, ENTRY_INFORMATION26 ENTRY_INFORMATION26, ENTRY_INFORMATION27 ENTRY_INFORMATION27, ENTRY_INFORMATION28 ENTRY_INFORMATION28, ENTRY_INFORMATION29 ENTRY_INFORMATION29, ENTRY_INFORMATION30 ENTRY_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "BEN"."BEN_ICD_TRANSACTION"

View Text - HTML Formatted

SELECT ICD_TRANSACTION_ID ICD_TRANSACTION_ID
, ICD_CHC_RATE_ID ICD_CHC_RATE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_STEP_ID TRANSACTION_STEP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, DML_OPERATION DML_OPERATION
, DATETRACK_MODE DATETRACK_MODE
, EFFECTIVE_DATE EFFECTIVE_DATE
, PL_TYP_ID PL_TYP_ID
, PL_ID PL_ID
, OPT_ID OPT_ID
, OIPL_ID OIPL_ID
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT RT_STRT_DT
, RT_STRT_DT_RL RT_STRT_DT_RL
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT RT_END_DT
, RT_END_DT_RL RT_END_DT_RL
, NNMNTRY_UOM NNMNTRY_UOM
, BNF_RQD_FLAG BNF_RQD_FLAG
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ELEMENT_LINK_ID ELEMENT_LINK_ID
, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, ELEMENT_TYPE_CONTEXT ELEMENT_TYPE_CONTEXT
, INPUT_VALUE_ID1 INPUT_VALUE_ID1
, INPUT_VALUE1 INPUT_VALUE1
, INPUT_VALUE_ID2 INPUT_VALUE_ID2
, INPUT_VALUE2 INPUT_VALUE2
, INPUT_VALUE_ID3 INPUT_VALUE_ID3
, INPUT_VALUE3 INPUT_VALUE3
, INPUT_VALUE_ID4 INPUT_VALUE_ID4
, INPUT_VALUE4 INPUT_VALUE4
, INPUT_VALUE_ID5 INPUT_VALUE_ID5
, INPUT_VALUE5 INPUT_VALUE5
, INPUT_VALUE_ID6 INPUT_VALUE_ID6
, INPUT_VALUE6 INPUT_VALUE6
, INPUT_VALUE_ID7 INPUT_VALUE_ID7
, INPUT_VALUE7 INPUT_VALUE7
, INPUT_VALUE_ID8 INPUT_VALUE_ID8
, INPUT_VALUE8 INPUT_VALUE8
, INPUT_VALUE_ID9 INPUT_VALUE_ID9
, INPUT_VALUE9 INPUT_VALUE9
, INPUT_VALUE_ID10 INPUT_VALUE_ID10
, INPUT_VALUE10 INPUT_VALUE10
, INPUT_VALUE_ID11 INPUT_VALUE_ID11
, INPUT_VALUE11 INPUT_VALUE11
, INPUT_VALUE_ID12 INPUT_VALUE_ID12
, INPUT_VALUE12 INPUT_VALUE12
, INPUT_VALUE_ID13 INPUT_VALUE_ID13
, INPUT_VALUE13 INPUT_VALUE13
, INPUT_VALUE_ID14 INPUT_VALUE_ID14
, INPUT_VALUE14 INPUT_VALUE14
, INPUT_VALUE_ID15 INPUT_VALUE_ID15
, INPUT_VALUE15 INPUT_VALUE15
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, STATUS STATUS
, PL_ORDR_NUM PL_ORDR_NUM
, OIPL_ORDR_NUM OIPL_ORDR_NUM
, REASON REASON
, FUTURE_DATA_EXISTS FUTURE_DATA_EXISTS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, E_OBJECT_VERSION_NUMBER E_OBJECT_VERSION_NUMBER
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ENTRY_INFORMATION_CATEGORY ENTRY_INFORMATION_CATEGORY
, ENTRY_INFORMATION1 ENTRY_INFORMATION1
, ENTRY_INFORMATION2 ENTRY_INFORMATION2
, ENTRY_INFORMATION3 ENTRY_INFORMATION3
, ENTRY_INFORMATION4 ENTRY_INFORMATION4
, ENTRY_INFORMATION5 ENTRY_INFORMATION5
, ENTRY_INFORMATION6 ENTRY_INFORMATION6
, ENTRY_INFORMATION7 ENTRY_INFORMATION7
, ENTRY_INFORMATION8 ENTRY_INFORMATION8
, ENTRY_INFORMATION9 ENTRY_INFORMATION9
, ENTRY_INFORMATION10 ENTRY_INFORMATION10
, ENTRY_INFORMATION11 ENTRY_INFORMATION11
, ENTRY_INFORMATION12 ENTRY_INFORMATION12
, ENTRY_INFORMATION13 ENTRY_INFORMATION13
, ENTRY_INFORMATION14 ENTRY_INFORMATION14
, ENTRY_INFORMATION15 ENTRY_INFORMATION15
, ENTRY_INFORMATION16 ENTRY_INFORMATION16
, ENTRY_INFORMATION17 ENTRY_INFORMATION17
, ENTRY_INFORMATION18 ENTRY_INFORMATION18
, ENTRY_INFORMATION19 ENTRY_INFORMATION19
, ENTRY_INFORMATION20 ENTRY_INFORMATION20
, ENTRY_INFORMATION21 ENTRY_INFORMATION21
, ENTRY_INFORMATION22 ENTRY_INFORMATION22
, ENTRY_INFORMATION23 ENTRY_INFORMATION23
, ENTRY_INFORMATION24 ENTRY_INFORMATION24
, ENTRY_INFORMATION25 ENTRY_INFORMATION25
, ENTRY_INFORMATION26 ENTRY_INFORMATION26
, ENTRY_INFORMATION27 ENTRY_INFORMATION27
, ENTRY_INFORMATION28 ENTRY_INFORMATION28
, ENTRY_INFORMATION29 ENTRY_INFORMATION29
, ENTRY_INFORMATION30 ENTRY_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "BEN"."BEN_ICD_TRANSACTION"