View – WQX.PROJECT

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Views >

View – WQX.PROJECT

View Name: WQX.PROJECT

 

View Type: WQX

 

Description: WQX.PROJECT returns details about the WQX project.

 

Language: English

 

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

PROJECTID = DT_TASK.TASK_CODE

PROJECTNAME = DT_TASK.TASK_DESC

PROJECTDESC = DT_TASK.REMARK

SAMPLINGDESIGNTYPECODE = DT_TASK.TASK_TYPE

QAPPAPPROVEDIND = DT_TASK.QAPP_APPROVAL_YN

QAPPAPPROVALAGENCYNAME = DT_TASK.QAPP_APPROVAL_AGENCY

 

Tables: DT_FACILITY, DT_TASK  

 

Database Type: SQL

 

Database Schema: WQX Schema

 

Database Version: EQuIS 7.0+

 

Data Requirements: Data must be present in the DT_TASK table to be generated in WQX.PROJECT.

 

Output Type: Grid