PSPTADSRUNCNTL(SQL Table) | 
Index Back | 
|---|---|
ADS Run Control | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | PTACTION | Character(1) | VARCHAR2(1) NOT NULL | 
Action
 C=Copy Project L=Load Project V=Validate Project Z=Compare Project Default Value: C  | 
| 4 | PTOPTION | Character(2) | VARCHAR2(2) NOT NULL | 
Option
 FD=From Database FF=From File TF=To File TN=To Node Default Value: FF  | 
| 5 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). | 
| 6 | PTLANGUAGELIST | Character(254) | VARCHAR2(254) NOT NULL | Language List | 
| 7 | PTOVERWRITE | Character(1) | VARCHAR2(1) NOT NULL | 
Overwrite existing
 N=False Y=True Y/N Table Edit Default Value: Y  | 
| 8 | PT_COMMIT_INTERVAL | Number(8,0) | INTEGER NOT NULL | Commit Interval | 
| 9 | PTREPNAME | Character(30) | VARCHAR2(30) NOT NULL | 
Location Name
 Prompt Table: PSPRJREP_DMW_VW  | 
| 10 | PTAREANAME | Character(254) | VARCHAR2(254) NOT NULL | 
Area Name
 Prompt Table: PSPRJREPOSAREA  |