EG_REVIEW_PATH(SQL Table) |
Index Back |
---|---|
Review PathThe Review Path record tracks Case Review information as it travels through the hierarchy of reviewing bodies. |
# | 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 |
5 | EG_EMPLID_REVIEW | Character(11) | VARCHAR2(11) NOT NULL |
Reviewer EmplID
Prompt Table:
PERSON_NAME
|
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 |
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 |