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