INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
EMPLIDEXT_ORG_IDCP_PLEDGE_NOPrompt Table: CURRENCY_CD_TBL
Default Value: %date
AV_CP_PLDG_VW2(SQL View) |
Index Back |
|---|---|
Conditional Pledge Detail VW2Converts GIFT_NO field to CP_PLEDGE_NO for use on the pledge entry screen. |
| SELECT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.GIFT_NO, A.GIFT_AMT, A.CURRENCY_CD, A.PLDG_EFFDT, A.FULF_DT FROM PS_AV_CP_PLDG_DTL A WHERE STATUS = 'A' |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | CP_PLEDGE_NO |
Character(11) | VARCHAR2(11) NOT NULL | Conditional Pledge Nbr |
| 5 | GIFT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gift Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | PLDG_EFFDT | Date(10) | DATE | Effective Date |
| 8 | FULF_DT | Date(10) | DATE NOT NULL |
Fulfillment Date
Default Value: %date |