EMPLIDINSTITUTIONSESSION_NOGIFT_NORECOGNITION_TYPEDESIGNATIONINTV_CDAV_RCG_DES_VW4(SQL View) |
Index Back |
|---|---|
Recognition/Designate Cross VwRecognition/Designate Cross Vw |
| SELECT DISTINCT A.EMPLID, A.INSTITUTION, A.SESSION_NO, A.GIFT_NO, A.RECOGNITION_TYPE, A.DESIGNATION, A.INTV_CD FROM PS_AV_RCG_DES A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 4 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 5 | RECOGNITION_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Recognition Type |
| 6 | DESIGNATION |
Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 7 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |