AV_WORKSET

(SQL Table)
 Index Back

Workset

Basic workset information.

  • Related Language Record: AV_WORKSETLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: AV_OPREMPLID_VW

    2 WORKSET_CD Character(10) VARCHAR2(10) NOT NULL Workset Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: AV_WORKSET.DESCR

    5 WORKSET_SRCH Character(30) VARCHAR2(30) NOT NULL Workset Search
    6 WORKSET_STATUS Character(1) VARCHAR2(1) NOT NULL Workset Status
    A=Active
    I=Inactive

    Default Value: A

    7 WORKSET_TYPE Character(1) VARCHAR2(1) NOT NULL Workset Type
    D=Dynamic
    S=Static

    Default Value: S

    8 AV_AUTHOR_ID Character(30) VARCHAR2(30) NOT NULL Workset Author

    Prompt Table: AV_OPREMPLID_VW

    9 WORKSET_NOTES Long Character(254) VARCHAR2(254) Workset Notes
    10 WORKSET_ACCESS_TYP Character(1) VARCHAR2(1) NOT NULL Workset Access
    A=Staff Role
    O=Public
    P=Private
    S=Security Role

    Default Value: P

    11 AV_WS_METHOD Character(1) VARCHAR2(1) NOT NULL Method used to build a Workset
    M=Manual
    P=Population Selection

    Default Value: M

    12 BUILT_FLG Character(1) VARCHAR2(1) NOT NULL Audience Built

    Y/N Table Edit

    Default Value: N

    13 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    14 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    15 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    16 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    17 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    18 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    19 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    20 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    21 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    22 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    23 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time