HRS_RCMNT_LTR

(SQL Table)
Index Back

Recruitment Letter

Applicant Tracking Recruitment Letter

  • Parent record: HRS_RCMNT
  • # 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_RCMNT_LTR_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Letter ID
    4 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    5 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
    6 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
    7 HRS_ATCH_DESCR Character(50) VARCHAR2(50) NOT NULL Attachment Description
    8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id