PeopleSoft 9
Asset Management

Table Name AM_SUBTYPE

Table Description
AM_SUBTYPE
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
ASSET_TYPE char(3) Yes No
ASSET_SUBTYPE char(15) Yes No
DESCRSHORT char(10) No No
DESCR char(30) No No
IT_SUBTYPE char(15) No No
DFLT_RULE_STYPE_SW char(1) No No
RETIRE_AC_SW char(1) No No
TRF_OUT_SW char(1) No No
TRF_IN_SW char(1) No No
TRF_ACQ_DET_SW char(1) No No
TRF_ATTRIBUTES_SW char(1) No No
TRF_COMMENTS_SW char(1) No No
TRF_LEASE_SW char(1) No No
TRF_LIC_REG_SW char(1) No No
TRF_MAINT_SW char(1) No No
TRF_WARRANTY_SW char(1) No No
TRF_NON_CAP_COST char(1) No No
TRK_COMP_HIST_SW CHAR(1) No No
TRF_INSPECTION_SW char(1) No No
TRF_INSURANCE_SW char(1) No No
ATTRIBUTE_GROUP_SW CHAR(1) No No
Index
Name Type Unique Member
PS_AM_SUBTYPE PK Yes
Member(s) of "PS_AM_SUBTYPE" Index
SETID
ASSET_TYPE
ASSET_SUBTYPE

Published December 16, 2006