PeopleSoft 9
Asset Management

Table Name PI_EXTRACT_RUL

Table Description
PI_EXTRACT_RUL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
DEPTID char(10) Yes Yes
LOCATION char(10) Yes No
CATEGORY char(5) Yes Yes
ACQUISITION_CD char(1) Yes Yes
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
CYCLE_YEAR smallint No No
Index
Name Type Unique Member
PS_PI_EXTRACT_RUL PK Yes
Member(s) of "PS_PI_EXTRACT_RUL" Index
BUSINESS_UNIT
DEPTID
LOCATION
CATEGORY
ACQUISITION_CD
EFFDT

Published December 16, 2006