AV_STRATEGY_VW

(SQL View)
 Index Back

Strategy Table View

An exact view of the strategy table. Initially used on the strategy panel to update spouse's information for a linked strategy.

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

  • Related Language Record: AVSTRATEGYVWLNG

    • # 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.
    10 DESCRLONG Long Character CLOB Long Description