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 |