PeopleSoft 9.0
Cash Management

Table Name TRP_PART_ACCT_D

Table Description
TRP_PART_ACCT_D
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
PARTICIPANT_ID CHAR(10) Yes Yes
EFFDT datetime Yes Yes
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes Yes
PARTICIPANT_ACCT CHAR(25) Yes Yes
TRP_ACCOUNT_TYPE CHAR(1) Yes No
ACCOUNT CHAR(10) No No
ALTACCT CHAR(10) No No
DEPTID 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
TR_WR_TEMPLATE_ID CHAR(12) No No
Index
Name Type Unique Member
PS_TRP_PART_ACCT_D PK Yes
Member(s) of "PS_TRP_PART_ACCT_D" Index
SETID
PARTICIPANT_ID
EFFDT
BUSINESS_UNIT
POOL_ID
PARTICIPANT_ACCT
TRP_ACCOUNT_TYPE

Published April 30, 2007