PeopleSoft 9.0
Cash Management

Table Name TRP_POOL_DEFN

Table Description
TRP_POOL_DEFN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS CHAR(1) No No
DESCR CHAR(30) No No
CALENDAR_ID CHAR(2) No Yes
CALC_PERIOD SMALLINT No No
TRP_INTEREST_TYPE CHAR(1) No No
TRP_INTEREST_RATE DECIMAL(15,8) No No
INT_ACCTG_TMPL_ID CHAR(15) No No
SHARES_DISTRIBUTED CHAR(1) No No
INIT_SHARE_PRICE DECIMAL(26,3) No No
TRP_FEE_TYPE CHAR(1) No No
FEE_RATE DECIMAL(15,8) No No
FEE_AMOUNT DECIMAL(26,3) No No
FEE_ACCTG_TMPL_ID CHAR(15) No No
CURRENCY_CD CHAR(3) No 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
EVENT_TRACKING_ID DECIMAL(10) No No
DOC_TYPE CHAR(8) No No
DOC_TYPE_ACCR CHAR(8) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_TRP_POOL_DEFN PK Yes
PS0TRP_POOL_DEFN IE1 No
Member(s) of "PS_TRP_POOL_DEFN" Index
BUSINESS_UNIT
POOL_ID
EFFDT
Member(s) of "PS0TRP_POOL_DEFN" Index
DESCR
BUSINESS_UNIT
POOL_ID
EFFDT

Published April 30, 2007