PeopleSoft 9
Asset Management

Table Name BOOK_ARCHIVE

Table Description
BOOK_ARCHIVE
Columns
Name Datatype Is PK Is FK
ARCHIVE_ID char(8) Yes No
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes No
BOOK char(10) Yes Yes
BEGIN_CALC_DT PSDATE No No
BEGIN_CALC_FY smallint No No
BEGIN_CALC_PD smallint No No
RSV_FRACTION decimal(15,13) No No
SCHED_FRACTION decimal(15,13) No No
BEGIN_FRACTION decimal(15,13) No No
LIFE_REMAINING decimal(15,11) No No
OLD_ARCHIVE_ID char(8) No No
Index
Name Type Unique Member
PS_BOOK_ARCHIVE PK Yes
Member(s) of "PS_BOOK_ARCHIVE" Index
ARCHIVE_ID
BUSINESS_UNIT
ASSET_ID
BOOK

Published December 16, 2006