HRS_JCP_FLD_VW

(SQL View)
 Index Back

Job Creation Process Fields

Job Creation Process Field Configuration table.

SELECT B.HRS_JCP_ID , B.HRS_ROLE_TYPE , B.HRS_JO_SECTION , B.HRS_JCP_JOFLD_ORDR , B.RECNAME , 'HRS_ADDEMPQSTN_LNK' , 'N' FROM PS_HRS_JCP_FLD_CFG B WHERE B.FIELDNAME = 'HRS_ADD_QSTN_LINK' AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_JCP_FLD_CFG C WHERE B.HRS_JCP_ID = C.HRS_JCP_ID AND B.HRS_JO_SECTION = C.HRS_JO_SECTION AND B.HRS_ROLE_TYPE = C.HRS_ROLE_TYPE AND B.RECNAME = C.RECNAME AND C.FIELDNAME = 'HRS_ADDEMPQSTN_LNK')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JCP_ID Number(15,0) DECIMAL(15) NOT NULL Job Creation Process ID used by Recruiting Solutions
2 HRS_ROLE_TYPE Character(2) VARCHAR2(2) NOT NULL Recruiting Role Types
00=Recruitment Administrator
01=Recruiter
02=Recruiting User
03=Hiring Manager
04=Federal Recruiter
05=RS Approval Administrator
06=RS Technical Administrator
3 HRS_JO_SECTION Character(4) VARCHAR2(4) NOT NULL Field for Job Opening Sections
1=1. Job Opening Information
2=2. Profile Combination
3=3. Additional Job Details
4=4. Additional Profile Details
5=5. Assignments
6=6. Job Postings
4 HRS_JCP_JOFLD_ORDR Number(5,0) INTEGER NOT NULL Order of the fields on Job Opening Page
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 HRS_VISIBLE_FLAG Character(1) VARCHAR2(1) NOT NULL Field visibility flag for Flex Processes

Y/N Table Edit