rs_files

The following table lists the columns for the rs_files view. The equivalent jcs_files view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.

Column	Datatype	Description
ID	NUMBER	The unique ID of the file object
URL	VARCHAR2	The unique URL of the file
VERSION	NUMBER	The version number of the file object
OWNER	VARCHAR2	The owner of the file object
DESCRIPTION	VARCHAR2	The description of the file object
APPLICATION_PARTITION	VARCHAR2	The partition of the application; can be used to group Redwood objects in logical groups
APPLICATION_NAME	VARCHAR2	The name of the application; can be used to group Redwood objects in logical groups
COMMENT_TEXT	VARCHAR2	Comment describing the file object
FILE_SIZE	NUMBER	The (operating system) size of the file
CREATION_DATE	TIMESTAMP	The date that the file object was created
EXPIRATION_DATE	TIMESTAMP	The date that the file object can be thrown away
FORMAT_PARTITION	VARCHAR2	The partition of the format belonging to the file object
FORMAT_NAME	VARCHAR2	The name of the format belonging to the file object
INDEX_NAME	VARCHAR2	The index belonging to the file object
TRY_DELETE	VARCHAR2	Should we try to delete the file, when the file object is deleted
MUST_DELETE	VARCHAR2	MUST we delete the file, when the file object is deleted
DELETING	VARCHAR2	Is the file being deleted
REF_SCHEMA	NUMBER	Schema ID of referring object
REF_SCHEMANAME	VARCHAR2	The name of the schema of the referenced object
REF_OBJID	NUMBER	Object ID of referring object
REF_OBJNAME	VARCHAR2	The name of the referenced object
DELETE_FAIL_TIME	TIMESTAMP	The timestamp of the last failed delete
DELETE_FAIL_REASON	VARCHAR2	The reason why the last delete failed