PSCQTMPTBL_RUN

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CONQRSNAME Character(30) VARCHAR2(30) NOT NULL Connected Queries object name

Prompt Table: PSCONQRSRNC_DVW
Set Control Field: CONQRSNAME

3 PTRECLIST Character(254) VARCHAR2(254) NOT NULL Record List
4 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
5 TEMPTBLINSTANCES Number(4,0) SMALLINT NOT NULL Temp Table Instances (Total)
6 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
N=No
Y=Yes

Default Value: 0

7 DESCRLONG Long Character CLOB Long Description