HRS_ATTCH_SS_VW

(SQL View)
 Index Back

Applicant attachments

This record contains non-resume applicant attachments. Resume attachments are stored on the APP_RESUME_TEXT record.

SELECT HRS_PERSON_ID , HRS_PROFILE_SEQ , ATTACH_SEQ_NBR , DESCR , ATTACH_TYPE_CD , %subrec(FILE_ATTACH_SBR, AA) , ATTACHDTTM , HRS_ATCH_AUD , HRS_ATTACH_BY , %subrec(HRS_AUDIT_SBR, AA) FROM PS_HRS_APP_ATTACH AA WHERE HRS_PROFILE_SEQ > 0 AND (ATTACH_TYPE_CD = ' ' OR EXISTS ( SELECT 1 FROM PS_HRS_ATT_TYP_TBL AT WHERE AA.ATTACH_TYPE_CD = AT.ATTACH_TYPE_CD AND AT.ATTACH_PROCESS_TYP NOT IN ('RES', 'COV', 'OIF')))

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 ATTACH_SEQ_NBR Number(3,0) SMALLINT NOT NULL Attachment Sequence Number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ATTACH_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Attachment Type Code

    Prompt Table: HRS_ATT_TYP_VW

    6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    8 ATTACHDTTM DateTime(26) TIMESTAMP Attachment Date Time
    9 HRS_ATCH_AUD Character(1) VARCHAR2(1) NOT NULL Indicates to whom the attachment should be visible.
    1=Private
    2=Administrator
    3=Candidate
    10 HRS_ATTACH_BY Character(1) VARCHAR2(1) NOT NULL Indicates who attached the document.
    A=External Applicant
    E=Internal Applicant
    R=Recruiter
    11 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    12 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    13 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    14 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id