BPW_ENTYPT_U_VW(SQL View) |
Index Back |
---|---|
BPW Entry Point user view |
SELECT BPW_ENTRY_POINT , SYSTEM_DATA_FLG , BPW_ENTRYPNT_DESCR , BPW_DYNAMIC_RC_FLG , BPW_PROC_TYPE , BPW_PROC_ID , BPW_PROC_RUN_CNTL , BPW_OBJECTOWNERID , BPW_ACTIVE_FLAG FROM PS_BPW_ENTYPNT_REG WHERE SYSTEM_DATA_FLG = 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Entry Point | |
2 | Character(1) | VARCHAR2(1) NOT NULL |
System Data
Default Value: N |
|
3 | BPW_ENTRYPNT_DESCR | Character(80) | VARCHAR2(80) NOT NULL | Entry Point Description |
4 | BPW_DYNAMIC_RC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Dynamic Run Control
Y/N Table Edit Default Value: Y |
5 | BPW_PROC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined Default Value: USER Prompt Table: BPW_PRC_TYPE_VW |
6 | BPW_PROC_ID | Character(30) | VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table: BPW_PROC_DEFN |
7 | BPW_PROC_RUN_CNTL | Character(30) | VARCHAR2(30) NOT NULL |
Process Run Control ID
Prompt Table: BPW_PROC_RUN |
8 | BPW_OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL |
Additional valid values are from OBJECTOWNERID
Prompt Table: BPW_OBJOWNID_VW |
9 | BPW_ACTIVE_FLAG | Number(1,0) | SMALLINT NOT NULL |
Active
1/0 Table Edit (1=True, 0=False) Default Value: 1 |