EX_SRCH_APRV_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' , ' ' , 'and' , %DateNull , %DateNull , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Panel Field Name
Prompt Table: EX_SRCH_FLD_VW |
| 2 | 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 Prompt Table: EX_SRCH_OPRS_VW |
| 3 | SRCH_LOGICAL_OPR | Character(4) | VARCHAR2(4) NOT NULL |
Logical Operator
AND=and OR=or Default Value: AND |
| 4 | SRCH_DATE_END_VAL | Date(10) | DATE | End Date |
| 5 | SRCH_DATE_STRT_VAL | Date(10) | DATE | Start Date |
| 6 | SRCH_SIGN_END_VAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | End Value |
| 7 | SRCH_SIGN_STRT_VAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Start value |
| 8 | SRCH_CHAR_END_VAL | Character(35) | VARCHAR2(35) NOT NULL | End value |
| 9 | SRCH_CHAR_STRT_VAL | Character(35) | VARCHAR2(35) NOT NULL | Start value |
| 10 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 11 | DESCR254_MIXED2 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 12 | APPR_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
| 13 | PB_SRCH_RANGE | Character(1) | VARCHAR2(1) NOT NULL | Sequence Range Search Button |