PeopleSoft 9
Asset Management

Table Name PROFILE_DET_TBL

Table Description
PROFILE_DET_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
PROFILE_ID char(10) Yes Yes
BOOK char(10) Yes Yes
EFFDT PSDATE Yes No
CATEGORY char(5) No Yes
DEPR_STATUS char(1) No No
REGULATION char(1) No No
RECOVERY_LIFE decimal(3,1) No No
RECOVERY_SUBTYPE char(2) No No
CONVENTION char(2) No No
RETIRE_CONVENTION char(2) No No
METHOD char(2) No No
CALCULATION_TYPE char(1) No No
DEPR_PERCENT decimal(9,8) No No
DB_PERCENT decimal(15,14) No No
DEPR_SCHED_CD char(10) No No
DEPR_LIMIT_CD char(10) No No
LIFE smallint No No
TAX_CLASS_AM char(6) No No
PROPERTY_CD char(1) No No
PROPERTY_TYPE char(1) No No
SALVAGE_VALUE decimal(26,3) No No
SALVAGE_PCT decimal(15,14) No No
LIFE_END_DT PSDATE No No
DEPR_LOW_LIMIT decimal(26,3) No No
COST_BASIS_LIMIT decimal(26,3) No No
DEPR_AVG_OPTION char(1) No No
UOP_ID char(10) No No
GROUP_BUS_UNIT char(5) No No
GROUP_ASSET_ID char(12) No No
CURRENCY_CD char(3) No No
INCLUDE_CAP_GAINS char(1) No No
UD_METHOD_ID char(5) No No
PERIOD_DEPR_SW char(1) No No
DEPR_PASS_LIFE_SW char(1) No No
LISTED_PROP char(1) No No
LISTED_PROP_TYPE char(1) No No
BUS_USE_PERCENT decimal(9,8) No No
SEC_291 char(1) No No
DEPR_LIMIT_PCT decimal(5,2) No No
MULTI_SHIFT_CODE char(6) No No
MULTI_SHIFT_NBR smallint No No
SPECIAL_TERMS char(10) No No
ACCELERATED_TERMS char(10) No No
INITIAL_TERMS char(10) No No
INCREASE_RATE decimal(9,6) No No
ACCOUNTING_MTHD char(3) No No
SPECIAL_DEPR_SW char(1) No No
LOW_VALUE_SW char(1) No No
BUSINESS_TAX_FLG char(1) No No
DEROGATORY_SW char(1) No No
FUTURE_DEPR_YEARS smallint No No
ROUND_RULE_AM char(1) No No
ROUND_TYPE char(1) No No
ROUND_PRECISION smallint No No
ROUND_FACTOR decimal(14,7) No No
TRUNCATE_FLAG char(1) No No
DEPR_BONUS_SW char(1) No No
DEPR_BONUS_PCT decimal(5,2) No No
AM_BK_UD_CHAR1 char(10) No No
AM_BK_UD_CHAR2 char(10) No No
AM_BK_UD_DATE1 PSDATE No No
AM_BK_UD_NUM1 decimal(18,3) No No
AM_BK_UD_NUM2 decimal(18,3) No No
IMPAIR_FLG char(1) No No
DEPR_IN_SERVICE_SW CHAR(1) No No
ADJUST_CONVENTION CHAR(2) No No
Index
Name Type Unique Member
PS_PROFILE_DET_TBL PK Yes
Member(s) of "PS_PROFILE_DET_TBL" Index
SETID
PROFILE_ID
BOOK
EFFDT

Published December 16, 2006