SPB_SETID_ACT_V

(SQL View)
 Index Back

Activities by SetId

This record stores activities by SetID.

SELECT A.SETID , A.ACTIVITY_ID , A.DESCR , B.SERVICE_METHOD , B.SP_ACTIVITY_SUBTYP FROM PS_FS_ACTIVITY_TBL A , PS_SP_ACTIVITY_TYP B WHERE A.ACT_USE_SP='Y' AND A.SETID = B.SETID AND A.ACTIVITY_ID = B.ACTIVITY_ID

  • Related Language Record: SPB_SET_AC_LG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL 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 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource
    5 SP_ACTIVITY_SUBTYP Character(1) VARCHAR2(1) NOT NULL Activty Sub Type
    G=Generic Activity
    M=Milestone
    R=Rate Based
    S=Specific Activity