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 BPW_ENTRY_POINT Character(30) VARCHAR2(30) NOT NULL Entry Point
2 SYSTEM_DATA_FLG 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