AVPLDGESRCHLNG (SQL View)	Index Back
Advancement People Search View Common view used when searching for/selecting an organization for display/update. ----------------------------------------------------------------------------------------------------------------- Changed search field order to be consistent with the other search records - 22 Aug 2000. SELECT A.EXT_ORG_ID, C.SESSION_NO, C.GIFT_NO, C.SEQ_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N' ----------------------------------------------------------------------------------------------------------------- DD 2/4/00 Modify view for APRD => R-ACLARK-W26U6 OLD: SELECT A.EXT_ORG_ID, C.GIFT_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N'

AVPLDGESRCHLNG

(SQL View)

Advancement People Search View

Common view used when searching for/selecting an organization for display/update. ----------------------------------------------------------------------------------------------------------------- Changed search field order to be consistent with the other search records - 22 Aug 2000. SELECT A.EXT_ORG_ID, C.SESSION_NO, C.GIFT_NO, C.SEQ_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N' ----------------------------------------------------------------------------------------------------------------- DD 2/4/00 Modify view for APRD => R-ACLARK-W26U6 OLD: SELECT A.EXT_ORG_ID, C.GIFT_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N'

SELECT B.OPRID , B.INSTITUTION , A.EXT_ORG_ID , C.SESSION_NO , C.GIFT_NO ,A.LANGUAGE_CD , A.DESCR FROM PS_EXT_ORG_LANG A , PS_SCRTY_TBL_INST B , PS_AV_PLEDGE_DTL C , PS_AV_SESSION_TBL G WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_LANG E, A, %CurrentDateIn) AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N' AND C.BUSINESS_UNIT = G.BUSINESS_UNIT AND C.SESSION_NO = G.SESSION_NO AND G.SESS_STATUS = 'P'

Related Language Record for AV_PLDG_E_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTN_SCRTY

3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Prompt Table: EXT_ORG_TBL

4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
Prompt Table: AV_PLDG3_SRCH

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY
3	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
4	SESSION_NO	Character(11)	VARCHAR2(11) NOT NULL	Session Nbr
5	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr Prompt Table: AV_PLDG3_SRCH
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description