PeopleSoft 9
Asset Management

Table Name PROFILE_PARCHD

Table Description
PROFILE_PARCHD
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
PROFILE_ID char(10) Yes Yes
EFFDT PSDATE Yes No
PAR_PROFILE_SW char(1) No No
PAR_TAG_SW char(1) No No
PAR_DESCR_SW char(1) No No
PAR_ASSET_CLASS_SW char(1) No No
PAR_ACQUIS_CD_SW char(1) No No
PAR_CUSTODIAN_SW char(1) No No
PAR_LOCATION_SW char(1) No No
PAR_LICENSE_SW char(1) No No
PAR_INDEX_SW char(1) No No
PAR_INVENTOR_DT_SW char(1) No No
PAR_CAP_METHOD_SW char(1) No No
Index
Name Type Unique Member
PS_PROFILE_PARCHD PK Yes
Member(s) of "PS_PROFILE_PARCHD" Index
SETID
PROFILE_ID
EFFDT

Published December 16, 2006