ACE_BUSINESS_DET_STAGING

Details

Schema: FUSION
Object owner: ACE
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ACE_BUSINESS_DET_STAGING_B_PK	BUSINESS_DET_STAGING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BUSINESS_DET_STAGING_ID	NUMBER		18	Yes	Primary Key which will be system generated Application Unique Id.
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.
PRODUCT_PROPOSAL_ID	NUMBER		18	Yes	Foreign key reference to the ACD_PRODUCT_PROPOSAL table
USER_ID	VARCHAR2	64			Used to store the current logged in user
DISCOUNT_RATE	NUMBER		5		The rate of discount defined in proposal details page
TARGET_COST	NUMBER				The targeted proposal costs defined on the proposal details page.
AVERAGE_SELLING_PRICE	NUMBER				The average price used in proposal details page
FUNDING_REQUEST_FOR	VARCHAR2	30			The purpose of the funding as defined in proposal details page
FUNDING_AMOUNT	NUMBER				The funding amount defined in proposal details page
BUSINESS_UNIT	VARCHAR2	30			The business unit defined in proposal details page
PRODUCT_LINE	VARCHAR2	30			Product line defined on the proposal details page.
PRIMARY_JUSTIFICATION	VARCHAR2	30			Primary justification provided on the proposal details page.
SECONDARY_JUSTIFICATION	VARCHAR2	30			Secondary justification provided on the proposal details page.
ALLOCATED_BUDGET	NUMBER				The allocated budget used in proposal details page.
REQUIREMENTS_DEFINITION	DATE				Completion date of the requirements definition provided on the proposal details page.
HIGH_LEVEL_DESIGN	DATE				Completion date of the high-level design defined on the proposal details page.
DEVELOPMENT_START	DATE				Development start date provided on proposal details page.
DEVELOPMENT_END	DATE				Development completion date provided on the proposal details page.
LAUNCH	DATE				The date of launch, defined in proposal details page
EOL	DATE				The date for end of life defined in proposal details page
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	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.
SUMMARY	CLOB				Summary is Rich Text content for Business Case Summary for a Product Proposal
NET_PRESENT_VALUE	NUMBER				The net present value, calculated in metrics.
INTERNAL_RATE_OF_RETURN	NUMBER				The internally calculated return rate as defined in metrics.
RETURN_ON_INVESTMENT	NUMBER				The calculated ROI used in metrics.
BREAK_EVEN_TIME	NUMBER				The break-even time used in metrics.
PROPOSAL_PROJECTED_COST	NUMBER				The projected proposal costs used in metrics.
PROPOSAL_PROJECTED_REVENUE	NUMBER				The projected proposal revenue used in metrics.
SCENARIO_ID	NUMBER		18		Used to store Business object id
PORTFOLIO_ID	NUMBER		18		The unique ID to reference a portfolio.
MARKET_STRATEGY	VARCHAR2	30			Stores the market strategy of proposal

Foreign Keys

Table	Foreign Table	Foreign Key Column
ACE_BUSINESS_DET_STAGING_B	acd_product_proposal	PRODUCT_PROPOSAL_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ACE_BUSINESS_DET_STAGING_B_N1	Non Unique	Default	PRODUCT_PROPOSAL_ID
ACE_BUSINESS_DET_STAGING_B_U1	Unique	Default	BUSINESS_DET_STAGING_ID