Column name | TDV JDBC Data Type | Nullable | Description |
PROCEDURE_ID: | INTEGER | Identifier of the procedure; Primary key. | |
PROCEDURE_NAME: | VARCHAR | Name of the procedure | |
PROCEDURE_TYPE: | SMALLINT | Type of the procedure 1 indicates procedure returns no result 2 indicates procedure returns result | |
SCHEMA_ID: | INTEGER | Yes | See SCHEMA_ID in Table: model.ALL_SCHEMAS |
SCHEMA_NAME: | VARCHAR | Yes | See SCHEMA_NAME in Table: model.ALL_SCHEMAS |
CATALOG_ID: | INTEGER | Yes | See CATALOG_ID in Table: model.ALL_CATALOGS |
CATALOG_NAME: | VARCHAR | Yes | See CATALOG_ID in Table: model.ALL_CATALOGS |
DATASOURCE_ID: | INTEGER | See DATASOURCE_ID in Table: model.ALL_DATASOURCES | |
DATASOURCE_NAME: | VARCHAR | See DATASOURCE_NAME in Table: model.ALL_DATASOURCES | |
GUID: | VARCHAR | 128 bit unique identifier | |
ANNOTATION: | VARCHAR | Annotation for the procedure | |
OWNER_ID: | INTEGER | Identifier of the person who created/owns the procedure. Same as USER_ID in Table: ALL_USERS | |
OWNER: | VARCHAR | User name of the person who created/owns the procedureSame as USERNAME in Table: ALL_USERS | |
PARENT_PATH: | VARCHAR | Path to the parent container. | |
IS_AUTO_GENERATED | VARCHAR | Indicates if the parent folder has an attribute called 'webui_model'. If attribute is present, the value is 'YES' else 'NO' | |
PROCEDURE_CREATOR_ID: | INTEGER | Identifier of the user who created this procedure. Same as USER_ID in Table: ALL_USERS | |
PROCEDURE_CREATION_TIMESTAMP: | BIGINT | Timestamp when the procedure was created. | |
PROCEDURE_MODIFIER_ID: | INTEGER | Identifier of the user who last modified this procedure. Same as USER_ID in Table: ALL_USERS | |
PROCEDURE_MODIFICATION_TIMESTAMP: | BIGINT | Timestamp of the last modification of this procedure. | |
IMPACT_MESSAGE | VARCHAR | Impact message indicating errors. |