DRAFT_BUSN_EVENTLANGUAGE_CDDR_BUSEVNT_VWLG(SQL View) |
Index Back |
|---|---|
Draft Business Event |
| SELECT %subrec(DR_BUSEVNT_VWLG, L) FROM PS_DR_BUS_EVNT_LG L , PS_DR_BUS_EVNT_TBL A WHERE A.DRAFT_BUSN_EVENT=L.DRAFT_BUSN_EVENT AND A.ACTIVE_STATUS = 'A' AND A.DR_ENTRY_USE_FLG = 'Y' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | DRAFT_DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |