RAD_REC_ENTITY_IDLANGUAGE_CDPrompt Table: PSRECDEFN
RAD_REC_ENT_VWL(SQL View) |
Index Back |
|---|---|
Search View for CharacteristicAdvisor Search View for Characteristic, Language View |
| SELECT A.RAD_REC_ENTITY_ID , B.LANGUAGE_CD , B.DESCR , B.RECNAME , B.DESCR100 , A.RAD_CHAR_DISPLAY , A.RAD_CHAR_RECOM FROM PS_RAD_REC_ENTITY A , PS_RAD_REC_ENT_LNG B WHERE A.RAD_REC_ENTITY_ID = B.RAD_REC_ENTITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RAD_REC_ENTITY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Characteristic mapping |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | RAD_CHAR_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL | Display Characteristic |
| 7 | RAD_CHAR_RECOM | Character(1) | VARCHAR2(1) NOT NULL | Recommendation Characteristic |