HRS_AL_LOG_RES

(SQL Table)
 Index Back

Resume Extract Log Resolution

Tracks Resolution Statuses of Logs

  • Parent record: HRS_AL_LOG

    • # 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_RES_ID Number(15,0) DECIMAL(15) NOT NULL Resolution Log ID
    3 HRS_CHANNEL Character(3) VARCHAR2(3) NOT NULL Communication Channel
    10=Integration Framework
    20=Email
    30=Apply Online
    40=Load Resume
    50=Refer a Friend
    60=Manager Entry
    70=Log Update
    80=Manage Applicant
    4 HRS_SITE_ID Number(15,0) DECIMAL(15) NOT NULL Site ID

    Prompt Table: HRS_SITE_ID_PT

    5 HRS_RESOLUTION Character(3) VARCHAR2(3) NOT NULL Resolution State
    10=Success
    20=Rejected
    30=Unresolved with Errors
    40=Draft
    50=Awaiting Resolution
    6 HRS_RES_DESCR Character(254) VARCHAR2(254) NOT NULL Resolution Description. Describes why the resolution was resolved the way it was.
    7 HRS_END_EFFDTTM DateTime(26) TIMESTAMP End Effective DateTime
    8 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    9 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id