PeopleSoft 9
Asset Management

Table Name DEPR_SCHED_PD

Table Description
DEPR_SCHED_PD
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
LIFE smallint Yes Yes
DEPR_SCHED_CD char(10) Yes Yes
EFFDT PSDATE Yes Yes
LIFE_YEAR smallint Yes No
LIFE_PERIOD smallint Yes No
DEPR_PERCENT decimal(9,8) No No
Index
Name Type Unique Member
PS_DEPR_SCHED_PD PK Yes
PSADEPR_SCHED_PD IE1 No
Member(s) of "PS_DEPR_SCHED_PD" Index
SETID
LIFE
DEPR_SCHED_CD
EFFDT
LIFE_YEAR
LIFE_PERIOD
Member(s) of "PSADEPR_SCHED_PD" Index
LIFE
LIFE_YEAR
LIFE_PERIOD

Published December 16, 2006