PeopleSoft 9
Asset Management

Table Name ALLOC_DEFN

Table Description
ALLOC_DEFN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
ALLOC_ID char(10) Yes No
EFFDT PSDATE Yes Yes
EFF_STATUS char(1) No No
BOOK char(10) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No Yes
COST_TYPE char(1) No Yes
ASSET_FLAG char(1) No No
BASIS_ID char(10) No Yes
Index
Name Type Unique Member
PS_ALLOC_DEFN PK Yes
PSAALLOC_DEFN IE1 No
Member(s) of "PS_ALLOC_DEFN" Index
BUSINESS_UNIT
ALLOC_ID
EFFDT
Member(s) of "PSAALLOC_DEFN" Index
BUSINESS_UNIT
ALLOC_ID
EFFDT
BOOK
CATEGORY
DEPTID
PROJECT_ID

Published December 16, 2006