Results for “igi_itr_charge_auth_tmp”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGI_ITR_CHARGE_AUTH_TMP is a table in the IGI schema, belonging to the Oracle EBS product family known as IGI – Public Sector Financials International. Its documented purpose is to contain charge authorizer information. The object is flagged as VALID in the ETRM metadata, indicating that it is a supported and currently maintained database object within the E-Business Suite 12.1.1 and 12.2.2 releases. Because IGI addresses the specific statutory, budgetary, and charge-handling requirements of public sector institutions, this table sits within the charge authorization layer that governs which users are empowered to authorize charges against a given charge center.
From a heuristic Data Vault modeling perspective, the FK relationship from CHARGE_CENTER_ID to IGI_ITR_CHARGE_CENTER suggests that this table behaves as a link construct, associating a charge center with an authorizing user identity. It is standalone in the mined FK graph, meaning no other table points back to it as a parent, which is consistent with its role as a leaf-level association record rather than a reusable hub. Practitioners modeling IGI data for warehouse purposes may therefore treat it as a transaction-level relationship rather than a dimension or master entity.
Key Information Stored
The documented physical schema contains seven columns. The most significant are the following:
- CHARGE_CENTER_ID – the foreign key referencing IGI_ITR_CHARGE_CENTER. This is the business-key candidate that ties each authorization record to a specific charge center.
- USER_ID – identifies the authorizing user, forming the second half of the association between the charge center and the individual empowered to authorize charges.
- CREATION_DATE – the timestamp at which the authorization record was created, supporting audit and effective-dating analysis.
- CREATED_BY – the user who created the record, consistent with the standard EBS WHO-column audit pattern.
- LAST_UPDATE_DATE – the timestamp of the most recent modification, used in incremental extraction and change-detection logic.
- LAST_UPDATED_BY – the user responsible for the last modification.
- LAST_UPDATE_LOGIN – the login session associated with the last update, useful for forensic and audit reporting.
No surrogate primary key column is documented separately, and no unique index is recorded in the ETRM metadata. The combination of CHARGE_CENTER_ID and USER_ID is the natural business key that gives each row its meaning, while the WHO columns provide the standard auditing envelope. The remaining columns are audit and concurrency attributes rather than business data.
Common Use Cases and Queries
Typical usage centers on determining who may authorize charges for a charge center and on reconciling authorization coverage. A common reporting query joins the table to its parent charge center:
SELECT c.charge_center_id, c.name, a.user_id, a.creation_date FROM igi_itr_charge_center c, igi_itr_charge_auth_tmp a WHERE c.charge_center_id = a.charge_center_id;
Auditors frequently extract records by LAST_UPDATE_DATE ranges to identify recent changes in authorization assignments. Security administrators use the table to verify that every active charge center has at least one named authorizer. The WHO columns also support user-activity reporting, showing which administrators have maintained authorization records and when.
Related Objects
- IGI_ITR_CHARGE_CENTER – the parent table referenced by CHARGE_CENTER_ID; joins are performed on this column.
- FND_USER – the standard EBS user table, joined on USER_ID, CREATED_BY, and LAST_UPDATED_BY to resolve names.
- IGI_ITR_CHARGE_AUTH – the likely production counterpart holding persistent charge authorizer information, against which the temporary table's contents may be staged or compared.
- FND_LOGINS – joined on LAST_UPDATE_LOGIN for session-level audit detail.
-
Contains charge authorizer information
-
Contains charge authorizer information
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.