QS_TRC_FLDS8_VW(SQL View) |
Index Back |
|---|---|
Trace Set Children view12/28/00 RRE Set Control field to Business Unit and updated description of view for cleanup purposes |
| select a.setid, a.qs_app_context, a.qs_traceset_id, a.qs_tracefld_id, a.qs_seq, a.qs_field_comp_name, a.qs_active, a.cat_id, a.qs_tracfld_usecode, a.qs_field_entry_opt, a.qs_prompt_tbl, a.qs_field_source, a.qs_field_format from PS_QS_TRACE_FLDS8 a where a.qs_active='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | QS_APP_CONTEXT | Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 3 | QS_TRACESET_ID | Number(5,0) | INTEGER NOT NULL | Trace Set ID |
| 4 | QS_TRACEFLD_ID | Number(5,0) | INTEGER NOT NULL | TraceSet Field ID |
| 5 | QS_SEQ | Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 6 | QS_FIELD_COMP_NAME | Character(18) | VARCHAR2(18) NOT NULL | QC application structure field component |
| 7 | QS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive X=Do not use in Search Y=Active |
| 8 | CAT_ID | Number(3,0) | SMALLINT NOT NULL | ID of catalog field |
| 9 | QS_TRACFLD_USECODE | Character(4) | VARCHAR2(4) NOT NULL |
QC Field useage code
TRC1=Individual TRC2=Subgroup |
| 10 | QS_FIELD_ENTRY_OPT | Character(4) | VARCHAR2(4) NOT NULL |
Field input options
DFLT=Auto Dflt FIXD=Fixed FIXN=Fixed/Hide USR=User Input |
| 11 | QS_PROMPT_TBL | Character(24) | VARCHAR2(24) NOT NULL | Validation table/view name |
| 12 | QS_FIELD_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Field entry source - table or global variable name that contains values for input.
disable %time as this option causes SQL errors.
DT=%Date DTTM=%Datetime OPID=%OperatorId TM=%Time TR01=&G_TRACE_01 TR02=&G_TRACE_02 TR03=&G_TRACE_03 TR04=&G_TRACE_04 TR05=&G_TRACE_05 TR06=&G_TRACE_06 TR07=&G_TRACE_07 TR08=&G_TRACE_08 TR09=&G_TRACE_09 TR10=&G_TRACE_10 TR11=&G_TRACE_11 TR12=&G_TRACE_12 XTRN=External |
| 13 | QS_FIELD_FORMAT | Character(24) | VARCHAR2(24) NOT NULL | Custom field format name |