BAS_TMPL_DEF_IDBAS_STM_TM_SRCH(SQL View) |
Index Back |
|---|---|
Statement Template Defn SearchDefine the Statement Template Sections and Fields |
| SELECT DISTINCT BAS_TMPL_DEF_ID , BAS_TMPL_DEF_NAME FROM PS_BAS_STM_TM_DEFN A WHERE A.EFFDT=( SELECT MAX(EFFDT) FROM PS_BAS_STM_TM_DEFN B WHERE B.BAS_TMPL_DEF_ID=A.BAS_TMPL_DEF_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BAS_TMPL_DEF_ID |
Character(4) | VARCHAR2(4) NOT NULL | Template Definition ID |
| 2 | BAS_TMPL_DEF_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Definition Name |