QAS_RECORD_DEFN_REST_GET
Use this service operation to return the definition of a given record, including field descriptions and key information.
Request Message: QAS_RECORD_DEFN_TEMPL
| Element Name | Description |
|---|---|
|
RECORD_NAME Required element |
Complete record name. Required. |
Example Request:
This request will return the record definition for PSMSGCATDEFN.
https://<servername>:<port>/PSIGW/RESTListeningConnector/<default
local node>/RecordDefn.v1/PSMSGCATDEFN
Response Message: QAS_RECORD_DEFN_RESP_MSG
| Element Name | Description |
|---|---|
|
RECORD_NAME |
Record name. |
|
FIELD_NAME |
Field name. |
|
FIELD_DESCRIPTION |
Field description. |
|
KEY |
Indicates whether this field is a key; value will be Yes or No. |
|
FIELD_TYPE |
Field type. |
|
FIELD_LENGTH |
Field length. |
|
FIELD_LOOKUP_TABLE |
Prompt table name, if applicable. |
|
FIELD_EDIT_TYPE |
Field edit type is a 32-bit binary number. Counting from 1 from the right, a 1 in bit 10 indicates translate values, a 1 in bit 14 indicates a yes/no table, and a 1 in bit 15 indicates a prompt table. Client applications need to do bit-wise AND on this value. For example, the value 2337 represents:
See PeopleCode API Reference: Flag property: QueryDBRecordField class. |
|
FIELD_SHORT_NAME |
Short name. |
|
FIELD_LONG_NAME |
Long name. |
|
INFORMATION_MESSAGE |
Returns information about the request. For example if the criterion in the request is incorrect or if no records meet the criteria, a message indicating the error is returned. |
Example Response:
<?xml version="1.0"?>
<qcs:QAS_RECORD_DEFN_RESP_MSG xmlns:qcs="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_RECORD_DEFN_RESP_MSG.VERSION_1">
<RECORD_NAME>PSMSGCATDEFN</RECORD_NAME>
<FIELD>
<FIELD_NAME>MESSAGE_SET_NBR</FIELD_NAME>
<FIELD_DESCRIPTION>Message Set Number</FIELD_DESCRIPTION>
<KEY>Yes</KEY>
<FIELD_TYPE>Number</FIELD_TYPE>
<FIELD_LENGTH>5</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>2337</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Set</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Message Set Number</FIELD_LONG_NAME>
</FIELD>
<FIELD>
<FIELD_NAME>MESSAGE_NBR</FIELD_NAME>
<FIELD_DESCRIPTION>Message Number</FIELD_DESCRIPTION>
<KEY>Yes</KEY>
<FIELD_TYPE>Number</FIELD_TYPE>
<FIELD_LENGTH>5</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>2337</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Msg</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Message Number</FIELD_LONG_NAME>
</FIELD>
<FIELD>
<FIELD_NAME>MESSAGE_TEXT</FIELD_NAME>
<FIELD_DESCRIPTION>Message Text</FIELD_DESCRIPTION>
<KEY>No</KEY>
<FIELD_TYPE>Character</FIELD_TYPE>
<FIELD_LENGTH>100</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>33554720</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Message</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Message Text</FIELD_LONG_NAME>
</FIELD>
<FIELD>
<FIELD_NAME>MSG_SEVERITY</FIELD_NAME>
<FIELD_DESCRIPTION>Message Severity</FIELD_DESCRIPTION>
<KEY>No</KEY>
<FIELD_TYPE>Character</FIELD_TYPE>
<FIELD_LENGTH>1</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>768</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Severity</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Message Severity</FIELD_LONG_NAME>
</FIELD>
<FIELD>
<FIELD_NAME>LAST_UPDATE_DTTM</FIELD_NAME>
<FIELD_DESCRIPTION>Last Update Timestamp</FIELD_DESCRIPTION>
<KEY>No</KEY>
<FIELD_TYPE>Datetime</FIELD_TYPE>
<FIELD_LENGTH>26</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>33024</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Last Updt</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Last Update Timestamp</FIELD_LONG_NAME>
</FIELD>
<FIELD>
<FIELD_NAME>DESCRLONG</FIELD_NAME>
<FIELD_DESCRIPTION>Description</FIELD_DESCRIPTION>
<KEY>No</KEY>
<FIELD_TYPE>Long Character</FIELD_TYPE>
<FIELD_LENGTH>0</FIELD_LENGTH>
<FIELD_LOOKUP_TABLE/>
<FIELD_EDIT_TYPE>33554432</FIELD_EDIT_TYPE>
<FIELD_SHORT_NAME>Descr</FIELD_SHORT_NAME>
<FIELD_LONG_NAME>Description</FIELD_LONG_NAME>
</FIELD>
</qcs:QAS_RECORD_DEFN_RESP_MSG>