AV_ACCOUNT_VW (SQL View)	Index Back
Account Designation Table Account Designation Table View for prompting on all unique Designation codes regardless of status. Used on places like the Transaction register where inactive Designations would need to be available as a prompt value.

AV_ACCOUNT_VW

(SQL View)

Account Designation Table

Account Designation Table View for prompting on all unique Designation codes regardless of status. Used on places like the Transaction register where inactive Designations would need to be available as a prompt value.

SELECT A.SETID , A.DESIGNATION , A.EFFDT , A.EFF_STATUS , A.AV_DES_NAME , A.DESCR254 , A.DESCR60_SRCH FROM PS_AV_ACCOUNT_TBL A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_AV_ACCOUNT_TBL A1 WHERE A.SETID=A1.SETID AND A.DESIGNATION=A1.DESIGNATION AND A1.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation

3 AS_OF_DATE Date(10) DATE As of Date

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

5 AV_DES_NAME Character(30) VARCHAR2(30) NOT NULL Designation Name

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

7 DESCR60_SRCH Character(60) VARCHAR2(60) NOT NULL Formal Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DESIGNATION	Character(11)	VARCHAR2(11) NOT NULL	Designation
3	AS_OF_DATE	Date(10)	DATE	As of Date
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
5	AV_DES_NAME	Character(30)	VARCHAR2(30) NOT NULL	Designation Name
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
7	DESCR60_SRCH	Character(60)	VARCHAR2(60) NOT NULL	Formal Description