PSARCH_IDRECNAMEARCH_SEQPrompt Table: RECDEFN_VW
1==
2=<
3=>
4=<=
5=>=
6=<>
7=LIKE
8=NOT LIKE
ARCH_OTH_CTL_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | ARCH_SEQ |
Number(4,0) | SMALLINT NOT NULL | Archiving Number Sequence |
| 4 | ARCH_UNIQ | Number(4,0) | SMALLINT NOT NULL | Unique Recname Identifier |
| 5 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL |
Record Name 1
Prompt Table: RECDEFN_VW |
| 6 | PSARCH_AND_OR1 | Character(1) | VARCHAR2(1) NOT NULL | AND or OR 1 |
| 7 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 8 | PSARCH_OPERANDS1 | Character(1) | VARCHAR2(1) NOT NULL |
Operator 1
1== 2=< 3=> 4=<= 5=>= 6=<> 7=LIKE 8=NOT LIKE |
| 9 | PSARCH_MATCHVAL1 | Character(30) | VARCHAR2(30) NOT NULL | Value to Match 1 |
| 10 | PSARCH_MATCHDT1 | Date(10) | DATE | Value to Match (Date) 1 |
| 11 | PSARCH_CHECK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Check Flag |