PGM_NAMESTMT_TYPEB=Boolean
F=Function
O=Operation
STMT_NAMESQLSTMT_TBL(SQL Table) |
Index Back |
|---|---|
Stored SQL Statements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PGM_NAME |
Character(8) | VARCHAR2(8) NOT NULL | Program Name |
| 2 | STMT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
SQL Statement Type
B=Boolean F=Function O=Operation |
| 3 | STMT_NAME |
Character(7) | VARCHAR2(7) NOT NULL | SQL Statement Name |
| 4 | STMT_TEXT | Long Character(8192) | CLOB NOT NULL | SQL Statement Text |