Dashboard > Electronic Research Administration > Database Schema > ER.ER_RF_PRM_PRJDR_HIER_V
Electronic Research Administration Log In   View a printable version of the current page.
ER.ER_RF_PRM_PRJDR_HIER_V
Browse Space    
Added by Michael Clay, last edited by K Lars Lohn on Jul 12, 2005  (view change)
Labels: 
(None)

ERA Routing Form Primary Project Director Hierarchy View

This is a view in tablespace ER.

Purpose:

Schema

name human readable name primary type size scale null default indexed comment
APPROVER_IND Approver Indicator (boolean)   CHAR 1 0 ?   No  
DELEGATE_IND Delegate Indicator (boolean)   CHAR 1 0 ?   No  
EMP_FSCL_CMP_CD Employee Fiscal Campus Code   VARCHAR2 2 0 ?   No  
EMP_PRM_DEPT_CD Employee Primary Department Code   VARCHAR2 4 0 ?   No  
PERSON_UNVL_ID Person Universal (User ID) Identifier   VARCHAR2 10 0 ?   No  
PRPSL_NBR Proposal Number   NUMBER 13 0 ?   No  
PRPSL_PRMSN_CD Proposal Permission Code   CHAR 3 0 ?   No  
PRSN_APRVL_UID Person Aproval User ID   VARCHAR2 0 0 ?   No  
ROLE Role   VARCHAR2 4 0 ?   No  

Potential Foreign Key Relationships

local column name qualified foreign column name caveats comment
PERSON_UNVL_ID ER.ER_ACC_STSTC_T.PERSON_UNVL_ID Scale does not match (local:"0" foreign:"")
Nulls does not match (local:"?" foreign:"No")
Size does not match (local:"10" foreign:"11")
foreign column is not indexed		  
PRPSL_NBR ER.ER_DLGT_AD_HOC_PRMSN_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF1_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF2_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF3_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF4_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF_ALL_PRMSN_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF_DLGT_PRMSN_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF_PRMSN_1_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_RF_PRMSN_V.PRPSL_NBR Scale does not match (local:"0" foreign:"-127")
Size does not match (local:"13" foreign:"127")
foreign column is not indexed		  
PRPSL_NBR ER.ER_CG_PRPSL_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_IU_CST_SHR_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_OTHR_CST_SHR_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_PRM_PRJDR_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_PRPSL_DIS_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_PRPSL_INC_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_AGNCY_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_APRVL_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_ATT_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_BDGT_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_CI_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_CRDT_PCT_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_DIARY_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_KEYWRD_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_ORG_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_PRJDR_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_PRTCL_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_SUBCNR_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"Yes")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_UPDT_TYP_CD_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_NBR ER.ER_RF_USR_PRMSN_T.PRPSL_NBR Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"13" foreign:"12")		  
PRPSL_PRMSN_CD ER.ER_DLGT_AD_HOC_PRMSN_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_DLGT_CO_PRJDR_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_DLGT_CO_PRJDR_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_DLGT_IU_CST_SHR_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_DLGT_OTHR_ORG_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_AD_HOC_PRMSN_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_ALL_PRMSN_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_CO_PRJDR_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_CO_PRJDR_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_DLGT_PRMSN_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_IU_CST_SHR_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_OTHR_ORG_HIER_V.PRPSL_PRMSN_CD Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_PRMSN_1_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_PRMSN_V.PRPSL_PRMSN_CD DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRPSL_PRMSN_CD ER.ER_RF_USR_PRMSN_T.PRPSL_PRMSN_CD Scale does not match (local:"0" foreign:"")
DataType does not match (local:"CHAR" foreign:"VARCHAR2")
Nulls does not match (local:"?" foreign:"Yes")
Size does not match (local:"3" foreign:"4")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_BDGT_ALL_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_BDGT_DLGT_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_AD_HOC_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_CNTCT_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_CO_PRJDR_HIER_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_CO_PRJDR_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_INIT_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_IU_CST_SHR_HIER_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_OTHR_ORG_HIER_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_PRM_PRJDR_HIER_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_DLGT_PRM_PRJDR_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_RF_ALL_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_RF_DLGT_PRMSN_V.PRSN_APRVL_UID Size does not match (local:"0" foreign:"10")
foreign column is not indexed		  
PRSN_APRVL_UID ER.ER_APRVL_DLGT_T.PRSN_APRVL_UID Scale does not match (local:"0" foreign:"")
Nulls does not match (local:"?" foreign:"No")
Indexed does not match (local:"no" foreign:"yes")
Size does not match (local:"0" foreign:"10")		  
ROLE ER.ER_BDGT_PRJDR_PRMSN_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"2")
foreign column is not indexed		  
ROLE ER.ER_DLGT_CNTCT_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"7")
foreign column is not indexed		  
ROLE ER.ER_DLGT_CO_PRJDR_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"5")
foreign column is not indexed		  
ROLE ER.ER_DLGT_PRM_PRJDR_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"2")
foreign column is not indexed		  
ROLE ER.ER_RF_ALL_PRMSN_V.ROLE Size does not match (local:"4" foreign:"7")
foreign column is not indexed		  
ROLE ER.ER_RF_CO_PRJDR_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"5")
foreign column is not indexed		  
ROLE ER.ER_RF_DLGT_PRMSN_V.ROLE Size does not match (local:"4" foreign:"7")
foreign column is not indexed		  
ROLE ER.ER_RF_PRMSN_1_V.ROLE Size does not match (local:"4" foreign:"7")
foreign column is not indexed		  
ROLE ER.ER_RF_PRMSN_V.ROLE Size does not match (local:"4" foreign:"7")
foreign column is not indexed		  
ROLE ER.ER_RF_PRM_PRJDR_V.ROLE DataType does not match (local:"VARCHAR2" foreign:"CHAR")
Size does not match (local:"4" foreign:"2")
foreign column is not indexed		  

Source Code References

No source code references detected

DDL SQL

CREATE OR REPLACE VIEW "ER"."ER_RF_PRM_PRJDR_HIER_V" ("PRPSL_NBR",
    "PERSON_UNVL_ID","EMP_FSCL_CMP_CD","EMP_PRM_DEPT_CD",
    "APPROVER_IND","ROLE","DELEGATE_IND","PRPSL_PRMSN_CD",
    "PRSN_APRVL_UID") AS 
    select a.prpsl_nbr, 
       b.person_unvl_id, 
       b.fin_coa_cd as emp_fscl_cmp_cd, 
       b.org_cd as emp_prm_dept_cd, 
       'Y' as approver_ind, 
       b.prpsl_aprv_cd as role, 
       'N' as delegate_ind, 
       'MOD' as prpsl_prmsn_cd, 
       null as prsn_aprvl_uid 
  from er_rf_prjdr_t a, er_org_aprvl_prsn_t b 
 where a.prpsl_pjd_coa_cd = b.fin_coa_cd 
   and a.prpsl_pjd_org_cd = b.org_cd 
   and a.prpsl_prm_pjd_ind = 'Y' 
   and b.person_unvl_id is not null
Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.2.7 Build:#524 Jul 28, 2006) - Bug/feature request - Contact Administrators