HRS_APPL_SRC_I

(SQL View)
Index Back

Applicatin Source & Subscoure


SELECT APP.HRS_PERSON_ID , APP.HRS_PROFILE_SEQ , SRC.HRS_AL_LOG_SRC_SEQ , APP.HRS_AL_LOG_ID , SRC.HRS_SOURCE_ID , SRC.HRS_SUBSOURCE_ID FROM PS_HRS_APP_PROFILE APP , PS_HRS_AL_LOG_SRCE SRC WHERE APP.HRS_AL_LOG_ID = SRC.HRS_AL_LOG_ID

# 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
3 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
4 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
5 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
6 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Subsource Id