HRS_RTE_DTL_I

(SQL View)
 Index Back

Applicant Route Detail View

This is an interface view to the base table HRS_APP_RTE_DTL. This view should always be used in place of the base table if accessed outside of the Applicant Tracking module.

SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_RTE_ID ,A.HRS_RTE_SEQ ,A.ROUTE_DT ,A.ROUTE_TO_ID ,A.RESPONSE_DUE_DT ,A.STATUS_DT ,A.STATUS_CODE ,A.STATUS_REASON ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APP_RTE_DTL A

# 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_RTE_ID Number(15,0) DECIMAL(15) NOT NULL Route ID
4 HRS_RTE_SEQ Number(3,0) SMALLINT NOT NULL Route Sequence
5 ROUTE_DT Date(10) DATE NOT NULL Route Date

Default Value: %date

6 ROUTE_TO_ID Character(11) VARCHAR2(11) NOT NULL Route To ID

Prompt Table: HRS_PERSON_NM_I

7 RESPONSE_DUE_DT Date(10) DATE Response Due Date
8 STATUS_DT Date(10) DATE Status Date

Default Value: %date

9 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_RTE_I

10 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_RTE_I

11 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
12 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
13 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
14 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id