PRCSTYPEPrompt Table: PRCSTYPE_VW
PRCSNAMEPNLGRPNAMEPrompt Table: PRCSPNLGRP_VW
OBJECTOWNERIDRECNAMEY/N Table Edit
Y/N Table Edit
EORD_MD_VW(SQL View) |
Index Back |
|---|
| SELECT PRCSTYPE, PRCSNAME, PRCSJOBNAME, PNLGRPNAME, OBJECTOWNERID, RECNAME, EORD_INCL_RD, BPW_SYS_DEFN_FLG FROM PS_EORD_METADATA WHERE BPW_SYS_DEFN_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PRCSTYPE_VW |
| 2 | PRCSNAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 3 | PRCSJOBNAME | Character(8) | VARCHAR2(8) NOT NULL | Process Job Name |
| 4 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PRCSPNLGRP_VW |
| 5 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 6 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 7 | EORD_INCL_RD | Character(1) | VARCHAR2(1) NOT NULL |
Included In Run Control Delete
Y/N Table Edit |
| 8 | BPW_SYS_DEFN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Defined
Y/N Table Edit |