DR_BUS_EVNT_VW

(SQL View)
 Index Back

Active Draft Business Events


Select %subrec(DR_BUS_EVNT_SBR, A) from PS_DR_BUS_EVNT_TBL A where A.ACTIVE_STATUS = 'A' and A.DR_ENTRY_USE_FLG = 'Y'

  • Related Language Record: DR_BUSEVNT_VWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DRAFT_BUSN_EVENT Character(2) VARCHAR2(2) NOT NULL Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
    2 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 DRAFT_DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case
    5 DR_ENTRY_USE_FLG Character(1) VARCHAR2(1) NOT NULL Specify System Function

    Y/N Table Edit

    Default Value: Y