SPS_GWABETCA_VW

(SQL View)
 Index Back

BETC code view for GWA Report.

BETC code view for GWA Report.

SELECT B.TAS_GWA ,A.BETC_CD , A.AGENCY_ID1 , A.MAIN_ACCOUNT , A.SUB_LEVEL_CD , A.ALLO_TR_AGENCY , A.BEGIN_PERIOD_AVAIL , A.END_PERIOD_AVAIL , A.AVAIL_TYPE_CD , A.SUB_ACCOUNT , A.PYMNT_OR_CLLCTN , A.ADJUSTMENT , A.ACTIVE_INACTIVE FROM PS_BETC_DEFN_TBL A , PS_TAS_DEFN_TBL B WHERE A.AGENCY_ID1 = B.AGENCY_ID1 AND A.MAIN_ACCOUNT = B.MAIN_ACCOUNT AND A.SUB_LEVEL_CD = B.SUB_LEVEL_CD AND A.ALLO_TR_AGENCY = B.ALLO_TR_AGENCY AND A.BEGIN_PERIOD_AVAIL = B.BEGIN_PERIOD_AVAIL AND A.END_PERIOD_AVAIL = B.END_PERIOD_AVAIL AND A.AVAIL_TYPE_CD = B.AVAIL_TYPE_CD AND A.SUB_ACCOUNT = B.SUB_ACCOUNT AND A.PYMNT_OR_CLLCTN ='P' AND A.ACTIVE_INACTIVE = 'A' AND A.ADJUSTMENT = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SPS_TAS Character(27) VARCHAR2(27) NOT NULL Sender Treasury Account Symbol
2 BETC_CD Character(8) VARCHAR2(8) NOT NULL Business Event Type Code
3 AGENCY_ID1 Character(3) VARCHAR2(3) NOT NULL TAS agency id
4 MAIN_ACCOUNT Character(4) VARCHAR2(4) NOT NULL Main Account TAS
5 SUB_LEVEL_CD Character(2) VARCHAR2(2) NOT NULL Sub level prefix code
6 ALLO_TR_AGENCY Character(3) VARCHAR2(3) NOT NULL Allocation Transfer Agency Identifier
7 BEGIN_PERIOD_AVAIL Character(4) VARCHAR2(4) NOT NULL Beginning Period of Availability (BPOA)
8 END_PERIOD_AVAIL Character(4) VARCHAR2(4) NOT NULL Ending Period of Availability (EPOA)
9 AVAIL_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Availability Type Code
A=Treasury cental smmry account
C=Cancelled
F=Clearing/suspense account
M=Merged surplus account
X=No-year account
10 SUB_ACCOUNT Character(3) VARCHAR2(3) NOT NULL Sub Account TAS
11 PYMNT_OR_CLLCTN Character(1) VARCHAR2(1) NOT NULL Payment or collection
C=Collection
P=Payment
12 ADJUSTMENT Character(1) VARCHAR2(1) NOT NULL Adjustment
13 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive