| # |
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
Default Value: 1
|
| 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
Default Value: Y
|
| 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
Default Value: TRC2
|
| 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
Default Value: USR
|
| 11 |
QS_PROMPT_TBL |
Character(24) |
VARCHAR2(24) NOT NULL |
Validation table/view name
Prompt Table:
QS_PSRECDEFN_VW
|
| 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
|