RAD_REC_ENTITY_IDPrompt Table: PSRECDEFN
Y/N Table Edit
Y/N Table Edit
RAD_REC_ENT_VW(SQL View) |
Index Back |
|---|---|
Search View for CharacteristicAdvisor Search View for Characteristic |
| SELECT RAD_REC_ENTITY_ID , DESCR , RECNAME , DESCR100 , RAD_CHAR_DISPLAY , RAD_CHAR_RECOM FROM PS_RAD_REC_ENTITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RAD_REC_ENTITY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Characteristic mapping |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | RAD_CHAR_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Display Characteristic
Y/N Table Edit |
| 6 | RAD_CHAR_RECOM | Character(1) | VARCHAR2(1) NOT NULL |
Recommendation Characteristic
Y/N Table Edit |