AV_SEC_G_SP_VW

(SQL View)
Index Back

Session Gift view

Shows all gift sessions. before 8.1.00 SELECT INSTITUTION, SESSION_NO, OPRID, SESS_STATUS, AV_OPEN_DT, LAST_MOD_DT FROM PS_AV_SESSION_TBL WHERE AV_SESS_TYPE = 'G' OR AV_SESS_TYPE = 'AG'

SELECT B.OPRID , A.BUSINESS_UNIT , A.SESSION_NO , A.OPRID , A.SESS_STATUS , A.AV_OPEN_DT , A.LAST_MOD_DT FROM PS_AV_SESSION_TBL A , PS_AV_SCRTY_BU_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND (A.AV_SESS_TYPE = 'G' OR A.AV_SESS_TYPE = 'AG')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT

Prompt Table: AV_BU_SCRTY_VW

3 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

Prompt Table: AV_SESS_G_VW

4 AV_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

Prompt Table: AV_SESS_OPR_VW

5 SESS_STATUS Character(1) VARCHAR2(1) NOT NULL Session Status
B=Balanced
O=Open
P=Posted
Q=Queued
S=Suspense
6 AV_OPEN_DT Date(10) DATE Date Opened
7 LAST_MOD_DT Date(10) DATE Last Modification Date