SQL-010: Task priority code list¶
Reads the full priority-code lookup list.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-010 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsTaskPriorityCodeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
No parameters. This statement does not accept bind input.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| TASK_PRIORITY_CODE | SELECT | CODE, CODE_DESCR |
Sample SQL¶
SELECT TASK_PRIORITY_CODE.CODE AS Code
, TASK_PRIORITY_CODE.CODE_DESCR AS CodeDescr
FROM TASK_PRIORITY_CODE
ORDER BY CODE_DESCR
Operations and processes¶
Note: Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Tasks\clsTaskPriorityCodeCollection.vb