PSARCHREC_VW

index back

Records in Archive Template


SELECT A.PSARCH_ID , B.PSARCH_OBJECT , B.PSARCH_BASEOBJECT , B.PSARCH_LINKTABLE , C.PSARCH_BASETABLE , C.RECNAME FROM PSARCHTEMPLATE A , PSARCHTEMPOBJ B , PSARCHOBJREC C WHERE A.PSARCH_ID = B.PSARCH_ID AND B.PSARCH_OBJECT = C.PSARCH_OBJECT

PeopleSoft Field NameField TypeColumn TypeDescription
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).

Default: PSARCHRUNCNTL.PSARCH_ID

PSARCH_OBJECTCharacter(30)VARCHAR2(30) NOT NULLArchive Object (see PSARCHOBJDEFN).
PSARCH_BASEOBJECTCharacter(1)VARCHAR2(1) NOT NULLBase Object

Y/N Table Edit

PSARCH_LINKTABLECharacter(15)VARCHAR2(15) NOT NULLLink Table
PSARCH_BASETABLECharacter(1)VARCHAR2(1) NOT NULLBase Table

Y/N Table Edit

RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19