RAD_ADVISOR_TDL(SQL Table) |
Index Back |
|---|---|
Transition TableAdvisor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RAD_ADVISOR_ID |
Character(20) | VARCHAR2(20) NOT NULL | Advisor Dialog Guid - represents internally the Advisor dialog |
| 2 | RAD_VERSION_ID |
Character(20) | VARCHAR2(20) NOT NULL | Advisor Version Identifier - internally represents a version |
| 3 | RAD_STATION_ID |
Character(20) | VARCHAR2(20) NOT NULL | station ID |
| 4 | RAD_TRANS_ID |
Character(20) | VARCHAR2(20) NOT NULL | Advisor Transition guid - represents the transition in a dialog |
| 5 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | RAD_OPEN_BRACKETS | Character(2) | VARCHAR2(2) NOT NULL |
Open Brackets
01=( 02=(( 03=((( 04=(((( |
| 7 | RAD_OPERAND | Character(4) | VARCHAR2(4) NOT NULL |
Advisor Operands for Transitions and Segments
<=Less Than <==Less than or Equal <>=Not Equal To ==Equal To >=Greater Than >==Greater than or Equal EFDT=Effective Date LIKE=Pattern Search |
| 8 | RAD_CLOSE_BRACKETS | Character(2) | VARCHAR2(2) NOT NULL |
Close bracket
01=) 02=)) 03=))) 04=)))) |
| 9 | RAD_AND_OR | Character(1) | VARCHAR2(1) NOT NULL |
Advisor AND/OR Field used in Transitions and User Segments
1=AND 2=OR |
| 10 | RAD_GUID | Character(20) | VARCHAR2(20) NOT NULL |
Advisor Identifier used internally to represent questions, dialogs, and other Advisor objects.
Prompt Table: RB_DROPDOWN |
| 11 | RAD_ANSWER_ID | Character(20) | VARCHAR2(20) NOT NULL |
Answer ID
Prompt Table: RB_DROPDOWN |
| 12 | RAD_ANSWER_NUM | Number(20,4) | DECIMAL(19,4) NOT NULL | Field that represents the input value of a number as an answer to a dialog question. |
| 13 | RAD_ANSWER_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Answer Value |
| 14 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 15 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 16 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 17 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 18 | 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. |
| 19 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |