ACN_REQUIREMENT_INT

Requirements Interface table for Bulk Import Support

Details

  • Schema: FUSION

  • Object owner: ACN

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ACN_REQUIREMENT_INT_PK

SEQ_ID

Columns

Name Datatype Length Precision Not-null Comments Status
IMPORT_STATUS_CODE VARCHAR2 1000 IMPORT_STATUS_CODE tells status of a row in the interface table.
HEADER_FLAG NUMBER 1 Header flag columns holds the value of 0 or 1 based on the value.
INTERFACE_ROW_ID NUMBER 18 INTERFACE_ROW_ID is the unique identifier for the record with in a batch.
ACTION_CODE VARCHAR2 1000 ACTION_CODE in interface table allows source system to specify a particular operation (insert, update, etc) for a row.
INTERNAL_ACTION_CODE VARCHAR2 1000 This column is created for internal use and will be populated and used by bulk import logic.
SEQ_NO NUMBER For every record of data that will be inserted into the interface table SEQ_NO will be populated. Obsolete
SEQ_ID NUMBER Yes For every record of data that will be inserted into the interface table SEQ_NO will be populated.
REQUIREMENT_ID NUMBER 18 Requirement id value for the requirement interface table.
TYPE VARCHAR2 200 Type value for the requirement interface table.
REQ_LEVEL VARCHAR2 1000 Requirement level value for the requirement interface table.
NAME VARCHAR2 400 Name value for the requirement interface table.
ROOT_REQUIREMENT NUMBER Root requirement value for the requirement interface table.
PARENT_REQUIREMENT NUMBER Parent requirement value for the requirement interface table.
PARENT_LEVEL VARCHAR2 1000 Parent level value for the requirement interface table.
DESCRIPTION CLOB Description value for the requirement interface table.
CONTENT CLOB Requirement Line Item Content value for the requirement interface table.
STATUS VARCHAR2 1000 Status value for the requirement interface table.
PRIORITY VARCHAR2 1000 Priority value for the requirement interface table.
SCOPE VARCHAR2 1000 Scope value for the requirement interface table.
ESTIMATES NUMBER 18 Estimates value for the requirement interface table.
FULFILLED VARCHAR2 1000 Fulfilled value for the requirement interface table.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LOAD_REQUEST_ID NUMBER 18 When Data file uploaded and click on submit that time the load request Id generated.
EXTN_ATTR001 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR002 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR003 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR004 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR005 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR006 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR007 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR008 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR009 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR010 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR011 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR012 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR013 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR014 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR015 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR016 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR017 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR018 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR019 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR020 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR021 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR022 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR023 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR024 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR025 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR026 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR027 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR028 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR029 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR030 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR031 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR032 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR033 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR034 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR035 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR036 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR037 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR038 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR039 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR040 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR041 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR042 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR043 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR044 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR045 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR046 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR047 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR048 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR049 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR050 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR051 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR052 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR053 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR054 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR055 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR056 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR057 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR058 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR059 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR060 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR061 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR062 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR063 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR064 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR065 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR066 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR067 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR068 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR069 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR070 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR071 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR072 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR073 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR074 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR075 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR076 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR077 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR078 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR079 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR080 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR081 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR082 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR083 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR084 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR085 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR086 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR087 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR088 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR089 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR090 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR091 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR092 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR093 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR094 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR095 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR096 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR097 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR098 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR099 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR100 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR101 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR102 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR103 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR104 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR105 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR106 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR107 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR108 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR109 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR110 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR111 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR112 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR113 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR114 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR115 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR116 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR117 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR118 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR119 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR120 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR121 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR122 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR123 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR124 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR125 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR126 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR127 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR128 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR129 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR130 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR131 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR132 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR133 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR134 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR135 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR136 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR137 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR138 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR139 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR140 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR141 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR142 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR143 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR144 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR145 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR146 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR147 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR148 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR149 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR150 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR151 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR152 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR153 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR154 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR155 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR156 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR157 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR158 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR159 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR160 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR161 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR162 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR163 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR164 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR165 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR166 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR167 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR168 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR169 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR170 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR171 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR172 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR173 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR174 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR175 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.

Indexes

Index Uniqueness Tablespace Columns
ACN_REQUIREMENT_INT_U1 Unique Default SEQ_ID
ACN_REQUIREMENT_INT_U2 Unique Default SEQ_ID, LOAD_REQUEST_ID