BUSINESS_UNITDefault Value: AV_OPR_DEF_TBL.BUSINESS_UNIT
Prompt Table: AV_BUS_UNIT_TBL
EMPLIDPrompt Table: AV_PEOPLE_SRCH
EXT_ORG_IDPrompt Table: AV_EXT_ORG_SRCH
SESSION_NOGIFT_NOPrompt Table: AV_TNDR_TYPE_VW
AV_ED_TNDR_SRCH(SQL View) |
Index Back |
|---|---|
Search record Edt Tndr Dtls |
| SELECT A.BUSINESS_UNIT , B.EMPLID , B.EXT_ORG_ID , A.SESSION_NO , B.GIFT_NO , B.GIFT_DT , B.GIFT_AMT , B.TENDER_TYPE FROM PS_AV_GIFT_DTL B , PS_AV_SESSION_TBL A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND A.AV_SESS_TYPE IN ('G','AG') AND A.SESS_STATUS = 'P' AND B.ADJUSTMENT_FLG = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: AV_PEOPLE_SRCH |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: AV_EXT_ORG_SRCH |
| 4 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Number |
| 5 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Number |
| 6 | GIFT_DT | Date(10) | DATE | Gift Date |
| 7 | GIFT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gift Amount |
| 8 | TENDER_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Tender Type
Prompt Table: AV_TNDR_TYPE_VW |