AV_RCG_DES(SQL Table) |
Index Back |
---|---|
Recognition/Designation CrossRecognition/Designation Cross |
# | 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
Default Value: AV_SESSION_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
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
Y/N Table Edit Default Value: N |
27 | CURRENCY_CD_ENTRY | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY |
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 |