TL_MSS_SRCH_OPT(SQL Table) |
Index Back |
|---|---|
T&L MSS Search OptionsMSS Search Options by Operator ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | AUTOPOP_TL | Character(1) | VARCHAR2(1) NOT NULL |
Loading of Matching Employees
N=Prompt for Results Y=Auto Populate Results Default Value: TL_INSTALLATION.AUTOPOP_TL |
| 3 | COLLAPSE_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
Default Criteria Presentation
N=Show Criteria List Expanded Y=Show Criteria List Collapsed Default Value: TL_INSTALLATION.COLLAPSE_CRITERIA |
| 4 | TL_SCHED_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Show Schedule Information
Y/N Table Edit Default Value: Y |
| 5 | TL_DSH_DFLT_PERIOD | Character(12) | VARCHAR2(12) NOT NULL |
Time Period ID
Default Value: PSWEEK Prompt Table: TL_TR_PRDS_VW |