HRS_LIST_VW

(SQL View)
 Index Back

Applicant Lists View

Applicant Lists View

SELECT A.HRS_LST_ID , A.HRS_LST_NAME , A.DESCR254 , A.HRS_LST_PUBLIC , A.HRS_OWNER_ID , A.HRS_JOBBAS_OWNER , A.HRS_LST_TYPE , A.HRS_LST_FREEZE , A.HRS_SAVE_UNTIL , A.HRS_SEARCH_NAME , HRS_LST_ACTIVE , %subrec(HRS_AUDIT_SBR,A) , CASE WHEN( SELECT NAME_DISPLAY FROM PS_HRS_PERSON_NM_I B WHERE A.HRS_OWNER_ID = B.EMPLID) IS NULL THEN( SELECT OPRID FROM PSOPRDEFN C WHERE C.OPRID = A.HRS_OWNER_ID ) ELSE ( SELECT NAME_DISPLAY FROM PS_HRS_PERSON_NM_I B WHERE A.HRS_OWNER_ID = B.EMPLID) END OWNER_NAME FROM PS_HRS_LIST A WHERE A.HRS_LST_TYPE IN ('APPL','SSRL') AND A.HRS_LST_FREEZE<>'Y' AND (A.HRS_SAVE_UNTIL IS NULL OR A.HRS_SAVE_UNTIL >=%CurrentDateIn)

  • Related Language Record: HRS_LIST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_LST_ID Number(15,0) DECIMAL(15) NOT NULL List ID
    2 HRS_LST_NAME Character(50) VARCHAR2(50) NOT NULL List Name
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 HRS_LST_PUBLIC Character(1) VARCHAR2(1) NOT NULL Share with Others?

    Y/N Table Edit

    5 HRS_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Owner ID
    6 HRS_JOBBAS_OWNER Number(15,0) DECIMAL(15) NOT NULL Owner ID
    7 HRS_LST_TYPE Character(4) VARCHAR2(4) NOT NULL List Type
    APPL=Applicant List
    JOBS=Job Basket
    SSRL=Saved Search Result
    8 HRS_LST_FREEZE Character(1) VARCHAR2(1) NOT NULL Freeze List
    9 HRS_SAVE_UNTIL Date(10) DATE Save Until
    10 HRS_SEARCH_NAME Character(30) VARCHAR2(30) NOT NULL Search Name
    11 HRS_LST_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    A=Active
    I=Inactive
    12 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    13 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    14 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    15 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    16 HRS_OWNER_NAME Character(60) VARCHAR2(60) NOT NULL Owner