IT_SEARCH_WK0(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 2 | FIELDLABEL | Character(60) | VARCHAR2(60) NOT NULL | Field Label |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | RECALIAS | Character(15) | VARCHAR2(15) NOT NULL | Record Alias |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 7 | LOGIC_OPER_CHAR | Character(1) | VARCHAR2(1) NOT NULL |
Logic Operator
1== 2=<> 3=> 4=< 5=>= 6=<= 7=Like 8=Not Like 9=Is Empty A=Between B=Not Between |
| 8 | LOGIC_OPER_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Logic Operator
1== 2=<> 3=> 4=< 5=>= 6=<= 7=Begins with 8=Does NOT begins with 9=Is Empty A=Between B=Not Between |
| 9 | LOGIC_OPER_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Logic Operator
1== 2=<> 3=> 4=< 5=>= 6=<= 7=Like 8=Does NOT begins with 9=Is Empty A=Between B=Not Between |
| 10 | PROMPT_EDITTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No 5=Currency Controlled |
| 11 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL | Prompt Table |
| 12 | UPDT_SETID_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 13 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 14 | UPDT_BUS_UNIT_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 16 | UPDT_KEY_CHAR_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 17 | KEY_CHAR_30_01 | Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 01 |
| 18 | UPDT_KEY_DATE_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 19 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 20 | UPDT_KEY_SIGN_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 21 | UPDT_KEY_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 22 | KEY_SIGN_NUM_28_0 | Signed Number(29,0) | DECIMAL(28) NOT NULL | Key 1 |
| 23 | UPDT_KEY_CURR_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 24 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 25 | FIELDVALUE_CHAR1 | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 26 | FIELDVALUE_CHAR2 | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 27 | FIELDVALUE_CHR_DD1 | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: DUMMY_PROMPT_VW |
| 28 | FIELDVALUE_CHR_DD2 | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: DUMMY_PROMPT_VW |
| 29 | FIELDVALUE_NUM1 | Signed Number(29,0) | DECIMAL(28) NOT NULL | Value |
| 30 | FIELDVALUE_NUM2 | Signed Number(29,0) | DECIMAL(28) NOT NULL | Value |
| 31 | FIELDVALUE_DT1 | Date(10) | DATE | Value |
| 32 | FIELDVALUE_DT2 | Date(10) | DATE | Value |
| 33 | FIELDVALUE_CHAR1P | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: %EDITTABLE |
| 34 | FIELDVALUE_CHAR2P | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: %EDITTABLE |
| 35 | FIELDVALUE_DT1P | Date(10) | DATE |
Value
Prompt Table: %EDITTABLE3 |
| 36 | FIELDVALUE_DT2P | Date(10) | DATE |
Value
Prompt Table: %EDITTABLE3 |
| 37 | FIELDVALUE_NUM1P | Signed Number(29,0) | DECIMAL(28) NOT NULL |
Value
Prompt Table: %EDITTABLE2 |
| 38 | FIELDVALUE_NUM2P | Signed Number(29,0) | DECIMAL(28) NOT NULL |
Value
Prompt Table: %EDITTABLE2 |
| 39 | FIELDVALUE_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Value |
| 40 | FIELDVALUE_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Value |
| 41 | SETID_FIELD | Character(18) | VARCHAR2(18) NOT NULL | SetID Field |
| 42 | RECNAME_SETID | Character(15) | VARCHAR2(15) NOT NULL | Set Id Record Name |
| 43 | UPPER_SW | Character(1) | VARCHAR2(1) NOT NULL | Upper Case |