HRS_RTE_DTL_S_I

(SQL View)
 Index Back

Route Status

Records the status history for a routing detail record.

SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_RTE_ID ,A.HRS_RTE_SEQ ,A.HRS_RTE_STS_SEQ ,A.STATUS_CODE ,A.STATUS_REASON ,A.STATUS_DT ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_RTE_DTL_STS A

  • Parent record: HRS_APP_RTE_DTL

    • # 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 HRS_RTE_STS_SEQ Number(3,0) SMALLINT NOT NULL Route Status Sequence
    6 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

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

    Prompt Table: HRS_RSN_REC_I

    8 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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