GM_PROJ_RES

(SQL Table)
Index Back

Operational Projects

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_VW

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 RESOURCE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Resource Sequence Number
5 GRANTS_RES_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type

Prompt Table: GM_RESOURCE_TBL

6 DESCRLONG Long Character CLOB Long Description