The IFRPT_CASE_LOG Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
CASE_ID Format NUMBER Indexed? No May be Null? Yes	The system ID of the related case in the Interfolio system.
CREATION_DATE Format DATE Indexed? No May be Null? Yes	The date on which the IFRPT_CASE_LOG record was loaded into the Data Warehouse.
LOG_DATE Format DATE Indexed? No May be Null? Yes	The date on which the activity was logged in Interfolio.
MESSAGE Format CLOB(4000) Indexed? No May be Null? Yes	The text record of the activity performed and logged in Interfolio.
TYPE Format VARCHAR2(400) Indexed? No May be Null? Yes	The type of action performed and logged in Interfolio.

Questions about this page? Email us at da-staff@isc.upenn.edu