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 |
plsqlTopic
onsiteTopic