PC_ETC_TA1

(SQL Table)
Index Back

Record to capture ETC data

This is a temp table used in the PC_ETC_CALC app engine for calculating ETC amounts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
6 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
7 PC_BUDGET_HRS Signed Number(16,2) DECIMAL(14,2) NOT NULL Budget Hours
8 PC_ACTUAL_HRS Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Hours
9 PC_ETC_HRS Signed Number(16,2) DECIMAL(14,2) NOT NULL Forecast to Complete Hours