RS_WRKSPCTP_VW1

(SQL View)
Index Back

SELECT A.EMPLID , A.RS_WRKR_SPEC , A.RS_WRKR_SPEC_TYPE , B.DESCR , ' ' , 0 , ' ' , ' ' , ' ' , 0 , 0 FROM %Table(RS_WRKR_SPECS) A , %Table(RS_TYPE_TBL) B WHERE A.RS_WRKR_SPEC = B.RS_TYPE AND A.RS_WRKR_SPEC_TYPE = 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 RS_WRKR_SPEC Character(8) VARCHAR2(8) NOT NULL Worker Specialty

Prompt Table: %EDITTABLE

3 RS_WRKR_SPEC_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Specialty
C=Competency
T=Category
4 RS_COMPETENCY_DESC Character(30) VARCHAR2(30) NOT NULL Competency
5 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID
6 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
7 HOW_VERIFIED Character(1) VARCHAR2(1) NOT NULL Verified By
E=Employee Claim
J=On the Job Training
N=Not Verified
O=Employer Observation
T=By Test
V=NVQ Authority
8 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

Prompt Table: REVW_RATING_VW

9 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level

Prompt Table: INT_RATING_VW

10 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
11 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired