PSPTADS_AET(SQL Table) |
Index Back |
|---|---|
ADS State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | RUN_CNTL_ID | 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 |
| 4 | PTOPTION | Character(2) | VARCHAR2(2) NOT NULL |
Option
FD=From Database FF=From File TF=To File TN=To Node |
| 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 |
| 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 |
| 11 | RETURNCODE | Number(10,0) | DECIMAL(10) NOT NULL | Return Code |