HRS_AL_SRCE_I

(SQL View)
 Index Back

Resume Extraction Log

Log of all resumes recieved, where they were recieved from and their current state

SELECT A.HRS_AL_LOG_ID , A.HRS_AL_LOG_SRC_SEQ , A.HRS_SOURCE_ID , A.HRS_SUBSOURCE_ID , A.HRS_SUBSOURCE_DESC , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_AL_LOG_SRCE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
2 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
3 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID

Prompt Table: HRS_SRC_SU_PT_I

4 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Subsource Id

Prompt Table: HRS_SUBSRC_VW_I

5 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description
6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id