ARCH_OTH_CTL_VW

index back

PS Archiving OtherCtrl View


SELECT PSARCH_ID , recname , arch_seq , arch_uniq , recname1 , PSARCH_AND_OR1 , fieldname1 , PSARCH_OPERANDS1 , PSARCH_MATCHVAL1 , PSARCH_MATCHDT1 , PSARCH_CHECK_FLAG FROM PS_ARCH_OTH_CTRL

PeopleSoft Field NameField TypeColumn TypeDescription
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
ARCH_SEQNumber(4,0)SMALLINT NOT NULLArchiving Number Sequence
ARCH_UNIQNumber(4,0)SMALLINT NOT NULLUnique Recname Identifier
RECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1

Prompt Table: RECDEFN_VW

PSARCH_AND_OR1Character(1)VARCHAR2(1) NOT NULLAND or OR 1
FIELDNAME1Character(18)VARCHAR2(18) NOT NULLField Name 1
PSARCH_OPERANDS1Character(1)VARCHAR2(1) NOT NULLOperator 1
1==
2=<
3=>
4=<=
5=>=
6=<>
7=LIKE
8=NOT LIKE
PSARCH_MATCHVAL1Character(30)VARCHAR2(30) NOT NULLValue to Match 1
PSARCH_MATCHDT1Date(10)DATEValue to Match (Date) 1
PSARCH_CHECK_FLAGCharacter(1)VARCHAR2(1) NOT NULLCheck Flag
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19