Results for “datapoint_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AR_CMGT_OTHER_DATA table is an Oracle Receivables (AR) object residing in the AR schema and classified as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores detailed information about Venture Capital funding in use by the company under credit review. Within the Credit Management workflow, the table captures supplementary credit-review datapoints that are not contained in the primary credit request record, allowing credit analysts to document external funding relationships, investor contacts, and funding runway metrics that influence an applicant's overall creditworthiness assessment.

The documented physical schema exposes 26 columns. The primary key is enforced by the constraint AR_CMGT_OTHER_DATA_PK on the DATAPOINT_ID column, and a unique index AR_CMGT_OTHER_DATA_U1 also exists on DATAPOINT_ID, confirming it as the singular business-key candidate. Heuristic Data Vault classification of this object, mined from its foreign-key structure, resolves to standalone—meaning the table is not a strict hub, link, or satellite but operates as a self-contained detail store anchored by two foreign keys to AR_CMGT_CREDIT_REQUESTS and AR_CMGT_CASE_FOLDERS. This should be treated as a modeling suggestion rather than a normative statement.

Key Information Stored

The most significant columns capture the identity and financial profile of the venture capital relationship under review:

• DATAPOINT_ID — Surrogate primary key; uniquely identifies each credit-review datapoint row.
• CREDIT_REQUEST_ID — Foreign key linking the datapoint to its parent credit request in AR_CMGT_CREDIT_REQUESTS.
• CASE_FOLDER_ID — Foreign key associating the datapoint with the enclosing case folder in AR_CMGT_CASE_FOLDERS.
• VENTURE_CAPITAL_NAME — Name of the venture capital firm providing funding.
• KEY_EXECUTIVE — Principal executive or sponsor at the venture capital firm.
• VC_CONTACT_NAME, VC_CONTACT_PHONE, VC_CONTACT_FAX, VC_CONTACT_EMAIL — Contact details for the venture capital representative.
• VC_ADDRESS, VC_STATE, VC_PROVINCE, VC_POSTAL_CODE, COUNTRY — Geographic and mailing information.
• CAPITAL_STAGE_COMPLETED — Financing stage reached (e.g., seed, Series A).
• FUNDING_AMOUNT and CURRENCY — Total capital committed and its currency of denomination.
• PERCENT_INVESTED — Percentage of equity held by the investor in the company under review.
• BURN_RATE — Rate at which the company consumes capital.
• FUTURE_FUNDING_PLANS and NOTES — Narrative fields describing planned financing activity and analyst commentary.
• Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Credit analysts and reporting developers query this table to retrieve all venture capital funding records attached to a credit review, or aggregate funding exposure across applicants.

• Retrieve all venture capital datapoints for a specific credit request:

SELECT datapoint_id, venture_capital_name, funding_amount, currency,
       percent_invested, capital_stage_completed, burn_rate
FROM   ar.ar_cmgt_other_data
WHERE  credit_request_id = :p_credit_request_id;

• Join to case folders to view all datapoints across a portfolio of credit cases:

SELECT o.datapoint_id, o.venture_capital_name, o.funding_amount
FROM   ar.ar_cmgt_other_data o,
       ar.ar_cmgt_case_folders c
WHERE  o.case_folder_id = c.case_folder_id
AND    c.case_folder_id = :p_case_folder_id;

• Reporting: summarize total funding by currency or stage to assess concentration risk.
• Analytics: track burn rate and percent-invested metrics over time using audit columns.

Related Objects

• AR_CMGT_CREDIT_REQUESTS — Parent object; joined via AR_CMGT_OTHER_DATA.CREDIT_REQUEST_ID.
• AR_CMGT_CASE_FOLDERS — Parent object; joined via AR_CMGT_OTHER_DATA.CASE_FOLDER_ID.
• AR_CMGT_OTHER_DATA_PK — Primary key constraint on DATAPOINT_ID.
• AR_CMGT_OTHER_DATA_U1 — Unique index on DATAPOINT_ID.
• AR_CMGT_CREDIT_REVIEWS and AR_CMGT_CASE_FOLDER_TXNS — Related Credit Management objects sharing the same AR_CMGT_ prefix and schema, referenced through sibling relationships.
• Credit Management UI pages and AR_CMGT public APIs — Consume and maintain rows in this table directly during the credit review lifecycle.