GVT_TAS_BETC_VW (SQL View)	Index Back
TAS Fund Code View TAS Fund Code View

GVT_TAS_BETC_VW

(SQL View)

TAS Fund Code View

SELECT DISTINCT GVT_TAS_GWA , GVT_BETC_CD , GVT_PYMT_OR_CLLCTN , GVT_ADJUSTMENT , DESCR50 FROM ps_gvt_tas_defn A , PS_GVT_BETC_DEFN B WHERE B.GVT_TAS_AID = A.GVT_TAS_AID AND B.GVT_TAS_MAIN = A.GVT_TAS_MAIN AND B.GVT_TAS_SP = A.GVT_TAS_SP AND B.GVT_TAS_ATA = A.GVT_TAS_ATA AND B.GVT_TAS_BPOA = A.GVT_TAS_BPOA AND B.GVT_TAS_EPOA = A.GVT_TAS_EPOA AND B.GVT_TAS_A = A.GVT_TAS_A AND B.GVT_TAS_SUB = A.GVT_TAS_SUB AND B.GVT_ACTIVE_INDC = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_ADJ_TAS_GWA Character(26) VARCHAR2(26) NOT NULL New GWA TAS String

2 GVT_ADJ_BETC_CD Character(8) VARCHAR2(8) NOT NULL New Business Event Type Code

3 GVT_PYMT_OR_CLLCTN Character(1) VARCHAR2(1) NOT NULL Payment or collection
C=Collection
P=Payment

4 GVT_ADJUSTMENT Character(1) VARCHAR2(1) NOT NULL Adjustment
Y/N Table Edit

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_ADJ_TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	New GWA TAS String
2	GVT_ADJ_BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	New Business Event Type Code
3	GVT_PYMT_OR_CLLCTN	Character(1)	VARCHAR2(1) NOT NULL	Payment or collection C=Collection P=Payment
4	GVT_ADJUSTMENT	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Y/N Table Edit
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50