...
a. KRAD Design: A simple KRAD maintenance document will be used to create and update a new or search an existing Location record.
...
b. Permissions to do the following on the below entities:
Location Level
a) Create
b) Edit
c) View(Inquiry)
Location
a) Create
b) Edit
c) View(Inquiry)
Upload Locations
a) Create/Update
7. Services
8. Data Model
...
Tables involved as per the requirement given in LocationhandlinginOLE.pdf and JIRA No. OLE-2558 OLE_LOCN_LEVEL_T and OLE_LOCN_T
OLE_LOCN_LEVEL_T:
- LEVEL_ID – varchar2(40)(Primary key)
- OBJ_ID – varchar2(Not Null)
- VER_NBR – Number(8)(Not Null)
- LEVEL_CD – varchar2(40)(Unique & Not Null)
- LEVEL_NAME – varchar2(100)(Not Null)
- PARENT_LEVEL – varchar2(40) (Nullable) - References OLE_LOCN_LEVEL_T.LEVEL_ID. Varchar2(40)
OLE_LOCN_T:
...
:The DM for Patron is going to reside in the Rice2.x Schema
