PROJ_TYPE_LANG

(SQL Table)
Index Back

Project Type Table

Project Type Table

  • Related Language Record for PC_PRJ_STAT_VW1 PROJ_TYPE2_VW PROJ_TYPE_TBL PROJ_TYP_DEF_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment

    Prompt Table: PROJ_TYPE_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %DATE

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description