[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_ORG_EXTENSIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_ORG_EXTENSIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Obsolete
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INST_ORG_CODE | VARCHAR2 | (30) | Yes | The Institution or Organizational Unit Code |
| INST_ORG_INDICATOR | VARCHAR2 | (1) | Flag indicates whether it is an organization or institution. 'O' - Organization, 'I' - Institution | |
| INSTITUTION_CODE | VARCHAR2 | (30) | Identifier code of the institution in which the Organizational Unit is associated | |
| ORG_START_DATE | DATE | Start date of the org unit | ||
| ORG_END_DATE | DATE | End date of the org unit | ||
| _LA:ORG_MEMBER_TYPE | CHAR | (63) | Member type of the Organizational Unit. | |
| ORG_STATUS | VARCHAR2 | (10) | Status of the Organizational Unit. | |
| _LA:ORG_TYPE | CHAR | (57) | Type of Organizational Unit | |
| LOCAL_INSTITUTION_INDICATOR | VARCHAR2 | (1) | Indicator if the institution is local | |
| OVERSEAS_INDICATOR | VARCHAR2 | (1) | Indicator to show if the institution is overseas. | |
| _LA:GOVT_INSTITUTION_CODE | CHAR | (72) | Government institution code | |
| _LA:INST_CONTROL_TYPE | CHAR | (71) | Control Type of the Institution | |
| _LA:INST_PRIORITY | CHAR | (70) | Institution Priority | |
| INSTITUTION_TYPE | VARCHAR2 | (20) | Type of Institution | |
| INSTITUTION_STATUS | VARCHAR2 | (10) | Status of Institution. | |
| INST_MARKET_CODE | VARCHAR2 | (8) | The Institution Market Code | |
| INST_PHONE_COUNTRY_CODE | VARCHAR2 | (10) | Country Code telephone number for the institution. | |
| INST_PHONE_AREA_CODE | VARCHAR2 | (10) | Area Code telephone number for the institution. | |
| INST_PHONE_NUMBER | VARCHAR2 | (40) | Telephone Number of the institution. | |
| ORG_STATUS_DESC | VARCHAR2 | (60) | Description of Organizational Unit status | |
| INSTITUTION_TYPE_DESC | VARCHAR2 | (60) | Description of Institution type | |
| INSTITUTION_STATUS_DESC | VARCHAR2 | (60) | Description of institution status | |
| SEC_SCHOOL_LOCATION | VARCHAR2 | (10) | Secondary school location | |
| SEC_SCHOOL_LOCATION_DESC | VARCHAR2 | (30) | Description of the Secondary school location | |
| ADV_STUDIES_CLASSES | NUMBER | The number of Advanced Studies Classes Offered | ||
| HONORS_CLASSES | NUMBER | The number of Honours classes offered | ||
| CLASS_SIZE | NUMBER | Size of the class | ||
| PERCENT_PLAN_HIGHER_EDU | NUMBER | The percentage of students planning to pursue higher education | ||
| PARTY_ID | NUMBER | (15) | Yes | Unique identifier of the party |
| SEC_SCHOOL_LOCATION_ID | NUMBER | (15) | Secondary school location identifier | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ORG_CODE
, INST_ORG_INDICATOR
, INSTITUTION_CODE
, ORG_START_DATE
, ORG_END_DATE
, _LA:ORG_MEMBER_TYPE
, ORG_STATUS
, _LA:ORG_TYPE
, LOCAL_INSTITUTION_INDICATOR
, OVERSEAS_INDICATOR
, _LA:GOVT_INSTITUTION_CODE
, _LA:INST_CONTROL_TYPE
, _LA:INST_PRIORITY
, INSTITUTION_TYPE
, INSTITUTION_STATUS
, INST_MARKET_CODE
, INST_PHONE_COUNTRY_CODE
, INST_PHONE_AREA_CODE
, INST_PHONE_NUMBER
, ORG_STATUS_DESC
, INSTITUTION_TYPE_DESC
, INSTITUTION_STATUS_DESC
, SEC_SCHOOL_LOCATION
, SEC_SCHOOL_LOCATION_DESC
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, PERCENT_PLAN_HIGHER_EDU
, PARTY_ID
, SEC_SCHOOL_LOCATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_ORG_EXTENSIONS;
APPS
HZ_PARTIES
IGS_AD_CODE_CLASSES
IGS_OR_INST_STAT
IGS_OR_ORG_INST_TYPE
IGS_OR_STATUS
IGS_PE_HZ_PARTIES
APPS.IGSFV_ORG_EXTENSIONS is not referenced by any database object
|
|
|
|