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