PTUS_CNTX_TYPEH=Home Page
N=Portal Node
W=Work Center
PTUS_CNTX_KEY1Prompt Table: PTUS_CNTX_VW
PTSF_SRCCAT_NAMEPrompt Table: PTUS_GROUPS_VW
N=No
Y=Yes
Y/N Table Edit
Default Value: N
PSPTUS_CTX_DET(SQL Table) |
Index Back |
|---|---|
Search Context |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTUS_CNTX_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Context Type
H=Home Page N=Portal Node W=Work Center |
| 2 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | PTUS_CNTX_KEY1 |
Character(65) | VARCHAR2(65) NOT NULL |
Node Name\Workcenter ID
Prompt Table: PTUS_CNTX_VW |
| 4 | PTSF_SRCCAT_NAME |
Character(65) | VARCHAR2(65) NOT NULL |
Search Category Name (see PSPTSF_SRCCAT).
Prompt Table: PTUS_GROUPS_VW |
| 5 | IS_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Default Template
N=No Y=Yes Y/N Table Edit Default Value: N |