Results for “late_entry_code”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_EXPENDITURE_HISTORY is an audit table within the Oracle Projects (PA) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to capture audit records for self-service time entry, preserving a historical trail of changes applied to expenditure items submitted through web-based timecards and related self-service flows. Each row represents a discrete audit event tied to a specific expenditure item, recording what changed, when, by whom, and under what change context.
The table holds 34 documented columns and is owned by the PA schema with VALID status. It references PA_EXPENDITURES_ALL through the EXPENDITURE_ID foreign key, anchoring each audit record to its parent expenditure. Under a heuristic Data Vault classification derived from its FK structure, this table is mined as a standalone object; in Data Vault modeling terms it functions most naturally as a satellite, since it stores descriptive, time-stamped change attributes attached to the EXPENDITURE_ID business key rather than acting as a hub or link.
Key Information Stored
The table's structure centers on the audited expenditure and the nature of the change event. The most significant columns include:
- EXPENDITURE_ID — Foreign key to PA_EXPENDITURES_ALL, identifying the expenditure item being audited.
- PROJECT_ID and TASK_ID — The project and task context for the audited expenditure.
- INCURRED_BY_PERSON_ID — The person who incurred the expenditure, central to self-service time reporting.
- EXPENDITURE_CLASS_CODE, EXPENDITURE_SOURCE_CODE, and EXPENDITURE_TYPE — Classify the expenditure being audited.
- EXPENDITURE_ITEM_DATE and QUANTITY — The expenditure date and quantity values captured in the audit snapshot.
- CHANGE_CODE and AUDIT_TYPE_CODE — Describe the category of change and audit action recorded.
- ADJUSTED_EXPENDITURE_ITEM_ID — Links audit records to adjustment-related expenditure items.
- EXPENDITURE_ITEM_COMMENT and REASON_COMMENT — Free-text comments and reasons associated with the change.
- LATE_ENTRY_CODE — Indicates late-entry characteristics of the audited item.
- AUDIT_ORDER — Sequentially orders audit events for a given expenditure chain.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance.
The documented metadata does not identify a named surrogate primary key or unique business-key index, though EXPENDITURE_ID combined with AUDIT_ORDER typically serves as the practical business-key combination for ordering audit history. DESCRIPTIVE flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10 are also present.
Common Use Cases and Queries
Typical uses involve reconciling self-service timecard changes, investigating disputed or adjusted expenditure items, and building audit-trail reports for compliance.
- Retrieving the full change history for a specific expenditure ordered chronologically.
- Identifying who modified self-service time entries within a period.
- Reconciling adjustments against the original expenditure item.
A representative query pattern:
SELECT eh.EXPENDITURE_ID, eh.AUDIT_ORDER, eh.CHANGE_CODE,
eh.AUDIT_TYPE_CODE, eh.EXPENDITURE_ITEM_DATE,
eh.QUANTITY, eh.LATE_ENTRY_CODE,
eh.CREATED_BY, eh.CREATION_DATE
FROM PA.PA_EXPENDITURE_HISTORY eh
WHERE eh.EXPENDITURE_ID = :expenditure_id
ORDER BY eh.AUDIT_ORDER;
Related Objects
- PA_EXPENDITURES_ALL — Primary referent via the documented foreign key PA_EXPENDITURE_HISTORY.EXPENDITURE_ID → PA_EXPENDITURES_ALL. The essential join for retrieving expenditure context.
- PA_PROJECTS_ALL — Joined on PROJECT_ID to resolve project details.
- PA_TASKS — Joined on TASK_ID to resolve task descriptions.
- PER_ALL_PEOPLE_F — Joined on INCURRED_BY_PERSON_ID or CREATED_BY to resolve the person who incurred or changed the entry.
- PA_EXPENDITURE_ITEMS and adjustment records referenced by ADJUSTED_EXPENDITURE_ITEM_ID — useful for tracing adjustment chains.
- PA_EXPENDITURE_TYPES — Resolves EXPENDITURE_TYPE values.
-
Audit records for self service time
-
Pa_Expenditure_History_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Audit records for self service time
-
Pa_Expenditure_History_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
VIEW: PA.PA_EXP_HISTORY_AR# 12.2.2
-
VIEW: PA.PA_EXP_HISTORY_AR# 12.2.2
-
TABLE: PA.PA_EXP_HISTORY_AR 12.1.1
-
TABLE: PA.PA_EXP_HISTORY_AR 12.2.2
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2