PSARCHIVE_AET

index back

AET record for PSARCHIVE


PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
PSARCH_PROCESSCharacter(1)VARCHAR2(1) NOT NULLArchive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection

Default: S

PSARCH_BATCHNUMNumber(30,0)DECIMAL(30) NOT NULLArchive Batch Number
PSARCH_AERESTARTCharacter(1)VARCHAR2(1) NOT NULLArchive Restart
PSARCH_SELECTQRYCharacter(30)VARCHAR2(30) NOT NULLSelection Query for Archiving
PSARCH_QRYTYPENumber(1,0)SMALLINT NOT NULLData Archive Manager - Archive Query Type

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

Default: 0

PSARCH_PREAECharacter(12)VARCHAR2(12) NOT NULLPre AE
PSARCH_POSTAECharacter(12)VARCHAR2(12) NOT NULLPost AE
PSARCH_GOTOENDCharacter(1)VARCHAR2(1) NOT NULLGoto End
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
AE_APPSTATUSNumber(1,0)SMALLINT NOT NULLAE Application Warning Status
PSARCH_COUNT_ROWSCharacter(1)VARCHAR2(1) NOT NULLCount Number of Affected Rows
PSARCH_NUMOFROWSSigned Number(19,0)DECIMAL(18) NOT NULLNumber of Rows
PSARCH_UNITOFWORKCharacter(1)VARCHAR2(1) NOT NULLDo Archiving as Unit of Work
N=Do Archiving Row by Row
Y=Do Archiving in a Run Unit
PSARCH_ROWPROCESSCharacter(1)VARCHAR2(1) NOT NULLRow-based processing
E=Commit at End
N=Set-Based Processing
Y=Row-Based Processing
PSARCH_COMMIT_ROWSNumber(18,0)DECIMAL(18) NOT NULLNum of rows to commit after
PSARCH_PROC_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchiving Process Flag
PSARCH_OBJECTCharacter(30)VARCHAR2(30) NOT NULLArchive Object (see PSARCHOBJDEFN).
PSARCH_BASEOBJECTCharacter(1)VARCHAR2(1) NOT NULLBase Object
PSARCH_LINKTABLECharacter(15)VARCHAR2(15) NOT NULLLink Table
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PSARCH_BASETABLECharacter(1)VARCHAR2(1) NOT NULLBase Table
RECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1
PSARCH_SQLLong CharacterCLOBSQL Statement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19