OPRIDRUN_CNTL_IDDefault Value: 1
Y/N Table Edit
Default Value: N
JPN=Japanese
KOR=Korean
ZHS=Simplified Chinese
ZHT=Traditional Chinese
QUERY_RUN_CNTRL(SQL Table) |
Index Back |
|---|---|
Scheduled Query Run Control |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | QRYTYPE | Number(1,0) | SMALLINT NOT NULL |
Query type field with translates for Query
Default Value: 1 |
| 5 | PRIVATE_QUERY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Flag to indicate if its a private query
Y/N Table Edit Default Value: N |
| 6 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 7 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 8 | ASIAN_FONT_SETTING | Character(3) | VARCHAR2(3) NOT NULL |
Setting when multiple double byte languages are installed on the system. Currently, only used by PDF and the Adobe PDF print dialog refers to these as 'Asian Fonts' so we are using same terminology
JPN=Japanese KOR=Korean ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 9 | PTFP_FEED_ID | Character(30) | VARCHAR2(30) NOT NULL | Feed ID (see PSFP_FEED). |