AV_PLEDGES_P_VW (SQL View)	Index Back
Posted Pledge Detail Returns all non adjustment pledges that have been posted. Used as a prompt for Pledge No on AV_GIFT_ENTRY, AV_ADJ_GIFT before 7.31.00 SELECT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.GIFT_NO, A.SA_ID_TYPE, A.PLDG_EFFDT, A.GIFT_AMT, A.CURRENCY_CD, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT, A.FULF_DT, A.PMT_SCHD, A.DATA_ENTRY_DT FROM PS_AV_PLEDGE_DTL A, PS_AV_SESSION_TBL B WHERE A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.INSTITUTION = B.INSTITUTION AND A.ADJUSTMENT_FLG = 'N' AND A.PLEDGE_PMT_RCVD < A.GIFT_AMT

AV_PLEDGES_P_VW

(SQL View)

Posted Pledge Detail

Returns all non adjustment pledges that have been posted. Used as a prompt for Pledge No on AV_GIFT_ENTRY, AV_ADJ_GIFT before 7.31.00 SELECT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.GIFT_NO, A.SA_ID_TYPE, A.PLDG_EFFDT, A.GIFT_AMT, A.CURRENCY_CD, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT, A.FULF_DT, A.PMT_SCHD, A.DATA_ENTRY_DT FROM PS_AV_PLEDGE_DTL A, PS_AV_SESSION_TBL B WHERE A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.INSTITUTION = B.INSTITUTION AND A.ADJUSTMENT_FLG = 'N' AND A.PLEDGE_PMT_RCVD < A.GIFT_AMT

SELECT A.BUSINESS_UNIT, A.EMPLID, A.EXT_ORG_ID, A.GIFT_NO, A.SA_ID_TYPE, A.PLDG_EFFDT, A.GIFT_AMT, A.CURRENCY_CD, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT, A.FULF_DT, A.PMT_SCHD, A.DATA_ENTRY_DT FROM PS_AV_PLEDGE_DTL A, PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.ADJUSTMENT_FLG = 'N' AND A.PLEDGE_PMT_RCVD < A.GIFT_AMT

Parent record: AV_SESSION_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: AV_INST_BU_VW

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: AV_PEOPLE_SRCH

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

4 PLEDGE_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number

5 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
Default Value: P

6 PLDG_EFFDT Date(10) DATE Effective Date

7 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Pledge Amount

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

9 PLEDGE_PMT_RCVD Number(16,2) DECIMAL(15,2) NOT NULL Payments Received

10 LAST_PMT_DT Date(10) DATE Last Payment Date

11 FULF_DT Date(10) DATE NOT NULL Fulfillment Date
Default Value: %date

12 PMT_SCHD Character(2) VARCHAR2(2) NOT NULL Payment Schedule
A=Annual
BM=Bi-Monthly
I=Irregular
M=Monthly
Q=Quarterly
SA=Semi-Annually
W=Weekly

13 DATA_ENTRY_DT Date(10) DATE NOT NULL Data Entry Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: AV_INST_BU_VW
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
3	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
4	PLEDGE_GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Pledge Number
5	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
6	PLDG_EFFDT	Date(10)	DATE	Effective Date
7	GIFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Pledge Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
9	PLEDGE_PMT_RCVD	Number(16,2)	DECIMAL(15,2) NOT NULL	Payments Received
10	LAST_PMT_DT	Date(10)	DATE	Last Payment Date
11	FULF_DT	Date(10)	DATE NOT NULL	Fulfillment Date Default Value: %date
12	PMT_SCHD	Character(2)	VARCHAR2(2) NOT NULL	Payment Schedule A=Annual BM=Bi-Monthly I=Irregular M=Monthly Q=Quarterly SA=Semi-Annually W=Weekly
13	DATA_ENTRY_DT	Date(10)	DATE NOT NULL	Data Entry Date Default Value: %date