{"id":95,"date":"2024-04-08T21:54:59","date_gmt":"2024-04-08T21:54:59","guid":{"rendered":"http:\/\/193.123.79.68\/?p=95"},"modified":"2024-04-09T09:49:11","modified_gmt":"2024-04-09T09:49:11","slug":"student-counseling-app-developed-in-oracle-apex","status":"publish","type":"post","link":"http:\/\/193.123.79.68\/?p=95","title":{"rendered":"Student Counseling App Developed in Oracle Apex"},"content":{"rendered":"\n<p><strong>University of Technology and Applied Sciences &#8211; Salalah<\/strong><\/p>\n\n\n\n<p>ARMS \u2013 Academic Record Management System v3.0<\/p>\n\n\n\n<p>ARMS Counseling Guidelines and Procedures<\/p>\n\n\n\n<p><strong>LOG-IN as an Advisor in ARMS Staff<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login in ARMS-Staff:\u00a0 <a href=\"https:\/\/apex.oracle.com\/pls\/apex\/f?p=arms-sll\">https:\/\/apex.oracle.com\/pls\/apex\/f?p=arms-sll<\/a> (also available in University website: http:\/\/www.sct.edu.om\/)<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/a-71V_r1c_oSq8TTrDhnwF75r1giqvvaXTz_9bOXgIcvfkbLGOgnU-wAQKITa0VmxqVfCQLb4oSjdS9IZ8gg3WBm-UOH1AEePIA_cFBqaVjhgTKonlTfrDxZzrJEHfZG9ff5mLx6eia_A1Qaryd_gA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>From the Navigation Menu: Go to Advisor<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/ZgWHSBG9Fl2sRNr2_ZcdCDnjezsazwUyb8k0a6tMHRUWKYdrNYF7A4xvcNjT5esKsznzs6AclrkBHgnLmhfyaFv4YV1g-tjWbHuq8q_zZAu9nVcbJCd02hf1jpnGUfkzZV_pdIaSuDPUXxAhRx2qYA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>From the Advisor page, click the advisee counselling button<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/3tli1fmWjMWdzhIyW_ERvmkE_J3-JJriZstlog4Oixh1FNJAiEkyZLVIDt-9gpLG9SkihK7VXpzYrPRp0HIzwjlrvkL0_TlOBwPjy1PLtIIBquKV0v7oyxWdPSHLw_lG4pGhbNxKkZGcYFMaaDBkHg\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>To create New Counselling, click the button<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/22DhPi_OFyRWb_HDOed4J2ZUHDHM1p1KzmYazJDZr3RjTnEP1FPu36aDDkDJrvYuyWUSqySImIXNasj60L_-TX2dB9HsCA31Rssqgf28xIolqS8UAtd_an7SrCAMa93WH6sp73lFo-giEeXDs7GIzQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>From the counselling detail page, select one of your advisee<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/kSFw2f_z6gSnQUpGpoeJqGJWbPkpcVdHCjMBG41Py5SM9bSVYV9KX_Rwk4IUgNVs-LnMhO-HbPy4Yfhd3J2N11qemjyyc69Ln7eF6RML-j-FJUlmw7kDD8xwseNeLua_CyNu6fDBAZ-q5G2wJEEb5g\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>Fill-up the counselling form and click create<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/M1se99GVKLsOy8cL5LQcjXm6OMSzDQfdnsH_tkZSOwJ5dA0Xc4gneZrQAVrofyBOf0w-9XJPaotbE0NlsQvPB88GSBNDXU5PFeioek07GVITLM9gJZFzzjMEUQG0_gaS_tl6R5ZK_UXN4WOboq3FNA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\">\n<li>Counseling is created shown in advisee counselling page. Click the pencil icon to proceed in counseling master detail page.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/c8NuWOK1noz7MA6JloaL2vBGf0dde7kaF7omun4InmwH2_BxDtf2CDC4i_3IaXVrJ_TiyWc-mQoiyXk2WXYsRycJhJxASQ5WwCZXrOOjV01L-p_1PoPFutGwuWKOHhFkmSzRlyIqnRArXsz8YFiWWw\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\">\n<li>From the counseling master detail form region, click add row then select the purpose\/type from the select list<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/RjECDmQIJLORqCDzC7hg8GCvhQFmbYQCv9_OQCioLE-oZlY2yqoNa-XzVm8xWizACpgrS0aX_isZywdg5w_CMsVuqlp-ka2sIIoGiz8Youpt7dzD81Iuc6QVdTd0-ZgQ9SjSJm5hys7D7lUpfQ2WzA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"9\">\n<li>Complete the detail discussions between the student and advisor, write the advisor recommendation, and by default the status is \u201cRefer to Advisor\u201d then click the save button.<\/li>\n<\/ol>\n\n\n\n<p>Note: Incase the student wanted to speak to HOD, advisor may refer to the select list status referrals otherwise \u201cCompleted\u201d then click save button and back to advising counseling page.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/J2SUXg_WuSWr8ieI29mSY1tIsGWKeyvM4dSJJLQsVz8BruKSBqsvazfGD9Jm9hkJEWLZEq5XFdPKQrzJTglIE5G0hieAynSmgs7pv0UUreOwp9T661GD9hcIS8Oach6sCMurk-hYyM_-IrFGRu26lQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"10\">\n<li>Search the student ID of the recent created counsel report.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/ojmqYBupKK4AkmBynfCoEa27AQJNZUJ6p9k-1KNW6XVlalClZVeTnGfOVdOhk2vXj_hvVeRSdrmVsLvPe9ASRMCsatuIJm7v69x6IbryUySClkrDXX7bGTmF16ZjDSNJzExhS87E6g6lS2nx3h1mGQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"11\">\n<li>From the Advisee counseling page will show the detail report created and the status (assuming it was referring to HOD). Advisor can send the email to his advisor by clicking the action button of counselling report and select Download.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/8BlfCZzpMU3xZ9U8aFhNbL5HjlAsmIqPABQaH7lw92D_kpvVkD76NIu3jD8eSWarFgAQ5PzgzFJ1iXZ_4jjjx9ea6uC1tKm4XIZBeqSNvcPvOwLdRyk8BjE3bs2-8i1NI0nrCM__hqFaS757PpiOWw\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"12\">\n<li>Send the report to your advisor and complete all email credentials \/details\/attachments shown below then click send:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/53ej3si7aDyV9xjs7yFasnM4VXigI8t-4E5vwsgUTuSBO3icQ0wOqlc8muScJ-q_7Aj-qc0KwIuhjkAc9GevA1Mhk18QL-lKieiiL5B-rjbnQzrKI3GnIGuA9rQhZW5rJqh0wE3Qaa59K8nqmjPbMQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"13\">\n<li>An e-mail Notification will be receiving by the recipients.<\/li>\n<\/ol>\n\n\n\n<p><strong>LOG-IN as a Student in ARMS Student<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login in ARMS-Student:\u00a0 https:\/\/apex.oracle.com\/pls\/apex\/f?p= UTAS-SALALAH-SARS\u00a0<\/li>\n<\/ol>\n\n\n\n<p>(also available in University website: http:\/\/www.sct.edu.om\/)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/op_nyqfdMe9ZivGxazWysbcSO6LPTyRy1oUYThbVBdlSQmQnxhTeB5k--QlEuooCrsHfDHxQd6D869RRRiLR9nsVCUE1VL3c5cPJAcz8A833hBFMSk92lhN7kM4oRh7Tnj59WRip8BusntECrwFCVQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>From the Navigation menu, click the counseling<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/nInTQv1dIz34Qcv16H-NyFNc8paq9pFULERqkobYzI_7pZ_7HBXhx1XQsL1HWHb2plj2uXwcZ8oPhjLmwwVit2MIbINtCSHvB8RvmbYDAWzs9PTw6hCEQTr-KmSkENy6r8lWdXu8f-3jwL8pVvdzTg\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Counseling Report page shown in table format. Click the pencil icon to open the advisor report form master details created by his\/her advisor including the status. Student may submit a rating an optional rating the click apply changes.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/uWRF6Vlzz2IeURBmdGdN0RQbzlTX8KkfRgS0uFswQYaStWj6kh2NjniDGtjaZo0HpOtodGhQlrCg0NHdsWOfDN4orjXq6QcLjkDgeldE9c0eVXAB9yCaHK-FQCaUF5c_Uaf-UT25y_JzljB25Q8zYw\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>LOG-IN as a HOS\/HOD\/Councilor\/Registrar\/ADAA\/Dean in ARMS Analytics<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login in ARMS-Analytics:\u00a0 https:\/\/apex.oracle.com\/pls\/apex\/f?p= a-r-m-s<\/li>\n<\/ol>\n\n\n\n<p>(also available in University website: http:\/\/www.sct.edu.om\/)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/T0JWB0Rig04AFm9-YV8NzebtL7WD0nPGMqHVvOMx306JOy9vxd_Ivv-WELTAE9aKcyOuc2B1FDL0TsFAJvkKrDFpyy8A7c-Fn3jPodMPRZl9mMyPY2nQJHKX6wxiAKVX1fL_Cq0dsI4hw0p-e9mAjg\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Assuming login as HOD<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/5-hSV-wv8DHb2xBxn-adamebHfvp3P_n8xXLzcIv7thncw38QMx2kmV91ffPsqtBVzfTYSO4WI7hruafh6KKWRT9ZZbVaLWmFgpNVopqDnqJ1PPmqyf4QUfwt1Qw7G_DkickUo_zZZnDKmbG0pZgKg\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Home page of Advisor Report shown once it is successfully logged-in then click the referrals from the navigation menu.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/29Z_PinJs4Y-iE61i4xf3Ttpq5oilMBhhI_C0-WFe0eLOufUK6wTw06QpSMYXnRbDG1zbTTBmjQ8OpgnVqK2MlzdwBNiZ3dZ3MOHjfhgckfOfr8lk8JxKGKXg1pGv0uXJm4s-5GN4-asKgTRfJWyNQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Student List referrals to HOD page shown then click one student to show the detail counseling report refer to him\/her.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/qYXkvbhOWxy3t7cSyGqHxqZdBNXn9z76QSxL4-LT6Oz_x0-5LctCVvLrnn0Q4xmPSPgEK5W9wDxozY5tKOI0sMQRvwhBrCd23abgxSqF4opeApLJRoBQmigBDXv_jWM50SAX8QdgnmHWhj3k5PX4Ow\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>Student Council Detail form page shown:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/eVBNtxMsriyT88M8eqMS5yeMLAncbbXcud3UZXr72oF4EUyXAL95m-s1nv8pA1_ZT9TARDN7KWKpQKINYZAKzF_7DRYBn0TGn-22Y4oy7k3Hqv_AuG9Y7fOC7tnh9c0-xkwCNGwNxrXoAm1YrOa0KA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>Update the form by entering comments\/status then apply changes.\u00a0<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/lax_Ob08Jv0z_GfYRput5yypLLYZvhkR_ZYeLeYV6SHjgJR79OYmTLSAJ7TGpKtntUZenmxJnegbPH-STq6c1_TNrkFC-JOyHO0HnrMTEbnddUim2g3ZJ0j-csWSkwGa_kduKoQLty9bgFUAgjTNcA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\">\n<li>Otherwise update status referral such revert back to advisor or Completed, or referral to ADAA.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/LK51AOUX1cA0-xBG14ccQZuPEI-n9P_6m37gpXOi2X--3TTRxBVw7NF53K9_niap9BxKAKfBoJwfW70bRG4onhhTJ6knreP7Nczvr3ocDfXbXd3Js819VhVFW_XxJbjsQQNj1owzOfxrFdFtZWAEMw\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\">\n<li>Supposed it was referring to ADAA, an email need to be created from the action button and to be send to the recipient.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/qXxlisp9H49rFDGPl5dVIQCuTnof0p6DLp-Ue9IJ-ScmqsyU2YNNigKWurHNaOjt9TqA5Q_KdmxH9lwHSu5p0EjsCl8MRaE2Kny6QRav46wqeVSEe7xDLhqp1bsM7LcEj9-6ifd_oykZUKwmbUOhPQ\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"9\">\n<li>To check the referral Report, click on the reports from the navigation menu. Referral report page shows the statistics and detail student counseling transaction from the button region.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/pvSaURkk9ElBtUoGW4TrpMwJJTGMi5i_dgim01UI0EkU9pVMh-K4W0iXwI_7RAbP8OBPu3eF0YqRwe9SBfiIb8vvQKnIrhPiohjXgHGhjdrSwWfX_zwPQKBeOhnY62_jDaH0ac3OMpzpYlV_DP6p0A\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"10\">\n<li>Downloading the report from the action button<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/4koYI55ZmzRqKjHS0qiaWVi6QaTKmyhncWfKz3Necogl9Ol3LQaPt6R8_NoP1dLSpPtQatFPnUyxdZDUBMvpyRWFaWbzCqcF9oYMxfC0VCFdh6X2DBuebzFCN60QgpcQ_M6Px07VhZyZjgAvsJ8giw\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"11\">\n<li>Select the format to download<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/uWR6AVpuhhpG6jdaJ58472Wfrd8BZLT0dmxhW_z8x-XFHJfxHQx84cMI1f8SeUC3oBUdNO5zaTwy_2HWqjUFttT_jy-bYp2fX9fdqjCEhpHFjjGEADAwNl2BhB9RAjOuF82NE-UI_MFV5jDcwok-SA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"12\">\n<li>Sample downloaded counsel report in MS Excel format<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/4Uu__Q01Rafi2C9kRiaxc-fDAEDzbaBmNYKPev4KzmHLWnk4pom5eO6E5_iuZudFt7BqiUYIcNTWoUXWebJWQbbx5zzfldnoyzt21jHPr3zBVHqCcfA5YVINofxXBSKPW3JcsMUvAfXif8ORRXi66Q\" alt=\"\"\/><\/figure>\n\n\n\n<p>Drafted By: Hansel Delos Santos<\/p>\n\n\n\n<p>ARMS Developer<\/p>\n\n\n\n<p>April 1,2021<\/p>\n","protected":false},"excerpt":{"rendered":"<p>University of Technology and Applied Sciences &#8211; Salalah ARMS \u2013 Academic Record Management System v3.0 ARMS Counseling Guidelines and Procedures LOG-IN as an Advisor in ARMS Staff Note: Incase the student wanted to speak to HOD, advisor may refer to the select list status referrals otherwise \u201cCompleted\u201d then click save button and back to advising [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,11],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-oracle-apex","category-software-dev"],"_links":{"self":[{"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/193.123.79.68\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":1,"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":96,"href":"http:\/\/193.123.79.68\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions\/96"}],"wp:attachment":[{"href":"http:\/\/193.123.79.68\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/193.123.79.68\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/193.123.79.68\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}