PeopleSoft 9
Asset Management

Table Name CAP_TYPE_TBL

Table Description
CAP_TYPE_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
CAP_TYPE char(5) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
DESCRSHORT char(10) No No
Index
Name Type Unique Member
PS_CAP_TYPE_TBL PK Yes
Member(s) of "PS_CAP_TYPE_TBL" Index
SETID
CAP_TYPE
EFFDT

Published December 16, 2006