RS_ASSPRBREG_VW

(SQL View)

SELECT A.PROBINST , A.DESCR , A.CUR_SOLU_ASOF_DTTM FROM %Table(RS_ASS_PROBLEM) A , %Table(PSOPTPRBINST) B WHERE B.PROBINST = A.PROBINST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
Prompt Table: PSOPTPRBINST

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

3 CUR_SOLU_ASOF_DTTM DateTime(26) TIMESTAMP Current Solution As Of

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance Prompt Table: PSOPTPRBINST
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	CUR_SOLU_ASOF_DTTM	DateTime(26)	TIMESTAMP	Current Solution As Of