| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ARCHIVE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 4 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 5 |
BEGIN_CALC_DT |
Date(10) |
DATE |
Begin Depreciation Calc Date
|
| 6 |
BEGIN_CALC_FY |
Number(4,0) |
SMALLINT NOT NULL |
Begin Calculation Fiscal Yr
|
| 7 |
BEGIN_CALC_PD |
Number(3,0) |
SMALLINT NOT NULL |
Begin Calculation Period
|
| 8 |
RSV_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Reserve Fraction (RSV/Cost)
|
| 9 |
SCHED_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Fraction of Schedule Elapsed
|
| 10 |
BEGIN_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Begin Depr Period Fraction
|
| 11 |
LIFE_REMAINING |
Signed Number(17,11) |
DECIMAL(15,11) NOT NULL |
Remaining Life
|
| 12 |
OLD_ARCHIVE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Previous Archive Id
|