| RO_DISTMP_A_VW(SQL View) | Index Back | 
|---|---|
| Display TemplateDisplay Template | 
| SELECT TEMPLATE_ID_NUM , DESCR100 , DEFAULT_DISP_TEMP FROM PS_RO_DISPLAY_TEMP WHERE STATUS = 'A' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(5,0) | INTEGER NOT NULL | Template information for catalog used for catalog design | |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description | 
| 3 | DEFAULT_DISP_TEMP | Character(1) | VARCHAR2(1) NOT NULL | Default Display Template Y/N Table Edit |