PeopleSoft 9
Asset Management

Table Name ASSET_CUSTODIAN

Table Description
ASSET_CUSTODIAN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
EFFDT PSDATE Yes No
EFFSEQ smallint Yes No
CUSTODIAN char(30) No No
EMPLID char(11) 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
OFFSITE_SW char(1) No No
AUTH_STATUS char(1) No No
AUTHORIZATION_NAME char(30) No No
AUTHORIZATION_DT PSDATE No No
Index
Name Type Unique Member
PS_ASSET_CUSTODIAN PK Yes
Member(s) of "PS_ASSET_CUSTODIAN" Index
BUSINESS_UNIT
ASSET_ID
EFFDT
EFFSEQ

Published December 16, 2006