RAD_QA_HDR(SQL Table) |
Index Back |
---|---|
PA Question HeaderProduct Advisor Question Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RAD_QUESTION_ID | Character(20) | VARCHAR2(20) NOT NULL | Question ID |
2 | RAD_QUESTION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Advisor Question Name Field, user visible name of the question |
3 | RAD_QUESTION_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Advisor Question Type used to identify the question
C=Condition F=Freeform Text M=Multiple Selection N=Numeric S=Single Selection Y=Yes/No Default Value: Y |
4 | RAD_QUESTION_TEXT | Character(245) | VARCHAR2(245) NOT NULL | Represents the drop-down for questions in Dialog Test. |
5 | RAD_LIBRARY_ID | Character(20) | VARCHAR2(20) NOT NULL |
Library for advisor
Prompt Table: RB_DROPDOWN |
6 | RAD_EXPLAIN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Explanation ID - internally represents an explanation
Prompt Table: RAD_EXPLAIN |
7 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL |
the ID value for a configured context
Prompt Table: RAD_CONTEXT_VW |
8 | RAD_NAV_TEXT | Character(75) | VARCHAR2(75) NOT NULL | Advisor Navigation Text Information to display to user |
9 | RAD_YESNO | Character(1) | VARCHAR2(1) NOT NULL |
Yes no Field
N=No Y=Yes |
10 | RAD_VALUE_NUM | Signed Number(25,5) | DECIMAL(23,5) NOT NULL | Number Value |
11 | RAD_QA_TOKEN_TEXT | Long Character | CLOB | Used to store the Text with Tokens inside of it. |
12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
13 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
14 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
15 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
16 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
17 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |