PC_AMPRJDFN_AET

#	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
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
6	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
7	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
8	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
9	ANALYSIS_GROUP_RET	Character(5)	VARCHAR2(5) NOT NULL	Retirement Analysis Group
10	ANALYSIS_GROUP_AMR	Character(5)	VARCHAR2(5) NOT NULL	Retire Proceed and Cost An Grp
11	INTFC_TYPE_RET	Character(3)	VARCHAR2(3) NOT NULL	Retirement Interface Type AAD=Additional Cost Add ACQ=Insert Acquisition Detl ADD=Asset Add ADJ=Asset Cost Adjustment ADQ=Adjust Cost & Acquisition Detl ARA=Add Retired Assets ASD=Asset Deletion AUP=Asset Information Update BKD=Book Deletion BKS=Book Change BSD=Selective Book Delete CAP=Asset Capitalization CIC=Capitalize Into Composite CLC=Custodian/Location Change CN1=Conversion of First Book CN2=Conversion of Subsequent Books FAD=Financial & Physical Add IHI=Inventory History Insert IUI=Inter-Unit Transfer In Side IUO=Inter-Unit Transfer Out Side LAD=Leased Asset Add NAD=Non-Financial Add OPT=Open Trans Generation PHY=Physical Asset Change PRT=Partial Retirement RCT=Asset Recategorization REI=Asset Reinstatement RET=Asset Retirement TRF=Intra-Business Unit Transfer
12	ASSET_ALLOC_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Asset Allocation Percentage
13	DISTRIBUTION_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Distribution Percentage
14	DISTRIBUTION_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Distribution Amount