RAD_ADVISOR_TYP_IDRAD_STEP_IDC=Select Characteristics
P=Select Conditions
Q=Select Questions
S=Page Management
T=Test Dialog
U=Define Target Groups
V=Validate Dialog
W=Weighting Model
H=Hidden
R=Required
S=Show
RAD_ADV_STP_VW(SQL View) |
Index Back |
|---|---|
Step View for AdvisorStep View for Advisor |
| SELECT A.RAD_ADVISOR_TYP_ID , A.RAD_STEP_ID , B.RAD_STEP_TYP , A.RAD_STEP_USE , B.DESCR , B.DESCR254 , A.SEQNO FROM PS_RAD_ADV_TYP_STP A , PS_RAD_STEPS B WHERE A.RAD_STEP_ID = B.RAD_STEP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RAD_ADVISOR_TYP_ID |
Character(20) | VARCHAR2(20) NOT NULL | Advisor Type Guid - internally represents the Type |
| 2 | RAD_STEP_ID |
Character(20) | VARCHAR2(20) NOT NULL | Step ID |
| 3 | RAD_STEP_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Advisor flag to indicate the Step type
C=Select Characteristics P=Select Conditions Q=Select Questions S=Page Management T=Test Dialog U=Define Target Groups V=Validate Dialog W=Weighting Model |
| 4 | RAD_STEP_USE | Character(1) | VARCHAR2(1) NOT NULL |
Step Usage
H=Hidden R=Required S=Show |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |