HRS_CHKLST_I

(SQL View)
 Index Back

Recruitment Checklist View

Manages a list of task used in Recruiting.

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_CHKLST_ID , A.CHECKLIST_CD , A.CHECKLIST_DT , A.RESPONSIBLE_ID , %subrec(HRS_AUDIT_SBR,A) , A.COMMENTS FROM PS_HRS_CHKLST A

  • Related Language Record: HRS_CHKLST_LN_I

    • # 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