PTS_SRCH_DEF_L(SQL Table) |
Index Back |
---|---|
Search Configuration TableSearch Configuration Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
2 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
3 | PTS_SEARCH_ID | Character(65) | VARCHAR2(65) NOT NULL | Search ID |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | PTS_SRCH_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Search Page Heading |
7 | PTS_SRCH_PG_INSTR | Long Character | CLOB | Page Instructions |
8 | PTS_ADD_PG_LBL | Character(100) | VARCHAR2(100) NOT NULL | Add Page Heading |
9 | PTS_ADD_PG_INSTR | Long Character | CLOB | Add Page Instructions |