AP_NOGWABETC_VW

(SQL View)
 Index Back

BETC view For non GWA

BETC view For non GWA

SELECT B.TAS_STRING ,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 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 ADJUSTMENT = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TAS_STRING Character(20) VARCHAR2(20) NOT NULL TAS String
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