XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XOrgHrDesc 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 |
hier_value |
number10 |
1 |
1 |
The identifier of the
hierarchy value. This value must be unique among
other values of the same hierarchy level. It cannot
be modified. |
chain, area, region, district |
chain, area, region, district |
null |
null |
Yes |
The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level. It cannot be modified. |
hier_desc |
varchar2120 |
1 |
1 |
The description of the
hierarchy value. |
chain, area, region, district |
chain_name, area_name, region_name, district_name |
null |
null |
Yes |
The description of the hierarchy value. |
hier_level |
varchar22 |
1 |
1 |
Value is restricted by
message type. The value will indicate either CH
(chain), AR (area), RE (region), or DI (district).
|
n/a |
n/a |
null |
null |
Yes |
Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district). |
parent_id |
number10 |
0 |
1 |
The identifier of the
hierarchy value's parent hierarchy value. This
value must be predefined on either the CHAIN, AREA
or REGION table. |
chain, area, region |
chain, area, region |
null |
CHAIN, AREA, REGION. |
No |
The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on one of these tables |
mgr_name |
varchar2120 |
0 |
1 |
The manager name of the
hierarchy value. |
chain, area, region, district |
mgr_name |
null |
null |
No |
The manager name of the hierarchy value. |
currency_code |
varchar23 |
0 |
1 |
The code which identifies the
currency under which the hierarchy value operates.
This value must be predefined on the CURRENCIES
table. |
chain, area, region, district |
currency_code |
null |
null |
No |
The code that identifies the currency under which the hierarchy value operates. This value must be predefined in the CURRENCIES table. |
XOrgHrLocTrt:XOrgHrLocTrt
|
*
|
0
|
unbounded
|
It's a referenced element.
For detailed description, please refer referenced
element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|