SCCPS_TOOL_DFN

(SQL Table)
 Index Back

Pop Selection Tool Definition

Population Selection Tool Definition - selection tools, for example, PS Query, flat file, Equation Engine.

  • Related Language Record: SCCPS_TLDFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool
    2 SCCPS_TOOL_NAME Character(30) VARCHAR2(30) NOT NULL Pop selection tool name field. This is the user key to the pop select tool.
    3 SCCPS_STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 SCCPS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Generic description field used in the pop selection feature.
    5 SCCPS_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)
    6 SCCPS_AUTO_SEL Character(1) VARCHAR2(1) NOT NULL Automated Selection

    Y/N Table Edit

    Default Value: Y

    7 SCCPS_TOOLURL_LBL Character(30) VARCHAR2(30) NOT NULL Tool hyperlink label used by pop select. This field allows different tools to have their own tool hyperlink label.
    8 SCCPS_ADDURL_LBL Character(30) VARCHAR2(30) NOT NULL Tool hyperlink label used by pop select. This field allows different tools to have their own tool hyperlink label.
    9 SCCPS_TOOL_MENU Character(30) VARCHAR2(30) NOT NULL Pop Select tool menu name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MENU_VW

    10 SCCPS_TOOL_BARNAME Character(30) VARCHAR2(30) NOT NULL Pop Select tool bar name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MBAR_VW

    11 SCCPS_TOOL_ITEM Character(30) VARCHAR2(30) NOT NULL Pop Select tool item name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MITEM_VW

    12 SCCPS_TOOL_PAGE Character(30) VARCHAR2(30) NOT NULL Pop Select tool page name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MPAGE_VW

    13 SCCPS_QRY_PRMPT Character(15) VARCHAR2(15) NOT NULL Prompt record on the tool definition for pop select. This field contains the record used as the promtp for the selection name or "Query Name".

    Prompt Table: RECDEFN_VW

    14 SCCPS_MAX_RSLTS Number(9,0) DECIMAL(9) NOT NULL Maximum Results - used by pop select to cap the max records for a given selection tool.
    15 SCCPS_SEL_LABEL Character(30) VARCHAR2(30) NOT NULL Selection label value used by population select. Allows different selection tools to have there own label.
    16 SCCPS_ENABLE_PRVW Character(1) VARCHAR2(1) NOT NULL Enable Preview Results on the Pop Selection feature

    Y/N Table Edit

    Default Value: Y

    17 SCCPS_MAX_PRVW Number(9,0) DECIMAL(9) NOT NULL Pop Select Maximum number of records to preview
    18 SCCPS_SPRT_FILE Character(1) VARCHAR2(1) NOT NULL Pop Select File Input Support

    Y/N Table Edit

    Default Value: N

    19 SCCPS_FILE_OPTN Character(1) VARCHAR2(1) NOT NULL File Option
    A=Attachment
    P=Physical Path

    Default Value: A

    20 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

    Prompt Table: PSURLDEFN

    21 SCCPS_MAX_FILE Number(10,0) DECIMAL(10) NOT NULL Max File Size (Kbytes)