AV_ACK_DTL_VW(SQL View) |
Index Back |
---|---|
Acknowledgement DetailAcknowledgement Detail |
SELECT INSTITUTION ,SESSION_NO ,GIFT_NO ,EMPLID ,EXT_ORG_ID ,RECOGNITION_TYPE ,DESIGNATION ,AV_ACKNLDG_NO ,SA_ID_TYPE ,AV_DATE ,TENDER_TYPE ,GIFT_TYPE ,AV_AMOUNT ,CHARITABLE_AMT ,CURRENCY_CD ,ACKNLDG_STATUS ,ACKNLDG_TYPE ,ACKNLDG_REASON ,ACKNLDG_CTGY ,OPRID ,TRIBUTE_FLG ,LTR_TYPE ,EVENT_3CS_ID ,COMMENTS FROM PS_AV_ACKNLDG_DTL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
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 | AV_ACKNLDG_NO | Number(4,0) | SMALLINT NOT NULL | Acknowledgement Number |
9 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
10 | AV_DATE | Date(10) | DATE | Date |
11 | TENDER_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Tender Type
Prompt Table: AV_TNDR_TYPE_VW |
12 | GIFT_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Gift Type |
13 | AV_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |
14 | CHARITABLE_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Charitable Amount |
15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
16 | ACKNLDG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Acknowledgement Status
C=Complete IP=In Process Q=Queued S=Suspense |
17 | ACKNLDG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Acknowledgement Type
G=Gift P=Pledge |
18 | ACKNLDG_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Suspense Reason
ADJG=Adjusted Gift ADJP=Adjusted Pledge ANON=Anonymous Gift DEC=Deceased DES=Designation GAMT=Gift Amount HGTR=Gift In Honor of HPTR=Pledge In Honor of MGTR=Gift In Memory of MPTR=Pledge In Memory of NONE=No Acknowledgement Criteria RCPT=Receipt SRVC=Service Indicator |
19 | ACKNLDG_CTGY | Character(4) | VARCHAR2(4) NOT NULL |
Acknowledgement Category
ANON=Anonymous DEC=Deceased DES=Designation GA=Gift Amount HONR=In Honor MEM=In Memory SI=Service Indicator SUS=Suspense |
20 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
21 | TRIBUTE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In Honor/In Memory
Y/N Table Edit |
22 | LTR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Letter Type
C=Custom N=None S=Standard |
23 | EVENT_3CS_ID | Character(10) | VARCHAR2(10) NOT NULL |
3Cs event ID
Prompt Table: EVNT_3CS_TBL |
24 | COMMENTS | Long Character | CLOB | Comment |