PC_AM_RET_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LAST_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Last Interface ID
4	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
7	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
8	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	CF_SEQNO	Number(6,0)	INTEGER NOT NULL	Chartfield Sequence Number
10	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
11	EXP_RET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Retirement Process Flag Default Value: N
12	PC_AM_RET_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Run Retire Asset Option 1=Stage to Asset Management 2=Stage and Load Transactions Default Value: 1
13	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
14	RETIRE_CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Retirement Convention
15	FULLY_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Retire As Fully Depreciated SW F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense
16	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
17	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
18	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
19	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
20	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
21	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
22	APPROVAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Auto Approval Status