RD_PARTSHP_VW (SQL View)	Index Back
Partnership Main VW BO_ID Partnership Main Record with BO_ID as the PID

RD_PARTSHP_VW

(SQL View)

Partnership Main VW BO_ID

Partnership Main Record with BO_ID as the PID

SELECT BO_ID , PARTNERSHIP_ID , TIN , TIN_TYPE , LEGAL_FORM , CHAM_OF_COMM_NBR , WEB_URL , STOCK_SYMBOL , LOC_TYPE , BUSINESS , REVENUE , REVENUE_GEN , EMPL_TOTAL , MARKET , INDUSTRY_ID , SETID , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM FROM PS_RBF_PARTSHP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 PARTNERSHIP_ID Character(15) VARCHAR2(15) NOT NULL partnership id

3 TIN Character(20) VARCHAR2(20) NOT NULL TIN

4 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL Tin Type
F=Federal Employer ID
S=Social Security Number

5 LEGAL_FORM Character(30) VARCHAR2(30) NOT NULL legal form

6 CHAM_OF_COMM_NBR Character(18) VARCHAR2(18) NOT NULL Chamber of Commerce

7 WEB_URL Character(130) VARCHAR2(130) NOT NULL URL of a customer's website.

8 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol

9 LOC_TYPE Character(4) VARCHAR2(4) NOT NULL Location type. For example: Subsidiary, Division, Branch, Heaquarters, Single Location.
01=Subsidiary
02=Division
03=Branch
04=Headquarters
05=Single Location

10 BUSINESS Character(4) VARCHAR2(4) NOT NULL Business

11 REVENUE Character(4) VARCHAR2(4) NOT NULL Revenue

12 REVENUE_GEN Number(27,3) DECIMAL(26,3) NOT NULL Total Revenue generated by the customer.

13 EMPL_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total number of employees. Holds up to 9 integer positions.

14 MARKET Character(3) VARCHAR2(3) NOT NULL Market
Default Value: FIN

15 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

16 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	PARTNERSHIP_ID	Character(15)	VARCHAR2(15) NOT NULL	partnership id
3	TIN	Character(20)	VARCHAR2(20) NOT NULL	TIN
4	TIN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tin Type F=Federal Employer ID S=Social Security Number
5	LEGAL_FORM	Character(30)	VARCHAR2(30) NOT NULL	legal form
6	CHAM_OF_COMM_NBR	Character(18)	VARCHAR2(18) NOT NULL	Chamber of Commerce
7	WEB_URL	Character(130)	VARCHAR2(130) NOT NULL	URL of a customer's website.
8	STOCK_SYMBOL	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Stock Symbol
9	LOC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Location type. For example: Subsidiary, Division, Branch, Heaquarters, Single Location. 01=Subsidiary 02=Division 03=Branch 04=Headquarters 05=Single Location
10	BUSINESS	Character(4)	VARCHAR2(4) NOT NULL	Business
11	REVENUE	Character(4)	VARCHAR2(4) NOT NULL	Revenue
12	REVENUE_GEN	Number(27,3)	DECIMAL(26,3) NOT NULL	Total Revenue generated by the customer.
13	EMPL_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total number of employees. Holds up to 9 integer positions.
14	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market Default Value: FIN
15	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID.
16	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.