PeopleSoft 9
Asset Management

Table Name CAP_AUTHORIZE

Table Description
CAP_AUTHORIZE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
CAP_NUM char(15) Yes Yes
CAP_SEQUENCE smallint Yes Yes
DTTM_STAMP PSDATETIME Yes No
NAME char(50) No No
BD_UPDATE_FLAG char(1) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_CAP_AUTHORIZE PK Yes
PS0CAP_AUTHORIZE IE1 No
Member(s) of "PS_CAP_AUTHORIZE" Index
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE
DTTM_STAMP
Member(s) of "PS0CAP_AUTHORIZE" Index
NAME
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE
DTTM_STAMP

Published December 16, 2006