PSCQTMPTBL_OPT(SQL Table) |
Index Back |
|---|---|
CQ Temp Tables Defaults |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DDLSPACENAME | Character(30) | VARCHAR2(30) NOT NULL |
Tablespace Name
Prompt Table: PSTBLSPCCAT_VW |
| 2 | PT_CQAEPREFIX | Character(4) | VARCHAR2(4) NOT NULL | AE Name Prefix |
| 3 | PT_CQTEMPTBLPREF | Character(3) | VARCHAR2(3) NOT NULL | Temp Table Prefix |
| 4 | TEMPINSTANCEBATCH | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Batch) |