SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
INSTRUMENT_TYPEPrompt Table: INSTR_INST_H_VW
INSTR_INST_SRCH(SQL View) |
Index Back |
|---|---|
Instrument Header ViewView to retrieve Instrument Header fields (INSTRMNT_TEMPLATE=' ') |
| SELECT setid ,instrument_type ,instrmnt_template ,descr60 ,notes_1000 FROM PS_INSTR_HEADER_TR WHERE instrmnt_template = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | INSTRUMENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table: INSTR_INST_H_VW |
| 3 | INSTRMNT_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier associated with an instrument that describes a separate template version of a pre |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | NOTES_1000 | Long Character(1000) | VARCHAR2(1000) | Represents a field that allows free form text on the instrument definition panels. |