PeopleSoft 9
Asset Management

Table Name AM_LOCATION_TBL

Table Description
AM_LOCATION_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
LOCATION char(10) Yes Yes
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
ROOM char(11) No No
LATITUDE decimal(10,7) No No
LONGITUDE decimal(10,7) No No
Index
Name Type Unique Member
PS_AM_LOCATION_TBL PK Yes
Member(s) of "PS_AM_LOCATION_TBL" Index
SETID
LOCATION
EFFDT

Published December 16, 2006