AE_AM_UPG2_AET

(SQL Table)
Index Back

Upgrade to 8.4

# 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 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 IN_SERVICE_DT Date(10) DATE In Service Date
6 IN_SERVICE_FY Number(4,0) SMALLINT NOT NULL In Service Fiscal Year
7 IN_SERVICE_PD Number(3,0) SMALLINT NOT NULL In service Period
8 BEGIN_DEPR_DT Date(10) DATE Begin Depr Date
9 BEGIN_DEPR_FY Number(4,0) SMALLINT NOT NULL Begin Depreciation Fiscal Year
10 BEGIN_DEPR_PD Number(3,0) SMALLINT NOT NULL Begin Depreciation Period
11 END_DEPR_DT Date(10) DATE End Depreciation Date
12 END_DEPR_FY Number(4,0) SMALLINT NOT NULL End Depreciation Year
13 END_DEPR_PD Number(3,0) SMALLINT NOT NULL End Depreciation Period
14 BEGIN_FRACTION Signed Number(17,13) DECIMAL(15,13) NOT NULL Begin Depr Period Fraction
15 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
16 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
17 SUSPENDED_PERIODS Number(4,0) SMALLINT NOT NULL Number of Suspended Periods
18 RETIRED_SW Character(1) VARCHAR2(1) NOT NULL Retired
19 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention
20 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None
21 SETID Character(5) VARCHAR2(5) NOT NULL SetID
22 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID