Results for “pe_res_status”
25 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_FI_FTCI_ACCTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Student System (IGS) product family. Its name reflects its purpose: FTCI stands for Fee Type Course Instance Accounts, indicating that the view exposes account derivation records generated by the fee calculation engine for specific course or unit instances. In EBS 12.1.1 and 12.2.2 the view is used primarily for institutional reporting, reconciliation, and integration activities where fee account assignments must be presented alongside descriptive information about residency status, unit type, and the associated organizational unit.
The view is read-only and does not store data. It presents a denormalized, human-readable projection of the base account table, resolving coded values into their lookup meanings so that downstream reports, extracts, and interfaces do not need to perform their own joins to lookup tables.
Underlying Base Objects
Although the ETRM metadata does not document referenced base objects explicitly, the view text identifies three sources:
- IGS_FI_FTCI_ACCTS FTCI — the driving table, holding fee account derivation rows keyed by ACCT_ID and linked to a fee type, calendar, and course instance.
- IGS_LOOKUP_VALUES LKP — outer-joined on RESIDENCY_STATUS_CD = LOOKUP_CODE with LOOKUP_TYPE = 'PE_RES_STATUS'. This is the object directly relevant to the user search term pe_res_status, and it supplies the MEANING column.
- IGS_PS_UNIT_TYPE_LVL PUT — outer-joined on UNIT_TYPE_ID, supplying the LEVEL_CODE for the unit type level.
All joins to LKP and PUT are outer joins, so rows are retained even when the residency status code or unit type has no matching lookup or level record.
Key Columns
- ACCT_ID — primary identifier of the fee account derivation record.
- FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — identify the fee and the calendar instance to which the account applies.
- NATURAL_ACCOUNT_SEGMENT, REV_ACCOUNT_CD — the derived account code and revenue account used for the fee posting.
- RESIDENCY_STATUS_CD — the coded residency status; MEANING — its decoded description from lookup type PE_RES_STATUS.
- COURSE_CD, CRS_VERSION_NUMBER, UNIT_CD, UNIT_VERSION_NUMBER — course and unit context.
- UOO_ID and the function IGS_FI_GEN_APINT.GET_UNIT_SECTION_DESC — return the unit section description for the unit offering option.
- UNIT_LEVEL, UNIT_TYPE_ID, LEVEL_CODE, UNIT_CLASS, UNIT_MODE — academic classification attributes.
- ATTENDANCE_TYPE, ATTENDANCE_MODE, LOCATION_CD, ORG_UNIT_CD — delivery and organizational attributes.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
Common Use Cases and Queries
Typical scenarios include auditing residency-based fee account derivation, verifying that all residency statuses resolve to a PE_RES_STATUS lookup meaning, and extracting account assignments for financial reconciliation.
Sample query listing accounts by fee type with decoded residency status:
SELECT acct_id, fee_type, natural_account_segment, residency_status_cd, meaning, course_cd, unit_cd FROM apps.igs_fi_ftci_accts_v WHERE fee_type = :p_fee_type;
Sample query identifying rows where residency status is unmapped:
SELECT acct_id, residency_status_cd, fee_type FROM apps.igs_fi_ftci_accts_v WHERE meaning IS NULL;
Sample query filtering on unit level and audit period:
SELECT acct_id, unit_cd, level_code, last_update_date FROM apps.igs_fi_ftci_accts_v WHERE level_code = :p_level AND last_update_date >= :p_from_date;
Because the view depends on a PL/SQL function call per row, large-scale extracts should be filtered to limit the returned row set.
-
Lookup Type: PE_RES_STATUS 12.2.2
Person Residency Status
-
Lookup Type: PE_RES_STATUS 12.1.1
Person Residency Status
-
VIEW: APPS.IGS_FI_ELM_RNG_V 12.1.1
-
VIEW: APPS.IGS_PE_RES_DTLS_V 12.1.1
-
View: IGS_FI_FTCI_ACCTS_V 12.2.2
A supplementary view used to simplify forms coding.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_FTCI_ACCTS_V 12.1.1
A supplementary view used to simplify forms coding.
APPS.IGS_FI_FTCI_ACCTS_V·↳ IGS_FI_FTCI_ACCTS·↳ IGS_FI_GEN_APINT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_PE_RES_DTLS_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_ELM_RNG_V 12.2.2
This view determines the elements range rate specific to a given fee category fee liability.
Not implemented in this database·Explore IGS module →
-
View: IGS_PE_RES_DTLS_V 12.1.1
APPS.IGS_PE_RES_DTLS_V·↳ IGS_CA_INST_ALL·↳ IGS_LOOKUP_VALUES·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
View: IGS_FI_ELM_RNG_V 12.1.1
This view determines the elements range rate specific to a given fee category fee liability.
APPS.IGS_FI_ELM_RNG_V·↳ HZ_PARTIES·↳ IGS_FI_ELM_RANGE_RT·↳ IGS_FI_FEE_AS_RATE·Explore IGS module →
-
View: IGF_AP_IA_LOOKUP_V 12.2.2
Lookup Types required for Institutional Application LOV items
Not implemented in this database·Explore IGF module →
-
View: IGF_AP_IA_LOOKUP_V 12.1.1
Lookup Types required for Institutional Application LOV items
APPS.IGF_AP_IA_LOOKUP_V·↳ IGF_AP_APPL_SETUP_ALL·↳ IGF_LOOKUPS_VIEW·↳ IGS_AD_LOCATION·Explore IGF module →
-
View: IGS_FI_FEE_AS_RATE_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_FEE_AS_RATE_V 12.1.1
APPS.IGS_FI_FEE_AS_RATE_V·↳ HZ_PARTIES·↳ IGS_AD_LOCATION·↳ IGS_AS_UNIT_CLASS·Explore IGS module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2