HRS_APPCKLS_HST

(SQL Table)
 Index Back

Applicant Checklist

APP_CHECKLIST is used to create a list of task used in Recruiting. There is one record in this table for each dated list.

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    5 CHECKLIST_DT Date(10) DATE NOT NULL Checklist Date

    Default Value: %date

    6 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

    Prompt Table: HRS_CHCKLST_I

    7 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: HRS_PERSON_NM_I

    8 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    9 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    12 COMMENTS Long Character CLOB Comment