CA_TAS_STRNG_VW (SQL View)	Index Back
Non-internal TAS String View of all the TAS String values which are not marked as internal.

CA_TAS_STRNG_VW

(SQL View)

Non-internal TAS String

View of all the TAS String values which are not marked as internal.

SELECT TAS_STRING , AGENCY_ID1 , MAIN_ACCOUNT FROM PS_TAS_DEFN_TBL WHERE INTERNAL_TAS_SW = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TAS_STRING Character(20) VARCHAR2(20) NOT NULL TAS String

2 AGENCY_ID1 Character(3) VARCHAR2(3) NOT NULL TAS agency id

3 MAIN_ACCOUNT Character(4) VARCHAR2(4) NOT NULL Main Account TAS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TAS_STRING	Character(20)	VARCHAR2(20) NOT NULL	TAS String
2	AGENCY_ID1	Character(3)	VARCHAR2(3) NOT NULL	TAS agency id
3	MAIN_ACCOUNT	Character(4)	VARCHAR2(4) NOT NULL	Main Account TAS