rs_directories

The following table lists the columns for the rs_directories view. The equivalent jcs_directories 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
DIRECTORY_ID	NUMBER	Unique identification number of the directory
LINK_DIRECTORY_ID	NUMBER	The real directory where this one links to
VERSION	NUMBER	The version number of the directory
OWNER	VARCHAR2	Owner of the directory
NAME	VARCHAR2	Short name of the directory
DESCRIPTION	VARCHAR2	Descriptive text explaining the contents of the directory
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
PARENT_DIRECTORY_ID	NUMBER	Directory that this directory is a subdirectory of
SCRIPT_ID	NUMBER	Script that fills this directory
JOB_ID	NUMBER	Job that fills this directory
CREATION_TIME	TIMESTAMP WITH TIME ZONE	Timestamp that notes when the directory was createdThe timezone is specified as an Olson name.
LAST_MODIFICATION	TIMESTAMP WITH TIME ZONE	Timestamp that notes when the directory was changedThe timezone is specified as an Olson name.
DIRECT_SUBMIT	VARCHAR2	Flag if direct submit is allowed (effect only for script entries)
USE_DIRECTORY	VARCHAR2	Is the directory column in the job table checked
EXTERNAL_URL	VARCHAR2	Optional URL that this directory entry refers to
AUTO_DELETE	VARCHAR2	Directory is deleted when last child is deleted (Y,N,S) "S" is used when transaction children do not count
COMMENT_TEXT	VARCHAR2	Comment describing the directory

note

: V8 does not have directories anymore. Therefore this view is empty.

plsqlTopic

onsiteTopic