Sample Scenario general lookup/validation tables

SR_AREA general lookup/validation table

Some organizations classify issues as product-related, services-related, or other.  In this scenario, the SR_AREA general lookup/validation table contains the following issue relation codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• OTHER (Other)
• PRODUCTS (Products)
• SERVICES (Services)

SR_CAT general lookup/validation table

Some organizations classify issues according to category.  In this scenario, the SR_CAT general lookup/validation table contains the following category codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• BILLING (Billing)
• INCORRECT (Incorrect)
• MISSING (Missing)
• NONCURRENT (Noncurrent)
• NONWORKING (Not working)
• OTHER (Other)

SR_DEVSTATUS general lookup/validation table

Some organizations use issue resolution codes that require manager approval.  In this scenario, the SR_DEVSTATUS general lookup/validation table contains the following issue resolution codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• APPROVE (Approved)
• DECLINE (Declined)
• PENDING (Pending approval)

SR_ENVIRON general lookup/validation table

Some organizations classify issues by the member type of the person reporting the issue.  In this scenario, the SR_ENVIRON general lookup/validation table contains the following member type codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• ASSOCIATE (Associate)
• FAMILY (Family)
• FULL (Full)
• NONMEMBER (Nonmember)
• SENIOR (Senior)

SR_RECORDEDBY general lookup/validation table

Some organizations have several methods by which they are notified of issues.  In this scenario, the SR_RECORDEDBY general lookup/validation table contains the following issue notification method codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• E-MAIL (E-mail)
• FAX (Fax)
• LETTER (Letter)
• OTHER (Other)
• PHONE (Phone)
• WEB (Web)

SR_RES general lookup/validation table

Some organizations specify the current resolution status of issues. In this scenario, the SR_RES general lookup/validation table contains the following issue resolution status codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• CLOSED (Closed)
• CONFIRM (Confirm)
• INPROG (In progress)
• OPEN (Open)

SR_SRVTYPE general lookup/validation table

Some organizations provide several types of services. In this scenario, the SR_SRVTYPE general lookup/validation table contains the following service type codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• MEMBERSHIP (Membership)
• PUBS (Publications)
• SOFTWARE (Software)
• TOURS (Tours)
• VIDEOS (Videos)

SR_SYS general lookup/validation table

Some organizations manage issues by their relation to products and services.  In this scenario, the SR_SYS general lookup/validation table contains the following product and service codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• BOOKS (Books)
• CARDS (Cards)
• DVD (DVD video)
• MAGAZINES (Magazines)
• MEMBERSHIP (Membership)
• OTHER (Other)
• SERVICES (Services)
• SOFTWARE (Software)
• TOURS (Tours)
• VHS (VHS video)

SR_VERSION general lookup/validation table

Some organizations resolve issues within specific departments. In this scenario, the SR_VERSION general lookup/validation table contains the following department codes.

📘

Note

The code is listed first, followed by the description in parentheses.

• MEMBERSHIP (Membership)
• SALES (Sales)
• TOURS (Tours)
• VOLUNTEER (Volunteer Services)