CFG_UI_TBL

(SQL Table)
 Index Back

Configurator

Table of specifications for buttons and other UI objects used by Configurator

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator
2 CFG_PAGE_TITLE Character(254) VARCHAR2(254) NOT NULL Page title input field on Configurator Display tab
3 CFG_PAGE_HEIGHT Number(9,0) DECIMAL(9) NOT NULL Page height input field on Configurator Display tab

Default Value: 1200

4 CFG_PAGE_WIDTH Number(9,0) DECIMAL(9) NOT NULL Page width input field on Configurator Display tab

Default Value: 800

5 CFG_INCL_APPV Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Display tab to indicate that application level violations should be shown

Y/N Table Edit

Default Value: Y

6 CFG_SHOW_PRICE Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to Show control list price

Y/N Table Edit

Default Value: Y

7 CFG_REQ_COMPLETE Character(1) VARCHAR2(1) NOT NULL Check box to indicate that Configurator should validate the configuration upon return

Y/N Table Edit

Default Value: Y

8 CFG_CAPTION_RETURN Character(50) VARCHAR2(50) NOT NULL Configurator
9 CFG_CAPTION_CANCEL Character(50) VARCHAR2(50) NOT NULL Configurator
10 CFG_CAPTION_UPDATE Character(50) VARCHAR2(50) NOT NULL Configurator
11 CFG_CAPTION_NONE Character(50) VARCHAR2(50) NOT NULL Configurator
12 CFG_CAPTION_MGR Character(50) VARCHAR2(50) NOT NULL Return to Manager Caption input for Configurator
13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time