EG_CASE_FIN_VW(SQL View) |
Index Back |
|---|---|
Case Final ViewThis view is based upon EG_CASE_REVIEW where the Case Status field is equal to 'A', Approved. |
| SELECT EMPLID ,EG_CASE_ID ,EG_CASE_TYPE ,EG_CASE_STATUS ,TENURE_STATUS ,EG_ACADEMIC_RANK ,EG_ACADEMIC_TITLE ,FTE ,BEGIN_DT ,EG_OUTSIDE_OFFER ,DESCR50 ,DESCRLONG FROM PS_EG_CASE_REVIEW WHERE EG_CASE_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
EG_CASE_REVIEW
|
| 2 | EG_CASE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Case ID |
| 3 | EG_CASE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Case Type
FTE=FTE Review MIX=Mixed RNK=Rank Review TEN=Tenure Review TTL=Title Review |
| 4 | EG_CASE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Case Status
A=Approved D=Disapproved I=In Appeal O=Open |
| 5 | TENURE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Tenure Status
DEF=Tenure by de facto DEN=Tenure Denied NA=Not Applicable NOT=Non Tenure Not On Track NTK=Non Tenure On Track OTH=Other TEN=Tenure |
| 6 | EG_ACADEMIC_RANK | Character(3) | VARCHAR2(3) NOT NULL |
Academic Rank
Prompt Table: EG_RANK_TBL |
| 7 | EG_ACADEMIC_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Title |
| 8 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 9 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 10 | EG_OUTSIDE_OFFER | Character(1) | VARCHAR2(1) NOT NULL |
Outside Offer Indicator
Y/N Table Edit Default Value: N |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 12 | DESCRLONG | Long Character | CLOB | Long Description |