PTIASP_RUNCNTL(SQL Table) |
Index Back |
|---|---|
Run Cntl rec for PTIAINTCALC |
| # | 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 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 4 | PTIASPINTPKGFLAG | Character(1) | VARCHAR2(1) NOT NULL |
INT Package Flag
Default Value: N |
| 5 | PTIASPPKGNAME | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 6 | PTIASPACTIONS | Number(10,0) | DECIMAL(10) NOT NULL | Actions |
| 7 | PTIASPSEARCHSCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Scope for Selective Patching
A=All Updates Not Applied D=Generate Object Delta Package F=Standard System M=Merged Package P=Previously Defined R=Required For Upgrade Fixes S=All Other Search Criteria T=Translations Delta Package U=Application Upgrades to 9.2 |
| 8 | PTIASPSELECTPSTREQ | Character(1) | VARCHAR2(1) NOT NULL |
Post Requisites for (Select) Previously Applied Fixes
Y/N Table Edit Default Value: Y |
| 9 | PTIASPSELECTPRDFML | Character(1) | VARCHAR2(1) NOT NULL |
Product Family flag
Default Value: N |
| 10 | PTIASPSELPRDFMLYCR | Character(1) | VARCHAR2(1) NOT NULL |
Include Related Component and SubComponents flag
Y/N Table Edit Default Value: Y |
| 11 | PTIASPSELECTPROD | Character(1) | VARCHAR2(1) NOT NULL |
Select by Product flag
Default Value: N |
| 12 | PTIASPSELPRDCR | Character(1) | VARCHAR2(1) NOT NULL |
Include Related Component and SubComponents flag
Y/N Table Edit Default Value: Y |
| 13 | PTIASPSELECTPI | Character(1) | VARCHAR2(1) NOT NULL |
Field to select which type of Image Number to include in the search
Default Value: N |
| 14 | PTIASPSELECTSTDCAT | Character(1) | VARCHAR2(1) NOT NULL |
Standard Search Criteria flag
Default Value: N |
| 15 | PTIASPSELECTAVDCAT | Character(1) | VARCHAR2(1) NOT NULL |
Advanced Search Criteria flag
Default Value: N |
| 16 | PTIASPFRMTLSRELTXT | Character(7) | VARCHAR2(7) NOT NULL | From Tools Release |
| 17 | PTIASPUPGFROM | Character(254) | VARCHAR2(254) NOT NULL | Upgrade From |
| 18 | PTIASPUPGTO | Character(254) | VARCHAR2(254) NOT NULL | Upgrade To |
| 19 | PTIASPINCRFU | Character(1) | VARCHAR2(1) NOT NULL |
Include RFU
Y/N Table Edit Default Value: N |