FSPC_UPDUSR_AET

(SQL Table)
Index Back

FSWC State Record

State record for FSWC_UPD_USR AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
3 FSPC_PGLT_TYPE Character(1) VARCHAR2(1) NOT NULL Pagelet Type
1=My Links
2=My Reports
3=My Work
4=Queries
4 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
5 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
6 ENABLE_PERSONALIZE Character(1) VARCHAR2(1) NOT NULL FSWC-Workcenter Personaliztion

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 FSPC_AGRP_RECNAME Character(15) VARCHAR2(15) NOT NULL Admin Group Recname
10 FSPC_ALST_RECNAME Character(15) VARCHAR2(15) NOT NULL Admin List Recname
11 FSPC_UGRP_RECNAME Character(15) VARCHAR2(15) NOT NULL User Group Recname
12 FSPC_ULST_RECNAME Character(15) VARCHAR2(15) NOT NULL User List Recname
13 EOWC_ENABLE_VIEWBY Character(1) VARCHAR2(1) NOT NULL FSWC-Workcenter Personaliztion
14 EOWC_VIEWBY Character(36) VARCHAR2(36) NOT NULL Filter criteria identification
15 FSPC_DESCR Character(40) VARCHAR2(40) NOT NULL Description