EOEC_UL_SQLP_VW

(SQL View)
Index Back

UserList SQL Bind Prompt View

EOEC UserList SQL Bind values prompt view

SELECT A.RECNAME , A.FIELDNAME FROM PSRECFIELD A WHERE SUBRECORD='N' UNION SELECT A.RECNAME , B.FIELDNAME FROM PSRECFIELD A , PSRECFIELD B WHERE A.FIELDNAME=B.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEC_UL_CTX_REC Character(18) VARCHAR2(18) NOT NULL UserList Context Record Name
2 EOEC_UL_BIND_VALUE Character(32) VARCHAR2(32) NOT NULL Message Catalog Bind Values

Prompt Table: %EDITTABLE