PSPTADS_AET(SQL Table) |
Index Back |
---|---|
ADS State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | 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 |