EG_REVIEW_PATH

(SQL Table)
 Index Back

Review Path

The Review Path record tracks Case Review information as it travels through the hierarchy of reviewing bodies.

  • Parent record: EG_CASE_REVIEW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EG_CASE_ID Character(10) VARCHAR2(10) NOT NULL Case ID
    3 EG_REVIEW_STEP Number(2,0) SMALLINT NOT NULL Review Path Step
    4 EG_DEPTID_REVIEW Character(10) VARCHAR2(10) NOT NULL Current Review Department

    Default Value: EG_DERIVE_SRCH.EG_TENURE_HOME

    Prompt Table: DEPT_TBL
    Set Control Field: DEPTID

    5 EG_EMPLID_REVIEW Character(11) VARCHAR2(11) NOT NULL Reviewer Empl ID

    Prompt Table: PERSON_NAME
    Set Control Field: EMPLID

    6 EG_CURR_REVIEWER Character(50) VARCHAR2(50) NOT NULL Reviewer Team
    7 EG_RECEIVED_DATE Date(10) DATE Case Received Date
    8 EG_RECOMMEND_DATE Date(10) DATE Recommendation Date
    9 EG_RECOMMENDATION Character(1) VARCHAR2(1) NOT NULL Recommendation
    A=Approve
    D=Disapprove
    10 EG_FWD_DATE Date(10) DATE Forwarded Date
    11 EG_FWD_DEPTID Character(10) VARCHAR2(10) NOT NULL Forward Department

    Prompt Table: DEPT_TBL
    Set Control Field: DEPTID

    12 EG_FINAL_ACTION Character(1) VARCHAR2(1) NOT NULL Final Action

    Y/N Table Edit

    Default Value: N

    13 EG_NEXT_CASE_TYPE Character(3) VARCHAR2(3) NOT NULL Next Case Review Type
    FTE=FTE Case Review
    RNK=Rank Case Review
    TEN=Tenure Case Review
    TTL=Title Case Review
    14 NEXT_REVIEW_DT Date(10) DATE Next Review Date
    15 DESCRLONG Long Character CLOB Long Description