HRS_OFF_ATCH_I

(SQL View)
 Index Back

Emplymnt Offer Attachments

Employment Offer Job Offer Letter Attachments used on offer details page work area to have at level 1 for tab order purposes

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , %subrec(HR_ATT_DD_SBR, A) , A.HRS_OFF_ATTCH_SRC , A.HRS_RETURN_OLA , A.HRS_ATCH_AUD FROM PS_HRS_OFF_ATCH A

  • Parent record: HRS_OFFER

    • # 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration
    6 HR_ATT_ENT_ID Character(18) VARCHAR2(18) NOT NULL Attachment Authorization Entry ID
    7 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    9 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.
    10 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    11 HR_ATT_TYPE Character(3) VARCHAR2(3) NOT NULL Attachment Types
    001=URL
    002=Attachment
    003=Document Definition
    004=Note
    12 HR_ATT_SUBJECT Character(50) VARCHAR2(50) NOT NULL HR Notepad: Subject of note.
    13 HR_ATT_NOTETEXT Long Character(8095) CLOB HR Attachments: Text of note.
    14 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    15 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    16 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    17 HRS_OFF_ATTCH_SRC Character(1) VARCHAR2(1) NOT NULL Attachment Source
    A=Organizational Level Document
    U=Applicant Specific Document
    18 HRS_RETURN_OLA Character(1) VARCHAR2(1) NOT NULL Complete & return the document

    Y/N Table Edit

    Default Value: N

    19 HRS_ATCH_AUD Character(1) VARCHAR2(1) NOT NULL Indicates to whom the attachment should be visible.
    1=Private
    2=Administrator
    3=Candidate