TL_FS_ACTV_VW

(SQL View)
 Index Back

TL Central Activty View - PF

View of the activity setup table. FS_ACTIVITY_TBL Only PF activities are selected in thie view.

SELECT SETID , ACTIVITY_ID , DESCR , PROJECT_TYPE , ACT_USE_PC , ACT_USE_PF FROM PS_FS_ACTIVITY_TBL WHERE ACT_USE_PF = 'Y'

  • Related Language Record: TL_FS_ACTV_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type

    Prompt Table: PROJ_TYPE_TBL

    5 ACT_USE_PC Character(1) VARCHAR2(1) NOT NULL Projects

    Y/N Table Edit

    Default Value: Y

    6 ACT_USE_PF Character(1) VARCHAR2(1) NOT NULL Performance Measurement

    Y/N Table Edit

    Default Value: N