USP_DATALIST_JOBTRAIT

This datalist returns all traits for a job.

Parameters

Parameter	Parameter Type	Mode	Description
@JOBID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@TRAITTYPE	tinyint	IN	Type

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_JOBTRAIT (@JOBID uniqueidentifier, @TRAITTYPE tinyint = null)
            as
                set nocount on;

                select 
                        ID,
                        TRAITTYPEID,
                        TRAITTYPE,
                        coalesce(ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL),
                        SKILLLEVEL,
                        ISREQUIRED
                from dbo.UFN_JOB_TRAITS(@JOBID)
                where TRAITTYPEID = coalesce(@TRAITTYPE, TRAITTYPEID)
                order by TRAITTYPE, ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL;