AV_SESS_S_VW

(SQL View)
 Index Back

Suspense session view

Selects all sessions that have a session status='S' (Suspense) before 8.2.00 SELECT A.INSTITUTION, A.SESSION_NO, A.AV_SESS_TYPE, A.SESS_STATUS, A.OPRID, A.BAL_DT, A.AV_POST_DT, A.ACTL_TTL_AMT, A.ACTL_TTL_CNT, A.ORIG_OPRID, A.LAST_MOD_DT, A.GL_POST_DT, A.SPSNS_REASON FROM PS_AV_SESSION_TBL A WHERE A.SESS_STATUS='S'

SELECT A.INSTITUTION , A.SESSION_NO , A.AV_SESS_TYPE , A.SESS_STATUS , A.OPRID , A.BAL_DT , A.AV_POST_DT , A.ACTL_TTL_AMT , A.ACTL_TTL_CNT , A.ORIG_OPRID , A.LAST_MOD_DT , A.GL_POST_DT , A.SPSNS_REASON , A.BUSINESS_UNIT FROM PS_AV_SESSION_TBL A WHERE A.SESS_STATUS='S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
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
4 SESS_STATUS Character(1) VARCHAR2(1) NOT NULL Session Status
B=Balanced
O=Open
P=Posted
Q=Queued
S=Suspense
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 BAL_DT Date(10) DATE Balance Date
7 AV_POST_DT Date(10) DATE Post Date
8 ACTL_TTL_AMT Number(16,2) DECIMAL(15,2) NOT NULL Actual Total Amount
9 ACTL_TTL_CNT Number(5,0) INTEGER NOT NULL Actual Total Count
10 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
11 LAST_MOD_DT Date(10) DATE Last Modification Date
12 GL_POST_DT Date(10) DATE General Ledger Posting Date
13 SPSNS_REASON Character(100) VARCHAR2(100) NOT NULL Suspense Reason
14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit