SSF_RF_EVT3C_VW

(SQL View)
 Index Back

Refunding Event 3Cs View

Batch Refund Notifications only support SFRF admin function, since the variable data is tied directly to Refunding via Business Unit and Refund Nbr. This view only allows Events related to the SFRF admin function to be selected on the SF Business Unit - Refund Setup page.

SELECT A.INSTITUTION , A.EVENT_3CS_ID , A.ADMIN_FUNCTION , A.DESCR , A.DESCRSHORT FROM PS_EVNT_3CS_TBL A WHERE A.ADMIN_FUNCTION = 'SFRF' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EVNT_3CS_TBL A1 WHERE A.INSTITUTION = A1.INSTITUTION AND A.EVENT_3CS_ID = A1.EVENT_3CS_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: SSF_RF_3C_VWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID
    3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: EVNT_3CS_TBL.DESCR