Back to Home

Codelist Setup

Table of Contents

• Overview
• Stored Procedure
• Tables

Overview

1. Add, delete, or change status of Categories.
2. Add, delete, or change status of Titles.
3. View active, inactive, or deleted categories
4. Codelist Setup allows users to view table smart.p11_codelist and manipulate data in it.

What is a Code list table

it's a reference table that categorizes / groups sets of data together. This allows data to be used dynamically.

Stored Procedure

1. smart.p10_List_LookupCode
2. smart.p10_Update_Codelist
3. smart.p10_Read_UserNo

Tables

1. smart.p10_CodeList