PSARCHIVE_AET

index back

AET record for PSARCHIVE


PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
PSARCH_PROCESS Character(1) VARCHAR2(1) NOT NULL Archive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection

Default: S

PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
PSARCH_AERESTART Character(1) VARCHAR2(1) NOT NULL Archive Restart
PSARCH_SELECTQRY Character(30) VARCHAR2(30) NOT NULL Selection Query for Archiving
PSARCH_QRYTYPE Number(1,0) SMALLINT NOT NULL Data Archive Manager - Archive Query Type

1/0 Table Edit (1=True, 0=False)

Default: 0

PSARCH_PREAE Character(12) VARCHAR2(12) NOT NULL Pre AE
PSARCH_POSTAE Character(12) VARCHAR2(12) NOT NULL Post AE
PSARCH_GOTOEND Character(1) VARCHAR2(1) NOT NULL Goto End
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
PSARCH_COUNT_ROWS Character(1) VARCHAR2(1) NOT NULL Count Number of Affected Rows
PSARCH_NUMOFROWS Signed Number(19,0) DECIMAL(18) NOT NULL Number of Rows
PSARCH_UNITOFWORK Character(1) VARCHAR2(1) NOT NULL Do Archiving as Unit of Work
N=Do Archiving Row by Row
Y=Do Archiving in a Run Unit
PSARCH_ROWPROCESS Character(1) VARCHAR2(1) NOT NULL Row-based processing
E=Commit at End
N=Set-Based Processing
Y=Row-Based Processing
PSARCH_COMMIT_ROWS Number(18,0) DECIMAL(18) NOT NULL Num of rows to commit after
PSARCH_PROC_FLAG Character(1) VARCHAR2(1) NOT NULL Archiving Process Flag
PSARCH_OBJECT Character(30) VARCHAR2(30) NOT NULL Archive Object (see PSARCHOBJDEFN).
PSARCH_BASEOBJECT Character(1) VARCHAR2(1) NOT NULL Base Object
PSARCH_LINKTABLE Character(15) VARCHAR2(15) NOT NULL Link Table
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PSARCH_BASETABLE Character(1) VARCHAR2(1) NOT NULL Base Table
RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1
PSARCH_SQL Long Character CLOB SQL Statement
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19