SQLSTMT_TBL

index back

Stored SQL Statements


PeopleSoft Field NameField TypeColumn TypeDescription
PGM_NAMECharacter(8)VARCHAR2(8) NOT NULLProgram Name
STMT_TYPECharacter(1)VARCHAR2(1) NOT NULLSQL Statement Type
B=Boolean
F=Function
O=Operation
STMT_NAMECharacter(7)VARCHAR2(7) NOT NULLSQL Statement Name
STMT_TEXTLong Character(8192)CLOB NOT NULLSQL Statement Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19