View slot9.WORLD.TSTA.PROPERTY_SEARCH_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
ID varchar2 141  √  null
COUNTY varchar2 100  √  null
PID number 0
PTYPEDESC varchar2 80  √  null
PSECCODE number 0  √  null
PSECURITY varchar2 100  √  null
PTYPE varchar2 30
PDESC varchar2 2500  √  null
PCOLOR varchar2 30  √  null
SCOLOR varchar2 30  √  null
MAKE varchar2 20  √  null
MODEL varchar2 25  √  null
PVALUE number 11,2  √  null
QUANTITY number 20,3  √  null
SERIALNUMBER varchar2 25  √  null
MISC varchar2 160  √  null
DRUGTYPE varchar2 30  √  null
DRUGTYPEDESC varchar2 4000  √  null
QUANITITY number 20,3  √  null
TYPE_OF_QUANTITY varchar2 30  √  null
TYPE_OF_QUANTITY_DESC varchar2 4000  √  null
DOC_NUMBER varchar2 6  √  null
DOC_DATE varchar2 19  √  null
ACCOUNTNAME varchar2 40  √  null
ACCOUNT_NUMBER number 16  √  null
AMOUNT number 12,2  √  null
BANK varchar2 40  √  null
PAYABLE_TO varchar2 40  √  null
ENDORSEE varchar2 40  √  null
GUNTYPE varchar2 30  √  null
GUNTYPEDESC varchar2 4000  √  null
GUNACT varchar2 30  √  null
GUNACTDESC varchar2 4000  √  null
CALGAGCODE varchar2 30  √  null
CALGAGDESC varchar2 4000  √  null
BARRAEL_LENGTH varchar2 20  √  null
DOCUMENT varchar2 30
DOCUMENT_DESC varchar2 4000  √  null
SECID varchar2 100  √  null
CURRENCYCODE varchar2 30  √  null
CURRENCYDESC varchar2 4000  √  null
DENOMCODE varchar2 30  √  null
DENOMDESC varchar2 4000  √  null
CURNCYQUANTITY number 0  √  null
PROP_DTL_TYPE varchar2 6  √  null
PROPERTY_DETAIL_TYPE_CODES.PROP_DTL_TYPE Implied Constraint R
PCOMMENT varchar2 255  √  null
CREATEDBY varchar2 100  √  null
CREATION_DATE date 7  √  null
SOLR_CREATION_DATE varchar2 4000  √  null
MODIFICATION_DATE date 7  √  null
MODIFIEDBY varchar2 100  √  null
PCOLOR_DESC varchar2 4000  √  null
SCOLOR_DESC varchar2 4000  √  null
PROPERTY_CATEGORY_CODE varchar2 30  √  null
PROPERTY_CATEGORY_DESC varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT UPPER(i.db_schema) ||'_'|| p.property_id ID, UPPER(i.db_schema) county, p.property_id AS pid, ptc.property_type_desc AS ptypedesc, p.indx_sec_level_code AS pseccode, p.indx_sec_level_id AS psecurity, p.property_type_code AS ptype, p.description AS pdesc, p.primary_color AS pcolor, p.secondary_color AS scolor, p.make AS make, p.model AS model, p.VALUE AS pvalue, p.quantity AS quantity, p.serial_number AS serialnumber, p.misc AS misc, p.drug_type AS drugtype, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.DRUG_TYPE_TYPE AND EC.CODE = P.DRUG_TYPE) AS DRUGTYPEDESC, p.quantity AS quanitity, p.type_of_quantity AS type_of_quantity, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.type_of_quantity_TYPE AND EC.CODE = P.type_of_quantity) AS type_of_quantity_desc, p.document_number AS doc_number, TO_CHAR (p.document_date, 'MM/DD/YYYY HH:MI AM') AS doc_date, p.account_name AS accountname, p.account_number AS account_number, p.amount AS amount, p.bank AS bank, p.payable_to AS payable_to, p.endorsee AS endorsee, p.gun_typ_code AS guntype, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.GUN_TYP_CODE_TYPE AND EC.CODE = P.GUN_TYP_CODE) AS GUNTYPEDESC, p.gun_act_code AS gunact, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.GUN_ACT_CODE_TYPE AND EC.CODE = P.GUN_ACT_CODE) AS GUNACTDESC, p.calgag_code AS calgagcode, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.CALGAG_CODE_TYPE AND EC.CODE = P.CALGAG_CODE) AS CALGAGDESC, p.barrel_length AS barrael_length, p.document AS document, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.DOCUMENT_TYPE AND EC.CODE = P.DOCUMENT) AS DOCUMENT_DESC, p.indx_sec_level_id AS secid, p.currency_code AS currencycode, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = P.CURRENCY_CODE_TYPE AND EC.CODE = P.CURRENCY_CODE) AS CURRENCY_DESC, pc.denomination_code AS denomcode, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = PC.DENOMINATION_CODE_TYPE AND EC.CODE = PC.DENOMINATION_CODE) AS DENOMDESC, pc.quantity AS curncyquantity, pd.prop_dtl_type AS prop_dtl_type, pd.pd_comment AS pcomment, p.creator_id AS createdby, p.creator_date AS creation_date, CONV_SOLR_CREATOR_DATE(p.creator_date, (SELECT ec.code FROM ejs_codes ec WHERE ec.code_type = 'DATABASE_TIMEZONE' AND ROWNUM = 1)), p.updator_date AS modification_date, p.updator_id AS modifiedby, (SELECT ec.description FROM ejs_codes ec WHERE UPPER (ec.code) = UPPER (p.primary_color) AND ec.code_type = 'COLOR_CODES') AS pcolor_desc, (SELECT ec.description FROM ejs_codes ec WHERE UPPER (ec.code) = UPPER (p.secondary_color) AND ec.code_type = 'COLOR_CODES') AS scolor_desc, PCC.CODE AS PROPERTY_CATEGORY_CODE, PCC.DESCRIPTION AS PROPERTY_CATEGORY_DESC FROM install i, properties p LEFT OUTER JOIN property_cash pc ON p.property_id = pc.property_id LEFT OUTER JOIN property_details pd ON p.property_id = pd.property_id LEFT OUTER JOIN property_type_codes ptc ON p.property_type_code = ptc.property_type LEFT OUTER JOIN EJS_CODES PCC ON PTC.PROPERTY_CATEGORY_TYPE = PCC.CODE_TYPE AND PCC.CODE = PTC.PROPERTY_CATEGORY
 
Possibly Referenced Tables/Views:
EJS_CODES INSTALL PROPERTIES PROPERTY_CASH PROPERTY_DETAILS PROPERTY_TYPE_CODES 


Close relationships: