PC_CHC_INFO_VW

#	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
3	PC_CHC_COUNT	Number(15,0)	DECIMAL(15) NOT NULL	Count of Changes
4	CHANGE_REQ_ID	Character(15)	VARCHAR2(15) NOT NULL	Change Request ID
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	PC_CHC_OPRID	Character(50)	VARCHAR2(50) NOT NULL	Username
8	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
9	PC_CHC_INFO_DESCR	Character(3)	VARCHAR2(3) NOT NULL	Description of Change ADD=Activity Add ADE=Activity End Date ADL=Activity Delete ADS=Activity Start Date AMS=Activity Milestone Change ARA=Activity Resource Add ARD=Activity Resource Delete AST=Activity Status BUD=Finalize Budget ETC=Updating ETC PDE=Project End Date PDS=Project Start Date PST=Project Status RAD=Resource Add RDE=Resource End Date RDL=Resource Delete RDS=Resource Start Date RST=Resource Status RUE=Resource Unit Change TAD=Transaction Add TDE=Transaction Date End TDL=Transaction Delete TDS=Transaction Date Start TST=Transaction Status
10	NEWVALUE	Character(65)	VARCHAR2(65) NOT NULL	New Value
11	OLDVALUE	Character(65)	VARCHAR2(65) NOT NULL	Old Value