PRC_PROJ_CATG

(SQL View)
Index Back

Project Resource Category


SELECT a.setid , a.resource_category , a.descr FROM PS_PROJ_CATG_TBL a WHERE %EffdtCheck(proj_catg_tbl b, a, %CurrentDateIn) AND a.eff_status = 'A'

  • Related Language Record: PRC_PROJCATG_L
  • # 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 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: PROJ_CATG_TBL

    3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field