HRS_BIP_ALSRC_L

(SQL View)
 Index Back

AL Source View


SELECT A.HRS_AL_LOG_ID , A.HRS_AL_LOG_SRC_SEQ , D.LANGUAGE_CD , D.HRS_SOURCE_NAME , D.HRS_SOURCE_DESCR , C.HRS_SUBSOURCE_DESC , SUB.HRS_SUBSOURCE_DESC FROM PS_HRS_AL_LOG_SRCE A , PS_HRS_SOURCE B , PS_HRS_SOURCE_LNG D , PS_HRS_SUBSRCE_LNG C LEFT OUTER JOIN PS_HRS_SUBSRC_LN_I SUB ON SUB.HRS_SOURCE_ID=C.HRS_SOURCE_ID AND SUB.HRS_SUBSOURCE_ID=C.HRS_SUBSOURCE_ID AND SUB.LANGUAGE_CD=C.LANGUAGE_CD WHERE A.HRS_SOURCE_ID=B.HRS_SOURCE_ID AND D.LANGUAGE_CD=C.LANGUAGE_CD AND A.HRS_SOURCE_ID=D.HRS_SOURCE_ID AND ((B.HRS_SOURCE_ID=C.HRS_SOURCE_ID AND A.HRS_SUBSOURCE_ID=C.HRS_SUBSOURCE_ID AND B.EFFDT=C.EFFDT ) OR (A.HRS_SUBSOURCE_ID=0 AND C.HRS_SOURCE_ID=0)) AND %DatePart(A.HRS_ROW_UPD_DTTM) BETWEEN B.EFFDT AND B.HRS_END_EFFDT

  • Related Language Record for HRS_BIPCG_SRC_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
    2 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name
    5 HRS_SOURCE_DESCR Character(254) VARCHAR2(254) NOT NULL Description of the Source
    6 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description
    7 DESCR100B Character(100) VARCHAR2(100) NOT NULL Description