BUSINESS_UNITPrompt Table: AV_INST_BU_VW
SESSION_NOGIFT_NOLANGUAGE_CDAVPLEDGEVW2LNG(SQL View) |
Index Back |
|---|---|
Pledge Detail ViewReplica of AV_PLEDGE_DTL with no peoplecode. Used for new AV_ADJ_PLEDGE_SMRY panel. before 7.31.00 SELECT INSTITUTION, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, GIFT_AMT, CURRENCY_CD, PLDG_EFFDT, PLEDGE_DT, FULF_DT, PMT_SCHD, DATA_ENTRY_DT, PLEDGE_PMT_RCVD, LAST_PMT_DT, SEQ_NO, ADJUSTMENT_FLG, CP_PLEDGE_NO, FISCAL_YEAR, FEED_FLG, PMT_DTL_CHG, AV_PLDG_STATUS, PLEDGE_PG_TYPE, ACKN_FLG, DESCRLONG FROM PS_AV_PLEDGE_DTL |
| SELECT BUSINESS_UNIT , SESSION_NO , GIFT_NO , LANGUAGE_CD , DESCRLONG FROM PS_AVPLEDGEDTLLNG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: AV_INST_BU_VW |
| 2 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 3 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |