HRS_HIR_LOG_TIP

(SQL Table)
Index Back

Hire Log Table

Applicant who are hired through Talent Integration will be tracked in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID
2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
3 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
6 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
7 LASTUPDDTTM 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.
8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.