XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for CodeDtlDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
code_type |
varchar24 |
1 |
1 |
This field will contain a valid code type for the row. the valid code types are defined on the CODE_HEAD table. |
string |
code_detail |
xs |
Fill column length. |
code_type |
This field contains a valid code type for the row. Valid code types are defined in the CODE_HEAD table. |
code |
varchar26 |
1 |
1 |
This field contains the code used in Retek which must be decoded for display in the on-line forms. |
string |
code_detail |
xs |
Fill column length. |
code |
This field contains the code that must be decoded for display on on-line forms. |
code_desc |
varchar2250 |
1 |
1 |
This field contains the description associated with the code and the code type. |
string |
code_detail |
xs |
Fill column length. |
code_desc |
This field contains the description associated with the code and the code type. |
required_ind |
varchar21 |
1 |
1 |
This field indicates whether or not the code is required. If the code is specified as required, then the user will not be able to delete the rows in the table for that code. |
string |
code_detail |
xs |
Fill column length. |
required_ind |
This field indicates whether the code is required. If the code is required, the user cannot delete rows from the table for that code. |
code_seq |
number4 |
1 |
1 |
This is a number used to order the elements so that they appear consistently when using them to populate a list. |
string |
code_detail |
xs |
Fill column length. |
code_seq |
The number used to sort the elements so that they appear consistently when using them to populate a list. |