PSARCH_IDRECNAMEARCH_SEQPrompt Table: RECDEFN_VW
1==
2=<
3=>
4=<=
5=>=
6=<>
7=LIKE
8=NOT LIKE
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 Name | Field Type | Column Type | Description |
|---|---|---|---|
| PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| ARCH_SEQ |
Number(4,0) | SMALLINT NOT NULL | Archiving Number Sequence |
| ARCH_UNIQ | Number(4,0) | SMALLINT NOT NULL | Unique Recname Identifier |
| RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL |
Record Name 1
Prompt Table: RECDEFN_VW |
| PSARCH_AND_OR1 | Character(1) | VARCHAR2(1) NOT NULL | AND or OR 1 |
| FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| PSARCH_OPERANDS1 | Character(1) | VARCHAR2(1) NOT NULL |
Operator 1
1== 2=< 3=> 4=<= 5=>= 6=<> 7=LIKE 8=NOT LIKE |
| PSARCH_MATCHVAL1 | Character(30) | VARCHAR2(30) NOT NULL | Value to Match 1 |
| PSARCH_MATCHDT1 | Date(10) | DATE | Value to Match (Date) 1 |
| PSARCH_CHECK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Check Flag |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |