HRS_CHKLST

(SQL Table)
Index Back

Recruitment Checklist

Manages a list of task used in Recruiting.

  • Related Language Record: HRS_CHKLST_LNG
  • Parent record: HRS_APP_PROFILE
  • # 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_CHKLST_ID Number(15,0) DECIMAL(15) NOT NULL Checklist ID
    4 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

    Prompt Table: CHECKLIST_TBL

    5 CHECKLIST_DT Date(10) DATE Checklist Date
    6 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: PERSON_NAME

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