BUSINESS_UNITSESSION_NOGIFT_NOAV_DES_RECOG_VW(SQL View) |
Index Back |
|---|---|
AV Designation/Recognition vw06/20/2001 (JPM) - Added AV_DES_BU AND DES_PCT_AMT fields to this view. |
| SELECT A.BUSINESS_UNIT , A.SESSION_NO , A.GIFT_NO , A.EMPLID , B.DESIGNATION , B.AV_DES_BU , B.DES_PCT_AMT FROM PS_AV_RECOGNITION A , PS_AV_DESIGNATION B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SESSION_NO=B.SESSION_NO AND A.GIFT_NO=B.GIFT_NO AND A.RECOGNITION_TYPE='H' |
| # | 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 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 6 | AV_DES_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | DES_PCT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |