RAD_ADVISOR_IDDESCRPrompt Table: RAD_STATUS_VW
RAD_ADV_VER_VW(SQL View) |
Index Back |
|---|---|
RAD Search RecordView Record used for Advisor Search |
| SELECT A.RAD_ADVISOR_ID , A.DESCR , C.DESCR , A.DESCR254 , B.START_DT , B.END_DT FROM PS_RAD_ADVISOR A , PS_RAD_ADVISOR_VER B , PS_RAD_STATUS C WHERE A.RAD_CUR_WRK_VER = B.RAD_VERSION_ID AND A.RAD_ADVISOR_ID = B.RAD_ADVISOR_ID AND B.RAD_STATUS_ID = C.RAD_STATUS_ID |
| # | 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 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | RAD_STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Advisor Status Description - description of the status
Prompt Table: RAD_STATUS_VW |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 6 | END_DT | Date(10) | DATE | This field stores the end date values. |