Application Programming Interface Guide > DSL API > Folders > System Tables
 
System Tables
ALL_FOLDERS
The model.ALL_FOLDERS table has the following columns:
 
Column name
TDV JDBC Data Type
Nullable
Description
FOLDER_ID:
INTEGER
 
Identifier of the folder.
FOLDER_NAME
VARCHAR
 
Name of the folder
GUID
CHAR
 
128 bit unique identifier.
ANNOTATION
VARCHAR
 
Annotation for the folder
OWNER_ID
INTEGER
 
Identifier of the person who created/owns the folder. Same as USER_ID in Table: ALL_USERS
OWNER
VARCHAR
 
User name of the person who created/owns the folder. Same as USERNAME in Table: ALL_USERS
PARENT_PATH
VARCHAR
 
Path to the parent container.
FOLDER_CREATION_TIMESTAMP
BIGINT
 
Timestamp when the folder was created.
FOLDER_MODIFICATION_TIMESTAMP
BIGINT
 
Timestamp of the last modification of this folder.
FOLDER_CREATOR_ID
INTEGER
 
Identifier of the user who created this folder. Same as USER_ID in Table: ALL_USERS
FOLDER_MODIFIER_ID
INTEGER
 
Identifier of the user who last modified this folder. Same as USER_ID in Table: ALL_USERS
This table is similar to system.ALL_PUBLISHED_FOLDERS table that represents only the folders created under /services/webservices folder.
The model.ALL_FOLDERS table does not include the folders starting with system paths like /policy "/system", "/deployment", "/scratch", "/security", "/packages", "/vcs_sources" or "/services/databases". This table does not include the folders owned by 'system' user.
The existing ALL_PUBLISHED_FOLDERS will continue to show only any folders that may be present under /services/webservices folder.