RO_BPSTATDSC_VW (SQL View)	Index Back
BP Status Description Business Project Status Description

RO_BPSTATDSC_VW

(SQL View)

BP Status Description

Business Project Status Description

SELECT A.BUS_PROC_INSTANCE , A.RC_BUS_PROCESS_ID , B.DESCR , C.XLATLONGNAME FROM %Table(RC_BP_STATUS) A , %Table(RC_BUS_PROCESS) B , %Table(PSXLATITEM) C WHERE A.RC_BUS_PROCESS_ID=B.RC_BUS_PROCESS_ID AND %EffdtCheck(RC_BUS_PROCESS, B, %currentdatein) AND C.FIELDNAME='BUS_PROCESS_STATUS' AND A.BUS_PROCESS_STATUS = C.FIELDVALUE AND %EffdtCheck(PSXLATITEM, C, %currentdatein)

Related Language Record: RO_BPSTAT_L_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

2 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
2	RC_BUS_PROCESS_ID	Character(15)	VARCHAR2(15) NOT NULL	Business Process ID used in Business Process tracking.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name