SCC_TMPL(SQL Table) |
Index Back |
---|---|
Template |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_TMPL_ID | 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 |