CFG_SCHEMA_VIEW

(SQL View)
 Index Back

Configurator

This view is created for oracle configurator integration. I has a field CZ whihc uses the case statement from sql query.

SELECT A.CFG_SCHEMA_ID , A.DESCR , A.CFG_SOLUTION_TYPE , A.CFG_SOLUTION_ID , A. CFG_CONFIG_TYPE , A. CFG_MODEL_ID , A. CFG_VERSION_MAJOR , A. CFG_VERSION_MINOR , A. CFG_RESTORE , A. CFG_ALLOW_NEW , A. CZ , %subrec(RB_AUDIT_SBR, A) FROM PS_CFG_SCHEMA_TBL A WHERE A.CZ = ( SELECT CASE WHEN CZ = 'Y' THEN 'Y' ELSE 'N' END FROM PS_INSTALLATION)

  • Related Language Record: CFG_SCHEMA_LANV

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CFG_SOLUTION_TYPE Character(1) VARCHAR2(1) NOT NULL Configurator
    0=Internal Solution
    1=External Solution

    Default Value: 1

    4 CFG_SOLUTION_ID Character(64) VARCHAR2(64) NOT NULL Configurator used in cz and cfg integration
    5 CFG_CONFIG_TYPE Character(1) VARCHAR2(1) NOT NULL Configurator
    0=Component
    1=Compound

    Default Value: 0

    6 CFG_MODEL_ID Character(64) VARCHAR2(64) NOT NULL Configurator
    7 CFG_VERSION_MAJOR Number(5,0) INTEGER NOT NULL Configurator
    8 CFG_VERSION_MINOR Number(5,0) INTEGER NOT NULL Configurator
    9 CFG_RESTORE Character(1) VARCHAR2(1) NOT NULL Restore Policy input on Configurator Display tab
    1=Original Model Version
    2=Original Model Version
    3=Most Current Model Version
    4=List Versions
    5=Allow Any Version

    Default Value: 1

    10 CFG_ALLOW_NEW Character(1) VARCHAR2(1) NOT NULL Field in the Database Table that indicates Y/N for user's ability to create a new Configuration

    Y/N Table Edit

    Default Value: Y

    11 CZ Character(1) VARCHAR2(1) NOT NULL This field is used for Option to install Oracle Configurator product.

    Y/N Table Edit

    Default Value: N

    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 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.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time