View slot9.WORLD.TSTA.JS_CIVIL_PROCESS_LOG_VW
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CP_ID number 0  √  null
CP_DEL_LOG.CP_ID Implied Constraint R
CP_TYPE_CODE varchar2 30  √  null
CP_TYPE_DESC varchar2 4000  √  null
EVENT_TYPE_CODE varchar2 30  √  null
DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE Implied Constraint R
EVENT_TYPE_DESC varchar2 4000  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
AGENCY_DESC varchar2 40  √  null
COUNTY_CODE varchar2 30  √  null
COUNTY_DESC varchar2 4000  √  null
PLAINTIFF varchar2 100  √  null
REFERENCES varchar2 4000  √  null
FILED_DATE date 7  √  null
RECIEVED_DATE date 7  √  null
STATE_CODE varchar2 30  √  null
STATE_DESC varchar2 4000  √  null
AGENCY_ONLY varchar2 1  √  null
LOG_NUM number 0  √  null
COURT_PAPER_LOGS.LOG_NUM Implied Constraint R
PARTY_INFO varchar2 4000  √  null
SERVE_DATE date 7  √  null
SERVING_PERSON varchar2 100  √  null
PERSON_SERVED varchar2 100  √  null
SERVE_LOCATION varchar2 100  √  null
STATUS_CODE varchar2 30  √  null
STATUS_DESC varchar2 4000  √  null
LOG_COMMENT varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT CP.CP_ID ,CP.CP_TYPE_CODE ,(SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE_TYPE = CP.CP_TYPE_CODE_TYPE AND TYP.CODE = CP.CP_TYPE_CODE) ,CP.EVENT_TYPE_CODE ,(SELECT EVT.DESCRIPTION FROM EJS_CODES EVT WHERE EVT.CODE_TYPE = CP.EVENT_TYPE_CODE_TYPE AND EVT.CODE = CP.EVENT_TYPE_CODE) ,CP.AGENCY_CODE ,(SELECT AGENCY_DESC FROM AGENCY_CODES WHERE AGENCY_CODE = CP.AGENCY_CODE) ,CP.COUNTY_CODE ,(SELECT CNTY.DESCRIPTION FROM EJS_CODES CNTY WHERE CNTY.CODE_TYPE = CP.COUNTY_CODE_TYPE AND CNTY.CODE = CP.COUNTY_CODE) ,CP.PLAINTIFF ,JOIN(CURSOR(SELECT REFERENCE_NUM||' - '||RF.DESCRIPTION FROM COURT_PAPER_REFS CPR, EJS_CODES RF WHERE RF.CODE_TYPE = CPR.REFERENCE_TYPE_CODE_TYPE AND RF.CODE = CPR.REFERENCE_TYPE_CODE AND CPR.CP_ID = CP.CP_ID),', ') ,CP.FILED_DATE ,CP.RECIEVED_DATE ,CP.STATE_CODE ,(SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE_TYPE = CP.STATE_CODE_TYPE AND ST.CODE = CP.STATE_CODE) ,CP.AGENCY_ONLY ,CPL.LOG_NUM --,CPL.CP_PERSON_ID ,CASE WHEN CPL.CP_PERSON_ID IS NOT NULL THEN EJS_PERSON_PKG.GET_PERSON_SUMMARY(CPL.CP_PERSON_ID) ELSE NULL END ,CPL.SERVE_DATE ,CPL.SERVING_PERSON ,CPL.PERSON_SERVED ,CPL.SERVE_LOCATION ,CPL.CP_STATUS_CODE ,(SELECT STAT.DESCRIPTION FROM EJS_CODES STAT WHERE STAT.CODE_TYPE = CPL.CP_STATUS_CODE_TYPE AND STAT.CODE = CPL.CP_STATUS_CODE) ,CPL.LOG_COMMENT FROM COURT_PAPERS CP LEFT OUTER JOIN COURT_PAPER_LOGS CPL ON CP.CP_ID = CPL.CP_ID AND CPL.CP_PERSON_ID IS NOT NULL AND CPL.CP_BUSINESS_ID IS NULL UNION SELECT CP.CP_ID ,CP.CP_TYPE_CODE ,(SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE_TYPE = CP.CP_TYPE_CODE_TYPE AND TYP.CODE = CP.CP_TYPE_CODE) ,CP.EVENT_TYPE_CODE ,(SELECT EVT.DESCRIPTION FROM EJS_CODES EVT WHERE EVT.CODE_TYPE = CP.EVENT_TYPE_CODE_TYPE AND EVT.CODE = CP.EVENT_TYPE_CODE) ,CP.AGENCY_CODE ,(SELECT AGENCY_DESC FROM AGENCY_CODES WHERE AGENCY_CODE = CP.AGENCY_CODE) ,CP.COUNTY_CODE ,(SELECT CNTY.DESCRIPTION FROM EJS_CODES CNTY WHERE CNTY.CODE_TYPE = CP.COUNTY_CODE_TYPE AND CNTY.CODE = CP.COUNTY_CODE) ,CP.PLAINTIFF ,JOIN(CURSOR(SELECT REFERENCE_NUM||' - '||RF.DESCRIPTION FROM COURT_PAPER_REFS CPR, EJS_CODES RF WHERE RF.CODE_TYPE = CPR.REFERENCE_TYPE_CODE_TYPE AND RF.CODE = CPR.REFERENCE_TYPE_CODE AND CPR.CP_ID = CP.CP_ID),', ') ,CP.FILED_DATE ,CP.RECIEVED_DATE ,CP.STATE_CODE ,(SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE_TYPE = CP.STATE_CODE_TYPE AND ST.CODE = CP.STATE_CODE) ,CP.AGENCY_ONLY ,CPL.LOG_NUM --,CPL.CP_BUSINESS_ID ,(SELECT BUSINESS_NAME FROM BUSINESSES B WHERE BUSINESS_NUMBER = CPL.CP_BUSINESS_ID) ,CPL.SERVE_DATE ,CPL.SERVING_PERSON ,CPL.PERSON_SERVED ,CPL.SERVE_LOCATION ,CPL.CP_STATUS_CODE ,(SELECT STAT.DESCRIPTION FROM EJS_CODES STAT WHERE STAT.CODE_TYPE = CPL.CP_STATUS_CODE_TYPE AND STAT.CODE = CPL.CP_STATUS_CODE) ,CPL.LOG_COMMENT FROM COURT_PAPERS CP LEFT OUTER JOIN COURT_PAPER_LOGS CPL ON CP.CP_ID = CPL.CP_ID AND CP_PERSON_ID IS NULL AND CPL.CP_BUSINESS_ID IS NOT NULL UNION SELECT CP.CP_ID ,CP.CP_TYPE_CODE ,(SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE_TYPE = CP.CP_TYPE_CODE_TYPE AND TYP.CODE = CP.CP_TYPE_CODE) ,CP.EVENT_TYPE_CODE ,(SELECT EVT.DESCRIPTION FROM EJS_CODES EVT WHERE EVT.CODE_TYPE = CP.EVENT_TYPE_CODE_TYPE AND EVT.CODE = CP.EVENT_TYPE_CODE) ,CP.AGENCY_CODE ,(SELECT AGENCY_DESC FROM AGENCY_CODES WHERE AGENCY_CODE = CP.AGENCY_CODE) ,CP.COUNTY_CODE ,(SELECT CNTY.DESCRIPTION FROM EJS_CODES CNTY WHERE CNTY.CODE_TYPE = CP.COUNTY_CODE_TYPE AND CNTY.CODE = CP.COUNTY_CODE) ,CP.PLAINTIFF ,JOIN(CURSOR(SELECT REFERENCE_NUM||' - '||RF.DESCRIPTION FROM COURT_PAPER_REFS CPR, EJS_CODES RF WHERE RF.CODE_TYPE = CPR.REFERENCE_TYPE_CODE_TYPE AND RF.CODE = CPR.REFERENCE_TYPE_CODE AND CPR.CP_ID = CP.CP_ID),', ') ,CP.FILED_DATE ,CP.RECIEVED_DATE ,CP.STATE_CODE ,(SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE_TYPE = CP.STATE_CODE_TYPE AND ST.CODE = CP.STATE_CODE) ,CP.AGENCY_ONLY ,CPL.LOG_NUM --,' ' ,'Note' ,CPL.SERVE_DATE ,CPL.SERVING_PERSON ,CPL.PERSON_SERVED ,CPL.SERVE_LOCATION ,CPL.CP_STATUS_CODE ,(SELECT STAT.DESCRIPTION FROM EJS_CODES STAT WHERE STAT.CODE_TYPE = CPL.CP_STATUS_CODE_TYPE AND STAT.CODE = CPL.CP_STATUS_CODE) ,CPL.LOG_COMMENT FROM COURT_PAPERS CP LEFT OUTER JOIN COURT_PAPER_LOGS CPL ON CP.CP_ID = CPL.CP_ID AND CP_PERSON_ID IS NULL AND CPL.CP_BUSINESS_ID IS NULL
 
Possibly Referenced Tables/Views:
AGENCY_CODES BUSINESSES COURT_PAPER_LOGS COURT_PAPER_REFS COURT_PAPERS EJS_CODES 


Close relationships: