HRS_MNG_HIR_COM

(SQL View)
 Index Back

Manage hire stp filter

This view filters HRS_MNG_HIR_STP table on Competency data type

SELECT HRS_HIRE_DAT_TYP ,HRS_HIRE_TYPE ,HRS_SUBCATG ,HRS_PUPL_ENBLD FROM PS_HRS_MNG_HIR_STP WHERE HRS_HIRE_DAT_TYP = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_HIRE_DAT_TYP Character(1) VARCHAR2(1) NOT NULL Hire Data Type
C=Competencies
O=Other
P=Person
2 HRS_HIRE_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Hire
H=Hire
J=Add Concurrent Job
R=Rehire
T=Transfer
W=Add Contingent Worker
3 HRS_SUBCATG Character(2) VARCHAR2(2) NOT NULL Hire Data Type Subcatagory
1=Person
11=Eligibility/Identity
12=Honors and Awards
13=Identification Data
14=Languages
15=Licenses & Certificates
16=Memberships
17=Prior Work Experience
18=Test Results
19=National ID
2=Addresses
20=Accomodation
21=Diversity
22=School Education
23=Training
24=Contract Data
25=Professional Education
26=Person Names
3=Email Addresses
4=Phones
5=Competencies
6=Appl/Person Assignment Chklist
7=Applicant/Employment Contracts
8=Bank Accounts
9=Disabilities
4 HRS_PUPL_ENBLD Character(1) VARCHAR2(1) NOT NULL Value Enabled (Y/N)
N=No
Y=Yes