PGM_NAMESTMT_TYPEB=Boolean
F=Function
O=Operation
STMT_NAMESQLSTMT_TBL |
index back |
|---|---|
Stored SQL Statements |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PGM_NAME |
Character(8) | VARCHAR2(8) NOT NULL | Program Name |
| STMT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
SQL Statement Type
B=Boolean F=Function O=Operation |
| STMT_NAME |
Character(7) | VARCHAR2(7) NOT NULL | SQL Statement Name |
| STMT_TEXT | Long Character(8192) | CLOB NOT NULL | SQL Statement Text |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |