UPG_QS_80TR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TR_ID	Number(3,0)	SMALLINT NOT NULL	Trace Set
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	QS_APP_CONTEXT	Character(18)	VARCHAR2(18) NOT NULL	QC application context identifier
6	QS_TRACESET_ID	Number(5,0)	INTEGER NOT NULL	Trace Set ID
7	QS_TRACESET_NAME	Character(24)	VARCHAR2(24) NOT NULL	Trace Set Name
8	QS_TRACEFLD_ID	Number(5,0)	INTEGER NOT NULL	TraceSet Field ID
9	QS_SEQ	Number(5,0)	INTEGER NOT NULL	Generic sequence number
10	QS_FIELD_COMP_NAME	Character(18)	VARCHAR2(18) NOT NULL	QC application structure field component
11	QS_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Active Switch N=Inactive X=Do not use in Search Y=Active
12	CAT_ID	Number(3,0)	SMALLINT NOT NULL	ID of catalog field
13	QS_TRACFLD_USECODE	Character(4)	VARCHAR2(4) NOT NULL	QC Field useage code TRC1=Individual TRC2=Subgroup
14	QS_FIELD_ENTRY_OPT	Character(4)	VARCHAR2(4) NOT NULL	Field input options DFLT=Auto Dflt FIXD=Fixed FIXN=Fixed/Hide USR=User Input
15	QS_PROMPT_TBL	Character(24)	VARCHAR2(24) NOT NULL	Validation table/view name
16	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
17	QS_FIELD_FORMAT	Character(24)	VARCHAR2(24) NOT NULL	Custom field format name