RIM_PERSON_LST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	CONTACT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role. E=External Contact I=Internal Corporate Contact
8	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
9	ADDRESS_LONG	Long Character	CLOB	Address Long - display concatenated address
10	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
11	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
16	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
17	CELL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cell Phone
18	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
19	PHONE_FAX	Character(12)	VARCHAR2(12) NOT NULL	Telephone
20	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
21	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
22	RIM_BIRTHDATE	Character(30)	VARCHAR2(30) NOT NULL	Birthdate of the person.
23	CR_RATING	Number(5,0)	INTEGER NOT NULL	Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
24	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
25	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
26	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
27	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
28	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
29	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
30	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
31	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
32	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time