RAD_ADV_TYP_VW(SQL View) |
Index Back |
---|---|
RAD Search View for TypesAdvisor Search View for Advisor Types |
SELECT RAD_ADVISOR_TYP_ID , DESCR50 , RECNAME , DESCR254 FROM PS_RAD_ADV_TYP_HDR |
# | 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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |