| PSXPTMPLTYPE(SQL Table) | Index Back | 
|---|---|
| Template Type DefinitionTemplate type is managed from "Template Type" page. Output type for each template type is stored on child record PSXPTMPLOUTTYPE. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | Template Type ETX=eText PDF=PDF RTF=RTF XLS=Excel XSL=XSL | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL | Status Indicator A=Active I=Inactive | 
| 4 | PT_FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension | 
| 5 | XLIFF_ENABLED | Character(1) | VARCHAR2(1) NOT NULL | XLIFF translation N=No Y=Yes | 
| 6 | PLUGIN_URL | Character(254) | VARCHAR2(254) NOT NULL | Plug-in URL |