PeopleSoft 9
Asset Management

Table Name PROFILE_TBL

Table Description
PROFILE_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
PROFILE_ID char(10) Yes No
DESCR char(30) No No
DEFAULT_DESCR char(30) No No
FINANCIAL_ASSET_SW char(1) No No
TAGGABLE_SW char(1) No No
ACQUISITION_CD char(1) No No
ASSET_CLASS char(10) No Yes
ASSET_TYPE char(3) No No
ASSET_SUBTYPE char(15) No No
RD_PLANT_ASSET char(1) No No
RD_START_DT PSDATE No No
RD_USE_NBV char(1) No No
INDEX_NAME char(20) No No
INDEX_DETAIL_NAME char(35) No No
ASSET_RESOURCE_SW char(1) No No
Index
Name Type Unique Member
PS_PROFILE_TBL PK Yes
Member(s) of "PS_PROFILE_TBL" Index
SETID
PROFILE_ID

Published December 16, 2006