AV_DES_DTL_VW

(SQL View)
 Index Back

Designation Detail View

This is a view of the Account Designation Table which selects the latest account details.

SELECT A.SETID , A.DESIGNATION , A.EFFDT , A.AV_DES_NAME , A.EFF_STATUS , A.AV_CASE_TYPE , A.AV_MTCH_GFT_TP , A.AV_INST_TYPE , A.ITEM_TYPE , A.AV_CASE_PRPS , A.AV_FASB_TYPE , A.STAFF_ID , A.DESCR254 , A.DEPTID , A.COMMENTS , A.CAMPUS , A.ACAD_ORG , A.INSTITUTION , A.GIFT_EVENT_3CS , A.PLDG_EVENT_3CS , A.PURPOSE_CD , A.PLDG_PURPOSE_CD FROM PS_AV_ACCOUNT_TBL A WHERE A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_AV_ACCOUNT_TBL A1 WHERE A1.SETID = A.SETID AND A1.DESIGNATION = A.DESIGNATION AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: AV_DES_DTLVWLNG

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 AV_DES_NAME Character(30) VARCHAR2(30) NOT NULL Designation Name
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 AV_CASE_TYPE Character(4) VARCHAR2(4) NOT NULL CASE Type
    C=Current Unrestricted
    E=Endowment & Similar
    L=Loan Funds
    N=Non-Gift
    P=Plant Funds
    R=Current Restricted
    7 AV_MTCH_GFT_TP Character(6) VARCHAR2(6) NOT NULL Matching Gift Type
    8 AV_INST_TYPE Character(6) VARCHAR2(6) NOT NULL Designation Type
    9 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    10 AV_CASE_PRPS Character(4) VARCHAR2(4) NOT NULL CASE Purpose
    A=Financial Aid
    B=Land & Buildings
    C=Chairs
    E=Equipment
    F=Faculty/Staff Compen
    J=Student Projects
    L=Library
    M=Academic Divisions
    N=Non-Gift
    O=Other Restricted Purposes
    P=Prizes
    R=Research
    S=Special Programs
    T=Athletics
    U=Unrestricted
    X=Public Service & Ext
    11 AV_FASB_TYPE Character(4) VARCHAR2(4) NOT NULL FASB Type
    1=Unrestricted
    2=Temp. Restricted
    3=Perm. Restricted
    4=Agency
    12 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID
    13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: AV_DEPT_VW

    15 COMMENTS Long Character CLOB Comment
    16 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    17 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    18 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    19 GIFT_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

    Prompt Table: EVNT_3CS_TBL

    20 PLDG_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

    Prompt Table: EVNT_3CS_TBL

    21 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role

    Prompt Table: AV_PRPS_VW

    22 PLDG_PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Purpose Code

    Prompt Table: AV_PRPS_VW