AV_STRATEGY_VW2 (SQL View)	Index Back
Prospect Strategy View2 View of the prospect strategy table without the long field description. Initially used on the strategy panel to check duplicate strategy names (which are not allowed).

AV_STRATEGY_VW2

(SQL View)

Prospect Strategy View2

View of the prospect strategy table without the long field description. Initially used on the strategy panel to check duplicate strategy names (which are not allowed).

SELECT INSTITUTION, EMPLID, EXT_ORG_ID, STRATEGY_NO, STRATEGY_NAME, STRATEGY_NAME_UPC, STRATEGY_STATUS, STRATEGY_SPS_LINK, LAST_UPDATE_DTTM FROM PS_AV_STRATEGY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: INSTITUTION_TBL.INSTITUTION

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

4 STRATEGY_NO Number(10,0) DECIMAL(10) NOT NULL Strategy Number

5 STRATEGY_NAME Character(30) VARCHAR2(30) NOT NULL Strategy Name

6 STRATEGY_NAME_UPC Character(30) VARCHAR2(30) NOT NULL Strategy name uppercase

7 STRATEGY_STATUS Character(3) VARCHAR2(3) NOT NULL Strategy Status
A=Active
HLD=On Hold
I=Inactive

8 STRATEGY_SPS_LINK Character(1) VARCHAR2(1) NOT NULL Spouse Link
D=Delete
K=Keep
N=No
Y=Yes

9 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: INSTITUTION_TBL.INSTITUTION
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
4	STRATEGY_NO	Number(10,0)	DECIMAL(10) NOT NULL	Strategy Number
5	STRATEGY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Strategy Name
6	STRATEGY_NAME_UPC	Character(30)	VARCHAR2(30) NOT NULL	Strategy name uppercase
7	STRATEGY_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Strategy Status A=Active HLD=On Hold I=Inactive
8	STRATEGY_SPS_LINK	Character(1)	VARCHAR2(1) NOT NULL	Spouse Link D=Delete K=Keep N=No Y=Yes
9	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.