AV_PLDG2_SRCH(SQL View) |
Index Back |
---|---|
Pledge Detail VWSearch view of AV_PLEDGE_DTL with emplid as a key. 7.27.00 SELECT INSTITUTION, EMPLID, SESSION_NO, GIFT_NO FROM PS_AV_PLEDGE_DTL |
SELECT INSTITUTION , BUSINESS_UNIT , EMPLID , SESSION_NO , GIFT_NO FROM PS_AV_PLEDGE_DTL WHERE ADJUSTMENT_FLG = 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
2 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_INST_BU_VW |
|
3 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: AV_PEOPLE_SRCH |
|
4 | SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
5 | Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |