SP_CMPSETID_VW3

(SQL View)
Index Back

competency by setid view


SELECT A.SETID , A.COMPETENCY , ' ' FROM PS_SP_COMPBY_SETID A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW
Set Control Field: SETID

2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

Prompt Table: SP_COMPBY_SETID
Set Control Field: SETID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description