SchemaSpy Analysis of shrdb.LAWRS - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Thu Dec 13 15:47 CST 2012 |
| ||||||
|
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 | 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 |