PSC_CE_CASE_TIMELINE_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
TIMELINE_KEY CASE_KEY EVENT_TYPE EVENT_DATETIME ATTR_1 ATTR_2 ATTR_3 ATTR_4 ATTR_5 ATTR_6 SPREADSHEETTITLE SPREADSHEETSUMMARY SPREADSHEETDETAIL

Query

SQL_Statement

select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_CREATE_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_UPDATE_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_NOTICE_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_INSPTN_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_PAYMNT_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_APPEAL_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_HEARNG_TML_V UNION ALL select TIMELINE_KEY, CASE_KEY, EVENT_TYPE, EVENT_DATETIME, ATTR_1, ATTR_2, ATTR_3, ATTR_4, ATTR_5, ATTR_6, SPREADSHEETTITLE, SPREADSHEETSUMMARY, SPREADSHEETDETAIL from PSC_CE_CASE_INCUPD_TML_V