RAD_AUD_QANDA (SQL Table)	Index Back
Audit for Questions in Advisor This record stores Audit for Questions in Advisor

RAD_AUD_QANDA

(SQL Table)

Audit for Questions in Advisor

This record stores Audit for Questions in Advisor

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RAD_SESSION_ID Character(20) VARCHAR2(20) NOT NULL User Session Identifier

2 RAD_SAVED_BY Character(1) VARCHAR2(1) NOT NULL Saved By
1=User Saved
2=System Saved

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 RAD_QUESTION_ID Character(20) VARCHAR2(20) NOT NULL Question ID

5 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

6 RAD_GUID Character(20) VARCHAR2(20) NOT NULL Advisor Identifier used internally to represent questions, dialogs, and other Advisor objects.

7 RAD_ANSWER_VALUE Character(254) VARCHAR2(254) NOT NULL Answer Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RAD_SESSION_ID	Character(20)	VARCHAR2(20) NOT NULL	User Session Identifier
2	RAD_SAVED_BY	Character(1)	VARCHAR2(1) NOT NULL	Saved By 1=User Saved 2=System Saved
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	RAD_QUESTION_ID	Character(20)	VARCHAR2(20) NOT NULL	Question ID
5	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
6	RAD_GUID	Character(20)	VARCHAR2(20) NOT NULL	Advisor Identifier used internally to represent questions, dialogs, and other Advisor objects.
7	RAD_ANSWER_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Answer Value