SDN_INQ_FLDS(SQL Table) |
Index Back |
---|---|
Search Configuration work |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: AP_MTCH_WB_HDR.OPRID |
2 | SRCH_CONFIG_ID | Character(20) | VARCHAR2(20) NOT NULL |
Search Configuration ID
Default Value: AP_MTCH_WB_HDR.SRCH_CONFIG_ID |
3 | SRCH_CRITERIA | Character(30) | VARCHAR2(30) NOT NULL | Search Criteria |
4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
5 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RECFLD_LABEL_VW |
7 | SRCH_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Allowed logic operator by field type
!IN=not in 0=All Values 1=equal to 2=less than 21=before 3=greater than 31=after 4=less than or equal to 41=on or before 5=greater than or equal to 51=on or after 6=between 7=begins with 8=contains 9=in <=< <==<= <>=not = === >=> >==>= A=not in B=not equal BEG=begins with BTWN=between IN=in LIKE=contains Default Value: 0 |
8 | FROM_MIXED_NP | Character(50) | VARCHAR2(50) NOT NULL | Equal To |
9 | FROM_MIXED_P | Character(50) | VARCHAR2(50) NOT NULL |
Equal To
Prompt Table: %EDITTABLE |
10 | FROM_UPPER_NP | Character(50) | VARCHAR2(50) NOT NULL | Equal To |
11 | FROM_UPPER_P | Character(50) | VARCHAR2(50) NOT NULL |
Equal To
Prompt Table: %EDITTABLE |
12 | DATE_FROM | Date(10) | DATE | Date From |
13 | DATE_TO | Date(10) | DATE | Date To |
14 | FROM_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Amount |
15 | TO_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | And |
16 | VALUE_XLAT | Character(4) | VARCHAR2(4) NOT NULL |
Translate Value
0=Null |
17 | IN_LIST_STRING | Character(254) | VARCHAR2(254) NOT NULL | SQL in list string |
18 | TO_MIXED_NP | Character(50) | VARCHAR2(50) NOT NULL | To Value |
19 | TO_MIXED_P | Character(50) | VARCHAR2(50) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
20 | TO_UPPER_NP | Character(50) | VARCHAR2(50) NOT NULL | To Value |
21 | TO_UPPER_P | Character(50) | VARCHAR2(50) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
22 | TO_NUMBER_P | Number(15,0) | DECIMAL(15) NOT NULL |
To
Prompt Table: %EDITTABLE |
23 | TO_NUMBER_NP | Number(15,0) | DECIMAL(15) NOT NULL | To |
24 | FROM_NUMBER_P | Number(15,0) | DECIMAL(15) NOT NULL |
From Number
Prompt Table: %EDITTABLE |
25 | FROM_NUMBER_NP | Number(15,0) | DECIMAL(15) NOT NULL | From Number |