DRAFT_BUSN_EVENTDR_SUBEVNT_SRCH(SQL View) |
Index Back |
|---|---|
Draft Sub Events Search |
| SELECT %subrec(dr_subevnt_srch, A) FROM PS_DR_BUS_EVNT_TBL A , PS_DR_BUS_EVNT_PST B WHERE B.DR_SUB_EVENT_FLG = 'Y' AND B.DRAFT_POST_ACTION = 'A' AND A.DRAFT_BUSN_EVENT = B.DRAFT_BUSN_EVENT |
| # | 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 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |