PGM_UPIND_TMP

(SQL Table)
Index Back

Warning Indicator Temp Table

Holds the information for the Warning Indicator.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PROJECT.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

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

Prompt Table: PROJECT_ALL_VW

4 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
A=Asset
L=Labor
M=Material
O=Other

Default Value: L

5 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
6 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

Prompt Table: %EDITTABLE

7 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag
8 FROM_PRL_POSTBUILD Character(1) VARCHAR2(1) NOT NULL From PRL Postbuild