MicroStrategy ONE
STG_IS_PR_ANS_STATS
Records statistics related to prompts and prompt answers. This table is used when the Prompts option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_PR_ANS_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Datatype | Oracle Datatype | DB2 Datatype | Teradata Datatype | Sybase Datatype | MySQL Datatype | |||||||||
|
DAY_ID |
Day the prompt was answered. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|||||||||
|
HOUR_ID |
Hour the prompt was answered. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|||||||||
|
MINUTE_ID |
Minute the prompt was answered. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|||||||||
|
JOBID |
Job ID assigned by the server. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|||||||||
|
SESSIONID |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|||||||||
|
PR_ORDER_ID |
Order in which prompts were answered. Prompt order is set in Developer's Prompt Ordering dialog box. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|||||||||
|
ANS_SEQ_ID |
Sequence ID. For MicroStrategy use. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|||||||||
|
PR_LOC_TYPE |
The COM object type of the object that the prompt resides in:
|
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|||||||||
|
PR_LOC_ID |
ID of the object that the prompt resides in. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|||||||||
|
PR_LOC_DESC |
Object name of the object that the prompt resides in. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|||||||||
|
PR_GUID |
GUID of the prompt. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|||||||||
|
PR_NAME |
Name of the prompt. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|||||||||
|
PR_TITLE |
Prompt title. This cannot be NULL. This is the text that is displayed in Developer's Prompt Ordering dialog box, under Title. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|||||||||
|
PR_ANS_TYPE |
Type of prompt. For example, element, expression, object, or numeric. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|||||||||
|
PR_ANSWERS |
Prompt answers. |
VARCHAR(4000) |
VARCHAR2(4000 CHAR) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
|||||||||
|
PR_ANS_GUID |
For MicroStrategy use. |
VARCHAR(4000) |
VARCHAR2(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
|||||||||
|
IS_REQUIRED |
Y: If a prompt answer is required. N: If a prompt answer is not required. |
CHAR |
CHAR |
CHAR |
CHAR |
CHAR |
CHAR |
|||||||||
|
SERVERID |
GUID of the server definition. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|||||||||
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|||||||||
|
SERVERMACHINE |
The Intelligence Server machine name and IP address. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|||||||||
|
STARTTIME |
Timestamp of the job start time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|||||||||
|
RECORDTIME |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|||||||||
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |