QS_EN_TASKS_VW

(SQL View)
Index Back

Prompt table for TASKS

Default in Field Catalog for TaskCode field, then used in Quality Control Plan as prompt table (unless user overrides default in Quality Function)

SELECT BUSINESS_UNIT , TASK_CODE , DESCR , DESCRSHORT FROM PS_EN_TASKS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 TASK_CODE Character(6) VARCHAR2(6) NOT NULL Task Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description