IT_SEARCH_01(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEARCH_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Name |
| 2 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: IT_CS_RECDEFN |
| 4 | RECALIAS | Character(15) | VARCHAR2(15) NOT NULL | Record Alias |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
| 6 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table: IT_SRCH_LBL |
| 7 | 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 |
| 8 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table: IT_PSRECDEFN |
| 9 | UPDT_SETID_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 10 | UPDT_BUS_UNIT_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 11 | UPDT_KEY_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 12 | UPDT_KEY_CURR_FROM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 13 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Template Status
A=Active I=Inactive Default Value: A |
| 14 | SETID_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
SetID Field
Prompt Table: PSRECFIELDALL |
| 15 | RECNAME_SETID | Character(15) | VARCHAR2(15) NOT NULL |
Set Id Record Name
Prompt Table: IT_CNTRL_REC_VW |