HRS_HIRE_CMP

(SQL View)
Index Back

Hire - Competencies

Hire Integration - Competencies

SELECT B.EMPLID ,C.REVIEW_DT ,A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.EVALUATION_ID ,A.COMPETENCY ,A.DT_ISSUED ,A.YR_ACQUIRED ,A.YR_LAST_USED ,A.HOW_VERIFIED ,A.PROFICIENCY ,A.INTEREST_LEVEL ,A.YEARS_OF_EXP ,B.HRS_HIRE_SEQ FROM PS_HRS_APP_CMP A , PS_HRS_APP_CM_EVAL C ,PS_HRS_HIRE B WHERE A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ AND A.EVALUATION_ID = C.EVALUATION_ID AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND A.COMPETENCY <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
4 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
5 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID
6 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
7 DT_ISSUED Date(10) DATE Issue Date
8 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
9 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
10 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
11 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
12 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level
13 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
14 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID