SCC_TMPL(SQL Table) | 
Index Back | 
|---|---|
Template | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(15,0) | DECIMAL(15) NOT NULL | Template ID | |
| 2 | SCC_TMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name | 
| 3 | SCC_TMPL_STATUS | Character(2) | VARCHAR2(2) NOT NULL | 
Status
 10=Active 20=Inactive Default Value: 10  | 
| 4 | SCC_TMPL_TYPE_ID | Character(25) | VARCHAR2(25) NOT NULL | 
Template Type ID
 Prompt Table: SCC_TMPL_TYPE  |