HRS_RTE_DTL_HST

(SQL Table)
 Index Back

Applicant Route Detail

Replaces APPLICATN_ROUTE. Records to whom an applicant was routed, when the routing occured, and when it is due back.

  • Parent record: HRS_APP_RTE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    5 HRS_RTE_ID Number(15,0) DECIMAL(15) NOT NULL Route ID
    6 HRS_RTE_SEQ Number(3,0) SMALLINT NOT NULL Route Sequence
    7 ROUTE_DT Date(10) DATE NOT NULL Route Date

    Default Value: %date

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

    Prompt Table: HRS_PERSON_NM_I

    9 RESPONSE_DUE_DT Date(10) DATE Response Due Date
    10 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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

    Prompt Table: HRS_STS_REC_I

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

    Prompt Table: HRS_RSN_REC_I

    13 HRS_SUBMITTED Character(1) VARCHAR2(1) NOT NULL Submitted
    14 HRS_COMMENTS_BY Character(11) VARCHAR2(11) NOT NULL Updated by
    15 DESCRLONG Long Character CLOB Long Description
    16 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    17 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    18 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    19 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id