PeopleSoft 9
Asset Management

Table Name AM_PROP_SUBC

Table Description
AM_PROP_SUBC
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
PROPERTY_CLASS char(2) Yes No
PROP_SUBCLASS_CD char(20) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
INSTANCE_NAME char(60) No No
INSTANCE_DESCR char(150) No No
Index
Name Type Unique Member
PS_AM_PROP_SUBC PK Yes
Member(s) of "PS_AM_PROP_SUBC" Index
SETID
PROPERTY_CLASS
PROP_SUBCLASS_CD
EFFDT

Published December 16, 2006