PSA_ORGPRJ_DEFN

(SQL Table)
Index Back

Project Owning Organization

Define the owning organization for a project.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PSA_PROJSRCH_VW

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 PRJ_LEVEL1_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 1 Chartfield

Prompt Table: SP_BU_GL_NONVW

5 PRJ_LEVEL2_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 2 Chartfield

Prompt Table: %EDITTABLE2

6 PRJ_LEVEL3_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 3 Chartfield

Prompt Table: %EDITTABLE3

7 PRJ_LEVEL4_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 4 Chartfield

Prompt Table: %EDITTABLE4

8 PRJ_LEVEL5_CF_VAL Character(30) VARCHAR2(30) NOT NULL Level 5 Chartfield

Prompt Table: %EDITTABLE5