AV_RCG_DES_VW

(SQL View)
 Index Back

Recognition/Designation View

Recognition/Designation View ----------------------------------------------------------------------------------------------------------------- 02/26/01 jpm - Added AV_DES_BU to this view. ----------------------------------------------------------------------------------------------------------------- Code change 27 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, RECOGNITION_TYPE, DESIGNATION, INTV_CD, SA_ID_TYPE, RCG_DES_AMT, CURRENCY_CD, AV_SESS_TYPE, GIFT_DT, STATUS, FISCAL_YEAR, CAE_GIFT_TYPE, CNST_TYPE, ALUMNUS_TYPE, MOTIVATION_CD, CHARITABLE_AMT, AV_CASE_TYPE, AV_CASE_PRPS, GIFT_TYPE, PLEDGE_GIFT_NO, CAE_RE_FLG, ANONYMOUS_FLG, CURRENCY_CD_ENTRY, CHARITAB_AMT_ENTRY, RCG_DES_AMT_ENTRY FROM PS_AV_RCG_DES ----------------------------------------------------------------------------------------------------------------- 05-Jan-2000 - added ext_org_id as key - R-CDEJEA-EP2XV

SELECT BUSINESS_UNIT , SESSION_NO , GIFT_NO , EMPLID , EXT_ORG_ID , RECOGNITION_TYPE , DESIGNATION , INTV_CD , SA_ID_TYPE , RCG_DES_AMT , CURRENCY_CD , AV_SESS_TYPE , GIFT_DT , STATUS , FISCAL_YEAR , CAE_GIFT_TYPE , CNST_TYPE , ALUMNUS_TYPE , MOTIVATION_CD , CHARITABLE_AMT , AV_CASE_TYPE , AV_CASE_PRPS , GIFT_TYPE , PLEDGE_GIFT_NO , CAE_RE_FLG , ANONYMOUS_FLG , CURRENCY_CD_ENTRY , CHARITAB_AMT_ENTRY , RCG_DES_AMT_ENTRY , AV_DES_BU , INSTITUTION FROM PS_AV_RCG_DES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
7 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
8 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
9 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
10 RCG_DES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 AV_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL Session Type
AG=Gift Adjustment
AM=Adjust Membership
AP=Pledge Adjustment
G=Gift
M=Membership
PL=Pledge
13 GIFT_DT Date(10) DATE Gift Date
14 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

15 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
16 CAE_GIFT_TYPE Character(1) VARCHAR2(1) NOT NULL CAE Type
D=Deferred Gift
E=Deferred Estate Gift
G=Gift
K=Gift In Kind
N=Non-Gift
17 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
18 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
G=Graduate
N=Non-Degree
U=Undergraduate
19 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code
20 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
21 AV_CASE_TYPE Character(4) VARCHAR2(4) NOT NULL CASE Type
C=Current Unrestricted
E=Endowment & Similar
L=Loan Funds
N=Non-Gift
P=Plant Funds
R=Current Restricted
22 AV_CASE_PRPS Character(4) VARCHAR2(4) NOT NULL CASE Purpose
A=Financial Aid
B=Land & Buildings
C=Chairs
E=Equipment
F=Faculty/Staff Compen
J=Student Projects
L=Library
M=Academic Divisions
N=Non-Gift
O=Other Restricted Purposes
P=Prizes
R=Research
S=Special Programs
T=Athletics
U=Unrestricted
X=Public Service & Ext
23 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type
24 PLEDGE_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number
25 CAE_RE_FLG Character(1) VARCHAR2(1) NOT NULL CAE Real Estate
26 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous
27 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code
28 CHARITAB_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
29 RCG_DES_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
30 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit
31 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: AV_SESSION_TBL.INSTITUTION