SchemaSpy Analysis of shrdb.LAWRS - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Dec 13 15:47 CST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

shrdb.LAWRS contains 641 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
EBS_WEBUSER ACCESS nvarchar2 1  √  null
ERS_PUBLICATIONS ACCESSCOUNT number 22  √  null
ERS_PUBLICATIONS2 ACCESSCOUNT number 22  √  null
ERS_LISTUSERS ACCESSTYPE nvarchar2 150  √  null
ERS_REPORTACCESS ACCESSTYPE nvarchar2 150
ERS_REPORTNOTIFICATION ACCESSTYPE nvarchar2 145
ERS_REPORTPERMISSIONS ACCESSTYPE nvarchar2 100
ERS_RULEACCESS ACCESSTYPE number 22  √  null
ERS_SERVERACCESS ACCESSTYPE nvarchar2 150
ERS_SYSTEMPERMISSIONS ACCESSTYPE nvarchar2 150
ERS_LISTUSERS ACCESSVALUE nvarchar2 150  √  null
ERS_REPORTACCESS ACCESSVALUE nvarchar2 150
ERS_REPORTNOTIFICATION ACCESSVALUE nvarchar2 150
ERS_REPORTPERMISSIONS ACCESSVALUE nvarchar2 145  √  null
ERS_SERVERACCESS ACCESSVALUE nvarchar2 150
ERS_SYSTEMPERMISSIONS ACCESSVALUE nvarchar2 150
RS_AUDIT ACCESSVALUE nvarchar2 250  √  null
EBS_WEBUSER ACCT_UNIT nvarchar2 15  √  null
EBS_WEBUSER ACGRP_COLLECT nvarchar2 15  √  null
ERS_ATTRIBUTES ACTIVESTATUS nvarchar2 4  √  null
EBS_WEBUSER ACTIVITY_LIST nvarchar2 12  √  null
EBS_WFWORKUNIT AGENT nvarchar2 15  √  null
EBS_WFSERVICE ALL_PROCSTATUS number 22  √  null
EBS_WEBUSER ALLOWJOBQUEUE nvarchar2 1  √  null
ERS_RULEACCESS ALLOWMAINT nvarchar2 100  √  null
ERS_PARAMETERS ALLOWMULTIPLE nvarchar2 2  √  null
ERS_PARAMETERS ALLOWNULLS nvarchar2 2  √  null
ERS_RULEMASTER ALLOWPARTIAL nvarchar2 100  √  null
ERS_PARAMETERS ALWAYSPROMPT nvarchar2 2  √  null
EBS_WEBUSER APP_LOGIN nvarchar2 20  √  null
ERS_REPORTFORMULAS APPENDRULE nvarchar2 20  √  null
ERS_REPORTDATASOURCES APPLYTO number 22  √  null
ERS_REPORTATTRIBUTES APPLYTOINSTANCES nvarchar2 100  √  null
ERS_ATTRIBUTES APPLYTONEWREPORTS nvarchar2 4  √  null
EBS_WEBUSER APPROVE_CD nvarchar2 5  √  null
ERS_REPORTS ARCHIVEINSTANCES number 22  √  null
EBS_WFFOLDER ATTACH_BY nvarchar2 30  √  null
ERS_SERVERATTRIBUTES ATTRIBUTECATEGORY nvarchar2 100  √  null
ERS_ATTRIBUTES ATTRIBUTEDESCRIPTION nvarchar2 800  √  null
ERS_ATTRIBUTELIST ATTRIBUTEID number 22
ERS_ATTRIBUTES ATTRIBUTEID number 22
ERS_REPORTATTRIBUTES ATTRIBUTEID number 22  √  null
ERS_ATTRIBUTES ATTRIBUTENAME nvarchar2 160  √  null
ERS_SERVERATTRIBUTES ATTRIBUTENAME nvarchar2 160
ERS_ATTRIBUTES ATTRIBUTEREQUIRED nvarchar2 4  √  null
ERS_ATTRIBUTELIST ATTRIBUTESEQ number 22
ERS_ATTRIBUTES ATTRIBUTETYPE nvarchar2 4  √  null
ERS_ATTRIBUTELIST ATTRIBUTEVALUE nvarchar2 2000  √  null
ERS_REPORTATTRIBUTES ATTRIBUTEVALUE nvarchar2 2000  √  null
ERS_SERVERATTRIBUTES ATTRIBUTEVALUE nvarchar2 512  √  null
ERS_PARM_AVAILVALUES AVAILABLEVALUE nvarchar2 2000  √  null
EJS_BLOB_TRIGGERS BLOB_DATA blob 4000  √  null
ERS_DISTRIBUTIONOPTIONS BURSTINGENABLED nvarchar2 2  √  null
EBS_WEBUSER BUYER_CODE nvarchar2 3  √  null
EJS_CALENDARS CALENDAR blob 4000  √  null
EJS_CALENDARS CALENDAR_NAME nvarchar2 80
EJS_TRIGGERS CALENDAR_NAME nvarchar2 80  √  null
ERS_REPORTS CATEGORY nvarchar2 100  √  null
ERS_SYSTEMTASKS CATEGORY nvarchar2 100  √  null
EBS_BSCHANNEL CH_STATUS nvarchar2 1  √  null
EBS_BSCHANNEL CHANNEL nvarchar2 20  √  null
EBS_BSFOLDER CHANNEL nvarchar2 20  √  null
EBS_BSIDCHAN CHANNEL nvarchar2 20  √  null
EBS_BSIDCHFLD CHANNEL nvarchar2 20  √  null
EBS_BSIDCHFLDI CHANNEL nvarchar2 20  √  null
EJS_SCHEDULER_STATE CHECKIN_INTERVAL number 13  √  null
EBS_WFWORKUNIT CLOSE_DATETIME timestamp(6) 11,6  √  null
EBS_BSINFODTL COMBINE_RULE nvarchar2 1  √  null
ERS_VARIABLES COMMENT nvarchar2 1600  √  null
EBS_WEBUSER COMPANY number 22  √  null
ERS_LISTDETAIL CONJUNCTION nvarchar2 40  √  null
ERS_RULEACCESS CONSUMERID nvarchar2 150
ERS_RULEMAPPINGS CONSUMERID nvarchar2 150
ERS_RULEMAPPINGS CONSUMERTYPE number 22
EBS_WEBUSER CONTACT_ID number 22  √  null
ERS_ELEMENTREFERENCES CONTAINERID nvarchar2 510  √  null
ERS_ELEMENTREFERENCES CONTAINERSUBTYPE nvarchar2 400  √  null
ERS_ELEMENTREFERENCES CONTAINERTYPE nvarchar2 400  √  null
ERS_PUBLICATIONS CREATED timestamp(6) 11,6  √  null
ERS_PUBLICATIONS2 CREATED timestamp(6) 11,6  √  null
ERS_REPORTS CREATED timestamp(6) 11,6  √  null
ERS_SOLPACKS CREATED timestamp(6) 11,6  √  null
RS_AUDIT CREATEDPUB nvarchar2 1
EBS_WFSERVICE CRITERIA_NAME_1 nvarchar2 15  √  null
EBS_WFSERVICE CRITERIA_NAME_2 nvarchar2 15  √  null
EBS_WFSERVICE CRITERIA_NAME_3 nvarchar2 15  √  null
EBS_WFSERVPROC CRITERION_1 nvarchar2 30  √  null
EBS_WFWORKUNIT CRITERION_1 nvarchar2 30  √  null
EBS_WFSERVPROC CRITERION_2 nvarchar2 30  √  null
EBS_WFWORKUNIT CRITERION_2 nvarchar2 30  √  null
EBS_WFSERVPROC CRITERION_3 nvarchar2 30  √  null
EBS_WFWORKUNIT CRITERION_3 nvarchar2 30  √  null
EJS_CRON_TRIGGERS CRON_EXPRESSION nvarchar2 80  √  null
EBS_WEBUSER CUST_GROUP nvarchar2 5  √  null
EBS_WEBUSER CUSTOMER nvarchar2 9  √  null
ERS_QUEUE_DTL CUSTOMGROUP nvarchar2 100  √  null
ERS_REPORTINSTANCEPARAMVALUE DATA_TYPE nvarchar2 20  √  null
ERS_PUBLICATIONS DATAMAP blob 4000  √  null
ERS_PUBLICATIONS2 DATAMAP blob 4000  √  null
ERS_ELEMENTREFERENCES DATASIZE number 22  √  null
ERS_ELEMENTS DATASIZE number 22  √  null
ERS_PARAMETERS DATASIZE nvarchar2 50  √  null
ERS_REPORTS DATASOURCE nvarchar2 100  √  null
ERS_REPORTDATASOURCES DATASOURCETYPE nvarchar2 100  √  null
ERS_ELEMENTREFERENCES DATATYPE nvarchar2 100  √  null
ERS_ELEMENTS DATATYPE nvarchar2 100  √  null
ERS_PARAMETERS DATATYPE nvarchar2 100  √  null
ERS_REPORTS DBPASSWORD nvarchar2 150  √  null
ERS_REPORTS DBUSELOGIN nvarchar2 4  √  null
ERS_REPORTS DBUSER nvarchar2 150  √  null
ERS_REPORTS DEFAULTDESTINATION nvarchar2 100  √  null
ERS_REPORTDATASOURCES DEFAULTPASSWORD nvarchar2 150  √  null
ERS_REPORTDATASOURCES DEFAULTUSER nvarchar2 150  √  null
ERS_ATTRIBUTES DEFAULTVALUE nvarchar2 2000  √  null
ERS_ELEMENTREFERENCES DEFAULTVALUE nvarchar2 400  √  null
ERS_ELEMENTS DEFAULTVALUE nvarchar2 400  √  null
ERS_REPORTPARMVALUES DEFAULTVALUE nvarchar2 2  √  null
ERS_SYSTEMTASKS DEFAULTVALUE nvarchar2 2  √  null
ERS_PARAMETERS DEFAULTVALUES nvarchar2 200  √  null
EBS_WFSERVICE DEFINED_BY nvarchar2 1  √  null
ERS_REPORTINSTANCEPARAMVALUE DEFINED_VALUE nvarchar2 500  √  null
EBS_WFFOLDER DELETE_FL nvarchar2 1  √  null
EBS_BSIDCHFLDI DELIVERY nvarchar2 1  √  null
EBS_BSLISTGRP DELIVERY nvarchar2 1  √  null
ERS_PARAMETERS DEPENDSON nvarchar2 200  √  null
EBS_BSCHANNEL DESCRIPTION nvarchar2 50  √  null
EBS_BSFOLDER DESCRIPTION nvarchar2 50  √  null
EBS_BSGROUP DESCRIPTION nvarchar2 50  √  null
EBS_BSINFODTL DESCRIPTION nvarchar2 50  √  null
EBS_BSINFOHDR DESCRIPTION nvarchar2 50  √  null
EBS_BSRULEHDR DESCRIPTION nvarchar2 50  √  null
EBS_SIBSLISTHD DESCRIPTION nvarchar2 50  √  null
EBS_SIBSLISTID DESCRIPTION nvarchar2 50  √  null
EBS_SIRDIDHDR DESCRIPTION nvarchar2 50  √  null
EBS_WFFOLDER DESCRIPTION nvarchar2 50  √  null
EBS_WFSERVICE DESCRIPTION nvarchar2 50  √  null
EJS_JOB_DETAILS DESCRIPTION nvarchar2 120  √  null
EJS_JOBS DESCRIPTION nvarchar2 1024  √  null
EJS_TRIGGERS DESCRIPTION nvarchar2 120  √  null
ERS_LISTS DESCRIPTION nvarchar2 1000  √  null
ERS_REPORTS DESCRIPTION nvarchar2 510  √  null
ERS_REPORTSTATUS DESCRIPTION nvarchar2 800  √  null
ERS_SECURITYGROUPS DESCRIPTION nvarchar2 1000  √  null
ERS_SERVERCONFIGURATIONS DESCRIPTION nvarchar2 512  √  null
ERS_SOLPACKS DESCRIPTION nvarchar2 800  √  null
EBS_WFVARIABLE DISP_VALUE nvarchar2 30  √  null
ERS_LISTS DISPLAY nvarchar2 150  √  null
EBS_WFFOLDER DOCUMENT_ID nvarchar2 10  √  null
EBS_WFWORKUNIT ELAPSED_TIME number 22  √  null
EBS_BSRULEDTL ELEMENT nvarchar2 20  √  null
ERS_ELEMENTS ELEMENTDESCRIPTION nvarchar2 400  √  null
ERS_ELEMENTREFERENCES ELEMENTID number 22
ERS_ELEMENTS ELEMENTID number 22
ERS_REPORTITEMMAPPINGS ELEMENTID nvarchar2 10
ERS_RULEDETAIL ELEMENTID number 22
ERS_RULEVALUES ELEMENTID number 22
ERS_STRUCTURETEMPLATE ELEMENTID number 22
ERS_STRUCTURETOFIELDMAP ELEMENTID number 22
ERS_ELEMENTS ELEMENTNAME nvarchar2 400  √  null
ERS_RULEDETAIL ELEMENTORDER number 22  √  null
ERS_STRUCTURETEMPLATE ELEMENTORDER number 22  √  null
ERS_ELEMENTREFERENCES ELEMENTUNIQUENAME nvarchar2 400  √  null
ERS_RULEVALUES ELEMENTVALUE1 nvarchar2 800  √  null
ERS_RULEDETAIL ELEMENTVALUE2 nvarchar2 800  √  null
EBS_WEBUSER EMAIL nvarchar2 100  √  null
ERS_DISTRIBUTIONOPTIONS EMAILENABLED nvarchar2 2  √  null
ERS_QUEUE_DTL EMAILSTATUS number 22
ERS_DISTRIBUTIONOPTIONS EMAILSUBJECT nvarchar2 510  √  null
ERS_DISTRIBUTIONOPTIONS EMAILTEXT nclob 4000  √  null
ERS_QUEUE_DTL EMAILTYPE number 22
EBS_WEBUSER EMPLOYEE number 22  √  null
EJS_TRIGGERS END_TIME number 13  √  null
ERS_RULEMASTER ENDDATE timestamp(6) 11,6  √  null
ERS_QUEUE_DTL ENDTIME timestamp(6) 11,6  √  null
ERS_QUEUE_HDR ENDTIME timestamp(6) 11,6  √  null
ERS_REPORTSTATUS ENDTIME timestamp(6) 11,6  √  null
EJS_FIRED_TRIGGERS ENTRY_ID nvarchar2 95
ERS_REPORTSTATUS ERRORKEY nvarchar2 100  √  null
EBS_WFSERVPROC EVENT_TYPE nvarchar2 15  √  null
EBS_WFWORKUNIT EVENT_TYPE nvarchar2 15  √  null
ERS_QUEUE_DTL EXCEPTIONLOG clob 4000  √  null
ERS_QUEUE_HDR EXCEPTIONLOG clob 4000  √  null
ERS_RULEDETAIL EXCLUDEINCLUDE nvarchar2 2  √  null
EBS_BSINFOHDR EXPIRE number 22  √  null
ERS_STRUCTURETOFIELDMAP FIELDID nvarchar2 1020  √  null
EBS_WFFOLDER FILE_NAME nvarchar2 30  √  null
EBS_BSLISTGRP FILTER nvarchar2 1  √  null
ERS_REPORTS FINISHED timestamp(6) 11,6  √  null
EJS_FIRED_TRIGGERS FIRED_TIME number 13  √  null
EBS_BSFOLDER FOLDER nvarchar2 20  √  null
EBS_BSIDCHFLD FOLDER nvarchar2 20  √  null
EBS_BSIDCHFLDI FOLDER nvarchar2 50  √  null
EBS_BSINFOHDR FOLDER nvarchar2 20  √  null
EBS_BSFOLDER FOLDER_STATUS nvarchar2 1  √  null
EBS_WFFOLDER FORM nvarchar2 10  √  null
ERS_ELEMENTREFERENCES FORMAT nvarchar2 100  √  null
ERS_ELEMENTS FORMAT nvarchar2 100  √  null
ERS_REPORTFORMULAS FORMULATYPE number 22
ERS_REPORTFORMULAS FORMULAVALUE nclob 4000  √  null
EBS_BSGROUP GROUP_STATUS nvarchar2 1  √  null
ERS_CUSTOMGROUPS GROUPDESCRIPTION nvarchar2 1600  √  null
ERS_CUSTOMGROUPMEMBERS GROUPID number 22
ERS_CUSTOMGROUPS GROUPID number 22
ERS_CUSTOMGROUPS GROUPNAME nvarchar2 150  √  null
ERS_PARAMETERS HIDDEN number 22
EBS_WFSERVPROC HISTORY_DATE_BACK timestamp(6) 11,6  √  null
EJS_JOBS HISTORYINTERVAL number 22  √  null
EBS_BSIDCHAN ID nvarchar2 20  √  null
EBS_BSIDCHFLD ID nvarchar2 20  √  null
EBS_BSIDCHFLDI ID nvarchar2 20  √  null
EBS_BSIDPUB ID nvarchar2 20  √  null
EBS_BSLISTGRP ID nvarchar2 20  √  null
EBS_BSSUBSCR ID nvarchar2 20  √  null
EBS_SIBSLISTID ID nvarchar2 20  √  null
EBS_SIRDIDHDR ID nvarchar2 20  √  null
ERS_PARAMETERS ID number 22
ERS_PARM_AVAILVALUES ID number 22
EBS_SIRDIDHDR ID_STATUS number 22  √  null
EBS_SIRDIDHDR ID_TYPE nvarchar2 15  √  null
ERS_LISTEXCEPTIONS INCLUDEEXCLUDE nvarchar2 4  √  null
ERS_REPORTDATASOURCES INDEXNUMBER number 22
EBS_BSPUBLISH INFO_DESC nvarchar2 50  √  null
EBS_BSINFODTL INFO_STATUS nvarchar2 1  √  null
EBS_BSINFOHDR INFO_STATUS nvarchar2 1  √  null
EBS_BSIDCHFLDI INFORMATION nvarchar2 20  √  null
EBS_BSINFODTL INFORMATION nvarchar2 20  √  null
EBS_BSINFOHDR INFORMATION nvarchar2 20  √  null
EBS_BSPUBLISH INFORMATION nvarchar2 20  √  null
EJS_FIRED_TRIGGERS INSTANCE_NAME nvarchar2 80  √  null
EJS_SCHEDULER_STATE INSTANCE_NAME nvarchar2 80
ERS_REPORTS INSTANCECOMMAND nvarchar2 1000  √  null
ERS_LISTEXCEPTIONS INSTANCEID number 22
ERS_PARAMETERVALUES INSTANCEID number 22  √  null
ERS_PUBLICATIONS INSTANCEID number 22
ERS_PUBLICATIONS2 INSTANCEID number 22
ERS_QUEUE_HDR INSTANCEID number 22
ERS_REPORTACCESS INSTANCEID number 22
ERS_REPORTATTRIBUTES INSTANCEID number 22  √  null
ERS_REPORTFORMULAS INSTANCEID number 22
ERS_REPORTINSTANCEPARAMVALUE INSTANCEID number 22
ERS_REPORTITEMMAPPINGS INSTANCEID number 22
ERS_REPORTNOTIFICATION INSTANCEID number 22
ERS_REPORTPERMISSIONS INSTANCEID number 22
ERS_REPORTS INSTANCEID number 22
ERS_REPORTSTATUS INSTANCEID number 22
RS_AUDIT INSTANCEID number 22  √  null
ERS_REPORTS INSTANCENAME nvarchar2 500  √  null
EJS_JOB_DETAILS IS_DURABLE number 22  √  null
EJS_FIRED_TRIGGERS IS_STATEFUL nvarchar2 1  √  null
EJS_JOB_DETAILS IS_STATEFUL number 22  √  null
EJS_FIRED_TRIGGERS IS_VOLATILE nvarchar2 1  √  null
EJS_JOB_DETAILS IS_VOLATILE number 22  √  null
EJS_TRIGGERS IS_VOLATILE nvarchar2 1  √  null
EJS_JOBS ISENABLED nvarchar2 2  √  null
EJS_JOBS ISSHARABLE nvarchar2 2  √  null
EJS_JOB_DETAILS JOB_CLASS_NAME nvarchar2 128  √  null
EJS_JOB_DETAILS JOB_DATA blob 4000  √  null
EJS_TRIGGERS JOB_DATA blob 4000  √  null
EJS_FIRED_TRIGGERS JOB_GROUP nvarchar2 80  √  null
EJS_JOB_DETAILS JOB_GROUP nvarchar2 80
EJS_JOB_LISTENERS JOB_GROUP nvarchar2 80
EJS_TRIGGERS JOB_GROUP nvarchar2 80  √  null
EJS_JOB_LISTENERS JOB_LISTENER nvarchar2 80
EJS_FIRED_TRIGGERS JOB_NAME nvarchar2 80  √  null
EJS_JOB_DETAILS JOB_NAME nvarchar2 80
EJS_JOB_LISTENERS JOB_NAME nvarchar2 80
EJS_TRIGGERS JOB_NAME nvarchar2 80  √  null
EJS_JOBS JOBGROUP nvarchar2 160  √  null
EJS_JOBS JOBNAME nvarchar2 130
ERS_PARAMETERVALUES JOBNAME nvarchar2 100  √  null
ERS_REPORTACCESS JOBNAME nvarchar2 100  √  null
ERS_REPORTPERMISSIONS JOBNAME nvarchar2 100  √  null
ERS_SOLPACKOBJECTS KEY1 nvarchar2 100  √  null
ERS_SOLPACKOBJECTS KEY2 nvarchar2 100  √  null
ERS_SOLPACKOBJECTS KEY3 nvarchar2 100  √  null
ERS_SOLPACKOBJECTS KEY4 nvarchar2 100  √  null
ERS_SOLPACKOBJECTS KEY5 nvarchar2 100  √  null
EBS_WFFOLDER KEY_STRING nvarchar2 70  √  null
EBS_WFWORKUNIT KEY_STRING nvarchar2 70  √  null
ERS_PUBLICATIONS2 KEYHASHCODE number 22
ERS_QUEUE_DTL KEYHASHCODE number 22
EJS_SCHEDULER_STATE LAST_CHECKIN_TIME number 13  √  null
EBS_BSINFOHDR LAST_RUN_SEQ number 22  √  null
ERS_CACHEDTABLES LAST_UPDATE number 13  √  null
ERS_PUBLICATIONS LASTACCESSED timestamp(6) 11,6  √  null
ERS_PUBLICATIONS2 LASTACCESSED timestamp(6) 11,6  √  null
ERS_PARAMETERS_IDS LASTID number 22
ERS_PARM_AVAILVALUES_IDS LASTID number 22
ERS_REPORTS LASTMODIFIED timestamp(6) 11,6  √  null
ERS_SOLPACKS LASTMODIFIED timestamp(6) 11,6  √  null
EBS_BSLISTGRP LIST nvarchar2 15  √  null
EBS_BSRULELIST LIST nvarchar2 15  √  null
EBS_SIBSLISTHD LIST nvarchar2 15  √  null
EBS_SIBSLISTID LIST nvarchar2 15  √  null
EBS_SIBSLISTHD LIST_STATUS nvarchar2 1  √  null
EBS_BSLISTGRP LISTGRP_STATUS nvarchar2 1  √  null
ERS_LISTDEFAULT LISTNAME nvarchar2 160
ERS_LISTDETAIL LISTNAME nvarchar2 160
ERS_LISTEXCEPTIONS LISTNAME nvarchar2 160
ERS_LISTS LISTNAME nvarchar2 160
ERS_LISTUSERS LISTNAME nvarchar2 160
ERS_ELEMENTREFERENCES LOCALE nvarchar2 100  √  null
EJS_LOCKS LOCK_NAME nvarchar2 40
EBS_WEBUSER LOGIN nvarchar2 20  √  null
EBS_WFWORKUNIT LST_ERROR_NBR number 22  √  null
EBS_WFWORKUNIT LST_FOLDER_NBR number 22  √  null
EBS_WFWORKUNIT LST_MSG_NBR number 22  √  null
EBS_WFWORKUNIT LST_VAR_NBR number 22  √  null
ERS_REPORTITEMMAPPINGS MAPID nvarchar2 400
ERS_REPORTITEMMAPPINGS MAPPINGTYPE number 22
ERS_ELEMENTREFERENCES MAXVALUE nvarchar2 510  √  null
ERS_ELEMENTS MAXVALUE nvarchar2 510  √  null
ERS_PARAMETERS MAXVALUE nvarchar2 400  √  null
ERS_CUSTOMGROUPMEMBERS MEMBERID nvarchar2 150
EBS_WFSERVPROC METRICS_LOGGING nvarchar2 1  √  null
EBS_WFWORKUNIT METRICS_LOGING nvarchar2 1  √  null
ERS_DISTRIBUTIONOPTIONS MIMETYPE nvarchar2 100  √  null
ERS_ELEMENTREFERENCES MINVALUE nvarchar2 510  √  null
ERS_ELEMENTS MINVALUE nvarchar2 510  √  null
ERS_PARAMETERS MINVALUE nvarchar2 400  √  null
EJS_TRIGGERS MISFIRE_INSTR number 2  √  null
ERS_DISTRIBUTIONOPTIONS MSGFORMAT nvarchar2 100  √  null
EBS_BSIDCHFLDI MULT_PUBLISH nvarchar2 1  √  null
ERS_ELEMENTREFERENCES NBRDECIMALS number 22  √  null
ERS_ELEMENTS NBRDECIMALS number 22  √  null
EJS_TRIGGERS NEXT_FIRE_TIME number 13  √  null
ERS_REPORTNOTIFICATION NOTIFICATIONTYPE nvarchar2 150
ERS_REPORTNOTIFICATION NOTIFICATIONVALUE nvarchar2 150  √  null
EBS_BSIDCHFLDI NOTIFY nvarchar2 1  √  null
EBS_BSLISTGRP NOTIFY nvarchar2 1  √  null
EBS_SIBSLISTHD OBJ_ID number 22  √  null
EBS_SIRDIDHDR OBJ_ID number 22  √  null
EBS_WEBUSER OBJ_ID number 22  √  null
EBS_WFWORKUNIT OBJECT_NAME nvarchar2 15  √  null
ERS_LISTDETAIL OBJID nvarchar2 400  √  null
ERS_LISTDETAIL OBJSOURCE nvarchar2 100  √  null
ERS_LISTDETAIL OBJTYPE nvarchar2 40
ERS_LISTDETAIL OBJVALUE nvarchar2 400  √  null
ERS_RULEDETAIL OPERAND nvarchar2 100  √  null
ERS_LISTDETAIL OPERATOR nvarchar2 40  √  null
EBS_BSIDCHAN ORDER_OPT number 22  √  null
EBS_BSIDCHFLD ORDER_OPT number 22  √  null
EBS_BSIDCHFLDI ORDER_OPT number 22  √  null
ERS_DISTRIBUTIONOPTIONS OUTPUTTYPE nvarchar2 100  √  null
ERS_REPORTS OUTPUTTYPE nvarchar2 100  √  null
ERS_REPORTDATASOURCES OVERRIDEUSER number 22  √  null
EJS_JOBS OWNER nvarchar2 100  √  null
ERS_PARAMETERVALUES OWNER nvarchar2 145  √  null
ERS_REPORTS OWNER nvarchar2 150  √  null
ERS_LISTS PAGESIZE number 22  √  null
ERS_REPORTINSTANCEPARAMVALUE PARAMETER_NAME nvarchar2 100
ERS_PARAMETERS PARAMETERDESCRIPTION nvarchar2 500  √  null
ERS_REPORTPARMVALUES PARAMETERDESCRIPTION nvarchar2 600  √  null
ERS_PARAMETERS PARAMETERINDEX number 22  √  null
ERS_PARAMETERS PARAMETERNAME nvarchar2 200
ERS_PARAMETERVALUES PARAMETERNAME nvarchar2 200  √  null
ERS_REPORTPARMVALUES PARAMETERNAME nvarchar2 200
ERS_REPORTFORMULAS PARAMETERRULE nvarchar2 20  √  null
ERS_PARAMETERS PARAMETERSOURCE number 22  √  null
ERS_PARAMETERS PARAMETERTYPE number 22  √  null
ERS_PARAMETERVALUES PARAMETERVALUE nvarchar2 400  √  null
ERS_REPORTPARMVALUES PARAMETERVALUE nvarchar2 400  √  null
RS_AUDIT PARAMETERVALUES clob 4000  √  null
EBS_WEBUSER PARTNER nvarchar2 9  √  null
EBS_BSFOLDER PATH nvarchar2 99  √  null
ERS_PARM_AVAILVALUES PID number 22
ERS_PARM_AVAILVALUES_IDS PID number 22
EJS_TRIGGERS PREV_FIRE_TIME number 13  √  null
ERS_DISTRIBUTIONOPTIONS PRINTERENABLED nvarchar2 2  √  null
ERS_DISTRIBUTIONOPTIONS PRINTERS nvarchar2 800  √  null
EBS_WFSERVPROC PROCESS_NAME nvarchar2 20  √  null
EBS_WFWORKUNIT PROCESS_NAME nvarchar2 20  √  null
RS_AUDIT PROCESSTIME timestamp(6) 11,6  √  null
EBS_WEBUSER PRODLINE nvarchar2 14  √  null
EBS_WFWORKUNIT PRODLINE nvarchar2 14  √  null
EBS_WEBUSER PRODLINE2 nvarchar2 15  √  null
ERS_PARAMETERS PROMPTDISPLAYFORMAT nvarchar2 2  √  null
ERS_PARAMETERS PROMPTTEXT nvarchar2 400  √  null
ERS_SOLPACKPROPERTIES PROPERTYNAME nvarchar2 40
ERS_SOLPACKPROPERTIES PROPERTYVALUE nvarchar2 40  √  null
EBS_WEBUSER PROSPECT nvarchar2 9  √  null
ERS_PUBLICATIONS PUBLICATIONID number 22
ERS_PUBLICATIONS2 PUBLICATIONID number 22
ERS_QUEUE_DTL PUBLICATIONID number 22
RS_AUDIT PUBLICATIONID number 22  √  null
ERS_PUBLICATIONS PUBLICATIONKEY nvarchar2 2000  √  null
ERS_PUBLICATIONS2 PUBLICATIONKEY clob 4000
ERS_QUEUE_DTL PUBLICATIONKEY clob 4000  √  null
RS_AUDIT PUBLICATIONSTRING clob 4000  √  null
EBS_BSIDCHFLDI PUBLISH number 12  √  null
EBS_BSIDPUB PUBLISH nvarchar2 12  √  null
EBS_BSPUBLISH PUBLISH number 22  √  null
EBS_BSLISTGRP PUBLISH_SUFFIX nvarchar2 50  √  null
ERS_REPORTS PUBLISHER nvarchar2 150  √  null
ERS_QUEUE_DTL QUEUEID number 22
ERS_QUEUE_HDR QUEUEID number 22
EBS_BSCHANNEL R_DATETIME timestamp(6) 11,6  √  null
EBS_BSFOLDER R_DATETIME timestamp(6) 11,6  √  null
EBS_BSGROUP R_DATETIME timestamp(6) 11,6  √  null
EBS_BSIDCHAN R_DATETIME timestamp(6) 11,6  √  null
EBS_BSIDCHFLD R_DATETIME timestamp(6) 11,6  √  null
EBS_BSIDCHFLDI R_DATETIME timestamp(6) 11,6  √  null
EBS_BSIDPUB R_DATETIME timestamp(6) 11,6  √  null
EBS_BSINFODTL R_DATETIME timestamp(6) 11,6  √  null
EBS_BSINFOHDR R_DATETIME timestamp(6) 11,6  √  null
EBS_BSLISTGRP R_DATETIME timestamp(6) 11,6  √  null
EBS_BSPUBLISH R_DATETIME timestamp(6) 11,6  √  null
EBS_BSRULEDTL R_DATETIME timestamp(6) 11,6  √  null
EBS_BSRULEHDR R_DATETIME timestamp(6) 11,6  √  null
EBS_BSRULELIST R_DATETIME timestamp(6) 11,6  √  null
EBS_BSSUBSCR R_DATETIME timestamp(6) 11,6  √  null
EBS_SIBSLISTHD R_DATETIME timestamp(6) 11,6  √  null
EBS_SIBSLISTID R_DATETIME timestamp(6) 11,6  √  null
EBS_SIRDIDHDR R_DATETIME timestamp(6) 11,6  √  null
EBS_BSIDPUB R_DELETE nvarchar2 1  √  null
EBS_BSGROUP R_GROUP nvarchar2 20  √  null
EBS_BSINFODTL R_GROUP nvarchar2 20  √  null
EBS_BSLISTGRP R_GROUP nvarchar2 20  √  null
EBS_BSSUBSCR R_GROUP nvarchar2 20  √  null
EBS_BSIDPUB R_READ nvarchar2 1  √  null
EBS_BSRULEDTL R_RULE nvarchar2 99  √  null
ERS_ATTRIBUTES READONLY nvarchar2 4  √  null
ERS_DISTRIBUTIONOPTIONS RECIPIENTS nvarchar2 1020  √  null
EBS_SIRDIDHDR RECORD_TYPE number 22  √  null
EJS_SCHEDULER_STATE RECOVERER nvarchar2 80  √  null
ERS_ELEMENTREFERENCES REFERENCEID number 22
RS_AUDIT REFRESHEDDATA nvarchar2 1
EJS_SIMPLE_TRIGGERS REPEAT_COUNT number 7  √  null
EJS_SIMPLE_TRIGGERS REPEAT_INTERVAL number 12  √  null
ERS_REPORTEVENTS REPORTACTION nvarchar2 2000  √  null
ERS_REPORTEVENTS REPORTAPPLYTO number 22  √  null
ERS_REPORTDATASOURCES REPORTDATASOURCE nvarchar2 200  √  null
ERS_REPORTEVENTS REPORTEVENT number 22
ERS_PARAMETERS REPORTFIELD nvarchar2 200  √  null
ERS_REPORTEVENTS REPORTFREQUENCY number 22  √  null
EBS_WFSERVPROC REPORTID number 22  √  null
ERS_DISTRIBUTIONOPTIONS REPORTID number 22
ERS_LISTEXCEPTIONS REPORTID number 22
ERS_PARAMETERS REPORTID number 22
ERS_PARAMETERVALUES REPORTID number 22  √  null
ERS_PUBLICATIONS REPORTID number 22
ERS_PUBLICATIONS2 REPORTID number 22
ERS_QUEUE_HDR REPORTID number 22
ERS_REPORTACCESS REPORTID number 22
ERS_REPORTATTRIBUTES REPORTID number 22  √  null
ERS_REPORTDATASOURCES REPORTID number 22
ERS_REPORTEVENTS REPORTID number 22
ERS_REPORTFORMULAS REPORTID number 22
ERS_REPORTINSTANCEPARAMVALUE REPORTID number 22
ERS_REPORTITEMMAPPINGS REPORTID number 22
ERS_REPORTNOTIFICATION REPORTID number 22
ERS_REPORTPARMVALUES REPORTID number 22
ERS_REPORTPERMISSIONS REPORTID number 22
ERS_REPORTS REPORTID number 22
ERS_REPORTSTATUS REPORTID number 22
ERS_STRUCTURETOFIELDMAP REPORTID number 22
RS_AUDIT REPORTID number 22
ERS_REPORTS REPORTNAME nvarchar2 200  √  null
ERS_REPORTEVENTS REPORTTYPE number 22  √  null
ERS_REPORTS REPORTTYPE nvarchar2 100
EBS_WEBUSER REQUESTER nvarchar2 10  √  null
EJS_FIRED_TRIGGERS REQUESTS_RECOVERY nvarchar2 1  √  null
EJS_JOB_DETAILS REQUESTS_RECOVERY number 22  √  null
RS_AUDIT REQUESTTIME timestamp(6) 11,6
ERS_QUEUE_DTL RETRYATTEMPTS number 22
ERS_QUEUE_DTL ROLENAME nvarchar2 100  √  null
ERS_REPORTDATASOURCES RSDATASOURCE nvarchar2 200  √  null
EBS_BSINFODTL RULE_ORDER number 22  √  null
EBS_BSRULEDTL RULE_STATUS nvarchar2 1  √  null
EBS_BSIDCHFLDI RULE_TAG nvarchar2 15  √  null
EBS_BSINFODTL RULE_TAG nvarchar2 15  √  null
EBS_BSPUBLISH RULE_TAG nvarchar2 50  √  null
EBS_BSRULEDTL RULE_TAG nvarchar2 15  √  null
EBS_BSRULEHDR RULE_TAG nvarchar2 15  √  null
EBS_BSRULELIST RULE_TAG nvarchar2 15  √  null
ERS_RULEMASTER RULEDESCRIPTION nvarchar2 800  √  null
ERS_RULEDETAIL RULEGROUPING number 22
ERS_RULEVALUES RULEGROUPING number 22
ERS_STRUCTURETEMPLATE RULEGROUPING number 22
EJS_JOBS RULEID nvarchar2 100  √  null
ERS_RULEACCESS RULEID number 22
ERS_RULEDETAIL RULEID number 22
ERS_RULEMAPPINGS RULEID number 22
ERS_RULEMASTER RULEID number 22
ERS_RULEVALUES RULEID number 22
ERS_STRUCTUREMAPPING RULEID number 22
EBS_BSRULELIST RULELST_STATUS nvarchar2 1  √  null
ERS_RULEMASTER RULENAME nvarchar2 510
ERS_RULEMASTER RULEORDER number 22  √  null
ERS_RULEMASTER RULEOWNER nvarchar2 150  √  null
EBS_BSPUBLISH RUN_SEQ number 22  √  null
ERS_SERVERACCESS SCGROUP number 22
ERS_SERVERATTRIBUTES SCGROUP number 22
ERS_SERVERCONFIGURATIONS SCGROUP number 22
ERS_DISTRIBUTIONOPTIONS SCHEDULENAME nvarchar2 100
ERS_QUEUE_HDR SCHEDULENAME nvarchar2 130
ERS_REPORTATTRIBUTES SCHEDULENAME nvarchar2 100  √  null
ERS_SERVERACCESS SCNAME nvarchar2 145
ERS_SERVERATTRIBUTES SCNAME nvarchar2 145
ERS_SERVERCONFIGURATIONS SCNAME nvarchar2 145
ERS_SERVERACCESS SCTYPE number 22
ERS_SERVERATTRIBUTES SCTYPE number 22
ERS_SERVERCONFIGURATIONS SCTYPE number 22
ERS_QUEUE_DTL SECURITYGROUP nvarchar2 100  √  null
ERS_SECURITYGROUPS SECURITYGROUPID number 22
ERS_SECURITYGROUPS SECURITYGROUPNAME nvarchar2 150  √  null
ERS_PARAMETERS SELECTIONFORMULAONLY nvarchar2 2  √  null
ERS_DISTRIBUTIONOPTIONS SENDBCC nvarchar2 2  √  null
EBS_BSRULEDTL SEQ_NBR number 22  √  null
EBS_WFFOLDER SEQ_NBR number 22  √  null
EBS_WFVARIABLE SEQ_NBR number 22  √  null
ERS_LISTDETAIL SEQUENCEID number 22  √  null
ERS_RULEVALUES SEQUENCEID number 22
ERS_REPORTPARMVALUES SEQUENCENUMBER number 22
ERS_SYSTEMTASKS SEQUENCENUMBER number 22  √  null
EBS_WFSERVICE SERVICE nvarchar2 15  √  null
EBS_WFSERVPROC SERVICE nvarchar2 15  √  null
EBS_WFWORKUNIT SERVICE nvarchar2 15  √  null
EBS_BSINFOHDR SH_FOLDER nvarchar2 18  √  null
EBS_BSIDCHFLDI SH_INFO_DESC nvarchar2 50  √  null
EBS_BSINFODTL SH_INFO_DESC nvarchar2 50  √  null
EBS_BSFOLDER SH_PATH nvarchar2 50  √  null
EBS_BSRULEDTL SH_RULE nvarchar2 40  √  null
EBS_SIRDIDHDR SH_WEB_USER nvarchar2 40  √  null
EBS_WFSERVICE SHORT_DESC nvarchar2 30  √  null
ERS_ELEMENTREFERENCES SIGNED nvarchar2 2  √  null
ERS_ELEMENTS SIGNED nvarchar2 2  √  null
ERS_SOLPACKOBJECTS SOLUTIONPACKID number 22
ERS_SOLPACKPROPERTIES SOLUTIONPACKID number 22
ERS_SOLPACKS SOLUTIONPACKID number 22
ERS_SOLPACKS SOLUTIONPACKNAME nvarchar2 160
ERS_SOLPACKOBJECTS SOLUTIONPACKTYPE nvarchar2 40
ERS_SOLPACKPROPERTIES SOLUTIONPACKTYPE nvarchar2 40
EBS_BSLISTGRP START_DATE timestamp(6) 11,6  √  null
EBS_WFFOLDER START_DATETIME timestamp(6) 11,6  √  null
EBS_WFWORKUNIT START_DATETIME timestamp(6) 11,6  √  null
EJS_TRIGGERS START_TIME number 13  √  null
ERS_RULEMASTER STARTDATE timestamp(6) 11,6  √  null
ERS_REPORTS STARTED timestamp(6) 11,6  √  null
ERS_QUEUE_DTL STARTTIME timestamp(6) 11,6  √  null
ERS_QUEUE_HDR STARTTIME timestamp(6) 11,6  √  null
ERS_REPORTSTATUS STARTTIME timestamp(6) 11,6  √  null
EJS_FIRED_TRIGGERS STATE nvarchar2 16  √  null
EBS_WEBUSER STATUS number 22  √  null
EJS_JOBS STATUS nvarchar2 2  √  null
ERS_QUEUE_DTL STATUS number 22
ERS_REPORTS STATUS number 22  √  null
ERS_REPORTSTATUS STATUS number 22  √  null
ERS_RULEMASTER STATUS nvarchar2 100  √  null
ERS_SERVERCONFIGURATIONS STATUS number 22  √  null
ERS_SOLPACKS STATUS number 22
ERS_STRUCTURE STATUS nvarchar2 100  √  null
ERS_STRUCTUREMAPPING STATUS nvarchar2 100  √  null
EBS_BSLISTGRP STOP_DATE timestamp(6) 11,6  √  null
ERS_QUEUE_HDR STRUCTURE nvarchar2 1020  √  null
ERS_STRUCTURE STRUCTUREDESCRIPTION nvarchar2 800  √  null
ERS_RULEDETAIL STRUCTUREID number 22
ERS_RULEMASTER STRUCTUREID number 22  √  null
ERS_RULEVALUES STRUCTUREID number 22
ERS_STRUCTURE STRUCTUREID number 22
ERS_STRUCTUREMAPPING STRUCTUREID number 22
ERS_STRUCTURETEMPLATE STRUCTUREID number 22
ERS_STRUCTURETOFIELDMAP STRUCTUREID number 22
ERS_STRUCTURE STRUCTURENAME nvarchar2 1020
EBS_BSCHANNEL STYLE nvarchar2 20  √  null
EBS_BSIDCHAN SUBSCRIBE nvarchar2 1  √  null
EBS_BSIDCHFLD SUBSCRIBE nvarchar2 1  √  null
EBS_BSIDCHFLDI SUBSCRIBE nvarchar2 1  √  null
EBS_BSSUBSCR SUBSCRIBE nvarchar2 1  √  null
EBS_BSSUBSCR SUBSCRIBE_TYPE nvarchar2 1  √  null
ERS_REPORTPERMISSIONS SYSTEMTASKID nvarchar2 100
ERS_SYSTEMPERMISSIONS SYSTEMTASKID nvarchar2 100
ERS_SYSTEMTASKS SYSTEMTASKID nvarchar2 100
ERS_SYSTEMTASKS SYSTEMTASKTYPE number 22  √  null
ERS_REPORTPERMISSIONS SYSTEMTASKVALUE nvarchar2 4  √  null
ERS_SYSTEMPERMISSIONS SYSTEMTASKVALUE nvarchar2 2  √  null
ERS_CACHEDTABLES TABLE_NAME nvarchar2 50
EBS_WFWORKUNIT TASK nvarchar2 20  √  null
EJS_CRON_TRIGGERS TIME_ZONE_ID nvarchar2 80  √  null
EJS_SIMPLE_TRIGGERS TIMES_TRIGGERED number 7  √  null
EJS_BLOB_TRIGGERS TRIGGER_GROUP nvarchar2 80
EJS_CRON_TRIGGERS TRIGGER_GROUP nvarchar2 80
EJS_FIRED_TRIGGERS TRIGGER_GROUP nvarchar2 80
EJS_PAUSED_TRIGGER_GRPS TRIGGER_GROUP nvarchar2 80
EJS_SIMPLE_TRIGGERS TRIGGER_GROUP nvarchar2 80
EJS_TRIGGER_LISTENERS TRIGGER_GROUP nvarchar2 80
EJS_TRIGGERS TRIGGER_GROUP nvarchar2 80
EJS_TRIGGER_LISTENERS TRIGGER_LISTENER nvarchar2 80
EJS_BLOB_TRIGGERS TRIGGER_NAME nvarchar2 80
EJS_CRON_TRIGGERS TRIGGER_NAME nvarchar2 80
EJS_FIRED_TRIGGERS TRIGGER_NAME nvarchar2 80
EJS_SIMPLE_TRIGGERS TRIGGER_NAME nvarchar2 80
EJS_TRIGGER_LISTENERS TRIGGER_NAME nvarchar2 80
EJS_TRIGGERS TRIGGER_NAME nvarchar2 80
EJS_TRIGGERS TRIGGER_STATE nvarchar2 16  √  null
EJS_TRIGGERS TRIGGER_TYPE nvarchar2 8  √  null
EBS_SIBSLISTHD TYPE nvarchar2 2  √  null
EBS_WEBUSER TYPE nvarchar2 2  √  null
ERS_REPORTSTATUS TYPE nvarchar2 4  √  null
ERS_SOLPACKOBJECTS UNIQUEID number 22
ERS_DISTRIBUTIONOPTIONS UNSUBSCRIBE nvarchar2 2  √  null
ERS_LISTDEFAULT USERID nvarchar2 150
ERS_LISTDETAIL USERID nvarchar2 150
ERS_LISTEXCEPTIONS USERID nvarchar2 150
ERS_LISTS USERID nvarchar2 150
ERS_LISTUSERS USERID nvarchar2 150
ERS_REPORTSTATUS USERID nvarchar2 150  √  null
RS_AUDIT USERID nvarchar2 250
RS_AUDIT USERIP nvarchar2 60
ERS_QUEUE_DTL USERNAME nvarchar2 100  √  null
ERS_REPORTINSTANCEPARAMVALUE VALUE_SOURCE nvarchar2 20  √  null
ERS_PARAMETERS VALUELISTTYPE nvarchar2 100  √  null
ERS_PARAMETERS VALUESOURCETYPE nvarchar2 50  √  null
ERS_PARAMETERS VALUESPAGINGSIZE number 22  √  null
ERS_PARAMETERS VALUETYPE nvarchar2 100  √  null
ERS_VARIABLES VALUETYPE nvarchar2 4  √  null
EBS_WFVARIABLE VARIABLE_NAME nvarchar2 20  √  null
EBS_WFVARIABLE VARIABLE_TYPE nvarchar2 1  √  null
EBS_WFVARIABLE VARIABLE_VALUE nvarchar2 60  √  null
ERS_VARIABLES VARIABLENAME nvarchar2 200
ERS_VARIABLES VARIABLETYPE nvarchar2 4  √  null
ERS_VARIABLES VARIABLEVALUE nvarchar2 800  √  null
EBS_WEBUSER VENDOR nvarchar2 9  √  null
EBS_WEBUSER VENDOR_GROUP nvarchar2 4  √  null
EBS_WEBUSER VENDOR_LOC nvarchar2 4  √  null
EBS_BSINFOHDR VIEW_APP nvarchar2 99  √  null
EBS_WEBUSER VIEW_CONTRACTS nvarchar2 1  √  null
EBS_SIRDIDHDR WEB_USER nvarchar2 80  √  null
EBS_WEBUSER WEB_USER nvarchar2 80  √  null
EBS_WFWORKUNIT WF_STATUS number 22  √  null
EBS_WFWORKUNIT WORK_CAT_VALUE nvarchar2 20  √  null
EBS_WFWORKUNIT WORK_CATEGORY nvarchar2 15  √  null
EBS_WFWORKUNIT WORK_COMMENT nvarchar2 60  √  null
EBS_WFWORKUNIT WORK_PRIORITY number 22  √  null
EBS_WFWORKUNIT WORK_RETURN_ID nvarchar2 60  √  null
EBS_WFWORKUNIT WORK_TITLE nvarchar2 50  √  null
EBS_WFWORKUNIT WORK_USER_ID nvarchar2 10  √  null
EBS_WFFOLDER WORKUNIT number 12  √  null
EBS_WFVARIABLE WORKUNIT number 12  √  null
EBS_WFWORKUNIT WORKUNIT number 12  √  null
EBS_WFSERVICE WRITE_HISTORY nvarchar2 1  √  null