HRS_RATE_SCR_VW

(SQL View)
Index Back

SELECT A.HRS_JOB_OPENING_ID ,A.JOBCODE ,A.HRS_JO_SCR_SUMM_ID ,B.HRS_JO_SCR_SEQ ,B.HRS_SCREENING_ID ,C.DESCR FROM PS_HRS_RATE_JC_VW A ,PS_HRS_JO_SCR_LV_I B ,PS_HRS_SCREEN_TBL C WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND B.HRS_SCREENING_ID = C.HRS_SCREENING_ID

  • Related Language Record: HRS_RAT_SCR_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    4 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    5 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description