PeopleSoft 9
Asset Management

Table Name AM_AREA_TBL

Table Description
AM_AREA_TBL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
LOCATION char(10) Yes Yes
AREA_ID CHAR(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS CHAR(1) No No
DESCR CHAR(30) No No
COMMENTS_2000 TEXT No No
Index
Name Type Unique Member
PS_AM_AREA_TBL PK Yes
PS0AM_AREA_TBL IE1 No
Member(s) of "PS_AM_AREA_TBL" Index
SETID
LOCATION
AREA_ID
EFFDT
Member(s) of "PS0AM_AREA_TBL" Index
DESCR
SETID
LOCATION
AREA_ID
EFFDT

Published December 16, 2006