PeopleSoft 9.0
Cash Management

Table Name TRP_PART_DEFN

Table Description
TRP_PART_DEFN
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
PARTICIPANT_ID CHAR(10) Yes No
EFFDT datetime Yes No
DESCR CHAR(30) No No
EFF_STATUS CHAR(1) No No
COUNTRY CHAR(3) No No
ADDRESS1 CHAR(55) No No
ADDRESS2 CHAR(55) No No
ADDRESS3 CHAR(55) No No
ADDRESS4 CHAR(55) No No
CITY CHAR(30) No No
NUM1 CHAR(6) No No
NUM2 CHAR(4) No No
HOUSE_TYPE CHAR(2) No No
ADDR_FIELD1 CHAR(2) No No
ADDR_FIELD2 CHAR(4) No No
ADDR_FIELD3 CHAR(4) No No
COUNTY CHAR(30) No No
STATE CHAR(6) No No
POSTAL CHAR(12) No No
GEO_CODE CHAR(11) No No
IN_CITY_LIMIT CHAR(1) No No
COUNTRY_CODE CHAR(3) No No
PHONE CHAR(24) No No
EXTENSION CHAR(6) No No
FAX CHAR(24) No No
EVENT_TRACKING_ID DECIMAL(10) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_TRP_PART_DEFN PK Yes
PS0TRP_PART_DEFN IE1 No
Member(s) of "PS_TRP_PART_DEFN" Index
SETID
PARTICIPANT_ID
EFFDT
Member(s) of "PS0TRP_PART_DEFN" Index
DESCR
SETID
PARTICIPANT_ID
EFFDT

Published April 30, 2007