FSPC_MST_QRY

(SQL Table)
Index Back

Pagelet Config - Queries

Administrator level configuration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
2 ENABLE_PERSONALIZE Character(1) VARCHAR2(1) NOT NULL FSWC-Workcenter Personaliztion

Y/N Table Edit

Default Value: Y

3 ENABLE_USR_ADD_LNK Character(1) VARCHAR2(1) NOT NULL FSWC-Workcenter Personaliztion

Y/N Table Edit

Default Value: Y

4 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On
5 LAST_RUN_OPRID Character(30) VARCHAR2(30) NOT NULL Last Run By
6 LAST_UPDATE_DTM DateTime(26) TIMESTAMP Last Modified
7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8 ENABLE_QUERY Character(1) VARCHAR2(1) NOT NULL Enable Query

Y/N Table Edit

Default Value: Y