AV_SESSION_DEF(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_SESSION_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL |
2 | SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL |
Session Nbr
Default Value: AV_SESSION_TBL.SESSION_NO |
3 | AV_SESS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Session Type
AG=Gift Adjustment AM=Adjust Membership AP=Pledge Adjustment G=Gift M=Membership PL=Pledge Default Value: AV_SESSION_TBL.AV_SESS_TYPE |
4 | AV_DES_BU | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_SESSION_TBL.BUSINESS_UNIT Prompt Table: %EDITTABLE |
5 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL |
Designation
Default Value: AV_OPR_DEF_BU.DESIGNATION Prompt Table: AV_ACCT_VW |
6 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL |
Initiative Code
Default Value: AV_OPR_DEF_BU.INTV_CD Prompt Table: AV_INTV_CMP_VW |
7 | MOTIVATION_CD | Character(9) | VARCHAR2(9) NOT NULL |
Appeal Code
Default Value: AV_OPR_DEF_BU.MOTIVATION_CD Prompt Table: AV_MTVTN_VW1 |
8 | TENDER_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Tender Type
Default Value: AV_BUS_UNIT_TBL.TENDER_TYPE Prompt Table: AV_TNDR_TYPE_VW |
9 | CARRY_TRANS_NBR | Character(11) | VARCHAR2(11) NOT NULL |
Carry Transaction
Prompt Table: %EDITTABLE2 |