PeopleSoft 9
Asset Management

Table Name CATEGORY_TBL

Table Description
CATEGORY_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
CATEGORY char(5) Yes Yes
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
INTANGIBLE_SW char(1) No No
DEPR_STATUS char(1) No No
LEASE_SW char(1) No No
Index
Name Type Unique Member
PS_CATEGORY_TBL PK Yes
PSACATEGORY_TBL IE1 No
Member(s) of "PS_CATEGORY_TBL" Index
SETID
CATEGORY
EFFDT
Member(s) of "PSACATEGORY_TBL" Index
CATEGORY

Published December 16, 2006