RPT_SESSION Table
This section lists the database columns in the RPT_SESSION table.
|
Database Column |
Details |
|
ID |
Type: Decimal. The ID column is the synthetic primary key for the RPT_SESSION table. |
|
USER_NAME |
Type: text. Unique. The name of the user who ran the report. |
|
USER_ID |
Type: Decimal. Unique. The ID of the usr who ran the report. |
|
TIME_STARTED |
Type: TimeStamp. Unique. The time at which the report started running. |
|
TIME_FINISHED |
Type: TimeStamp. Unique. The time at which the report finished running. |
|
TITLE |
Type: text. Unique. The TITLE Column holds the value from the NAME column of the RPT_CONFIGURATION table for the row that defines the report being run. |
|
PERCENT_COMPLETE |
Type: Integer. Unique. The PERCENT_COMPLETE column contains a value from 0 to 100 representing the progress of the report. |
|
NOTIFY_TO |
Type: text. Unique. Deprecated |
|
STATE |
Type: Integer. Unique. The STATE column holds information about the report run. Possible values are: 1: Scheduled, 2: Complete, 3: Reviewed, 4: Failed, 5: Running, 6: Interrupted, 7: Partial complete, 9: Could not execute, and 10: No data. |
|
STATUS_LOG |
Type: text(max length 4000). Unique. The STATUS_LOG column may contain a message relating to the status of the report, for example a failure reason. |
|
REPORT_GEN_RETURN_STATUS |
Type: Integer. Unique. The REPORT_GEN_RETURN_STATUS will be populated in the event of a failure running a report. Posible values are: 0: No failure, -1: General failure, -101: License checkout failue. |
|
PUBLISH_DIRECTORY |
Type: text. Unique. The PUBLISH_DIRECTORY contains the full path to where the report will be published to upon completion. |
|
OWNER_USER_ID |
Type: Decimal. Unique. Deprecated |
|
PRODUCT_TITLE |
Type: text. Unique. The PRODUCT_TITLE column contains the title of the report. |
|
NUM_PAGES |
Type: Integer. Unique. Deprecated |
|
FILE_NAME_BASE |
Type: text. Unique. The base file name used when saving the report files to disk. |
|
LOCATION_DIRECTORY |
Type: text. Unique. The LOCATION_DIRECTORY is the relative path to the report outout within the data directory. |
|
DEBUG_FILE |
Type: text. Unique. The name of the debug file written to disk for the report. |
|
config |
Type: Decimal. References Table: RPT_CONFIGURATION Table The NAME Column holds the value from the ID column of the RPT_CONFIGURATION table for the row that defines the report being run. |