RD_PR_PROG_SRCH (SQL View)	Index Back
Partner Program Search View View of Partner Program. Search record for Partner Program Configurable Search page.

RD_PR_PROG_SRCH

(SQL View)

Partner Program Search View

View of Partner Program. Search record for Partner Program Configurable Search page.

SELECT SETID , PARTNER_PGM_ID , PARTNER_PGM_NAME , %Upper(PARTNER_PGM_NAME) , PARTNER_PGM_STATUS , PARTNER_TYPE , PARTNER_SUBTYPE , PARTNER_LEVEL , START_DATE , END_DATE , SYNCID FROM PS_RD_PR_PROG

Related Language Record: RD_PR_PROG_SLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PARTNER_PGM_ID Character(15) VARCHAR2(15) NOT NULL Partner Program ID

3 PARTNER_PGM_NAME Character(50) VARCHAR2(50) NOT NULL Partner Program name

4 PARTNER_PGM_NM_UPR Character(50) VARCHAR2(50) NOT NULL Partner Program name

5 PARTNER_PGM_STATUS Character(1) VARCHAR2(1) NOT NULL Status of partner program
A=Active
I=Inactive
P=Pending
Default Value: A

6 PARTNER_TYPE Character(4) VARCHAR2(4) NOT NULL Partner type
Prompt Table: RD_PR_TYPE

7 PARTNER_SUBTYPE Character(4) VARCHAR2(4) NOT NULL Partner subtype
Prompt Table: RD_PR_SUBTYPE

8 PARTNER_LEVEL Character(4) VARCHAR2(4) NOT NULL Partner level
Prompt Table: RD_PR_LEVEL

9 START_DATE Date(10) DATE Start Date

10 END_DATE Date(10) DATE End date field to store an end date.

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	PARTNER_PGM_ID	Character(15)	VARCHAR2(15) NOT NULL	Partner Program ID
3	PARTNER_PGM_NAME	Character(50)	VARCHAR2(50) NOT NULL	Partner Program name
4	PARTNER_PGM_NM_UPR	Character(50)	VARCHAR2(50) NOT NULL	Partner Program name
5	PARTNER_PGM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of partner program A=Active I=Inactive P=Pending Default Value: A
6	PARTNER_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Partner type Prompt Table: RD_PR_TYPE
7	PARTNER_SUBTYPE	Character(4)	VARCHAR2(4) NOT NULL	Partner subtype Prompt Table: RD_PR_SUBTYPE
8	PARTNER_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Partner level Prompt Table: RD_PR_LEVEL
9	START_DATE	Date(10)	DATE	Start Date
10	END_DATE	Date(10)	DATE	End date field to store an end date.
11	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.