SCCPS_CNTXT_DFN

(SQL Table)
 Index Back

Pop Select Context Definition

Population Selection Context - the context stores information about how population is to be used bya specific process. For example, the results record, required fields, and field mapping are store here.

  • Related Language Record: SCCPS_CNTXT_LNG

  • Parent Record Of SCCPS_CNTTLS_VW SCCPS_CNTXT_BND SCCPS_CNTXT_CMP SCCPS_CNTXT_MAP SCCPS_CNTXT_MLN SCCPS_CNTXT_TL SCCPS_CNTXT_TLS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCCPS_CNTXT_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Population Selection Context Bind ID
    2 SCCPS_CNTXT_NAME Character(30) VARCHAR2(30) NOT NULL Context name - the user key to a pop select context.
    3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_ALT_VW

    4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

    Prompt Table: PRCSDEFN

    5 SCCPS_STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 SCCPS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Generic description field used in the pop selection feature.
    7 SCCPS_VARY_MAP Character(1) VARCHAR2(1) NOT NULL Pop Select Mapping Key

    Y/N Table Edit

    Default Value: N

    8 SCCPS_VARY_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Pop Select Mapping Key

    Prompt Table: SCCPS_CNTXT_MAP

    9 SCCPS_VARYMAP_CHNG Character(1) VARCHAR2(1) NOT NULL Context Varies per Application Data - Locked or Change Allowed

    Y/N Table Edit

    Default Value: N