PeopleSoft 9
Asset Management

Table Name THRESHOLD_SCH

Table Description
THRESHOLD_SCH
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
SCHED_TYPE_CD char(2) Yes Yes
EFFDT PSDATE Yes No
FROM_AMOUNT decimal(26,3) Yes No
TO_AMOUNT decimal(26,3) No No
YEAR_LEN smallint No No
CURRENCY_CD char(3) No No
Index
Name Type Unique Member
PS_THRESHOLD_SCH PK Yes
Member(s) of "PS_THRESHOLD_SCH" Index
SETID
SCHED_TYPE_CD
EFFDT
FROM_AMOUNT

Published December 16, 2006