BPW_DTCKREC_VW

(SQL View)
Index Back

BPW Data Check Record prompt

BPW Data Check Record prompt view, SQL table in PSRECDEFN.

SELECT D.RECNAME , D.RECTYPE , D.RECDESCR , D.DESCRLONG FROM PSRECDEFN D , PSRECFIELDDB B WHERE D.RECTYPE IN (0, 1) AND D.RECNAME = B.RECNAME AND B.FIELDNAME = 'PROCESS_INSTANCE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
0=SQL Table
1=SQL View
2=Derived Work/Record
3=Subrecord
5=Dynamic View
6=Query View
7=Temporary Table
3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
4 DESCRLONG Long Character CLOB Long Description