PGM_PRGRFSH_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PC_HEALTH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Project Health Type B=Budget I=Issues K=Risks P=Project R=Resources S=Schedule U=User Defined
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
7	BUPRJACT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	BU/Proj/Act Option A=Business Unit/Project/Activity B=Business Unit E=All P=Business Unit/Project
8	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
9	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
10	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
11	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
12	PC_CALC_HEALTH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Calculate Health
13	PC_ROLLUP_DATE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Roll Up Start/End Dates
14	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
15	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
16	AN_GRP_TOT_COSTS	Character(5)	VARCHAR2(5) NOT NULL	Cost Analysis Group
17	AN_GRP_ACTV_BUD	Character(5)	VARCHAR2(5) NOT NULL	Budget Analysis Group
18	PC_HLTH_ALERT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Project Health Alert percentage.
19	PC_HLTH_WARN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Project Health Warning percentage.
20	PC_HEALTH	Character(1)	VARCHAR2(1) NOT NULL	Calculated based on user-defined criteria, this field shows the overall health of a project. F=Fair G=Good P=Poor
21	PC_HEALTH_DTTM	DateTime(26)	TIMESTAMP	The datetime stamp of when Project Health was either calculated or manually entered.
22	ACT_OVRDUE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Activity Overdue Percent
23	START_DT	Date(10)	DATE	Start Date
24	END_DT	Date(10)	DATE	End Date
25	PC_DURATION	Number(11,2)	DECIMAL(10,2) NOT NULL	Duration
26	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
27	PC_COST_VARIANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost Variance is the difference between actual costs and budgeted costs.
28	VARIANCE_PERCENT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Variance Percentage
29	PC_BUDGET_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Project Budgeting: Budget Plan Total
30	PC_COST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total cost for a project.
31	OVRLOAD_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	A field that stores Overload Percent
32	TOT_RESOURCE	Number(8,0)	INTEGER NOT NULL	Total Number Of Resources
33	TOT_OVRLD_RES	Number(8,0)	INTEGER NOT NULL	Total Overloaded Resources
34	PC_HIGH_ISS_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Project High Issues Percent
35	PC_ISS_HIGH	Number(4,0)	SMALLINT NOT NULL	Number of High Issues
36	PC_ISS_MEDIUM	Number(4,0)	SMALLINT NOT NULL	Number of Medium Issues
37	PC_ISS_LOW	Number(4,0)	SMALLINT NOT NULL	Number of Low Issues
38	PC_HEALTH_CALC	Character(1)	VARCHAR2(1) NOT NULL	A flag that identifies whether Project Health will be calculated or entered manually. C=Calculated M=Manual Entry
39	PRJ_WT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Project Weight Percent
40	WORK_CNT1	Number(10,0)	DECIMAL(10) NOT NULL	Work Count 1
41	WORK_CNT2	Number(10,0)	DECIMAL(10) NOT NULL	Work Count 2
42	RISK_NO_PLAN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Project High Issues Percent
43	RISKS_NO_PLAN	Number(8,0)	INTEGER NOT NULL	Risks without Action Plan
44	RISKS_WITH_PLAN	Number(8,0)	INTEGER NOT NULL	Risks with Action Plan
45	TOTAL_RISKS	Number(8,0)	INTEGER NOT NULL	Total Risks